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.JTF_RS_IMP_RES_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 26: l_transaction_number jtf_rs_resource_extns.transaction_number%TYPE;

22: l_return_status VARCHAR2(1);
23: l_msg_count NUMBER;
24: l_msg_data VARCHAR2(2000);
25:
26: l_transaction_number jtf_rs_resource_extns.transaction_number%TYPE;
27: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
28:
29: l_address1 jtf_rs_resource_extns.source_address1%TYPE;
30: l_address2 jtf_rs_resource_extns.source_address2%TYPE;

Line 29: l_address1 jtf_rs_resource_extns.source_address1%TYPE;

25:
26: l_transaction_number jtf_rs_resource_extns.transaction_number%TYPE;
27: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
28:
29: l_address1 jtf_rs_resource_extns.source_address1%TYPE;
30: l_address2 jtf_rs_resource_extns.source_address2%TYPE;
31: l_address3 jtf_rs_resource_extns.source_address3%TYPE;
32: l_address4 jtf_rs_resource_extns.source_address4%TYPE;
33: l_city jtf_rs_resource_extns.source_city%TYPE;

Line 30: l_address2 jtf_rs_resource_extns.source_address2%TYPE;

26: l_transaction_number jtf_rs_resource_extns.transaction_number%TYPE;
27: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
28:
29: l_address1 jtf_rs_resource_extns.source_address1%TYPE;
30: l_address2 jtf_rs_resource_extns.source_address2%TYPE;
31: l_address3 jtf_rs_resource_extns.source_address3%TYPE;
32: l_address4 jtf_rs_resource_extns.source_address4%TYPE;
33: l_city jtf_rs_resource_extns.source_city%TYPE;
34: l_postal_code jtf_rs_resource_extns.source_postal_code%TYPE;

Line 31: l_address3 jtf_rs_resource_extns.source_address3%TYPE;

27: l_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE;
28:
29: l_address1 jtf_rs_resource_extns.source_address1%TYPE;
30: l_address2 jtf_rs_resource_extns.source_address2%TYPE;
31: l_address3 jtf_rs_resource_extns.source_address3%TYPE;
32: l_address4 jtf_rs_resource_extns.source_address4%TYPE;
33: l_city jtf_rs_resource_extns.source_city%TYPE;
34: l_postal_code jtf_rs_resource_extns.source_postal_code%TYPE;
35: l_state jtf_rs_resource_extns.source_state%TYPE;

Line 32: l_address4 jtf_rs_resource_extns.source_address4%TYPE;

28:
29: l_address1 jtf_rs_resource_extns.source_address1%TYPE;
30: l_address2 jtf_rs_resource_extns.source_address2%TYPE;
31: l_address3 jtf_rs_resource_extns.source_address3%TYPE;
32: l_address4 jtf_rs_resource_extns.source_address4%TYPE;
33: l_city jtf_rs_resource_extns.source_city%TYPE;
34: l_postal_code jtf_rs_resource_extns.source_postal_code%TYPE;
35: l_state jtf_rs_resource_extns.source_state%TYPE;
36: l_province jtf_rs_resource_extns.source_province%TYPE;

Line 33: l_city jtf_rs_resource_extns.source_city%TYPE;

29: l_address1 jtf_rs_resource_extns.source_address1%TYPE;
30: l_address2 jtf_rs_resource_extns.source_address2%TYPE;
31: l_address3 jtf_rs_resource_extns.source_address3%TYPE;
32: l_address4 jtf_rs_resource_extns.source_address4%TYPE;
33: l_city jtf_rs_resource_extns.source_city%TYPE;
34: l_postal_code jtf_rs_resource_extns.source_postal_code%TYPE;
35: l_state jtf_rs_resource_extns.source_state%TYPE;
36: l_province jtf_rs_resource_extns.source_province%TYPE;
37: l_county jtf_rs_resource_extns.source_county%TYPE;

Line 34: l_postal_code jtf_rs_resource_extns.source_postal_code%TYPE;

30: l_address2 jtf_rs_resource_extns.source_address2%TYPE;
31: l_address3 jtf_rs_resource_extns.source_address3%TYPE;
32: l_address4 jtf_rs_resource_extns.source_address4%TYPE;
33: l_city jtf_rs_resource_extns.source_city%TYPE;
34: l_postal_code jtf_rs_resource_extns.source_postal_code%TYPE;
35: l_state jtf_rs_resource_extns.source_state%TYPE;
36: l_province jtf_rs_resource_extns.source_province%TYPE;
37: l_county jtf_rs_resource_extns.source_county%TYPE;
38: l_country jtf_rs_resource_extns.source_country%TYPE;

Line 35: l_state jtf_rs_resource_extns.source_state%TYPE;

31: l_address3 jtf_rs_resource_extns.source_address3%TYPE;
32: l_address4 jtf_rs_resource_extns.source_address4%TYPE;
33: l_city jtf_rs_resource_extns.source_city%TYPE;
34: l_postal_code jtf_rs_resource_extns.source_postal_code%TYPE;
35: l_state jtf_rs_resource_extns.source_state%TYPE;
36: l_province jtf_rs_resource_extns.source_province%TYPE;
37: l_county jtf_rs_resource_extns.source_county%TYPE;
38: l_country jtf_rs_resource_extns.source_country%TYPE;
39:

Line 36: l_province jtf_rs_resource_extns.source_province%TYPE;

32: l_address4 jtf_rs_resource_extns.source_address4%TYPE;
33: l_city jtf_rs_resource_extns.source_city%TYPE;
34: l_postal_code jtf_rs_resource_extns.source_postal_code%TYPE;
35: l_state jtf_rs_resource_extns.source_state%TYPE;
36: l_province jtf_rs_resource_extns.source_province%TYPE;
37: l_county jtf_rs_resource_extns.source_county%TYPE;
38: l_country jtf_rs_resource_extns.source_country%TYPE;
39:
40: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE ;

Line 37: l_county jtf_rs_resource_extns.source_county%TYPE;

33: l_city jtf_rs_resource_extns.source_city%TYPE;
34: l_postal_code jtf_rs_resource_extns.source_postal_code%TYPE;
35: l_state jtf_rs_resource_extns.source_state%TYPE;
36: l_province jtf_rs_resource_extns.source_province%TYPE;
37: l_county jtf_rs_resource_extns.source_county%TYPE;
38: l_country jtf_rs_resource_extns.source_country%TYPE;
39:
40: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE ;
41: l_resource_id jtf_rs_resource_extns.resource_id%TYPE ;

Line 38: l_country jtf_rs_resource_extns.source_country%TYPE;

34: l_postal_code jtf_rs_resource_extns.source_postal_code%TYPE;
35: l_state jtf_rs_resource_extns.source_state%TYPE;
36: l_province jtf_rs_resource_extns.source_province%TYPE;
37: l_county jtf_rs_resource_extns.source_county%TYPE;
38: l_country jtf_rs_resource_extns.source_country%TYPE;
39:
40: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE ;
41: l_resource_id jtf_rs_resource_extns.resource_id%TYPE ;
42: l_resource_number jtf_rs_resource_extns.resource_number%TYPE ;

Line 40: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE ;

36: l_province jtf_rs_resource_extns.source_province%TYPE;
37: l_county jtf_rs_resource_extns.source_county%TYPE;
38: l_country jtf_rs_resource_extns.source_country%TYPE;
39:
40: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE ;
41: l_resource_id jtf_rs_resource_extns.resource_id%TYPE ;
42: l_resource_number jtf_rs_resource_extns.resource_number%TYPE ;
43: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
44:

Line 41: l_resource_id jtf_rs_resource_extns.resource_id%TYPE ;

37: l_county jtf_rs_resource_extns.source_county%TYPE;
38: l_country jtf_rs_resource_extns.source_country%TYPE;
39:
40: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE ;
41: l_resource_id jtf_rs_resource_extns.resource_id%TYPE ;
42: l_resource_number jtf_rs_resource_extns.resource_number%TYPE ;
43: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
44:
45: l_source_number jtf_rs_resource_extns.source_number%TYPE;

Line 42: l_resource_number jtf_rs_resource_extns.resource_number%TYPE ;

38: l_country jtf_rs_resource_extns.source_country%TYPE;
39:
40: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE ;
41: l_resource_id jtf_rs_resource_extns.resource_id%TYPE ;
42: l_resource_number jtf_rs_resource_extns.resource_number%TYPE ;
43: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
44:
45: l_source_number jtf_rs_resource_extns.source_number%TYPE;
46: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

Line 45: l_source_number jtf_rs_resource_extns.source_number%TYPE;

41: l_resource_id jtf_rs_resource_extns.resource_id%TYPE ;
42: l_resource_number jtf_rs_resource_extns.resource_number%TYPE ;
43: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
44:
45: l_source_number jtf_rs_resource_extns.source_number%TYPE;
46: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
47:
48: -- fetching the role_type_code in this cursor also so that if salesrep is not created then
49: -- do not create roles of type SALES_COMP -- bug 3579147