APPS.ECX_TP_API dependencies on ECX_TP_DETAILS_S

Line 773: l_source_tp_location_code ecx_tp_details.source_tp_location_code%type;

769:
770: l_confirmation ecx_tp_details.confirmation%type;
771: l_connection_type ecx_tp_details.connection_type%type;
772: l_hub_user_id ecx_hub_users.hub_user_id%type;
773: l_source_tp_location_code ecx_tp_details.source_tp_location_code%type;
774:
775: cursor get_src_loc_code (i_hub_id IN pls_integer) is
776: select name
777: from ecx_hubs

Line 851: select ecx_tp_details_s.nextval

847: where name=p_connection_type and
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;

Line 1444: l_source_tp_location_code ecx_tp_details.source_tp_location_code%type;

1440: ) Is
1441:
1442: l_confirmation ecx_tp_details.confirmation%type;
1443: l_connection_type ecx_tp_details.connection_type%type;
1444: l_source_tp_location_code ecx_tp_details.source_tp_location_code%type;
1445: i_passupd_flag varchar2(1);
1446:
1447: cursor get_src_loc_code (i_hub_id IN pls_integer) is
1448: select name

Line 1754: Update ECX_TP_DETAILS set

1750: End If;
1751: -- update ECX_TP_DETAILS.
1752: if (i_passupd_flag = 'Y')
1753: then
1754: Update ECX_TP_DETAILS set
1755: MAP_ID = i_map_id,
1756: EXT_PROCESS_ID = p_ext_process_id,
1757: CONNECTION_TYPE = l_connection_type,
1758: HUB_USER_ID = null,

Line 1773: Update ECX_TP_DETAILS set

1769: LAST_UPDATE_DATE = sysdate
1770: where tp_detail_id = p_tp_detail_id;
1771: elsif (i_passupd_flag = 'N')
1772: then
1773: Update ECX_TP_DETAILS set
1774: MAP_ID = i_map_id,
1775: EXT_PROCESS_ID = p_ext_process_id,
1776: CONNECTION_TYPE = l_connection_type,
1777: HUB_USER_ID = null,

Line 1865: Update ECX_TP_DETAILS set

1861:
1862: -- update ECX_TP_DETAILS.
1863: if (i_passupd_flag = 'Y')
1864: then
1865: Update ECX_TP_DETAILS set
1866: MAP_ID = i_map_id,
1867: EXT_PROCESS_ID = p_ext_process_id,
1868: CONNECTION_TYPE = p_connection_type,
1869: HUB_USER_ID = p_hub_user_id,

Line 1883: Update ECX_TP_DETAILS set

1879: LAST_UPDATE_DATE = sysdate
1880: where tp_detail_id = p_tp_detail_id;
1881: elsif (i_passupd_flag = 'N')
1882: then
1883: Update ECX_TP_DETAILS set
1884: MAP_ID = i_map_id,
1885: EXT_PROCESS_ID = p_ext_process_id,
1886: CONNECTION_TYPE = p_connection_type,
1887: HUB_USER_ID = p_hub_user_id,

Line 1959: Update ECX_TP_DETAILS set

1955:
1956: -- update ECX_TP_DETAILS.
1957: if (i_passupd_flag = 'Y')
1958: then
1959: Update ECX_TP_DETAILS set
1960: MAP_ID = i_map_id,
1961: EXT_PROCESS_ID = p_ext_process_id,
1962: CONNECTION_TYPE = null,
1963: HUB_USER_ID = null,

Line 1979: Update ECX_TP_DETAILS set

1975: where tp_detail_id = p_tp_detail_id;
1976:
1977: elsif (i_passupd_flag = 'N')
1978: then
1979: Update ECX_TP_DETAILS set
1980: MAP_ID = i_map_id,
1981: EXT_PROCESS_ID = p_ext_process_id,
1982: CONNECTION_TYPE = null,
1983: HUB_USER_ID = null,