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_DETAILS

Line 372: delete from ecx_tp_details

368: open get_xref_dtl_id;
369: fetch get_xref_dtl_id into l_xref_dtl_id;
370: close get_xref_dtl_id;
371:
372: delete from ecx_tp_details
373: where tp_header_id = p_tp_header_id;
374:
375: delete from ecx_xref_dtl
376: where tp_header_id = p_tp_header_id;

Line 513: from ecx_tp_details etd,

509: x_created_by ,
510: x_last_updated_by ,
511: x_creation_date,
512: x_last_update_date
513: from ecx_tp_details etd,
514: ecx_mappings em
515: where etd.tp_header_id = p_tp_header_id
516: and etd.ext_process_id = p_ext_process_id
517: and em.map_id = etd.map_id

Line 713: from ecx_tp_details etd,

709: x_created_by,
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

Line 770: l_confirmation ecx_tp_details.confirmation%type;

766: p_external_tp_location_code IN Varchar2,
767: p_confirmation IN pls_integer
768: )IS
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:

Line 771: l_connection_type ecx_tp_details.connection_type%type;

767: p_confirmation IN pls_integer
768: )IS
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

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 802: select 1 from ecx_tp_details

798: select 1 from ecx_hub_users
799: where hub_user_id = p_hub_user_id;
800:
801: Cursor c5 Is
802: select 1 from ecx_tp_details
803: where tp_detail_id = p_routing_id;
804:
805: /* Start changes for bug #2183619 */
806: Cursor c6(p_ext_type_in VARCHAR2,p_ext_subtype_in VARCHAR2,

Line 809: Select 1 from ecx_tp_details tp,ecx_ext_processes ep

805: /* Start changes for bug #2183619 */
806: Cursor c6(p_ext_type_in VARCHAR2,p_ext_subtype_in VARCHAR2,
807: p_standard_id_in NUMBER,p_direction_in VARCHAR2,
808: p_source_tp_location_code_in VARCHAR2) Is
809: Select 1 from ecx_tp_details tp,ecx_ext_processes ep
810: where tp.ext_process_id=ep.ext_process_id
811: And ep.ext_type = p_ext_type_in
812: And ep.ext_subtype = p_ext_subtype_in
813: And ep.standard_id = p_standard_id_in

Line 819: select 1 from ecx_tp_details

815: And ep.direction = p_direction_in ;
816:
817: Cursor c7(p_tp_header_id_in NUMBER,p_transaction_type_in VARCHAR2,
818: p_transaction_subtype_in VARCHAR2) is
819: select 1 from ecx_tp_details
820: where tp_header_id = p_tp_header_id_in
821: and ext_process_id in ( select ext.ext_process_id
822: from ecx_ext_processes ext,
823: ecx_transactions tran

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 856: encrypt_password ecx_tp_details.password%type;

852: from dual;
853:
854: num number := 0;
855: i_map_id number:=0;
856: encrypt_password ecx_tp_details.password%type;
857: i_direction ecx_ext_processes.direction%type;
858:
859: /* Added declartions for Bug #2183619 */
860: p_ext_type varchar2(80);

Line 1026: -- insert data into ECX_TP_DETAILS.

1022: open c_tp_dtl_id;
1023: fetch c_tp_dtl_id into x_tp_detail_id;
1024: close c_tp_dtl_id;
1025:
1026: -- insert data into ECX_TP_DETAILS.
1027: Insert into ECX_TP_DETAILS(
1028: TP_HEADER_ID,
1029: TP_DETAIL_ID,
1030: MAP_ID,

Line 1027: Insert into ECX_TP_DETAILS(

1023: fetch c_tp_dtl_id into x_tp_detail_id;
1024: close c_tp_dtl_id;
1025:
1026: -- insert data into ECX_TP_DETAILS.
1027: Insert into ECX_TP_DETAILS(
1028: TP_HEADER_ID,
1029: TP_DETAIL_ID,
1030: MAP_ID,
1031: EXT_PROCESS_ID,

Line 1139: -- insert data into ECX_TP_DETAILS.

1135: open c_tp_dtl_id;
1136: fetch c_tp_dtl_id into x_tp_detail_id;
1137: close c_tp_dtl_id;
1138:
1139: -- insert data into ECX_TP_DETAILS.
1140: Insert into ECX_TP_DETAILS(
1141: TP_HEADER_ID,
1142: TP_DETAIL_ID,
1143: MAP_ID,

Line 1140: Insert into ECX_TP_DETAILS(

1136: fetch c_tp_dtl_id into x_tp_detail_id;
1137: close c_tp_dtl_id;
1138:
1139: -- insert data into ECX_TP_DETAILS.
1140: Insert into ECX_TP_DETAILS(
1141: TP_HEADER_ID,
1142: TP_DETAIL_ID,
1143: MAP_ID,
1144: EXT_PROCESS_ID,

Line 1231: -- insert data into ECX_TP_DETAILS.

1227: open c_tp_dtl_id;
1228: fetch c_tp_dtl_id into x_tp_detail_id;
1229: close c_tp_dtl_id;
1230:
1231: -- insert data into ECX_TP_DETAILS.
1232: Insert into ECX_TP_DETAILS(
1233: TP_HEADER_ID,
1234: TP_DETAIL_ID,
1235: MAP_ID,

Line 1232: Insert into ECX_TP_DETAILS(

1228: fetch c_tp_dtl_id into x_tp_detail_id;
1229: close c_tp_dtl_id;
1230:
1231: -- insert data into ECX_TP_DETAILS.
1232: Insert into ECX_TP_DETAILS(
1233: TP_HEADER_ID,
1234: TP_DETAIL_ID,
1235: MAP_ID,
1236: EXT_PROCESS_ID,

Line 1442: l_confirmation ecx_tp_details.confirmation%type;

1438: p_confirmation In pls_integer ,
1439: p_passupd_flag IN varchar2
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:

Line 1443: l_connection_type ecx_tp_details.connection_type%type;

1439: p_passupd_flag IN varchar2
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

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 1466: select 1 from ecx_tp_details

1462: select direction from ecx_ext_processes
1463: where ext_process_id = p_ext_process_id;
1464:
1465: cursor c3 is
1466: select 1 from ecx_tp_details
1467: where tp_detail_id = p_tp_detail_id;
1468:
1469: Cursor c4 Is
1470: select 1 from ecx_hub_users

Line 1474: select 1 from ecx_tp_details

1470: select 1 from ecx_hub_users
1471: where hub_user_id = p_hub_user_id;
1472:
1473: Cursor c5 Is
1474: select 1 from ecx_tp_details
1475: where tp_detail_id = p_routing_id;
1476:
1477: /* Start changes for bug #2183619 */
1478: Cursor c6(p_ext_type_in VARCHAR2,p_ext_subtype_in VARCHAR2,

Line 1482: Select tp_detail_id from ecx_tp_details tp,ecx_ext_processes ep

1478: Cursor c6(p_ext_type_in VARCHAR2,p_ext_subtype_in VARCHAR2,
1479: p_standard_id_in NUMBER,p_direction_in VARCHAR2,
1480: p_source_tp_location_code_in VARCHAR2,
1481: p_tp_detail_id_in NUMBER) Is
1482: Select tp_detail_id from ecx_tp_details tp,ecx_ext_processes ep
1483: where tp.ext_process_id=ep.ext_process_id
1484: And ep.ext_type = p_ext_type_in
1485: And ep.ext_subtype = p_ext_subtype_in
1486: And ep.standard_id = p_standard_id_in

Line 1494: select 1 from ecx_tp_details

1490:
1491: Cursor c7(p_tp_header_id_in NUMBER,p_tp_detail_id_in NUMBER,
1492: p_transaction_type_in VARCHAR2,
1493: p_transaction_subtype_in VARCHAR2) is
1494: select 1 from ecx_tp_details
1495: where tp_header_id = p_tp_header_id_in
1496: and tp_detail_id <> p_tp_detail_id_in
1497: and ext_process_id in ( select ext.ext_process_id
1498: from ecx_ext_processes ext,

Line 1520: from ecx_tp_details

1516: and et.transaction_id = eep.transaction_id;
1517:
1518: Cursor c10 (p_tp_detail_id_in NUMBER) is
1519: select tp_header_id
1520: from ecx_tp_details
1521: where tp_detail_id=p_tp_detail_id_in;
1522:
1523: /* Bug #2449729 , cursor to retrieve hub_id */
1524: Cursor c11 is

Line 1531: encrypt_password ecx_tp_details.password%type;

1527: protocol_type= p_protocol_type;
1528:
1529: /* End of changes for bug #2183619*/
1530:
1531: encrypt_password ecx_tp_details.password%type;
1532: num number := 0;
1533: i_map_id number :=0;
1534: i_direction varchar2(5):= null;
1535: --Bug #2183619

Line 1751: -- update ECX_TP_DETAILS.

1747: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
1748: x_msg := ecx_debug.getTranslatedMessage('ECX_LOCATION_NOT_NULL');
1749: return;
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,

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 1793: 'p_table', 'ecx_tp_details',

1789:
1790: if (sql%rowcount = 0) then
1791: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
1792: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',
1793: 'p_table', 'ecx_tp_details',
1794: 'p_param_name', 'Trading partner detail ID',
1795: 'p_param_id', p_tp_detail_id);
1796: return;
1797: end if;

Line 1862: -- update ECX_TP_DETAILS.

1858: return;
1859: end if;
1860: end if;
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,

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 1902: 'p_table', 'ecx_tp_details',

1898:
1899: if (sql%rowcount = 0) then
1900: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
1901: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',
1902: 'p_table', 'ecx_tp_details',
1903: 'p_param_name', 'Trading partner detail ID',
1904: 'p_param_id', p_tp_detail_id);
1905: return;
1906: end if;

Line 1956: -- update ECX_TP_DETAILS.

1952: return;
1953: end if;
1954: /* End of changes for bug #2183619*/
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,

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,

Line 1999: 'p_table', 'ecx_tp_details',

1995:
1996: if (sql%rowcount = 0) then
1997: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
1998: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',
1999: 'p_table', 'ecx_tp_details',
2000: 'p_param_name', 'Trading partner detail ID',
2001: 'p_param_id', p_tp_detail_id);
2002: return;
2003: end if;

Line 2026: delete from ecx_tp_details

2022: x_msg := ecx_debug.getTranslatedMessage('ECX_TP_DTL_ID_NOT_NULL');
2023: return;
2024: End If;
2025:
2026: delete from ecx_tp_details
2027: where tp_detail_id = p_tp_detail_id;
2028:
2029: if (sql%rowcount = 0) then
2030: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

Line 2032: 'p_table', 'ecx_tp_details',

2028:
2029: if (sql%rowcount = 0) then
2030: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
2031: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_DELETED',
2032: 'p_table', 'ecx_tp_details',
2033: 'p_param_name', 'Trading partner detail ID',
2034: 'p_param_id', p_tp_detail_id);
2035: return;
2036: end if;