eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_APPROVAL_WF dependencies on PER_PEOPLE_F

Line 11: ,l_in_person_id in per_people_f.person_id%type) is

7:
8: --
9: -- returns the supervisor id for the person id passed into the cursor.
10: cursor g_csr_pa(l_effective_date in date
11: ,l_in_person_id in per_people_f.person_id%type) is
12: select ppf.person_id
13: from per_assignments_f paf
14: ,per_people_f ppf
15: where paf.person_id = l_in_person_id

Line 14: ,per_people_f ppf

10: cursor g_csr_pa(l_effective_date in date
11: ,l_in_person_id in per_people_f.person_id%type) is
12: select ppf.person_id
13: from per_assignments_f paf
14: ,per_people_f ppf
15: where paf.person_id = l_in_person_id
16: and paf.primary_flag = 'Y'
17: and (paf.assignment_type = 'E' and ppf.current_employee_flag = 'Y'
18: or paf.assignment_type = 'C' and ppf.current_npw_flag = 'Y')

Line 29: ,p_person_id in per_people_f.person_id%type) IS

25: and ppf.effective_end_date;
26:
27: -- returns a email address for the person id passed into the cursor.
28: CURSOR g_csr_email_address(l_effective_date in date
29: ,p_person_id in per_people_f.person_id%type) IS
30: SELECT email_address
31: FROM per_people_f pp
32: WHERE pp.person_id = p_person_id
33: AND l_effective_date

Line 31: FROM per_people_f pp

27: -- returns a email address for the person id passed into the cursor.
28: CURSOR g_csr_email_address(l_effective_date in date
29: ,p_person_id in per_people_f.person_id%type) IS
30: SELECT email_address
31: FROM per_people_f pp
32: WHERE pp.person_id = p_person_id
33: AND l_effective_date
34: between pp.effective_start_date
35: and pp.effective_end_date;

Line 81: ,p_approval_routing_id in per_people_f.person_id%type

77: --
78: procedure Set_Routing_Details
79: (p_item_type in varchar2
80: ,p_item_key in varchar2
81: ,p_approval_routing_id in per_people_f.person_id%type
82: ,p_router_index in number) is
83: --
84: l_approval_routing_username wf_users.name%type;
85: l_approval_routing_disp_name wf_users.display_name%type;

Line 201: l_person_id per_people_f.person_id%type;

197: -- -------------------------------------------------------------------------
198: -- local variables
199: -- -------------------------------------------------------------------------
200: l_proc_name varchar2(61) := g_package||'initialise_item_attributes';
201: l_person_id per_people_f.person_id%type;
202: l_creator_person_id per_people_f.person_id%type;
203: l_creator_username wf_users.name%type;
204: l_creator_disp_name wf_users.display_name%type;
205: l_candidate_assignment_id per_assignments_f.assignment_id%type;

Line 202: l_creator_person_id per_people_f.person_id%type;

198: -- local variables
199: -- -------------------------------------------------------------------------
200: l_proc_name varchar2(61) := g_package||'initialise_item_attributes';
201: l_person_id per_people_f.person_id%type;
202: l_creator_person_id per_people_f.person_id%type;
203: l_creator_username wf_users.name%type;
204: l_creator_disp_name wf_users.display_name%type;
205: l_candidate_assignment_id per_assignments_f.assignment_id%type;
206: l_candidate_person_id per_people_f.person_id%type;

Line 206: l_candidate_person_id per_people_f.person_id%type;

202: l_creator_person_id per_people_f.person_id%type;
203: l_creator_username wf_users.name%type;
204: l_creator_disp_name wf_users.display_name%type;
205: l_candidate_assignment_id per_assignments_f.assignment_id%type;
206: l_candidate_person_id per_people_f.person_id%type;
207: l_candidate_disp_name wf_users.display_name%type;
208: l_candidate_appl_number per_people_f.applicant_number%type;
209: l_fwd_from_username wf_users.name%type;
210: l_fwd_from_disp_name wf_users.display_name%type;

Line 208: l_candidate_appl_number per_people_f.applicant_number%type;

204: l_creator_disp_name wf_users.display_name%type;
205: l_candidate_assignment_id per_assignments_f.assignment_id%type;
206: l_candidate_person_id per_people_f.person_id%type;
207: l_candidate_disp_name wf_users.display_name%type;
208: l_candidate_appl_number per_people_f.applicant_number%type;
209: l_fwd_from_username wf_users.name%type;
210: l_fwd_from_disp_name wf_users.display_name%type;
211: l_url_index number default 1;
212: l_max_urls number default 20;

Line 527: l_creator_person_id per_people_f.person_id%type;

523: -- -------------------------------------------------------------------------
524: -- local variables
525: -- -------------------------------------------------------------------------
526: l_proc_name varchar2(61) := g_package||'set_routing_details1';
527: l_creator_person_id per_people_f.person_id%type;
528: l_approval_routing_id per_people_f.person_id%type;
529: --
530: begin
531: --

Line 528: l_approval_routing_id per_people_f.person_id%type;

524: -- local variables
525: -- -------------------------------------------------------------------------
526: l_proc_name varchar2(61) := g_package||'set_routing_details1';
527: l_creator_person_id per_people_f.person_id%type;
528: l_approval_routing_id per_people_f.person_id%type;
529: --
530: begin
531: --
532: if ( funmode = 'RUN' ) then

Line 581: l_creator_person_id per_people_f.person_id%type;

577: -- -------------------------------------------------------------------------
578: -- local variables
579: -- -------------------------------------------------------------------------
580: l_proc_name varchar2(61) := g_package||'set_routing_details2';
581: l_creator_person_id per_people_f.person_id%type;
582: l_approval_routing_id per_people_f.person_id%type;
583: --
584: begin
585: --

Line 582: l_approval_routing_id per_people_f.person_id%type;

578: -- local variables
579: -- -------------------------------------------------------------------------
580: l_proc_name varchar2(61) := g_package||'set_routing_details2';
581: l_creator_person_id per_people_f.person_id%type;
582: l_approval_routing_id per_people_f.person_id%type;
583: --
584: begin
585: --
586: if ( funmode = 'RUN' ) then

Line 636: l_creator_person_id per_people_f.person_id%type;

632: -- -------------------------------------------------------------------------
633: -- local variables
634: -- -------------------------------------------------------------------------
635: l_proc_name varchar2(61) := g_package||'set_routing_details3';
636: l_creator_person_id per_people_f.person_id%type;
637: l_approval_routing_id per_people_f.person_id%type;
638: l_vacancy_id per_vacancies.vacancy_id%type;
639: --
640: begin

Line 637: l_approval_routing_id per_people_f.person_id%type;

633: -- local variables
634: -- -------------------------------------------------------------------------
635: l_proc_name varchar2(61) := g_package||'set_routing_details3';
636: l_creator_person_id per_people_f.person_id%type;
637: l_approval_routing_id per_people_f.person_id%type;
638: l_vacancy_id per_vacancies.vacancy_id%type;
639: --
640: begin
641: --

Line 696: l_creator_person_id per_people_f.person_id%type;

692: -- -------------------------------------------------------------------------
693: -- local variables
694: -- -------------------------------------------------------------------------
695: l_proc_name varchar2(61) := g_package||'set_routing_details4';
696: l_creator_person_id per_people_f.person_id%type;
697: l_approval_routing_id per_people_f.person_id%type;
698: --
699: begin
700: --

Line 697: l_approval_routing_id per_people_f.person_id%type;

693: -- local variables
694: -- -------------------------------------------------------------------------
695: l_proc_name varchar2(61) := g_package||'set_routing_details4';
696: l_creator_person_id per_people_f.person_id%type;
697: l_approval_routing_id per_people_f.person_id%type;
698: --
699: begin
700: --
701: if ( funmode = 'RUN' ) then

Line 751: l_creator_person_id per_people_f.person_id%type;

747: -- -------------------------------------------------------------------------
748: -- local variables
749: -- -------------------------------------------------------------------------
750: l_proc_name varchar2(61) := g_package||'set_routing_details5';
751: l_creator_person_id per_people_f.person_id%type;
752: l_approval_routing_id per_people_f.person_id%type;
753: --
754: begin
755: --

Line 752: l_approval_routing_id per_people_f.person_id%type;

748: -- local variables
749: -- -------------------------------------------------------------------------
750: l_proc_name varchar2(61) := g_package||'set_routing_details5';
751: l_creator_person_id per_people_f.person_id%type;
752: l_approval_routing_id per_people_f.person_id%type;
753: --
754: begin
755: --
756: if ( funmode = 'RUN' ) then

Line 994: l_person_id per_people_f.person_id%type;

990: -- local variables
991: -- -------------------------------------------------------------------------
992: l_proc_name varchar2(61) := g_package||'set_URL5';
993: l_url varchar2(2000);
994: l_person_id per_people_f.person_id%type;
995: --
996: begin
997: --
998: if ( funmode = 'RUN' ) then

Line 1170: l_email_address per_people_f.email_address%type;

1166: -- local variables
1167: -- -------------------------------------------------------------------------
1168: l_proc_name varchar2(61) := g_package||'set_URL8';
1169: l_url varchar2(2000);
1170: l_email_address per_people_f.email_address%type;
1171: l_person_id per_vacancies.vacancy_id%type;
1172: --
1173: begin
1174: --

Line 1231: l_out_person_id per_people_f.person_id%type default null;

1227: -- local variables
1228: -- -------------------------------------------------------------------------
1229: l_proc_name varchar2(61) := g_package||'set_URL9';
1230: l_url varchar2(2000);
1231: l_out_person_id per_people_f.person_id%type default null;
1232: l_person_id per_people_f.person_id%type default null;
1233: l_email_address per_people_f.email_address%type;
1234: --
1235: begin

Line 1232: l_person_id per_people_f.person_id%type default null;

1228: -- -------------------------------------------------------------------------
1229: l_proc_name varchar2(61) := g_package||'set_URL9';
1230: l_url varchar2(2000);
1231: l_out_person_id per_people_f.person_id%type default null;
1232: l_person_id per_people_f.person_id%type default null;
1233: l_email_address per_people_f.email_address%type;
1234: --
1235: begin
1236: --

Line 1233: l_email_address per_people_f.email_address%type;

1229: l_proc_name varchar2(61) := g_package||'set_URL9';
1230: l_url varchar2(2000);
1231: l_out_person_id per_people_f.person_id%type default null;
1232: l_person_id per_people_f.person_id%type default null;
1233: l_email_address per_people_f.email_address%type;
1234: --
1235: begin
1236: --
1237: if ( funmode = 'RUN' ) then

Line 1297: l_person_id per_people_f.person_id%type default null;

1293: -- local variables
1294: -- -------------------------------------------------------------------------
1295: l_proc_name varchar2(61) := g_package||'set_URL10';
1296: l_url varchar2(2000);
1297: l_person_id per_people_f.person_id%type default null;
1298: l_email_address per_people_f.email_address%type;
1299: --
1300: begin
1301: --

Line 1298: l_email_address per_people_f.email_address%type;

1294: -- -------------------------------------------------------------------------
1295: l_proc_name varchar2(61) := g_package||'set_URL10';
1296: l_url varchar2(2000);
1297: l_person_id per_people_f.person_id%type default null;
1298: l_email_address per_people_f.email_address%type;
1299: --
1300: begin
1301: --
1302: if ( funmode = 'RUN' ) then

Line 1429: l_person_id per_people_f.person_id%type;

1425: -- local variables
1426: -- -------------------------------------------------------------------------
1427: l_proc_name varchar2(61) := g_package||'set_URL12';
1428: l_url varchar2(2000);
1429: l_person_id per_people_f.person_id%type;
1430: --
1431: begin
1432: --
1433: if ( funmode = 'RUN' ) then

Line 1500: l_person_id per_people_f.person_id%type;

1496: -- local variables
1497: -- -------------------------------------------------------------------------
1498: l_proc_name varchar2(61) := g_package||'set_URL13';
1499: l_url varchar2(2000);
1500: l_person_id per_people_f.person_id%type;
1501: l_email_address per_people_f.email_address%type;
1502: --
1503: begin
1504: --

Line 1501: l_email_address per_people_f.email_address%type;

1497: -- -------------------------------------------------------------------------
1498: l_proc_name varchar2(61) := g_package||'set_URL13';
1499: l_url varchar2(2000);
1500: l_person_id per_people_f.person_id%type;
1501: l_email_address per_people_f.email_address%type;
1502: --
1503: begin
1504: --
1505: if ( funmode = 'RUN' ) then

Line 1626: l_creator_person_id per_people_f.person_id%type;

1622: -- -------------------------------------------------------------------------
1623: -- local variables
1624: -- -------------------------------------------------------------------------
1625: l_proc_name varchar2(61) := g_package||'check_final_approver';
1626: l_creator_person_id per_people_f.person_id%type;
1627: l_forward_to_person_id per_people_f.person_id%type;
1628: --
1629: begin
1630: --

Line 1627: l_forward_to_person_id per_people_f.person_id%type;

1623: -- local variables
1624: -- -------------------------------------------------------------------------
1625: l_proc_name varchar2(61) := g_package||'check_final_approver';
1626: l_creator_person_id per_people_f.person_id%type;
1627: l_forward_to_person_id per_people_f.person_id%type;
1628: --
1629: begin
1630: --
1631: if ( funmode = 'RUN' ) then

Line 1676: l_creator_person_id per_people_f.person_id%type;

1672: --
1673: -- -------------------------------------------------------------------------
1674: -- local variables
1675: -- -------------------------------------------------------------------------
1676: l_creator_person_id per_people_f.person_id%type;
1677: l_forward_from_person_id per_people_f.person_id%type;
1678: l_forward_from_username wf_users.name%type;
1679: l_forward_from_disp_name wf_users.display_name%type;
1680: l_forward_to_person_id per_people_f.person_id%type;

Line 1677: l_forward_from_person_id per_people_f.person_id%type;

1673: -- -------------------------------------------------------------------------
1674: -- local variables
1675: -- -------------------------------------------------------------------------
1676: l_creator_person_id per_people_f.person_id%type;
1677: l_forward_from_person_id per_people_f.person_id%type;
1678: l_forward_from_username wf_users.name%type;
1679: l_forward_from_disp_name wf_users.display_name%type;
1680: l_forward_to_person_id per_people_f.person_id%type;
1681: l_forward_to_username wf_users.name%type;

Line 1680: l_forward_to_person_id per_people_f.person_id%type;

1676: l_creator_person_id per_people_f.person_id%type;
1677: l_forward_from_person_id per_people_f.person_id%type;
1678: l_forward_from_username wf_users.name%type;
1679: l_forward_from_disp_name wf_users.display_name%type;
1680: l_forward_to_person_id per_people_f.person_id%type;
1681: l_forward_to_username wf_users.name%type;
1682: l_forward_to_disp_name wf_users.display_name%type;
1683: l_proc_name varchar2(61) := g_package||'get_next_approver';
1684: l_current_forward_to_id per_people_f.person_id%type;

Line 1684: l_current_forward_to_id per_people_f.person_id%type;

1680: l_forward_to_person_id per_people_f.person_id%type;
1681: l_forward_to_username wf_users.name%type;
1682: l_forward_to_disp_name wf_users.display_name%type;
1683: l_proc_name varchar2(61) := g_package||'get_next_approver';
1684: l_current_forward_to_id per_people_f.person_id%type;
1685: l_current_forward_from_id per_people_f.person_id%type;
1686: --
1687: begin
1688: --

Line 1685: l_current_forward_from_id per_people_f.person_id%type;

1681: l_forward_to_username wf_users.name%type;
1682: l_forward_to_disp_name wf_users.display_name%type;
1683: l_proc_name varchar2(61) := g_package||'get_next_approver';
1684: l_current_forward_to_id per_people_f.person_id%type;
1685: l_current_forward_from_id per_people_f.person_id%type;
1686: --
1687: begin
1688: --
1689: if ( funmode = 'RUN' ) then

Line 1986: currentapproverid in per_people_f.person_id%type,

1982: --
1983: --
1984: procedure Get_Next_Approver ( itemtype in varchar2,
1985: itemkey in varchar2,
1986: currentapproverid in per_people_f.person_id%type,
1987: personid out nocopy per_people_f.person_id%type) is
1988: -- -------------------------------------------------------------------------
1989: -- local variables
1990: -- -------------------------------------------------------------------------

Line 1987: personid out nocopy per_people_f.person_id%type) is

1983: --
1984: procedure Get_Next_Approver ( itemtype in varchar2,
1985: itemkey in varchar2,
1986: currentapproverid in per_people_f.person_id%type,
1987: personid out nocopy per_people_f.person_id%type) is
1988: -- -------------------------------------------------------------------------
1989: -- local variables
1990: -- -------------------------------------------------------------------------
1991: l_creator_person_id per_people_f.person_id%type;

Line 1991: l_creator_person_id per_people_f.person_id%type;

1987: personid out nocopy per_people_f.person_id%type) is
1988: -- -------------------------------------------------------------------------
1989: -- local variables
1990: -- -------------------------------------------------------------------------
1991: l_creator_person_id per_people_f.person_id%type;
1992: BEGIN
1993:
1994: -- -----------------------------------------------------------------------
1995: -- expose the wf control variables to the custom package