APPS.EGO_ICC_BULKLOAD_PVT dependencies on EGO_ICC_VERS_INTERFACE

Line 388: FROM EGO_ICC_VERS_INTERFACE EIVI

384: ,G_CONC_REQUEST_ID
385: ,G_PROG_APPL_ID
386: ,G_PROGRAM_ID
387: ,l_sysdate
388: FROM EGO_ICC_VERS_INTERFACE EIVI
389: WHERE ( EIVI.transaction_type IS NULL OR
390: EIVI.transaction_type NOT IN ( G_TTYPE_CREATE )
391: )
392: AND (

Line 400: UPDATE EGO_ICC_VERS_INTERFACE EIVI

396: )
397: AND EIVI.process_status = G_PROCESS_STATUS_INITIAL
398: ;
399:
400: UPDATE EGO_ICC_VERS_INTERFACE EIVI
401: SET EIVI.process_status = G_PROCESS_STATUS_ERROR
402: WHERE ( EIVI.transaction_type IS NULL OR
403: EIVI.transaction_type <> G_TTYPE_CREATE
404: )

Line 768: FROM EGO_ICC_VERS_INTERFACE eivi

764: ,G_CONC_REQUEST_ID
765: ,G_PROG_APPL_ID
766: ,G_PROGRAM_ID
767: ,l_sysdate
768: FROM EGO_ICC_VERS_INTERFACE eivi
769: where (
770: ( G_SET_PROCESS_ID IS NULL )
771: OR
772: ( eivi.set_process_id = G_SET_PROCESS_ID)

Line 777: UPDATE EGO_ICC_VERS_INTERFACE eivi

773: )
774: AND eivi.process_status = G_PROCESS_STATUS_INITIAL
775: ;
776:
777: UPDATE EGO_ICC_VERS_INTERFACE eivi
778: SET eivi.process_status = G_PROCESS_STATUS_ERROR
779: where (
780: ( G_SET_PROCESS_ID IS NULL )
781: OR

Line 839: FROM EGO_ICC_VERS_INTERFACE eivi

835: ,G_CONC_REQUEST_ID
836: ,G_PROG_APPL_ID
837: ,G_PROGRAM_ID
838: ,l_sysdate
839: FROM EGO_ICC_VERS_INTERFACE eivi
840: where (
841: ( eivi.item_catalog_name IS NULL AND
842: eivi.item_catalog_group_id IS NULL
843: )

Line 853: UPDATE EGO_ICC_VERS_INTERFACE eivi

849: )
850: AND eivi.process_status = G_PROCESS_STATUS_INITIAL
851: ;
852:
853: UPDATE EGO_ICC_VERS_INTERFACE eivi
854: SET eivi.process_status = G_PROCESS_STATUS_ERROR
855: where (
856: ( eivi.item_catalog_name IS NULL AND
857: eivi.item_catalog_group_id IS NULL

Line 915: FROM ego_icc_vers_interface eivi

911: ,G_CONC_REQUEST_ID
912: ,G_PROG_APPL_ID
913: ,G_PROGRAM_ID
914: ,l_sysdate
915: FROM ego_icc_vers_interface eivi
916: WHERE 1=1
917: AND ---( eivi.ver_seq_no <= 0 ---- commented bug 9752139, moved to row by row
918: --- OR
919: eivi.ver_seq_no IS NULL

Line 930: UPDATE EGO_ICC_VERS_INTERFACE eivi

926: ( eivi.set_process_id = G_SET_PROCESS_ID)
927: );
928:
929:
930: UPDATE EGO_ICC_VERS_INTERFACE eivi
931: SET eivi.process_status = G_PROCESS_STATUS_ERROR
932: WHERE 1=1
933: AND ---( eivi.ver_seq_no <= 0 ---- commented bug 9752139, moved to row by row
934: --- OR

Line 1989: UPDATE EGO_ICC_VERS_INTERFACE eivi

1985: ---
1986: If p_entity = G_ENTITY_ICC_VERSION THEN
1987: --- ICC versions table , ICC Name
1988:
1989: UPDATE EGO_ICC_VERS_INTERFACE eivi
1990: SET eivi.item_catalog_name = ( select icc_kfv.concatenated_segments
1991: from mtl_item_catalog_groups_kfv icc_kfv
1992: where icc_kfv.item_catalog_group_id = eivi.item_catalog_group_id
1993: )

Line 2005: UPDATE ego_icc_vers_interface eivi

2001: ;
2002:
2003: write_debug(l_proc_name, 'updated name');
2004:
2005: UPDATE ego_icc_vers_interface eivi
2006: SET eivi.item_catalog_group_id = ( select icc_kfv.item_catalog_group_id
2007: from mtl_item_catalog_groups_kfv icc_kfv
2008: where icc_kfv.concatenated_segments = eivi.item_catalog_name
2009: )

Line 2071: FROM ego_icc_vers_interface eivi

2067: ,G_CONC_REQUEST_ID
2068: ,G_PROG_APPL_ID
2069: ,G_PROGRAM_ID
2070: ,l_sysdate
2071: FROM ego_icc_vers_interface eivi
2072: WHERE ( eivi.item_catalog_group_id IS NULL
2073: OR
2074: eivi.item_catalog_name IS NULL
2075: )

Line 2088: UPDATE ego_icc_vers_interface eivi

2084: write_debug(l_proc_name, 'inserted into errors=>'||SQL%ROWCOUNT);
2085:
2086: --- update status flag in ICC interface table
2087:
2088: UPDATE ego_icc_vers_interface eivi
2089: set process_status = G_PROCESS_STATUS_ERROR
2090: WHERE ( eivi.item_catalog_group_id IS NULL
2091: OR
2092: eivi.item_catalog_name IS NULL

Line 6589: UPDATE EGO_ICC_VERS_INTERFACE eivi

6585: l_proc_name VARCHAR2(50) := 'update_icc_id_name';
6586: BEGIN
6587:
6588: write_debug(l_proc_name, 'updating name');
6589: UPDATE EGO_ICC_VERS_INTERFACE eivi
6590: SET eivi.item_catalog_name = ( select icc_kfv.concatenated_segments
6591: from mtl_item_catalog_groups_kfv icc_kfv
6592: where icc_kfv.item_catalog_group_id = eivi.item_catalog_group_id
6593: )

Line 6607: UPDATE ego_icc_vers_interface eivi

6603:
6604:
6605: write_debug(l_proc_name, 'updating id');
6606:
6607: UPDATE ego_icc_vers_interface eivi
6608: SET eivi.item_catalog_group_id = ( select icc_kfv.item_catalog_group_id
6609: from mtl_item_catalog_groups_kfv icc_kfv
6610: where icc_kfv.concatenated_segments = eivi.item_catalog_name
6611: )

Line 8408: UPDATE EGO_ICC_VERS_INTERFACE

8404: l_transaction_id_tbl(i) := p_icc_vers_tbl(i).transaction_id;
8405: END LOOP;
8406:
8407: FORALL i in 1..p_icc_vers_tbl.COUNT
8408: UPDATE EGO_ICC_VERS_INTERFACE
8409: set ROW = p_icc_vers_tbl(i)
8410: WHERE transaction_id = l_transaction_id_tbl(i)
8411: AND process_status = G_PROCESS_STATUS_INITIAL
8412: ;

Line 9309: FROM EGO_ICC_VERS_INTERFACE

9305: ---
9306: CURSOR cur_icc_versions
9307: is
9308: SELECT *
9309: FROM EGO_ICC_VERS_INTERFACE
9310: WHERE process_status = G_PROCESS_STATUS_INITIAL
9311: AND (
9312: ( G_SET_PROCESS_ID IS NULL )
9313: OR

Line 9800: UPDATE EGO_ICC_VERS_INTERFACE

9796:
9797:
9798: write_debug(l_proc_name,'start icc vers update ');
9799:
9800: UPDATE EGO_ICC_VERS_INTERFACE
9801: SET transaction_id = mtl_system_items_interface_s.nextval
9802: ,transaction_type = upper(transaction_type)
9803: ,creation_date = nvl(creation_date, l_sysdate)
9804: ,created_by = NVL(created_by , G_USER_ID)

Line 9889: FROM EGO_ICC_VERS_INTERFACE

9885:
9886: CURSOR cur_icc_ver_count
9887: IS
9888: SELECT count(1) count
9889: FROM EGO_ICC_VERS_INTERFACE
9890: WHERE (
9891: ( G_SET_PROCESS_ID IS NULL )
9892: OR
9893: ( set_process_id = G_SET_PROCESS_ID)

Line 10188: DELETE FROM EGO_ICC_VERS_INTERFACE

10184: );
10185:
10186:
10187:
10188: DELETE FROM EGO_ICC_VERS_INTERFACE
10189: WHERE transaction_id IS NOT NULL
10190: AND process_status = G_PROCESS_STATUS_SUCCESS
10191: AND (
10192: ( G_SET_PROCESS_ID IS NULL )