This discussion is archived
5 Replies Latest reply: Feb 8, 2011 7:00 AM by 837000 RSS

How do i use paroutingx.route_to_extension

user537403 Newbie
Currently Being Moderated
We are migrating into OTL from Selfservice time for Projects.

Oracle has given extension paroutingx.route_to_extension to do so.

PROCEDURE route_to_extension (
x_expenditure_id IN NUMBER,
x_incurred_by_person_id IN NUMBER,
x_expenditure_end_date IN DATE,
x_exp_class_code IN VARCHAR2,
x_previous_approver_person_id IN NUMBER DEFAULT NULL,
p_timecard_table IN pa_otc_api.timecard_table
DEFAULT paroutingx.g_dummy,
x_route_to_person_id OUT NUMBER

In OTL, there is an approval style called "Project Manager". It routes the timesheet into project manager.

For instance

if the resource entered three different projects in in the same timecard, OTL sends the approval to three different project managers automatically.

Here we need to send the notification to Line manager if the uses "Admin" Project type.

User Xavier entered the timesheet using the Project code "X","Y","Z". X and Y are Client Projects and Z is Administrative Project.

If he submits, OTL sends notific ation to Project managers of X,Y and Z. But we need X and Y should go to their Projects and Z should go to Line Manager.

In OTL Document, Oracle has provided the client Extension to do so.However there is no documentation /examples to do this.

Please help me to achieve this.



  • Correct Answers - 10 points
  • Helpful Answers - 5 points