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.EGO_IMPORT_PVT dependencies on EGO_ITEM_ASSOCIATIONS_INTF

Line 22: SUBTYPE IAssocs_Row IS EGO_ITEM_ASSOCIATIONS_INTF%ROWTYPE;

18: SUBTYPE MSII_ROW IS MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;
19: TYPE COLUMN_NAMES IS TABLE OF ALL_TAB_COLUMNS.COLUMN_NAME%TYPE;
20: SUBTYPE EIUAI_ROW IS EGO_ITM_USR_ATTR_INTRFC%ROWTYPE;
21: TYPE EIUAI_ROWS IS TABLE OF EIUAI_ROW INDEX BY BINARY_INTEGER;
22: SUBTYPE IAssocs_Row IS EGO_ITEM_ASSOCIATIONS_INTF%ROWTYPE;
23: TYPE IAssocs_Rows IS TABLE OF IAssocs_Row INDEX BY BINARY_INTEGER;
24:
25: G_PARTY_NAME VARCHAR2(100);
26:

Line 158: FROM EGO_ITEM_ASSOCIATIONS_INTF

154: SELECT
155: ORGANIZATION_ID,
156: TRANSACTION_ID,
157: PROCESS_FLAG
158: FROM EGO_ITEM_ASSOCIATIONS_INTF
159: WHERE BATCH_ID = p_data_set_id
160: AND PROCESS_FLAG IN (33379, 33389);
161: --R12C:BEGIN
162: BEGIN

Line 267: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI

263: )
264: );
265:
266: -- R12C:BEGIN ASSOCSINTF
267: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
268: SET PROCESS_FLAG = (CASE WHEN EIAI.SOURCE_SYSTEM_REFERENCE IS NULL THEN 33379 ELSE 33389 END),
269: TRANSACTION_ID = NVL(TRANSACTION_ID, MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
270: PROGRAM_APPLICATION_ID = l_prog_appid,
271: PROGRAM_ID = l_prog_id,

Line 523: ,'EGO_ITEM_ASSOCIATIONS_INTF'

519: ,l_request_id
520: ,i.TRANSACTION_ID
521: ,l_msg_text
522: ,'SOURCE_SYSTEM_REFERENCE'
523: ,'EGO_ITEM_ASSOCIATIONS_INTF'
524: ,'INV_IOI_ERR_SSXREF_IS_NULL_07'--bug 11894684, replace INV_IOI_ERR
525: ,l_err_text);
526: ELSIF i.PROCESS_FLAG = 33389 THEN
527: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');

Line 539: ,'EGO_ITEM_ASSOCIATIONS_INTF'

535: ,l_request_id
536: ,i.TRANSACTION_ID
537: ,l_msg_text
538: ,'SOURCE_SYSTEM_ID'
539: ,'EGO_ITEM_ASSOCIATIONS_INTF'
540: ,'INV_IOI_ERR_SSXID_INVALID_07'--bug 11894684, replace INV_IOI_ERR
541: ,l_err_text);
542: END IF;
543: END LOOP;

Line 578: UPDATE EGO_ITEM_ASSOCIATIONS_INTF

574: SET PROCESS_FLAG =3
575: WHERE PROCESS_FLAG IN (33379, 33389)
576: AND DATA_SET_ID = p_data_set_id;
577: --R12C: BEGIN
578: UPDATE EGO_ITEM_ASSOCIATIONS_INTF
579: SET PROCESS_FLAG =3
580: WHERE PROCESS_FLAG IN (33379, 33389)
581: AND BATCH_ID = p_data_set_id;
582: --R12C:END

Line 717: -- checking whether stats needs to be collected on EGO_ITEM_ASSOCIATIONS_INTF

713: END IF;
714: */
715: -- Bug 12669090 : End
716: -- R12C: BEGIN
717: -- checking whether stats needs to be collected on EGO_ITEM_ASSOCIATIONS_INTF
718:
719: SELECT COUNT(1) INTO l_records
720: FROM EGO_ITEM_ASSOCIATIONS_INTF
721: WHERE BATCH_ID = p_data_set_id;

Line 720: FROM EGO_ITEM_ASSOCIATIONS_INTF

716: -- R12C: BEGIN
717: -- checking whether stats needs to be collected on EGO_ITEM_ASSOCIATIONS_INTF
718:
719: SELECT COUNT(1) INTO l_records
720: FROM EGO_ITEM_ASSOCIATIONS_INTF
721: WHERE BATCH_ID = p_data_set_id;
722:
723: IF (l_records > l_stats_profile) AND l_ego_installed AND l_schema IS NOT NULL THEN
724: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_ASSOCIATIONS_INTF');

Line 724: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_ASSOCIATIONS_INTF');

720: FROM EGO_ITEM_ASSOCIATIONS_INTF
721: WHERE BATCH_ID = p_data_set_id;
722:
723: IF (l_records > l_stats_profile) AND l_ego_installed AND l_schema IS NOT NULL THEN
724: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_ASSOCIATIONS_INTF');
725: Debug_Conc_Log('Collected Statistics on EGO_ITEM_ASSOCIATIONS_INTF');
726: END IF;
727:
728: --R12C: END

Line 725: Debug_Conc_Log('Collected Statistics on EGO_ITEM_ASSOCIATIONS_INTF');

721: WHERE BATCH_ID = p_data_set_id;
722:
723: IF (l_records > l_stats_profile) AND l_ego_installed AND l_schema IS NOT NULL THEN
724: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_ASSOCIATIONS_INTF');
725: Debug_Conc_Log('Collected Statistics on EGO_ITEM_ASSOCIATIONS_INTF');
726: END IF;
727:
728: --R12C: END
729: Debug_Conc_Log('Done Gather_Stats_For_Intf_Tables');

Line 2847: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai

2843: DATA_LEVEL_ID,
2844: ORGANIZATION_ID )
2845: RNK,
2846: eiai.*
2847: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai
2848: WHERE BATCH_ID = p_batch_id
2849: AND PROCESS_FLAG = 1
2850: )
2851: WHERE CNT > 1

Line 2883: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai

2879: DATA_LEVEL_ID,
2880: ORGANIZATION_ID )
2881: RNK,
2882: eiai.*
2883: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai
2884: WHERE BATCH_ID = p_batch_id
2885: AND PROCESS_FLAG = 0
2886: )
2887: WHERE CNT > 1

Line 3006: UPDATE EGO_ITEM_ASSOCIATIONS_INTF

3002:
3003: -- Updating default values for primary_flag and status_code
3004: -- primary_flag null is defaulted with 'N'
3005: -- status_code null is defaulted with 1
3006: UPDATE EGO_ITEM_ASSOCIATIONS_INTF
3007: SET PRIMARY_FLAG = 'N'
3008: WHERE PRIMARY_FLAG IS NULL
3009: AND BATCH_ID = p_batch_id
3010: AND TRANSACTION_TYPE = 'CREATE'; --Modified for bug 11670735

Line 3012: UPDATE EGO_ITEM_ASSOCIATIONS_INTF

3008: WHERE PRIMARY_FLAG IS NULL
3009: AND BATCH_ID = p_batch_id
3010: AND TRANSACTION_TYPE = 'CREATE'; --Modified for bug 11670735
3011:
3012: UPDATE EGO_ITEM_ASSOCIATIONS_INTF
3013: SET STATUS_CODE = 'N'
3014: WHERE STATUS_CODE IS NULL
3015: AND BATCH_ID = p_batch_id
3016: AND TRANSACTION_TYPE = 'CREATE'; --Modified for bug 11670735

Line 3021: DELETE FROM EGO_ITEM_ASSOCIATIONS_INTF

3017:
3018: IF l_new_rows IS NOT NULL THEN
3019: -- Delete
3020: FORALL rid_ix IN INDICES OF l_old_row_ids
3021: DELETE FROM EGO_ITEM_ASSOCIATIONS_INTF
3022: WHERE ROWID = l_old_row_ids( rid_ix );
3023: -- Insert
3024: FORALL row_index IN INDICES OF l_new_rows
3025: INSERT INTO EGO_ITEM_ASSOCIATIONS_INTF

Line 3025: INSERT INTO EGO_ITEM_ASSOCIATIONS_INTF

3021: DELETE FROM EGO_ITEM_ASSOCIATIONS_INTF
3022: WHERE ROWID = l_old_row_ids( rid_ix );
3023: -- Insert
3024: FORALL row_index IN INDICES OF l_new_rows
3025: INSERT INTO EGO_ITEM_ASSOCIATIONS_INTF
3026: VALUES l_new_rows( row_index );
3027: END IF;
3028: Debug_Conc_Log( 'End of Call to Merge_Associations ');
3029:

Line 6617: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI

6613: WHERE DATA_SET_ID = p_data_set_id AND
6614: (PROCESS_FLAG IS NULL OR PROCESS_FLAG IN (0, 1)) AND
6615: ORGANIZATION_ID IS NULL;
6616:
6617: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
6618: SET ORGANIZATION_ID =
6619: CASE
6620: WHEN ORGANIZATION_CODE IS NOT NULL
6621: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = EIAI.ORGANIZATION_CODE)

Line 6632: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI

6628: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Done populating organization_id' );
6629:
6630: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Resolving data_level_name' );
6631:
6632: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
6633: SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID
6634: FROM EGO_DATA_LEVEL_B EDLB
6635: WHERE EDLB.APPLICATION_ID = 431
6636: AND EDLB.ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'

Line 6699: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai

6695:
6696:
6697: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Done Resolving data_level_name' );
6698:
6699: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai
6700: SET PK1_VALUE = ( SELECT VENDOR_ID
6701: FROM AP_SUPPLIERS aas
6702: WHERE aas.SEGMENT1 = eiai.SUPPLIER_NUMBER
6703: AND NVL(aas.end_date_active,SYSDATE+1) > SYSDATE --bug11072046

Line 6710: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai

6706: AND (eiai.PROCESS_FLAG IS NULL OR eiai.PROCESS_FLAG IN (0, 1) )
6707: AND eiai.PK1_VALUE IS NULL
6708: AND eiai.SUPPLIER_NUMBER IS NOT NULL;
6709:
6710: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai
6711: SET PK1_VALUE = ( SELECT VENDOR_ID
6712: FROM AP_SUPPLIERS aas
6713: WHERE aas.VENDOR_NAME = eiai.SUPPLIER_NAME
6714: AND NVL(aas.end_date_active,SYSDATE+1) > SYSDATE --bug11072046

Line 6722: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai

6718: AND eiai.PK1_VALUE IS NULL
6719: AND eiai.SUPPLIER_NAME IS NOT NULL
6720: AND eiai.SUPPLIER_NUMBER IS NULL;
6721:
6722: UPDATE EGO_ITEM_ASSOCIATIONS_INTF eiai
6723: SET PK2_VALUE = ( SELECT VENDOR_SITE_ID
6724: FROM AP_SUPPLIER_SITES_ALL asa
6725: WHERE asa.VENDOR_ID = eiai.PK1_VALUE
6726: AND asa.VENDOR_SITE_CODE = eiai.SUPPLIER_SITE_NAME

Line 6816: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI

6812: AND PROCESS_STATUS = 1
6813: AND ITEM_NUMBER IS NULL
6814: AND INVENTORY_ITEM_ID IS NOT NULL;
6815:
6816: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
6817: SET item_number = (SELECT CONCATENATED_SEGMENTS
6818: FROM MTL_SYSTEM_ITEMS_KFV
6819: WHERE INVENTORY_ITEM_ID = EIAI.INVENTORY_ITEM_ID
6820: AND ORGANIZATION_ID = EIAI.ORGANIZATION_ID)

Line 6906: --R12C: Inseting Fake Row into MSII for orphan row in EGO_ITEM_ASSOCIATIONS_INTF.

6902: GROUP BY EAI.ITEM_NUMBER;
6903: -- using GROUP BY rather than distinct for performance reasons (emulating merge code)
6904: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - PDH batch, parent rows inserted for AMLs: ' || SQL%ROWCOUNT );
6905:
6906: --R12C: Inseting Fake Row into MSII for orphan row in EGO_ITEM_ASSOCIATIONS_INTF.
6907: INSERT INTO
6908: MTL_SYSTEM_ITEMS_INTERFACE MSII
6909: ( transaction_type, process_flag, set_process_id, organization_id, source_system_id
6910: , confirm_status, inventory_item_id, item_number

Line 6921: FROM EGO_ITEM_ASSOCIATIONS_INTF EIAI

6917: , l_insert_date -- LAST_UPDATE_DATE
6918: , MAX( EIAI.created_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) CREATED_BY
6919: , MAX( EIAI.last_updated_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) UPDATED_BY
6920: , MAX( EIAI.last_update_login ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) LAST_UPDATE_LOGIN
6921: FROM EGO_ITEM_ASSOCIATIONS_INTF EIAI
6922: WHERE
6923: batch_id = p_data_set_id
6924: AND process_flag = 1
6925: AND EIAI.organization_id = l_org_id

Line 7041: UPDATE EGO_ITEM_ASSOCIATIONS_INTF

7037: SET PROCESS_FLAG = 0
7038: WHERE DATA_SET_ID = p_data_set_id AND
7039: PROCESS_FLAG IS NULL;
7040:
7041: UPDATE EGO_ITEM_ASSOCIATIONS_INTF
7042: SET PROCESS_FLAG = 0
7043: WHERE BATCH_ID = p_data_set_id AND
7044: PROCESS_FLAG IS NULL;
7045:

Line 7140: --R12C: Inserting Fake Row (Parent Row in MSII) for Orphan row in EGO_ITEM_ASSOCIATIONS_INTF

7136: GROUP BY EAI.source_system_id, EAI.source_system_reference;
7137: -- using GROUP BY rather than distinct for performance reasons (no load on merge code)
7138: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Source System batch, parent rows inserted for AMLs: ' || SQL%ROWCOUNT );
7139:
7140: --R12C: Inserting Fake Row (Parent Row in MSII) for Orphan row in EGO_ITEM_ASSOCIATIONS_INTF
7141: INSERT INTO
7142: MTL_SYSTEM_ITEMS_INTERFACE MSII
7143: ( transaction_type, process_flag, set_process_id, organization_id, source_system_id, source_system_reference, bundle_id
7144: , confirm_status, inventory_item_id, item_number

Line 7156: FROM EGO_ITEM_ASSOCIATIONS_INTF EIAI

7152: , l_insert_date -- LAST_UPDATE_DATE
7153: , MAX( EIAI.created_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) CREATED_BY
7154: , MAX( EIAI.last_updated_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) UPDATED_BY
7155: , MAX( EIAI.last_update_login ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) LAST_UPDATE_LOGIN
7156: FROM EGO_ITEM_ASSOCIATIONS_INTF EIAI
7157: WHERE
7158: EIAI.batch_id = p_data_set_id
7159: AND EIAI.process_flag = 0
7160: AND EIAI.organization_id = l_org_id

Line 7176: --R12C: Inserting Fake Row (Parent Row in MSII) for Orphan row in EGO_ITEM_ASSOCIATIONS_INTF

7172: GROUP BY EIAI.source_system_id, EIAI.source_system_reference, EIAI.bundle_id;
7173: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Source System batch, parent rows inserted for ASSOCIATIONS: ' || SQL%ROWCOUNT );
7174:
7175:
7176: --R12C: Inserting Fake Row (Parent Row in MSII) for Orphan row in EGO_ITEM_ASSOCIATIONS_INTF
7177: INSERT INTO
7178: MTL_SYSTEM_ITEMS_INTERFACE MSII
7179: ( transaction_type, process_flag, set_process_id, organization_id, source_system_id, source_system_reference, bundle_id
7180: , confirm_status, inventory_item_id, item_number

Line 8962: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI

8958:
8959: Debug_Conc_Log( 'Resolve_Child_Entities - After resolving aml rows' );
8960:
8961: -- updating item_number, item_id from MSII table
8962: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
8963: SET (PROCESS_FLAG, TRANSACTION_TYPE, INVENTORY_ITEM_ID, ITEM_NUMBER) =
8964: (SELECT
8965: 1,
8966: (CASE

Line 9308: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI

9304: Debug_Conc_Log('Resolve_Child_Entities - After updating aml intf table for items that has XXref');
9305:
9306: -- updating the item intersections
9307: l_sql := q'#
9308: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
9309: SET (PROCESS_FLAG, TRANSACTION_TYPE, INVENTORY_ITEM_ID) =
9310: (SELECT
9311: 1,
9312: EIAI.TRANSACTION_TYPE,

Line 9716: UPDATE EGO_ITEM_ASSOCIATIONS_INTF

9712: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9713: );
9714: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9715:
9716: UPDATE EGO_ITEM_ASSOCIATIONS_INTF
9717: SET PROCESS_FLAG = 1
9718: WHERE ( INVENTORY_ITEM_ID = l_item_id
9719: OR ( ITEM_NUMBER = l_item_number
9720: AND INVENTORY_ITEM_ID IS NULL

Line 9811: UPDATE EGO_ITEM_ASSOCIATIONS_INTF

9807: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9808: );
9809: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9810: -- updating item ITEM ASSOCIATIONS
9811: UPDATE EGO_ITEM_ASSOCIATIONS_INTF
9812: SET PROCESS_FLAG = 1
9813: WHERE ITEM_NUMBER = l_item_number
9814: AND PROCESS_FLAG = 3
9815: AND BATCH_ID = p_batch_id

Line 10074: UPDATE EGO_ITEM_ASSOCIATIONS_INTF

10070: FROM MTL_PARAMETERS MP
10071: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
10072: );
10073: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
10074: UPDATE EGO_ITEM_ASSOCIATIONS_INTF
10075: SET PROCESS_FLAG = 1
10076: WHERE SOURCE_SYSTEM_ID = l_ss_id
10077: AND SOURCE_SYSTEM_REFERENCE = l_ssr
10078: AND PROCESS_FLAG = 3

Line 12879: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai, EGO_DATA_LEVEL_B edlb

12875: THEN 1
12876: ELSE NULL
12877: END
12878: ) UPDATE_CNT
12879: FROM EGO_ITEM_ASSOCIATIONS_INTF eiai, EGO_DATA_LEVEL_B edlb
12880: WHERE eiai.BATCH_ID = p_set_process_id
12881: AND eiai.DATA_LEVEL_ID = edlb.DATA_LEVEL_ID
12882: AND EXISTS
12883: (