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.ECX_TP_SYNCH dependencies on ECX_TP_HEADERS

Line 7: TYPE t_party_id_tl is TABLE of ecx_tp_headers.party_id%type;

3: procedure synch_ecx_tp
4:
5: IS
6:
7: TYPE t_party_id_tl is TABLE of ecx_tp_headers.party_id%type;
8: TYPE t_orig_system_id_tl is TABLE of wf_local_roles.orig_system_id%type;
9: TYPE t_party_site_id_tl is TABLE of ecx_tp_headers.party_site_id%type;
10:
11: v_party_id_tl t_party_id_tl;

Line 9: TYPE t_party_site_id_tl is TABLE of ecx_tp_headers.party_site_id%type;

5: IS
6:
7: TYPE t_party_id_tl is TABLE of ecx_tp_headers.party_id%type;
8: TYPE t_orig_system_id_tl is TABLE of wf_local_roles.orig_system_id%type;
9: TYPE t_party_site_id_tl is TABLE of ecx_tp_headers.party_site_id%type;
10:
11: v_party_id_tl t_party_id_tl;
12:
13: V_PARTY_SITE_ID_TL ecx_tp_headers.party_site_id%type;

Line 13: V_PARTY_SITE_ID_TL ecx_tp_headers.party_site_id%type;

9: TYPE t_party_site_id_tl is TABLE of ecx_tp_headers.party_site_id%type;
10:
11: v_party_id_tl t_party_id_tl;
12:
13: V_PARTY_SITE_ID_TL ecx_tp_headers.party_site_id%type;
14: V_PARTY_TYPE_TL ecx_tp_headers.party_type%type;
15:
16: P_COMPANY_EMAIL_ADDR varchar2(320);
17: l_event_name varchar2(250);

Line 14: V_PARTY_TYPE_TL ecx_tp_headers.party_type%type;

10:
11: v_party_id_tl t_party_id_tl;
12:
13: V_PARTY_SITE_ID_TL ecx_tp_headers.party_site_id%type;
14: V_PARTY_TYPE_TL ecx_tp_headers.party_type%type;
15:
16: P_COMPANY_EMAIL_ADDR varchar2(320);
17: l_event_name varchar2(250);
18:

Line 27: select party_id from ecx_tp_headers;

23: org_site_table_name varchar2(350);
24: site_name varchar2(350);
25:
26: cursor get_party_id is
27: select party_id from ecx_tp_headers;
28:
29: cursor get_mail(p_party_id in ecx_tp_headers.party_id%type) is
30: select company_admin_email from ecx_tp_headers where party_id=p_party_id;
31:

Line 29: cursor get_mail(p_party_id in ecx_tp_headers.party_id%type) is

25:
26: cursor get_party_id is
27: select party_id from ecx_tp_headers;
28:
29: cursor get_mail(p_party_id in ecx_tp_headers.party_id%type) is
30: select company_admin_email from ecx_tp_headers where party_id=p_party_id;
31:
32: cursor get_party_type(p_party_id in ecx_tp_headers.party_id%type) is
33: select party_type from ecx_tp_headers where party_id=p_party_id;

Line 30: select company_admin_email from ecx_tp_headers where party_id=p_party_id;

26: cursor get_party_id is
27: select party_id from ecx_tp_headers;
28:
29: cursor get_mail(p_party_id in ecx_tp_headers.party_id%type) is
30: select company_admin_email from ecx_tp_headers where party_id=p_party_id;
31:
32: cursor get_party_type(p_party_id in ecx_tp_headers.party_id%type) is
33: select party_type from ecx_tp_headers where party_id=p_party_id;
34:

Line 32: cursor get_party_type(p_party_id in ecx_tp_headers.party_id%type) is

28:
29: cursor get_mail(p_party_id in ecx_tp_headers.party_id%type) is
30: select company_admin_email from ecx_tp_headers where party_id=p_party_id;
31:
32: cursor get_party_type(p_party_id in ecx_tp_headers.party_id%type) is
33: select party_type from ecx_tp_headers where party_id=p_party_id;
34:
35: cursor get_party_site_id(p_party_id in ecx_tp_headers.party_id%type) is
36: select party_site_id from ecx_tp_headers where party_id=p_party_id;

Line 33: select party_type from ecx_tp_headers where party_id=p_party_id;

29: cursor get_mail(p_party_id in ecx_tp_headers.party_id%type) is
30: select company_admin_email from ecx_tp_headers where party_id=p_party_id;
31:
32: cursor get_party_type(p_party_id in ecx_tp_headers.party_id%type) is
33: select party_type from ecx_tp_headers where party_id=p_party_id;
34:
35: cursor get_party_site_id(p_party_id in ecx_tp_headers.party_id%type) is
36: select party_site_id from ecx_tp_headers where party_id=p_party_id;
37:

Line 35: cursor get_party_site_id(p_party_id in ecx_tp_headers.party_id%type) is

31:
32: cursor get_party_type(p_party_id in ecx_tp_headers.party_id%type) is
33: select party_type from ecx_tp_headers where party_id=p_party_id;
34:
35: cursor get_party_site_id(p_party_id in ecx_tp_headers.party_id%type) is
36: select party_site_id from ecx_tp_headers where party_id=p_party_id;
37:
38: cursor internal_party_name(v_party_id varchar) is
39: select LOCATION_CODE from hr_locations where LOCATION_ID=v_party_id ;

Line 36: select party_site_id from ecx_tp_headers where party_id=p_party_id;

32: cursor get_party_type(p_party_id in ecx_tp_headers.party_id%type) is
33: select party_type from ecx_tp_headers where party_id=p_party_id;
34:
35: cursor get_party_site_id(p_party_id in ecx_tp_headers.party_id%type) is
36: select party_site_id from ecx_tp_headers where party_id=p_party_id;
37:
38: cursor internal_party_name(v_party_id varchar) is
39: select LOCATION_CODE from hr_locations where LOCATION_ID=v_party_id ;
40:

Line 68: select decode(party_type,'C','HZ_PARTIES','EXCHANGE','HZ_PARTIES','CARRIER','HZ_PARTIES','S','PO_VENDORS','I','HR_LOCATIONS','B','CE_BANK_BRANCHES_V') from ecx_tp_headers where party_id =v_party_id ;

64: STATE ||' '||PROVINCE ||' '||COUNTY||' '||COUNTRY from hz_locations
65: where location_id =(select location_id from hz_party_sites where party_id=v_party_id and party_site_id=v_party_site_id);
66:
67: cursor org_table(v_party_id varchar) is
68: select decode(party_type,'C','HZ_PARTIES','EXCHANGE','HZ_PARTIES','CARRIER','HZ_PARTIES','S','PO_VENDORS','I','HR_LOCATIONS','B','CE_BANK_BRANCHES_V') from ecx_tp_headers where party_id =v_party_id ;
69:
70: cursor org_table_site(v_party_id varchar) is
71: select decode(party_type,'C','HZ_PARTY_SITES','EXCHANGE','HZ_PARTY_SITES','CARRIER','HZ_PARTY_SITES','S','PO_VENDOR_SITES_ALL','I','HR_LOCATIONS_SITES','B','CE_BANK_BRANCHES_SITE') from ecx_tp_headers where party_id =v_party_id ;
72:

Line 71: select decode(party_type,'C','HZ_PARTY_SITES','EXCHANGE','HZ_PARTY_SITES','CARRIER','HZ_PARTY_SITES','S','PO_VENDOR_SITES_ALL','I','HR_LOCATIONS_SITES','B','CE_BANK_BRANCHES_SITE') from ecx_tp_headers where party_id =v_party_id ;

67: cursor org_table(v_party_id varchar) is
68: select decode(party_type,'C','HZ_PARTIES','EXCHANGE','HZ_PARTIES','CARRIER','HZ_PARTIES','S','PO_VENDORS','I','HR_LOCATIONS','B','CE_BANK_BRANCHES_V') from ecx_tp_headers where party_id =v_party_id ;
69:
70: cursor org_table_site(v_party_id varchar) is
71: select decode(party_type,'C','HZ_PARTY_SITES','EXCHANGE','HZ_PARTY_SITES','CARRIER','HZ_PARTY_SITES','S','PO_VENDOR_SITES_ALL','I','HR_LOCATIONS_SITES','B','CE_BANK_BRANCHES_SITE') from ecx_tp_headers where party_id =v_party_id ;
72:
73:
74: begin
75: OPEN get_party_id;