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 FND_API

Line 733: * - Pass FND_API.G_TRUE to indicate that the batch is a PIMDH batch

729: * p_batch_id IN NUMBER =>
730: * The batch identifier (MANDATORY).
731: * p_is_pdh_batch IN FLAG DEFAULT NULL =>
732: * Used to determine the set of keys to use for merging.
733: * - Pass FND_API.G_TRUE to indicate that the batch is a PIMDH batch
734: * - Pass FND_API.G_FALSE to indicate that the batch is a non-PIMDH batch
735: * - If not passed, the batch header will be used to determine whether or not
736: * the batch is a PIMDH batch (absence of a header implies that it is).
737: * p_master_org_id IN NUMBER DEFAULT NULL =>

Line 734: * - Pass FND_API.G_FALSE to indicate that the batch is a non-PIMDH batch

730: * The batch identifier (MANDATORY).
731: * p_is_pdh_batch IN FLAG DEFAULT NULL =>
732: * Used to determine the set of keys to use for merging.
733: * - Pass FND_API.G_TRUE to indicate that the batch is a PIMDH batch
734: * - Pass FND_API.G_FALSE to indicate that the batch is a non-PIMDH batch
735: * - If not passed, the batch header will be used to determine whether or not
736: * the batch is a PIMDH batch (absence of a header implies that it is).
737: * p_master_org_id IN NUMBER DEFAULT NULL =>
738: * The ID of the default batch organization, to be used for rows for which neither

Line 742: * p_commit IN FLAG DEFAULT FND_API.G_FALSE =>

738: * The ID of the default batch organization, to be used for rows for which neither
739: * ORGANIZATION_ID nor ORGANIZATION_CODE are provided.
740: * If not passed, the ORGANIZATION_ID in the batch header will be used.
741: *
742: * p_commit IN FLAG DEFAULT FND_API.G_FALSE =>
743: * Pass FND_API.G_TRUE to have a COMMIT issued at the end of the procedure.
744: */
745:
746: PROCEDURE merge_params_from_batch_header( p_batch_id IN NUMBER

Line 743: * Pass FND_API.G_TRUE to have a COMMIT issued at the end of the procedure.

739: * ORGANIZATION_ID nor ORGANIZATION_CODE are provided.
740: * If not passed, the ORGANIZATION_ID in the batch header will be used.
741: *
742: * p_commit IN FLAG DEFAULT FND_API.G_FALSE =>
743: * Pass FND_API.G_TRUE to have a COMMIT issued at the end of the procedure.
744: */
745:
746: PROCEDURE merge_params_from_batch_header( p_batch_id IN NUMBER
747: , x_is_pdh_batch OUT NOCOPY FLAG

Line 775: WHEN NULL THEN FND_API.G_TRUE

771:
772: x_ss_id := l_ss_id;
773: Debug_Conc_Log( 'SS ID:' || x_ss_id );
774: x_is_pdh_batch := CASE l_ss_id
775: WHEN NULL THEN FND_API.G_TRUE
776: WHEN get_pdh_source_system_id THEN FND_API.G_TRUE
777: ELSE FND_API.G_FALSE
778: END;
779: Debug_Conc_Log( 'Is PDH Batch:' || x_is_pdh_batch );

Line 776: WHEN get_pdh_source_system_id THEN FND_API.G_TRUE

772: x_ss_id := l_ss_id;
773: Debug_Conc_Log( 'SS ID:' || x_ss_id );
774: x_is_pdh_batch := CASE l_ss_id
775: WHEN NULL THEN FND_API.G_TRUE
776: WHEN get_pdh_source_system_id THEN FND_API.G_TRUE
777: ELSE FND_API.G_FALSE
778: END;
779: Debug_Conc_Log( 'Is PDH Batch:' || x_is_pdh_batch );
780: x_master_org_id := l_org_id;

Line 777: ELSE FND_API.G_FALSE

773: Debug_Conc_Log( 'SS ID:' || x_ss_id );
774: x_is_pdh_batch := CASE l_ss_id
775: WHEN NULL THEN FND_API.G_TRUE
776: WHEN get_pdh_source_system_id THEN FND_API.G_TRUE
777: ELSE FND_API.G_FALSE
778: END;
779: Debug_Conc_Log( 'Is PDH Batch:' || x_is_pdh_batch );
780: x_master_org_id := l_org_id;
781: Debug_Conc_Log( 'Master Org ID:' || x_master_org_id );

Line 791: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

787: PROCEDURE merge_rev_attrs ( p_batch_id IN NUMBER
788: , p_is_pdh_batch IN FLAG DEFAULT NULL
789: , p_ss_id IN NUMBER DEFAULT NULL
790: , p_master_org_id IN NUMBER DEFAULT NULL
791: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
792: )
793: IS
794: --6468564:Perf issue replacing EGO_ATTRS_V
795: CURSOR c_pdh_target_rev_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE, cp_rev_dl_id NUMBER ) IS

Line 1007: l_is_pdh_batch := ( l_pdh_batch_flag = FND_API.G_TRUE );

1003: Debug_Conc_Log( l_proc_log_prefix || 'Master Org ID: '|| l_org_id );
1004: Debug_Conc_Log( l_proc_log_prefix || 'SS ID: ' || l_ss_id );
1005: Debug_Conc_Log( l_proc_log_prefix || 'Is PDH Batch?: '|| l_pdh_batch_flag );
1006:
1007: l_is_pdh_batch := ( l_pdh_batch_flag = FND_API.G_TRUE );
1008: IF l_is_pdh_batch THEN
1009: -- DBMS_OUTPUT.PUT_LINE( 'PDH Batch' );
1010: OPEN c_pdh_target_rev_attrs( l_org_id, l_rev_dl_id );
1011: FETCH c_pdh_target_rev_attrs BULK COLLECT INTO l_old_rows;

Line 1209: IF p_commit = FND_API.G_TRUE THEN

1205: VALUES l_merged_rows( row_index );
1206: END IF;
1207: END IF; -- ENDS IF l_old_rows.count <> 0
1208:
1209: IF p_commit = FND_API.G_TRUE THEN
1210: Debug_Conc_Log( l_proc_log_prefix || 'Committing' );
1211: COMMIT;
1212: END IF;
1213: Debug_Conc_Log( l_proc_log_prefix || 'Exiting' );

Line 1220: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

1216: PROCEDURE merge_item_attrs ( p_batch_id IN NUMBER
1217: , p_is_pdh_batch IN FLAG DEFAULT NULL
1218: , p_ss_id IN NUMBER DEFAULT NULL
1219: , p_master_org_id IN NUMBER DEFAULT NULL
1220: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
1221: )
1222: IS
1223:
1224: --6468564:Perf issue replacing EGO_ATTRS_V

Line 1414: l_is_pdh_batch := ( l_pdh_batch_flag = FND_API.G_TRUE );

1410: Debug_Conc_Log( l_proc_log_prefix || 'Master Org ID: ' || l_org_id );
1411: Debug_Conc_Log( l_proc_log_prefix || 'SS ID: ' || l_ss_id );
1412: Debug_Conc_Log( l_proc_log_prefix || 'Is PDH Batch?: ' || l_pdh_batch_flag );
1413:
1414: l_is_pdh_batch := ( l_pdh_batch_flag = FND_API.G_TRUE );
1415: IF l_is_pdh_batch THEN
1416: -- DBMS_OUTPUT.PUT_LINE( 'PDH Batch' );
1417: OPEN c_pdh_target_item_attrs( l_org_id );
1418: FETCH c_pdh_target_item_attrs BULK COLLECT INTO l_old_rows;

Line 1620: IF p_commit = FND_API.G_TRUE THEN

1616: VALUES l_merged_rows( row_index );
1617: END IF;
1618: END IF; -- ENDS IF l_old_rows.count <> 0
1619:
1620: IF p_commit = FND_API.G_TRUE THEN
1621: Debug_Conc_Log( l_proc_log_prefix || 'Committing' );
1622: COMMIT;
1623: END IF;
1624: Debug_Conc_Log( l_proc_log_prefix || 'Exiting' );

Line 1631: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

1627: PROCEDURE merge_items( p_batch_id IN NUMBER
1628: , p_is_pdh_batch IN FLAG
1629: , p_ss_id IN NUMBER DEFAULT NULL
1630: , p_master_org_id IN NUMBER DEFAULT NULL
1631: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
1632: )
1633: IS
1634: TYPE MSII_ROWS IS TABLE OF MSII_ROW INDEX BY BINARY_INTEGER;
1635:

Line 1685: l_is_pdh_batch := ( l_pdh_batch_flag = FND_API.G_TRUE );

1681: Debug_Conc_Log( l_proc_log_prefix || 'Master Org ID: ' || l_org_id );
1682: Debug_Conc_Log( l_proc_log_prefix || 'SS ID: ' || l_ss_id );
1683: Debug_Conc_Log( l_proc_log_prefix || 'Is PDH Batch?: ' || l_pdh_batch_flag );
1684:
1685: l_is_pdh_batch := ( l_pdh_batch_flag = FND_API.G_TRUE );
1686: IF l_is_pdh_batch THEN
1687: OPEN c_target_rows FOR
1688: SELECT *
1689: FROM

Line 2418: IF p_commit = FND_API.G_TRUE THEN

2414: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
2415: VALUES l_merged_rows( row_index );
2416: END IF;
2417:
2418: IF p_commit = FND_API.G_TRUE THEN
2419: Debug_Conc_Log( l_proc_log_prefix || 'Committing' );
2420: COMMIT;
2421: END IF;
2422: Debug_Conc_Log( l_proc_log_prefix || 'Exiting' );

Line 2429: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

2425: PROCEDURE merge_revs( p_batch_id IN NUMBER
2426: , p_is_pdh_batch IN FLAG
2427: , p_ss_id IN NUMBER DEFAULT NULL
2428: , p_master_org_id IN NUMBER DEFAULT NULL
2429: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
2430: )
2431: IS
2432: SUBTYPE MIRI_ROW IS MTL_ITEM_REVISIONS_INTERFACE%ROWTYPE;
2433: TYPE MIRI_ROWS IS TABLE OF MIRI_ROW INDEX BY BINARY_INTEGER;

Line 2581: l_is_pdh_batch := ( l_pdh_batch_flag = FND_API.G_TRUE );

2577: WHERE REVISION_ID IS NOT NULL
2578: AND SET_PROCESS_ID = p_batch_id
2579: AND REVISION IS NULL;
2580:
2581: l_is_pdh_batch := ( l_pdh_batch_flag = FND_API.G_TRUE );
2582: IF l_is_pdh_batch THEN
2583: OPEN c_pdh_target_revs( l_org_id );
2584: FETCH c_pdh_target_revs BULK COLLECT INTO l_old_rows;
2585: CLOSE c_pdh_target_revs;

Line 2746: IF p_commit = FND_API.G_TRUE THEN

2742: INSERT INTO MTL_ITEM_REVISIONS_INTERFACE
2743: VALUES l_merged_rows( row_index );
2744: END IF;
2745: END IF; -- ENDS IF l_old_rows.count <> 0
2746: IF p_commit = FND_API.G_TRUE THEN
2747: Debug_Conc_Log( l_proc_log_prefix || 'Committing' );
2748: COMMIT;
2749: END IF;
2750: Debug_Conc_Log( l_proc_log_prefix || 'Exiting' );

Line 2756: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

2752:
2753: -- Merging Item Associations.
2754: PROCEDURE Merge_Associations ( p_batch_id IN NUMBER
2755: , p_is_pdh_batch IN FLAG DEFAULT NULL
2756: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
2757: )
2758: IS
2759:
2760: CURSOR pdh_candidate_assocs_rows_cur IS

Line 2847: IF p_is_pdh_batch = FND_API.G_TRUE THEN

2843: Debug_Conc_Log( 'Calling Merge_Associations ');
2844: l_current_rank_handled := 0;
2845: l_previous_rank_handled := 0;
2846:
2847: IF p_is_pdh_batch = FND_API.G_TRUE THEN
2848: -- 'PDH Batch'
2849: Debug_Conc_Log( 'Getting candidate rows for merging for PDH Batch ');
2850: OPEN pdh_candidate_assocs_rows_cur;
2851: FETCH pdh_candidate_assocs_rows_cur BULK COLLECT INTO l_old_rows;

Line 2975: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

2971: PROCEDURE merge_batch ( p_batch_id IN NUMBER
2972: , p_is_pdh_batch IN FLAG DEFAULT NULL
2973: , p_ss_id IN NUMBER DEFAULT NULL
2974: , p_master_org_id IN NUMBER DEFAULT NULL
2975: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
2976: )
2977: IS
2978: l_org_id NUMBER := p_master_org_id;
2979: l_pdh_batch_flag FLAG := p_is_pdh_batch;

Line 2996: , p_commit => FND_API.G_FALSE

2992: MERGE_ITEMS( p_batch_id => p_batch_id
2993: , p_master_org_id => l_org_id
2994: , p_is_pdh_batch => l_pdh_batch_flag
2995: , p_ss_id => l_ss_id
2996: , p_commit => FND_API.G_FALSE
2997: );
2998: Debug_Conc_Log( 'merge_batch: Merging batch revisions' );
2999: MERGE_REVS ( p_batch_id => p_batch_id
3000: , p_master_org_id => l_org_id

Line 3003: , p_commit => FND_API.G_FALSE

2999: MERGE_REVS ( p_batch_id => p_batch_id
3000: , p_master_org_id => l_org_id
3001: , p_is_pdh_batch => l_pdh_batch_flag
3002: , p_ss_id => l_ss_id
3003: , p_commit => FND_API.G_FALSE
3004: );
3005: Debug_Conc_Log( 'merge_batch: Merging Associations' );
3006: merge_associations( p_batch_id => p_batch_id
3007: , p_is_pdh_batch => l_pdh_batch_flag

Line 3008: , p_commit => FND_API.G_FALSE

3004: );
3005: Debug_Conc_Log( 'merge_batch: Merging Associations' );
3006: merge_associations( p_batch_id => p_batch_id
3007: , p_is_pdh_batch => l_pdh_batch_flag
3008: , p_commit => FND_API.G_FALSE
3009: );
3010:
3011: Debug_Conc_Log( 'merge_batch: Merging batch extended attributes' );
3012: MERGE_ATTRS( p_batch_id => p_batch_id

Line 3016: , p_commit => FND_API.G_FALSE

3012: MERGE_ATTRS( p_batch_id => p_batch_id
3013: , p_master_org_id => l_org_id
3014: , p_is_pdh_batch => l_pdh_batch_flag
3015: , p_ss_id => l_ss_id
3016: , p_commit => FND_API.G_FALSE
3017: );
3018: IF p_commit = FND_API.G_TRUE THEN
3019: Debug_Conc_Log( 'merge_batch: Committing' );
3020: COMMIT;

Line 3018: IF p_commit = FND_API.G_TRUE THEN

3014: , p_is_pdh_batch => l_pdh_batch_flag
3015: , p_ss_id => l_ss_id
3016: , p_commit => FND_API.G_FALSE
3017: );
3018: IF p_commit = FND_API.G_TRUE THEN
3019: Debug_Conc_Log( 'merge_batch: Committing' );
3020: COMMIT;
3021: END IF;
3022: Debug_Conc_Log( 'merge_batch: Exiting' );

Line 3029: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

3025: PROCEDURE merge_attrs ( p_batch_id IN NUMBER
3026: , p_is_pdh_batch IN FLAG DEFAULT NULL
3027: , p_ss_id IN NUMBER DEFAULT NULL
3028: , p_master_org_id IN NUMBER DEFAULT NULL
3029: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
3030: )
3031: IS
3032: l_org_id NUMBER := p_master_org_id;
3033: l_pdh_batch_flag FLAG := p_is_pdh_batch;

Line 3050: , p_commit => FND_API.G_FALSE

3046: MERGE_ITEM_ATTRS ( p_batch_id => p_batch_id
3047: , p_master_org_id => l_org_id
3048: , p_is_pdh_batch => l_pdh_batch_flag
3049: , p_ss_id => l_ss_id
3050: , p_commit => FND_API.G_FALSE
3051: );
3052: Debug_Conc_Log( 'merge_attrs: merging revision-level extended attributes' );
3053: MERGE_REV_ATTRS( p_batch_id => p_batch_id
3054: , p_master_org_id => l_org_id

Line 3057: , p_commit => FND_API.G_FALSE

3053: MERGE_REV_ATTRS( p_batch_id => p_batch_id
3054: , p_master_org_id => l_org_id
3055: , p_is_pdh_batch => l_pdh_batch_flag
3056: , p_ss_id => l_ss_id
3057: , p_commit => FND_API.G_FALSE
3058: );
3059: IF p_commit = FND_API.G_TRUE THEN
3060: Debug_Conc_Log( 'merge_attrs: Committing' );
3061: COMMIT;

Line 3059: IF p_commit = FND_API.G_TRUE THEN

3055: , p_is_pdh_batch => l_pdh_batch_flag
3056: , p_ss_id => l_ss_id
3057: , p_commit => FND_API.G_FALSE
3058: );
3059: IF p_commit = FND_API.G_TRUE THEN
3060: Debug_Conc_Log( 'merge_attrs: Committing' );
3061: COMMIT;
3062: END IF;
3063: Debug_Conc_Log( 'merge_attrs: Exiting' );

Line 6271: , p_is_pdh_batch IN FLAG DEFAULT FND_API.G_FALSE

6267: * parse item segments into item number if item_number is null
6268: */
6269: PROCEDURE PARSE_ITEM_SEGMENTS ( p_set_id IN NUMBER
6270: , p_master_org_id IN NUMBER
6271: , p_is_pdh_batch IN FLAG DEFAULT FND_API.G_FALSE
6272: )
6273: IS
6274: CURSOR c_ss_items_table IS
6275: SELECT rowid rid

Line 6302: IF p_is_pdh_batch = FND_API.G_TRUE THEN

6298: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE := NULL;
6299: l_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE := NULL;
6300: l_ret_code INTEGER;
6301: BEGIN
6302: IF p_is_pdh_batch = FND_API.G_TRUE THEN
6303: FOR item_record IN c_pdh_items_table LOOP
6304: l_ret_code := INVPUOPI.MTL_PR_PARSE_ITEM_SEGMENTS ( p_row_id =>item_record.rid
6305: , item_number =>l_item_number
6306: , item_id =>l_item_id

Line 6407: ,p_commit IN FLAG DEFAULT FND_API.G_TRUE

6403: * This procedure needs to be safe for re-execution if data is loaded into an
6404: * active batch repeatedly.
6405: */
6406: PROCEDURE Resolve_SSXref_on_Data_load( p_data_set_id IN NUMBER
6407: ,p_commit IN FLAG DEFAULT FND_API.G_TRUE
6408: )
6409: IS
6410: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6411: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

Line 6745: PARSE_ITEM_SEGMENTS(p_data_set_id, l_org_id, FND_API.G_TRUE);

6741: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - PDH batch, done updating item_number if inventory_item_id is populated' );
6742:
6743: -- parse segments into item_number if item_number is null
6744: -- so that we can join to the child entities by item number alone
6745: PARSE_ITEM_SEGMENTS(p_data_set_id, l_org_id, FND_API.G_TRUE);
6746: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - PDH batch, done parsing item segments' );
6747:
6748: -- insert fake records ...
6749: l_insert_date := SYSDATE;

Line 6884: , p_is_pdh_batch => FND_API.G_TRUE

6880: GROUP BY MICI.ITEM_NUMBER, MICI.organization_id;
6881: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - PDH batch, parent rows inserted for CATEGORY ASSIGNMENT rows: ' || SQL%ROWCOUNT );
6882: MERGE_BATCH( p_batch_id => p_data_set_id
6883: , p_master_org_id => l_org_id
6884: , p_is_pdh_batch => FND_API.G_TRUE
6885: , p_commit => FND_API.G_FALSE
6886: );
6887: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - PDH batch, done merging batch' );
6888:

Line 6885: , p_commit => FND_API.G_FALSE

6881: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - PDH batch, parent rows inserted for CATEGORY ASSIGNMENT rows: ' || SQL%ROWCOUNT );
6882: MERGE_BATCH( p_batch_id => p_data_set_id
6883: , p_master_org_id => l_org_id
6884: , p_is_pdh_batch => FND_API.G_TRUE
6885: , p_commit => FND_API.G_FALSE
6886: );
6887: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - PDH batch, done merging batch' );
6888:
6889: -- resolve SYNC transaction_type into UPDATE or CREATE

Line 6909: IF FND_API.G_TRUE = p_commit THEN

6905: AND confirm_status = G_FAKE_CONF_STATUS_FLAG;
6906: */
6907:
6908: -- that's it
6909: IF FND_API.G_TRUE = p_commit THEN
6910: COMMIT;
6911: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - PDH batch, committed' );
6912: END IF;
6913:

Line 7162: , p_is_pdh_batch => FND_API.G_FALSE

7158: */
7159: IF l_enabled_for_data_pool = 'N' THEN
7160: MERGE_BATCH( p_batch_id => p_data_set_id
7161: , p_master_org_id => l_org_id
7162: , p_is_pdh_batch => FND_API.G_FALSE
7163: , p_commit => FND_API.G_FALSE
7164: );
7165: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Source System batch, done merging rows' );
7166: ELSE

Line 7163: , p_commit => FND_API.G_FALSE

7159: IF l_enabled_for_data_pool = 'N' THEN
7160: MERGE_BATCH( p_batch_id => p_data_set_id
7161: , p_master_org_id => l_org_id
7162: , p_is_pdh_batch => FND_API.G_FALSE
7163: , p_commit => FND_API.G_FALSE
7164: );
7165: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Source System batch, done merging rows' );
7166: ELSE
7167: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Not calling merging, because batch is enabled for data pool' );

Line 7389: IF FND_API.G_TRUE = p_commit THEN

7385:
7386: Debug_Conc_Log('Resolve_SSXref_on_Data_load - After Updating Item Catalog Group ID' );
7387:
7388:
7389: IF FND_API.G_TRUE = p_commit THEN
7390: COMMIT;
7391: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Source System batch, committed' );
7392: END IF;
7393: EXCEPTION

Line 7395: IF FND_API.G_TRUE = p_commit THEN

7391: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Source System batch, committed' );
7392: END IF;
7393: EXCEPTION
7394: WHEN NO_DATA_FOUND THEN
7395: IF FND_API.G_TRUE = p_commit THEN
7396: COMMIT;
7397: END IF;
7398: RETURN;
7399:

Line 7409: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE

7405: * Here we group the rows based on item_number or source_system_reference
7406: */
7407: PROCEDURE CLEAN_UP_UDA_ROW_IDENTS_PRE( p_batch_id IN NUMBER,
7408: p_process_status IN NUMBER,
7409: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
7410: )
7411: IS
7412: CURSOR c_unmerged_rows(cp_ss_id IN NUMBER) IS
7413: SELECT ROW_IDENTIFIER FROM

Line 7622: IF FND_API.G_TRUE = p_commit THEN

7618: END LOOP;
7619: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - Done updating row_identifiers');
7620: CLOSE c_intf_recs;
7621:
7622: IF FND_API.G_TRUE = p_commit THEN
7623: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre COMMITING');
7624: COMMIT;
7625: END IF;
7626: EXCEPTION WHEN OTHERS THEN

Line 7640: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE

7636:
7637:
7638: PROCEDURE CLEAN_UP_UDA_ROW_IDENTS_POST( p_batch_id IN NUMBER,
7639: p_process_status IN NUMBER,
7640: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
7641: )
7642: IS
7643: CURSOR c_unmerged_rows IS
7644: SELECT ROW_IDENTIFIER FROM

Line 7820: IF FND_API.G_TRUE = p_commit THEN

7816: END LOOP;
7817: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post - Done updating row_identifiers');
7818: CLOSE c_intf_recs;
7819:
7820: IF FND_API.G_TRUE = p_commit THEN
7821: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post COMMITING');
7822: COMMIT;
7823: END IF;
7824: EXCEPTION WHEN OTHERS THEN

Line 7843: p_ignore_item_num_upd IN VARCHAR2, --FND_API.G_TRUE

7839: * Helper procedure for resolve_child_entities
7840: */
7841: PROCEDURE CLEAN_UP_UDA_ROW_IDENTS( p_batch_id IN NUMBER,
7842: p_process_status IN NUMBER,
7843: p_ignore_item_num_upd IN VARCHAR2, --FND_API.G_TRUE
7844: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
7845: )
7846: IS
7847: BEGIN

Line 7844: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE

7840: */
7841: PROCEDURE CLEAN_UP_UDA_ROW_IDENTS( p_batch_id IN NUMBER,
7842: p_process_status IN NUMBER,
7843: p_ignore_item_num_upd IN VARCHAR2, --FND_API.G_TRUE
7844: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
7845: )
7846: IS
7847: BEGIN
7848: Debug_Conc_Log('Clean_Up_UDA_Row_Idents - Starting');

Line 7849: IF p_ignore_item_num_upd = FND_API.G_FALSE THEN

7845: )
7846: IS
7847: BEGIN
7848: Debug_Conc_Log('Clean_Up_UDA_Row_Idents - Starting');
7849: IF p_ignore_item_num_upd = FND_API.G_FALSE THEN
7850: Debug_Conc_Log('Clean_Up_UDA_Row_Idents - Calling CLEAN_UP_UDA_ROW_IDENTS_PRE');
7851: CLEAN_UP_UDA_ROW_IDENTS_PRE(p_batch_id => p_batch_id,
7852: p_process_status => p_process_status,
7853: p_commit => p_commit);

Line 7871: , p_commit IN FLAG DEFAULT FND_API.G_TRUE

7867: * EGO_ITEM_PEOPLE_INTF, MTL_ITEM_CATEGORIES_INTERFACE, EGO_ITM_USR_ATTR_INTRFC etc.
7868: * with the inventory item id/number and organization id/code.
7869: */
7870: PROCEDURE Resolve_Child_Entities( p_data_set_id IN NUMBER
7871: , p_commit IN FLAG DEFAULT FND_API.G_TRUE
7872: )
7873: IS
7874: CURSOR c_no_privilege_rows IS
7875: SELECT

Line 7986: p_ignore_item_num_upd => FND_API.G_FALSE,

7982:
7983: Debug_Conc_Log('Resolve_Child_Entities - Calling Clean_Up_UDA_Row_Idents');
7984: Clean_Up_UDA_Row_Idents( p_batch_id => p_data_set_id,
7985: p_process_status => 1,
7986: p_ignore_item_num_upd => FND_API.G_FALSE,
7987: p_commit => FND_API.G_FALSE );
7988: Debug_Conc_Log('Resolve_Child_Entities - Clean_Up_UDA_Row_Idents Done.');
7989:
7990: Debug_Conc_Log('Resolve_Child_Entities - Resolving Style_Item_Flag');

Line 7987: p_commit => FND_API.G_FALSE );

7983: Debug_Conc_Log('Resolve_Child_Entities - Calling Clean_Up_UDA_Row_Idents');
7984: Clean_Up_UDA_Row_Idents( p_batch_id => p_data_set_id,
7985: p_process_status => 1,
7986: p_ignore_item_num_upd => FND_API.G_FALSE,
7987: p_commit => FND_API.G_FALSE );
7988: Debug_Conc_Log('Resolve_Child_Entities - Clean_Up_UDA_Row_Idents Done.');
7989:
7990: Debug_Conc_Log('Resolve_Child_Entities - Resolving Style_Item_Flag');
7991: UPDATE MTL_SYSTEM_ITEMS_INTERFACE msii

Line 8013: IF FND_API.G_TRUE = p_commit THEN

8009:
8010: Debug_Conc_Log('Resolve_Child_Entities - Done Resolving Style_Item_Flag, rows processed='||SQL%ROWCOUNT);
8011:
8012: Debug_Conc_Log('Resolve_Child_Entities END');
8013: IF FND_API.G_TRUE = p_commit THEN
8014: Debug_Conc_Log('Resolve_Child_Entities COMMITING');
8015: COMMIT;
8016: END IF;
8017: RETURN;

Line 8168: IF FND_API.G_TRUE = p_commit THEN

8164: AND ORGANIZATION_ID = l_org_id;
8165:
8166: Debug_Conc_Log( 'Resolve_Child_Entities - After erroring out records without privilege' );
8167:
8168: IF FND_API.G_TRUE = p_commit THEN
8169: Debug_Conc_Log( 'Resolve_Child_Entities COMMITING' );
8170: COMMIT;
8171: END IF;
8172:

Line 9289: p_ignore_item_num_upd => FND_API.G_FALSE,

9285:
9286: Debug_Conc_Log('Resolve_Child_Entities - Calling Clean_Up_UDA_Row_Idents');
9287: Clean_Up_UDA_Row_Idents( p_batch_id => p_data_set_id,
9288: p_process_status => 1,
9289: p_ignore_item_num_upd => FND_API.G_FALSE,
9290: p_commit => FND_API.G_FALSE );
9291:
9292: Debug_Conc_Log('Resolve_Child_Entities - Clean_Up_UDA_Row_Idents Done.');
9293: ELSE

Line 9290: p_commit => FND_API.G_FALSE );

9286: Debug_Conc_Log('Resolve_Child_Entities - Calling Clean_Up_UDA_Row_Idents');
9287: Clean_Up_UDA_Row_Idents( p_batch_id => p_data_set_id,
9288: p_process_status => 1,
9289: p_ignore_item_num_upd => FND_API.G_FALSE,
9290: p_commit => FND_API.G_FALSE );
9291:
9292: Debug_Conc_Log('Resolve_Child_Entities - Clean_Up_UDA_Row_Idents Done.');
9293: ELSE
9294: Debug_Conc_Log('Resolve_Child_Entities - Not calling Merge_Batch_For_Import, because this batch is enabled for data pool');

Line 9319: IF FND_API.G_TRUE = p_commit THEN

9315:
9316: Debug_Conc_Log('Resolve_Child_Entities - Done Resolving Style_Item_Flag, rows processed='||SQL%ROWCOUNT);
9317:
9318: Debug_Conc_Log('Resolve_Child_Entities END');
9319: IF FND_API.G_TRUE = p_commit THEN
9320: Debug_Conc_Log('Resolve_Child_Entities COMMITING');
9321: COMMIT;
9322: END IF;
9323:

Line 10047: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

10043: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10044: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10045: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10046: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10047: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10048: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10049: )
10050: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10051: IS

Line 10054: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN

10050: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10051: IS
10052: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10053: BEGIN
10054: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN
10055: SELECT MAX( EIUAI.REVISION ) INTO l_rev_code
10056: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10057: WHERE EIUAI.SOURCE_SYSTEM_REFERENCE = p_source_system_reference
10058: AND EIUAI.SOURCE_SYSTEM_ID = p_source_system_id

Line 10117: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

10113: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10114: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10115: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10116: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10117: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10118: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10119: )
10120: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10121: IS

Line 10130: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN

10126: -- no need to check for the NO_DATA_FOUND exception, or initialize l_rev_code
10127:
10128: IF p_inventory_item_id IS NULL
10129: THEN
10130: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN
10131: SELECT MAX( EIUAI.REVISION )
10132: INTO l_rev_code
10133: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10134: WHERE EIUAI.ITEM_NUMBER = p_item_number

Line 10185: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN

10181: -- the aggregate function MAX always returns one (possibly null) row, so
10182: -- no need to check for the NO_DATA_FOUND exception, or initialize l_rev_code
10183: END IF;
10184: ELSE
10185: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN
10186: SELECT MAX( EIUAI.REVISION )
10187: INTO l_rev_code
10188: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10189: WHERE

Line 10259: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

10255: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10256: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
10257: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
10258: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10259: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10260: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10261: )
10262: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10263: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;

Line 10265: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN

10261: )
10262: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10263: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
10264: BEGIN
10265: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10266: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10267: INTO l_revision
10268: FROM
10269: MTL_ITEM_REVISIONS_INTERFACE MIRI

Line 10300: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

10296: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10297: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
10298: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
10299: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10300: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10301: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10302: )
10303: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10304: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;

Line 10307: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN

10303: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10304: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
10305: BEGIN
10306: IF p_inventory_item_id IS NULL THEN
10307: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10308: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST
10309: ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10310: INTO l_revision
10311: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

Line 10328: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN

10324: AND MIRI.REQUEST_ID = p_request_id
10325: AND MIRI.PROCESS_FLAG IN (3, 7);
10326: END IF;
10327: ELSE -- p_inventory_item_id is not null
10328: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10329: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST
10330: ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10331: INTO l_revision
10332: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

Line 10429: , p_do_processed_rows_flag => FND_API.G_FALSE

10425: l_revision_code := GET_LATEST_EIUAI_REV_SS( p_batch_id => p_batch_id
10426: , p_source_system_id => p_source_system_id
10427: , p_source_system_reference => p_source_system_reference
10428: , p_organization_id => p_organization_id
10429: , p_do_processed_rows_flag => FND_API.G_FALSE
10430: );
10431: END IF;
10432:
10433: IF l_revision_code IS NOT NULL

Line 10573: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

10569: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10570: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10571: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10572: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10573: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10574: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10575: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10576: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10577: , p_use_pdh_keys_to_join IN BOOLEAN

Line 10622: l_do_processed_rows := ( p_do_processed_rows_flag = FND_API.G_TRUE );

10618: l_join_sql := ' AND EIUAI.SOURCE_SYSTEM_REFERENCE = :ss_ref '
10619: || ' AND EIUAI.SOURCE_SYSTEM_ID = :ss_id ';
10620: END CASE;
10621:
10622: l_do_processed_rows := ( p_do_processed_rows_flag = FND_API.G_TRUE );
10623: l_do_procd_rows_sql := ' AND EIUAI.PROCESS_STATUS'
10624: || CASE
10625: WHEN l_do_processed_rows THEN ' IN ( 3, 4 ) AND EIUAI.REQUEST_ID = :req_id '
10626: WHEN NOT l_do_processed_rows AND NOT p_use_pdh_keys_to_join THEN ' = 0 '

Line 10770: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

10766: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10767: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10768: , p_attr_type IN FLAG
10769: , p_from_internal_column IN FLAG
10770: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10771: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10772: )
10773: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10774: IS

Line 10775: l_get_value_col BOOLEAN := ( FND_API.G_TRUE = p_from_internal_column );

10771: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10772: )
10773: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10774: IS
10775: l_get_value_col BOOLEAN := ( FND_API.G_TRUE = p_from_internal_column );
10776: BEGIN
10777: RETURN GET_REV_USR_ATTR_TO_CHAR
10778: (
10779: p_batch_id => p_batch_id

Line 10808: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

10804: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10805: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10806: , p_attr_type IN FLAG
10807: , p_from_internal_column IN FLAG
10808: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10809: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10810: )
10811: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10812: IS

Line 10813: l_get_value_col BOOLEAN := ( FND_API.G_TRUE = p_from_internal_column );

10809: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10810: )
10811: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10812: IS
10813: l_get_value_col BOOLEAN := ( FND_API.G_TRUE = p_from_internal_column );
10814: BEGIN
10815: RETURN GET_REV_USR_ATTR_TO_CHAR
10816: (
10817: p_batch_id => p_batch_id

Line 10850: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

10846: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10847: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10848: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10849: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10850: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10851: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10852: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10853: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10854: , p_use_pdh_keys_to_join IN BOOLEAN

Line 10895: l_do_processed_rows := ( p_do_processed_rows_flag = FND_API.G_TRUE );

10891: l_join_sql := ' AND EIUAI.SOURCE_SYSTEM_REFERENCE = :ss_ref '
10892: || ' AND EIUAI.SOURCE_SYSTEM_ID = :ss_id ';
10893: END CASE;
10894:
10895: l_do_processed_rows := ( p_do_processed_rows_flag = FND_API.G_TRUE );
10896: l_do_procd_rows_sql := ' AND EIUAI.PROCESS_STATUS'
10897: || CASE
10898: WHEN l_do_processed_rows THEN ' IN ( 3, 4 ) AND EIUAI.REQUEST_ID = :req_id '
10899: WHEN NOT l_do_processed_rows AND NOT p_use_pdh_keys_to_join THEN ' = 0 '

Line 11019: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11015: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11016: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11017: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11018: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11019: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11020: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11021: )
11022: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11023: BEGIN

Line 11050: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11046: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11047: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11048: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11049: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11050: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11051: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11052: )
11053: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11054: BEGIN

Line 11086: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11082: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11083: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11084: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11085: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11086: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11087: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11088: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11089: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11090: , p_use_pdh_keys_to_join IN BOOLEAN

Line 11132: l_do_processed_rows := ( p_do_processed_rows_flag = FND_API.G_TRUE );

11128: AND EIUAI.SOURCE_SYSTEM_REFERENCE = :ss_ref
11129: AND EIUAI.SOURCE_SYSTEM_ID = :ss_id ';
11130: END CASE;
11131:
11132: l_do_processed_rows := ( p_do_processed_rows_flag = FND_API.G_TRUE );
11133: l_do_procd_rows_sql := ' AND EIUAI.PROCESS_STATUS'
11134: || CASE
11135: WHEN l_do_processed_rows THEN ' IN ( 3, 4 ) AND EIUAI.REQUEST_ID = :req_id '
11136: WHEN NOT l_do_processed_rows AND NOT p_use_pdh_keys_to_join THEN ' = 0 '

Line 11252: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11248: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11249: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11250: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11251: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11252: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11253: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11254: )
11255: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11256: BEGIN

Line 11284: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11280: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11281: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11282: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11283: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11284: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11285: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11286: )
11287: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11288: BEGIN

Line 11322: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11318: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11319: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11320: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11321: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL
11322: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11323: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11324: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11325: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11326: , p_use_pdh_keys_to_join IN BOOLEAN

Line 11372: l_do_processed_rows := ( p_do_processed_rows_flag = FND_API.G_TRUE );

11368: l_join_sql := ' AND EIUAI.SOURCE_SYSTEM_REFERENCE = :ss_ref '
11369: || ' AND EIUAI.SOURCE_SYSTEM_ID = :ss_id ';
11370: END CASE;
11371:
11372: l_do_processed_rows := ( p_do_processed_rows_flag = FND_API.G_TRUE );
11373: l_do_procd_rows_sql := ' AND EIUAI.PROCESS_STATUS'
11374: || CASE
11375: WHEN l_do_processed_rows THEN ' IN ( 3, 4 ) AND EIUAI.REQUEST_ID = :req_id '
11376: WHEN NOT l_do_processed_rows AND NOT p_use_pdh_keys_to_join THEN ' = 0 '

Line 11549: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11545: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11546: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11547: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11548: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11549: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11550: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11551: )
11552: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11553: BEGIN

Line 11583: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11579: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11580: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11581: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11582: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11583: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11584: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11585: )
11586: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11587: BEGIN

Line 11621: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11617: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11618: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11619: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11620: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11621: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11622: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11623: )
11624: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11625: BEGIN

Line 11653: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11649: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11650: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11651: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11652: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11653: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11654: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11655: )
11656: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11657: BEGIN

Line 11690: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11686: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11687: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11688: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11689: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11690: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11691: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11692: )
11693: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11694: BEGIN

Line 11722: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11718: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11719: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11720: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11721: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11722: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11723: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11724: )
11725: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11726: BEGIN

Line 11761: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11757: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11758: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11759: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11760: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11761: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11762: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11763: )
11764: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11765: BEGIN

Line 11795: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11791: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11792: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11793: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11794: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11795: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11796: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11797: )
11798: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11799: BEGIN

Line 12068: l_revision_code := GET_LATEST_MIRI_REV_SS( p_batch_id, p_source_system_id, p_source_system_reference, p_organization_id, FND_API.G_FALSE );

12064:
12065: -- attempt to get the latest revision from the revision interface table
12066: -- according to latest effectivity date; in the case of equal effectivity
12067: -- dates, return that with the "greatest" revision code (ASCII sort order)
12068: l_revision_code := GET_LATEST_MIRI_REV_SS( p_batch_id, p_source_system_id, p_source_system_reference, p_organization_id, FND_API.G_FALSE );
12069:
12070: -- if the revision still could not be obtained, then obtain it from the
12071: -- user attrs interface table (ASCII sort order)
12072: IF (l_revision_code IS NULL) THEN

Line 12073: l_revision_code := GET_LATEST_EIUAI_REV_SS( p_batch_id, p_source_system_id, p_source_system_reference, p_organization_id, FND_API.G_FALSE );

12069:
12070: -- if the revision still could not be obtained, then obtain it from the
12071: -- user attrs interface table (ASCII sort order)
12072: IF (l_revision_code IS NULL) THEN
12073: l_revision_code := GET_LATEST_EIUAI_REV_SS( p_batch_id, p_source_system_id, p_source_system_reference, p_organization_id, FND_API.G_FALSE );
12074: END IF;
12075:
12076: RETURN l_revision_code;
12077: END GET_LATEST_REVISION_FUNC;

Line 12180: ,p_check_matching_table IN FLAG DEFAULT FND_API.G_FALSE

12176: ,p_source_system_reference IN MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
12177: ,p_new_status IN MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE
12178: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
12179: ,p_organization_id IN MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE DEFAULT NULL
12180: ,p_check_matching_table IN FLAG DEFAULT FND_API.G_FALSE
12181: ,errmsg OUT NOCOPY VARCHAR2
12182: ,retcode OUT NOCOPY VARCHAR2
12183: ) IS
12184: CURSOR cur_old_status IS

Line 12276: p_check_matching_table = FND_API.G_TRUE THEN

12272: END;
12273: END IF;
12274:
12275: IF p_new_status IN (G_CONF_MATCH, G_CONF_NEW, G_EXCLUDED) AND
12276: p_check_matching_table = FND_API.G_TRUE THEN
12277: errmsg := 'Invalid parameters: cannot check matching table when setting confirm_status to ' || p_new_status;
12278: retcode := 'F';
12279: RETURN;
12280: END IF;

Line 12283: l_need_resolve_unconf_status := FND_API.G_TRUE;

12279: RETURN;
12280: END IF;
12281:
12282: IF p_new_status IN (G_UNCONF_ACTION, G_UNEXCLUDE_ACTION) THEN
12283: l_need_resolve_unconf_status := FND_API.G_TRUE;
12284: END IF;
12285:
12286: IF l_need_resolve_unconf_status = FND_API.G_TRUE THEN
12287: SELECT decode(count(1), 0, G_UNCONF_NONE_MATCH, 1, G_UNCONF_SIGL_MATCH, G_UNCONF_MULT_match)

Line 12286: IF l_need_resolve_unconf_status = FND_API.G_TRUE THEN

12282: IF p_new_status IN (G_UNCONF_ACTION, G_UNEXCLUDE_ACTION) THEN
12283: l_need_resolve_unconf_status := FND_API.G_TRUE;
12284: END IF;
12285:
12286: IF l_need_resolve_unconf_status = FND_API.G_TRUE THEN
12287: SELECT decode(count(1), 0, G_UNCONF_NONE_MATCH, 1, G_UNCONF_SIGL_MATCH, G_UNCONF_MULT_match)
12288: INTO l_resolved_status
12289: FROM EGO_ITEM_MATCHES
12290: WHERE BATCH_ID = p_batch_id