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_API dependencies on ECX_TP_HEADERS

Line 50: -- select data from ECX_TP_HEADERS.

46: 'p_party_type',p_party_type);
47: return;
48: end if;
49:
50: -- select data from ECX_TP_HEADERS.
51: Select
52: TP_HEADER_ID,
53: COMPANY_ADMIN_EMAIL,
54: LAST_UPDATED_BY,

Line 66: ECX_TP_HEADERS

62: x_last_update_date,
63: x_created_by,
64: x_creation_date
65: from
66: ECX_TP_HEADERS
67: where party_type = p_party_type
68: and party_id = p_party_id
69: and party_site_id = p_party_site_id;
70:

Line 106: select ecx_tp_headers_s.nextval

102: l_event_name varchar2(250) := null;
103: l_event_key number := -1;
104:
105: cursor c_tp_hdr_id is
106: select ecx_tp_headers_s.nextval
107: from dual;
108:
109: Begin
110:

Line 179: -- Insert data into ECX_TP_HEADERS.

175: open c_tp_hdr_id;
176: fetch c_tp_hdr_id into x_tp_header_id;
177: close c_tp_hdr_id;
178:
179: -- Insert data into ECX_TP_HEADERS.
180: insert into ECX_TP_HEADERS(
181: TP_HEADER_ID,
182: PARTY_TYPE,
183: PARTY_ID,

Line 180: insert into ECX_TP_HEADERS(

176: fetch c_tp_hdr_id into x_tp_header_id;
177: close c_tp_hdr_id;
178:
179: -- Insert data into ECX_TP_HEADERS.
180: insert into ECX_TP_HEADERS(
181: TP_HEADER_ID,
182: PARTY_TYPE,
183: PARTY_ID,
184: PARTY_SITE_ID,

Line 250: l_party_type ecx_tp_headers.party_type%type;

246: l_ret_msg varchar2(2000) := null;
247: l_event_name varchar2(250) := null;
248: l_event_key number := -1;
249:
250: l_party_type ecx_tp_headers.party_type%type;
251: l_party_id number;
252: l_party_site_id number;
253:
254: Begin

Line 280: -- update company_admin_email in ECX_TP_HEADERS.

276: 'p_tp_header_id', p_tp_header_id);
277: return;
278: end if;
279:
280: -- update company_admin_email in ECX_TP_HEADERS.
281: Update ECX_TP_HEADERS set
282: COMPANY_ADMIN_EMAIL = p_company_admin_email,
283: LAST_UPDATED_BY = 0,
284: LAST_UPDATE_DATE = sysdate

Line 281: Update ECX_TP_HEADERS set

277: return;
278: end if;
279:
280: -- update company_admin_email in ECX_TP_HEADERS.
281: Update ECX_TP_HEADERS set
282: COMPANY_ADMIN_EMAIL = p_company_admin_email,
283: LAST_UPDATED_BY = 0,
284: LAST_UPDATE_DATE = sysdate
285: where tp_header_id = p_tp_header_id;

Line 290: 'p_table', 'ecx_tp_headers',

286:
287: if (sql%rowcount = 0) then
288: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
289: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',
290: 'p_table', 'ecx_tp_headers',
291: 'p_param_name', 'Trading partner header ID',
292: 'p_param_id', p_tp_header_id);
293: return;
294: elsif (sql%rowcount > 0) then

Line 301: from ecx_tp_headers

297: party_site_id
298: into l_party_type,
299: l_party_id,
300: l_party_site_id
301: from ecx_tp_headers
302: where tp_header_id = p_tp_header_id;
303:
304: raise_tp_event(
305: x_return_status => l_ret_code,

Line 341: l_party_type ecx_tp_headers.party_type%type;

337: l_ret_code pls_integer := ECX_UTIL_API.G_NO_ERROR;
338: l_ret_msg varchar2(2000) := null;
339: l_event_name varchar2(250) := null;
340: l_event_key number := -1;
341: l_party_type ecx_tp_headers.party_type%type;
342: l_party_id number;
343: l_party_site_id number;
344: l_company_admin_email ecx_tp_headers.company_admin_email%type;
345:

Line 344: l_company_admin_email ecx_tp_headers.company_admin_email%type;

340: l_event_key number := -1;
341: l_party_type ecx_tp_headers.party_type%type;
342: l_party_id number;
343: l_party_site_id number;
344: l_company_admin_email ecx_tp_headers.company_admin_email%type;
345:
346: cursor get_xref_dtl_id is
347: select xref_dtl_id from ecx_xref_dtl
348: where tp_header_id = p_tp_header_id;

Line 390: from ecx_tp_headers

386: into l_party_type,
387: l_party_id,
388: l_party_site_id,
389: l_company_admin_email
390: from ecx_tp_headers
391: where tp_header_id = p_tp_header_id;
392:
393: delete from ecx_tp_headers
394: where tp_header_id = p_tp_header_id;

Line 393: delete from ecx_tp_headers

389: l_company_admin_email
390: from ecx_tp_headers
391: where tp_header_id = p_tp_header_id;
392:
393: delete from ecx_tp_headers
394: where tp_header_id = p_tp_header_id;
395:
396: if (sql%rowcount = 0) then
397: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

Line 399: 'p_table', 'ecx_tp_headers',

395:
396: if (sql%rowcount = 0) then
397: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
398: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_DELETED',
399: 'p_table', 'ecx_tp_headers',
400: 'p_param_name', 'Trading partner header ID',
401: 'p_param_id', p_tp_header_id);
402: return;
403: elsif (sql%rowcount > 0) then

Line 714: ecx_tp_headers eth,

710: x_last_updated_by,
711: x_creation_date,
712: x_last_update_date
713: from ecx_tp_details etd,
714: ecx_tp_headers eth,
715: ecx_mappings em
716: where eth.party_id = p_party_id
717: and eth.party_site_id = p_party_site_id
718: and eth.party_type = p_party_type

Line 786: select 1 from ecx_tp_headers

782: from ecx_hub_users
783: where hub_user_id = p_hub_user_id;
784:
785: Cursor c1 Is
786: select 1 from ecx_tp_headers
787: where tp_header_id = p_tp_header_id;
788:
789: Cursor c2 Is
790: select 1,direction from ecx_ext_processes

Line 2116: This API is called when ecx is synching up the data b/w ecx_tp_headers and the wf directories.

2112: org_role_name varchar2(350);
2113: org_site_role_name varchar2(350);
2114: party_site_loc varchar2(350);
2115: /*
2116: ** This API is called when ecx is synching up the data b/w ecx_tp_headers and the wf directories. **
2117: ** Please refer to the bug 4734256 for details.
2118: */
2119: cursor internal_party_name(v_party_id varchar) is
2120: select LOCATION_CODE from hr_locations where LOCATION_ID=v_party_id;

Line 2145: 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 ;

2141:
2142: cursor customer_site_name(v_party_id varchar,v_party_site_id varchar) is
2143: select ADDRESS1 ||ADDRESS2 || ADDRESS3 || ADDRESS4 ||CITY ||POSTAL_CODE ||STATE ||PROVINCE || COUNTY||COUNTRY from hz_locations where location_id =(select location_id from hz_party_sites where party_id=v_party_id and party_site_id=v_party_site_id);
2144: cursor org_table(v_party_id varchar) is
2145: 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 ;
2146:
2147: cursor org_site_table(v_party_id varchar) is
2148: 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 ;
2149:

Line 2148: 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 ;

2144: cursor org_table(v_party_id varchar) is
2145: 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 ;
2146:
2147: cursor org_site_table(v_party_id varchar) is
2148: 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 ;
2149:
2150:
2151: /* This cursor "orig_site_role" is defined to get the name of the orig_system from wf_local_roles
2152: ** This would be used when we are deleting a Trading Partner**

Line 2153: As the above cursors can not be used, because they are based on the ecx_tp_headers table

2149:
2150:
2151: /* This cursor "orig_site_role" is defined to get the name of the orig_system from wf_local_roles
2152: ** This would be used when we are deleting a Trading Partner**
2153: ** As the above cursors can not be used, because they are based on the ecx_tp_headers table**
2154: */
2155: cursor orig_site_role is
2156: select decode(p_party_type,'C','HZ_PARTY_SITES','EXCHANGE','HZ_PARTY_SITES','CARRIER','HZ_PARTY_SITES','S','PO_VENDOR_SITES','I','HR_LOCATIONS_SITES','B','CE_BANK_BRANCHES_SITE') from dual;
2157: