APPS.ECX_TP_API dependencies on DUAL

Line 107: from dual;

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:
111: x_return_status := ECX_UTIL_API.G_NO_ERROR;

Line 852: from dual;

848: protocol_type= p_protocol_type;
849:
850: Cursor c_tp_dtl_id is
851: select ecx_tp_details_s.nextval
852: from dual;
853:
854: num number := 0;
855: i_map_id number:=0;
856: encrypt_password ecx_tp_details.password%type;

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

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:
2158: cursor orig_role is
2159: select decode(p_party_type,'C','HZ_PARTIES','EXCHANGE','HZ_PARTIES','CARRIER','HZ_PARTIES','S','PO_VENDORS','I','HR_LOCATIONS','B','CE_BANK_BRANCHES_V') from dual;
2160:

Line 2159: select decode(p_party_type,'C','HZ_PARTIES','EXCHANGE','HZ_PARTIES','CARRIER','HZ_PARTIES','S','PO_VENDORS','I','HR_LOCATIONS','B','CE_BANK_BRANCHES_V') from dual;

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:
2158: cursor orig_role is
2159: select decode(p_party_type,'C','HZ_PARTIES','EXCHANGE','HZ_PARTIES','CARRIER','HZ_PARTIES','S','PO_VENDORS','I','HR_LOCATIONS','B','CE_BANK_BRANCHES_V') from dual;
2160:
2161: begin
2162: x_return_status := ECX_UTIL_API.G_NO_ERROR;
2163: x_msg := null;