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 748: * - Pass FND_API.G_TRUE to indicate that the batch is a PIMDH batch

744: * p_batch_id IN NUMBER =>
745: * The batch identifier (MANDATORY).
746: * p_is_pdh_batch IN FLAG DEFAULT NULL =>
747: * Used to determine the set of keys to use for merging.
748: * - Pass FND_API.G_TRUE to indicate that the batch is a PIMDH batch
749: * - Pass FND_API.G_FALSE to indicate that the batch is a non-PIMDH batch
750: * - If not passed, the batch header will be used to determine whether or not
751: * the batch is a PIMDH batch (absence of a header implies that it is).
752: * p_master_org_id IN NUMBER DEFAULT NULL =>

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

745: * The batch identifier (MANDATORY).
746: * p_is_pdh_batch IN FLAG DEFAULT NULL =>
747: * Used to determine the set of keys to use for merging.
748: * - Pass FND_API.G_TRUE to indicate that the batch is a PIMDH batch
749: * - Pass FND_API.G_FALSE to indicate that the batch is a non-PIMDH batch
750: * - If not passed, the batch header will be used to determine whether or not
751: * the batch is a PIMDH batch (absence of a header implies that it is).
752: * p_master_org_id IN NUMBER DEFAULT NULL =>
753: * The ID of the default batch organization, to be used for rows for which neither

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

753: * The ID of the default batch organization, to be used for rows for which neither
754: * ORGANIZATION_ID nor ORGANIZATION_CODE are provided.
755: * If not passed, the ORGANIZATION_ID in the batch header will be used.
756: *
757: * p_commit IN FLAG DEFAULT FND_API.G_FALSE =>
758: * Pass FND_API.G_TRUE to have a COMMIT issued at the end of the procedure.
759: */
760:
761: PROCEDURE merge_params_from_batch_header( p_batch_id IN NUMBER

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

754: * ORGANIZATION_ID nor ORGANIZATION_CODE are provided.
755: * If not passed, the ORGANIZATION_ID in the batch header will be used.
756: *
757: * p_commit IN FLAG DEFAULT FND_API.G_FALSE =>
758: * Pass FND_API.G_TRUE to have a COMMIT issued at the end of the procedure.
759: */
760:
761: PROCEDURE merge_params_from_batch_header( p_batch_id IN NUMBER
762: , x_is_pdh_batch OUT NOCOPY FLAG

Line 790: WHEN NULL THEN FND_API.G_TRUE

786:
787: x_ss_id := l_ss_id;
788: Debug_Conc_Log( 'SS ID:' || x_ss_id );
789: x_is_pdh_batch := CASE l_ss_id
790: WHEN NULL THEN FND_API.G_TRUE
791: WHEN get_pdh_source_system_id THEN FND_API.G_TRUE
792: ELSE FND_API.G_FALSE
793: END;
794: Debug_Conc_Log( 'Is PDH Batch:' || x_is_pdh_batch );

Line 791: WHEN get_pdh_source_system_id THEN FND_API.G_TRUE

787: x_ss_id := l_ss_id;
788: Debug_Conc_Log( 'SS ID:' || x_ss_id );
789: x_is_pdh_batch := CASE l_ss_id
790: WHEN NULL THEN FND_API.G_TRUE
791: WHEN get_pdh_source_system_id THEN FND_API.G_TRUE
792: ELSE FND_API.G_FALSE
793: END;
794: Debug_Conc_Log( 'Is PDH Batch:' || x_is_pdh_batch );
795: x_master_org_id := l_org_id;

Line 792: ELSE FND_API.G_FALSE

788: Debug_Conc_Log( 'SS ID:' || x_ss_id );
789: x_is_pdh_batch := CASE l_ss_id
790: WHEN NULL THEN FND_API.G_TRUE
791: WHEN get_pdh_source_system_id THEN FND_API.G_TRUE
792: ELSE FND_API.G_FALSE
793: END;
794: Debug_Conc_Log( 'Is PDH Batch:' || x_is_pdh_batch );
795: x_master_org_id := l_org_id;
796: Debug_Conc_Log( 'Master Org ID:' || x_master_org_id );

Line 806: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

802: PROCEDURE merge_rev_attrs ( p_batch_id IN NUMBER
803: , p_is_pdh_batch IN FLAG DEFAULT NULL
804: , p_ss_id IN NUMBER DEFAULT NULL
805: , p_master_org_id IN NUMBER DEFAULT NULL
806: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
807: )
808: IS
809: --6468564:Perf issue replacing EGO_ATTRS_V
810: 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 1022: l_is_pdh_batch := ( l_pdh_batch_flag = FND_API.G_TRUE );

1018: Debug_Conc_Log( l_proc_log_prefix || 'Master Org ID: '|| l_org_id );
1019: Debug_Conc_Log( l_proc_log_prefix || 'SS ID: ' || l_ss_id );
1020: Debug_Conc_Log( l_proc_log_prefix || 'Is PDH Batch?: '|| l_pdh_batch_flag );
1021:
1022: l_is_pdh_batch := ( l_pdh_batch_flag = FND_API.G_TRUE );
1023: IF l_is_pdh_batch THEN
1024: -- DBMS_OUTPUT.PUT_LINE( 'PDH Batch' );
1025: OPEN c_pdh_target_rev_attrs( l_org_id, l_rev_dl_id );
1026: FETCH c_pdh_target_rev_attrs BULK COLLECT INTO l_old_rows;

Line 1224: IF p_commit = FND_API.G_TRUE THEN

1220: VALUES l_merged_rows( row_index );
1221: END IF;
1222: END IF; -- ENDS IF l_old_rows.count <> 0
1223:
1224: IF p_commit = FND_API.G_TRUE THEN
1225: Debug_Conc_Log( l_proc_log_prefix || 'Committing' );
1226: COMMIT;
1227: END IF;
1228: Debug_Conc_Log( l_proc_log_prefix || 'Exiting' );

Line 1235: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

1231: PROCEDURE merge_item_attrs ( p_batch_id IN NUMBER
1232: , p_is_pdh_batch IN FLAG DEFAULT NULL
1233: , p_ss_id IN NUMBER DEFAULT NULL
1234: , p_master_org_id IN NUMBER DEFAULT NULL
1235: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
1236: )
1237: IS
1238:
1239: --6468564:Perf issue replacing EGO_ATTRS_V

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

1431: Debug_Conc_Log( l_proc_log_prefix || 'Master Org ID: ' || l_org_id );
1432: Debug_Conc_Log( l_proc_log_prefix || 'SS ID: ' || l_ss_id );
1433: Debug_Conc_Log( l_proc_log_prefix || 'Is PDH Batch?: ' || l_pdh_batch_flag );
1434:
1435: l_is_pdh_batch := ( l_pdh_batch_flag = FND_API.G_TRUE );
1436: IF l_is_pdh_batch THEN
1437: -- DBMS_OUTPUT.PUT_LINE( 'PDH Batch' );
1438: OPEN c_pdh_target_item_attrs( l_org_id );
1439: FETCH c_pdh_target_item_attrs BULK COLLECT INTO l_old_rows;

Line 1641: IF p_commit = FND_API.G_TRUE THEN

1637: VALUES l_merged_rows( row_index );
1638: END IF;
1639: END IF; -- ENDS IF l_old_rows.count <> 0
1640:
1641: IF p_commit = FND_API.G_TRUE THEN
1642: Debug_Conc_Log( l_proc_log_prefix || 'Committing' );
1643: COMMIT;
1644: END IF;
1645: Debug_Conc_Log( l_proc_log_prefix || 'Exiting' );

Line 1652: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

1648: PROCEDURE merge_items( p_batch_id IN NUMBER
1649: , p_is_pdh_batch IN FLAG
1650: , p_ss_id IN NUMBER DEFAULT NULL
1651: , p_master_org_id IN NUMBER DEFAULT NULL
1652: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
1653: )
1654: IS
1655: TYPE MSII_ROWS IS TABLE OF MSII_ROW INDEX BY BINARY_INTEGER;
1656:

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

1715: Debug_Conc_Log( l_proc_log_prefix || 'Master Org ID: ' || l_org_id );
1716: Debug_Conc_Log( l_proc_log_prefix || 'SS ID: ' || l_ss_id );
1717: Debug_Conc_Log( l_proc_log_prefix || 'Is PDH Batch?: ' || l_pdh_batch_flag );
1718:
1719: l_is_pdh_batch := ( l_pdh_batch_flag = FND_API.G_TRUE );
1720: IF l_is_pdh_batch THEN
1721: OPEN c_target_rows FOR
1722: SELECT *
1723: FROM

Line 2478: IF p_commit = FND_API.G_TRUE THEN

2474: ,l_err_text);
2475: End loop;
2476: END IF;
2477:
2478: IF p_commit = FND_API.G_TRUE THEN
2479: Debug_Conc_Log( l_proc_log_prefix || 'Committing' );
2480: COMMIT;
2481: END IF;
2482: Debug_Conc_Log( l_proc_log_prefix || 'Exiting' );

Line 2489: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

2485: PROCEDURE merge_revs( p_batch_id IN NUMBER
2486: , p_is_pdh_batch IN FLAG
2487: , p_ss_id IN NUMBER DEFAULT NULL
2488: , p_master_org_id IN NUMBER DEFAULT NULL
2489: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
2490: )
2491: IS
2492: SUBTYPE MIRI_ROW IS MTL_ITEM_REVISIONS_INTERFACE%ROWTYPE;
2493: TYPE MIRI_ROWS IS TABLE OF MIRI_ROW INDEX BY BINARY_INTEGER;

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

2637: WHERE REVISION_ID IS NOT NULL
2638: AND SET_PROCESS_ID = p_batch_id
2639: AND REVISION IS NULL;
2640:
2641: l_is_pdh_batch := ( l_pdh_batch_flag = FND_API.G_TRUE );
2642: IF l_is_pdh_batch THEN
2643: OPEN c_pdh_target_revs( l_org_id );
2644: FETCH c_pdh_target_revs BULK COLLECT INTO l_old_rows;
2645: CLOSE c_pdh_target_revs;

Line 2806: IF p_commit = FND_API.G_TRUE THEN

2802: INSERT INTO MTL_ITEM_REVISIONS_INTERFACE
2803: VALUES l_merged_rows( row_index );
2804: END IF;
2805: END IF; -- ENDS IF l_old_rows.count <> 0
2806: IF p_commit = FND_API.G_TRUE THEN
2807: Debug_Conc_Log( l_proc_log_prefix || 'Committing' );
2808: COMMIT;
2809: END IF;
2810: Debug_Conc_Log( l_proc_log_prefix || 'Exiting' );

Line 2816: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

2812:
2813: -- Merging Item Associations.
2814: PROCEDURE Merge_Associations ( p_batch_id IN NUMBER
2815: , p_is_pdh_batch IN FLAG DEFAULT NULL
2816: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
2817: )
2818: IS
2819:
2820: CURSOR pdh_candidate_assocs_rows_cur IS

Line 2907: IF p_is_pdh_batch = FND_API.G_TRUE THEN

2903: Debug_Conc_Log( 'Calling Merge_Associations ');
2904: l_current_rank_handled := 0;
2905: l_previous_rank_handled := 0;
2906:
2907: IF p_is_pdh_batch = FND_API.G_TRUE THEN
2908: -- 'PDH Batch'
2909: Debug_Conc_Log( 'Getting candidate rows for merging for PDH Batch ');
2910: OPEN pdh_candidate_assocs_rows_cur;
2911: FETCH pdh_candidate_assocs_rows_cur BULK COLLECT INTO l_old_rows;

Line 3037: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

3033: PROCEDURE merge_batch ( p_batch_id IN NUMBER
3034: , p_is_pdh_batch IN FLAG DEFAULT NULL
3035: , p_ss_id IN NUMBER DEFAULT NULL
3036: , p_master_org_id IN NUMBER DEFAULT NULL
3037: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
3038: )
3039: IS
3040: l_org_id NUMBER := p_master_org_id;
3041: l_pdh_batch_flag FLAG := p_is_pdh_batch;

Line 3058: , p_commit => FND_API.G_FALSE

3054: MERGE_ITEMS( p_batch_id => p_batch_id
3055: , p_master_org_id => l_org_id
3056: , p_is_pdh_batch => l_pdh_batch_flag
3057: , p_ss_id => l_ss_id
3058: , p_commit => FND_API.G_FALSE
3059: );
3060: Debug_Conc_Log( 'merge_batch: Merging batch revisions' );
3061: MERGE_REVS ( p_batch_id => p_batch_id
3062: , p_master_org_id => l_org_id

Line 3065: , p_commit => FND_API.G_FALSE

3061: MERGE_REVS ( p_batch_id => p_batch_id
3062: , p_master_org_id => l_org_id
3063: , p_is_pdh_batch => l_pdh_batch_flag
3064: , p_ss_id => l_ss_id
3065: , p_commit => FND_API.G_FALSE
3066: );
3067: Debug_Conc_Log( 'merge_batch: Merging Associations' );
3068: merge_associations( p_batch_id => p_batch_id
3069: , p_is_pdh_batch => l_pdh_batch_flag

Line 3070: , p_commit => FND_API.G_FALSE

3066: );
3067: Debug_Conc_Log( 'merge_batch: Merging Associations' );
3068: merge_associations( p_batch_id => p_batch_id
3069: , p_is_pdh_batch => l_pdh_batch_flag
3070: , p_commit => FND_API.G_FALSE
3071: );
3072:
3073: Debug_Conc_Log( 'merge_batch: Merging batch extended attributes' );
3074: MERGE_ATTRS( p_batch_id => p_batch_id

Line 3078: , p_commit => FND_API.G_FALSE

3074: MERGE_ATTRS( p_batch_id => p_batch_id
3075: , p_master_org_id => l_org_id
3076: , p_is_pdh_batch => l_pdh_batch_flag
3077: , p_ss_id => l_ss_id
3078: , p_commit => FND_API.G_FALSE
3079: );
3080: IF p_commit = FND_API.G_TRUE THEN
3081: Debug_Conc_Log( 'merge_batch: Committing' );
3082: COMMIT;

Line 3080: IF p_commit = FND_API.G_TRUE THEN

3076: , p_is_pdh_batch => l_pdh_batch_flag
3077: , p_ss_id => l_ss_id
3078: , p_commit => FND_API.G_FALSE
3079: );
3080: IF p_commit = FND_API.G_TRUE THEN
3081: Debug_Conc_Log( 'merge_batch: Committing' );
3082: COMMIT;
3083: END IF;
3084: Debug_Conc_Log( 'merge_batch: Exiting' );

Line 3091: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

3087: PROCEDURE merge_attrs ( p_batch_id IN NUMBER
3088: , p_is_pdh_batch IN FLAG DEFAULT NULL
3089: , p_ss_id IN NUMBER DEFAULT NULL
3090: , p_master_org_id IN NUMBER DEFAULT NULL
3091: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
3092: )
3093: IS
3094: l_org_id NUMBER := p_master_org_id;
3095: l_pdh_batch_flag FLAG := p_is_pdh_batch;

Line 3112: , p_commit => FND_API.G_FALSE

3108: MERGE_ITEM_ATTRS ( p_batch_id => p_batch_id
3109: , p_master_org_id => l_org_id
3110: , p_is_pdh_batch => l_pdh_batch_flag
3111: , p_ss_id => l_ss_id
3112: , p_commit => FND_API.G_FALSE
3113: );
3114: Debug_Conc_Log( 'merge_attrs: merging revision-level extended attributes' );
3115: MERGE_REV_ATTRS( p_batch_id => p_batch_id
3116: , p_master_org_id => l_org_id

Line 3119: , p_commit => FND_API.G_FALSE

3115: MERGE_REV_ATTRS( p_batch_id => p_batch_id
3116: , p_master_org_id => l_org_id
3117: , p_is_pdh_batch => l_pdh_batch_flag
3118: , p_ss_id => l_ss_id
3119: , p_commit => FND_API.G_FALSE
3120: );
3121: IF p_commit = FND_API.G_TRUE THEN
3122: Debug_Conc_Log( 'merge_attrs: Committing' );
3123: COMMIT;

Line 3121: IF p_commit = FND_API.G_TRUE THEN

3117: , p_is_pdh_batch => l_pdh_batch_flag
3118: , p_ss_id => l_ss_id
3119: , p_commit => FND_API.G_FALSE
3120: );
3121: IF p_commit = FND_API.G_TRUE THEN
3122: Debug_Conc_Log( 'merge_attrs: Committing' );
3123: COMMIT;
3124: END IF;
3125: Debug_Conc_Log( 'merge_attrs: Exiting' );

Line 6353: , p_is_pdh_batch IN FLAG DEFAULT FND_API.G_FALSE

6349: * parse item segments into item number if item_number is null
6350: */
6351: PROCEDURE PARSE_ITEM_SEGMENTS ( p_set_id IN NUMBER
6352: , p_master_org_id IN NUMBER
6353: , p_is_pdh_batch IN FLAG DEFAULT FND_API.G_FALSE
6354: )
6355: IS
6356: CURSOR c_ss_items_table IS
6357: SELECT rowid rid

Line 6384: IF p_is_pdh_batch = FND_API.G_TRUE THEN

6380: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE := NULL;
6381: l_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE := NULL;
6382: l_ret_code INTEGER;
6383: BEGIN
6384: IF p_is_pdh_batch = FND_API.G_TRUE THEN
6385: FOR item_record IN c_pdh_items_table LOOP
6386: l_ret_code := INVPUOPI.MTL_PR_PARSE_ITEM_SEGMENTS ( p_row_id =>item_record.rid
6387: , item_number =>l_item_number
6388: , item_id =>l_item_id

Line 6489: ,p_commit IN FLAG DEFAULT FND_API.G_TRUE

6485: * This procedure needs to be safe for re-execution if data is loaded into an
6486: * active batch repeatedly.
6487: */
6488: PROCEDURE Resolve_SSXref_on_Data_load( p_data_set_id IN NUMBER
6489: ,p_commit IN FLAG DEFAULT FND_API.G_TRUE
6490: )
6491: IS
6492: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6493: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

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

6826: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - PDH batch, done updating item_number if inventory_item_id is populated' );
6827:
6828: -- parse segments into item_number if item_number is null
6829: -- so that we can join to the child entities by item number alone
6830: PARSE_ITEM_SEGMENTS(p_data_set_id, l_org_id, FND_API.G_TRUE);
6831: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - PDH batch, done parsing item segments' );
6832:
6833: -- insert fake records ...
6834: l_insert_date := SYSDATE;

Line 6969: , p_is_pdh_batch => FND_API.G_TRUE

6965: GROUP BY MICI.ITEM_NUMBER, MICI.organization_id;
6966: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - PDH batch, parent rows inserted for CATEGORY ASSIGNMENT rows: ' || SQL%ROWCOUNT );
6967: MERGE_BATCH( p_batch_id => p_data_set_id
6968: , p_master_org_id => l_org_id
6969: , p_is_pdh_batch => FND_API.G_TRUE
6970: , p_commit => FND_API.G_FALSE
6971: );
6972: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - PDH batch, done merging batch' );
6973:

Line 6970: , p_commit => FND_API.G_FALSE

6966: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - PDH batch, parent rows inserted for CATEGORY ASSIGNMENT rows: ' || SQL%ROWCOUNT );
6967: MERGE_BATCH( p_batch_id => p_data_set_id
6968: , p_master_org_id => l_org_id
6969: , p_is_pdh_batch => FND_API.G_TRUE
6970: , p_commit => FND_API.G_FALSE
6971: );
6972: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - PDH batch, done merging batch' );
6973:
6974: -- resolve SYNC transaction_type into UPDATE or CREATE

Line 6994: IF FND_API.G_TRUE = p_commit THEN

6990: AND confirm_status = G_FAKE_CONF_STATUS_FLAG;
6991: */
6992:
6993: -- that's it
6994: IF FND_API.G_TRUE = p_commit THEN
6995: COMMIT;
6996: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - PDH batch, committed' );
6997: END IF;
6998:

Line 7051: , p_commit => FND_API.G_FALSE

7047:
7048: IF l_enabled_for_data_pool = 'Y' THEN
7049:
7050: EGO_IMPORT_UTIL_PVT.check_for_duplicates( p_batch_id => p_data_set_id
7051: , p_commit => FND_API.G_FALSE
7052: );
7053: Debug_Conc_Log( 'Done checking duplicates for a data_pool batch ' );
7054: ELSE
7055: Debug_Conc_Log( 'Duplicates checked only for a data_pool entabled batch' );

Line 7256: , p_is_pdh_batch => FND_API.G_FALSE

7252: */
7253: IF l_enabled_for_data_pool = 'N' THEN
7254: MERGE_BATCH( p_batch_id => p_data_set_id
7255: , p_master_org_id => l_org_id
7256: , p_is_pdh_batch => FND_API.G_FALSE
7257: , p_commit => FND_API.G_FALSE
7258: );
7259: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Source System batch, done merging rows' );
7260: ELSE

Line 7257: , p_commit => FND_API.G_FALSE

7253: IF l_enabled_for_data_pool = 'N' THEN
7254: MERGE_BATCH( p_batch_id => p_data_set_id
7255: , p_master_org_id => l_org_id
7256: , p_is_pdh_batch => FND_API.G_FALSE
7257: , p_commit => FND_API.G_FALSE
7258: );
7259: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Source System batch, done merging rows' );
7260: ELSE
7261: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Not calling merging, because batch is enabled for data pool' );

Line 7483: IF FND_API.G_TRUE = p_commit THEN

7479:
7480: Debug_Conc_Log('Resolve_SSXref_on_Data_load - After Updating Item Catalog Group ID' );
7481:
7482:
7483: IF FND_API.G_TRUE = p_commit THEN
7484: COMMIT;
7485: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Source System batch, committed' );
7486: END IF;
7487: EXCEPTION

Line 7489: IF FND_API.G_TRUE = p_commit THEN

7485: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Source System batch, committed' );
7486: END IF;
7487: EXCEPTION
7488: WHEN NO_DATA_FOUND THEN
7489: IF FND_API.G_TRUE = p_commit THEN
7490: COMMIT;
7491: END IF;
7492: RETURN;
7493:

Line 7503: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE

7499: * Here we group the rows based on item_number or source_system_reference
7500: */
7501: PROCEDURE CLEAN_UP_UDA_ROW_IDENTS_PRE( p_batch_id IN NUMBER,
7502: p_process_status IN NUMBER,
7503: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
7504: )
7505: IS
7506: CURSOR c_unmerged_rows(cp_ss_id IN NUMBER) IS
7507: SELECT ROW_IDENTIFIER FROM

Line 7720: IF FND_API.G_TRUE = p_commit THEN

7716: END LOOP;
7717: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - Done updating row_identifiers');
7718: CLOSE c_intf_recs;
7719:
7720: IF FND_API.G_TRUE = p_commit THEN
7721: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre COMMITING');
7722: COMMIT;
7723: END IF;
7724: EXCEPTION WHEN OTHERS THEN

Line 7738: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE

7734:
7735:
7736: PROCEDURE CLEAN_UP_UDA_ROW_IDENTS_POST( p_batch_id IN NUMBER,
7737: p_process_status IN NUMBER,
7738: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
7739: )
7740: IS
7741: CURSOR c_unmerged_rows IS
7742: SELECT ROW_IDENTIFIER FROM

Line 7922: IF FND_API.G_TRUE = p_commit THEN

7918: END LOOP;
7919: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post - Done updating row_identifiers');
7920: CLOSE c_intf_recs;
7921:
7922: IF FND_API.G_TRUE = p_commit THEN
7923: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post COMMITING');
7924: COMMIT;
7925: END IF;
7926: EXCEPTION WHEN OTHERS THEN

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

7941: * Helper procedure for resolve_child_entities
7942: */
7943: PROCEDURE CLEAN_UP_UDA_ROW_IDENTS( p_batch_id IN NUMBER,
7944: p_process_status IN NUMBER,
7945: p_ignore_item_num_upd IN VARCHAR2, --FND_API.G_TRUE
7946: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
7947: )
7948: IS
7949: BEGIN

Line 7946: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE

7942: */
7943: PROCEDURE CLEAN_UP_UDA_ROW_IDENTS( p_batch_id IN NUMBER,
7944: p_process_status IN NUMBER,
7945: p_ignore_item_num_upd IN VARCHAR2, --FND_API.G_TRUE
7946: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
7947: )
7948: IS
7949: BEGIN
7950: Debug_Conc_Log('Clean_Up_UDA_Row_Idents - Starting');

Line 7951: IF p_ignore_item_num_upd = FND_API.G_FALSE THEN

7947: )
7948: IS
7949: BEGIN
7950: Debug_Conc_Log('Clean_Up_UDA_Row_Idents - Starting');
7951: IF p_ignore_item_num_upd = FND_API.G_FALSE THEN
7952: Debug_Conc_Log('Clean_Up_UDA_Row_Idents - Calling CLEAN_UP_UDA_ROW_IDENTS_PRE');
7953: CLEAN_UP_UDA_ROW_IDENTS_PRE(p_batch_id => p_batch_id,
7954: p_process_status => p_process_status,
7955: p_commit => p_commit);

Line 7973: , p_commit IN FLAG DEFAULT FND_API.G_TRUE

7969: * EGO_ITEM_PEOPLE_INTF, MTL_ITEM_CATEGORIES_INTERFACE, EGO_ITM_USR_ATTR_INTRFC etc.
7970: * with the inventory item id/number and organization id/code.
7971: */
7972: PROCEDURE Resolve_Child_Entities( p_data_set_id IN NUMBER
7973: , p_commit IN FLAG DEFAULT FND_API.G_TRUE
7974: )
7975: IS
7976: CURSOR c_no_privilege_rows IS
7977: SELECT

Line 8089: p_ignore_item_num_upd => FND_API.G_FALSE,

8085:
8086: Debug_Conc_Log('Resolve_Child_Entities - Calling Clean_Up_UDA_Row_Idents');
8087: Clean_Up_UDA_Row_Idents( p_batch_id => p_data_set_id,
8088: p_process_status => 1,
8089: p_ignore_item_num_upd => FND_API.G_FALSE,
8090: p_commit => FND_API.G_FALSE );
8091: Debug_Conc_Log('Resolve_Child_Entities - Clean_Up_UDA_Row_Idents Done.');
8092:
8093: Debug_Conc_Log('Resolve_Child_Entities - Resolving Style_Item_Flag');

Line 8090: p_commit => FND_API.G_FALSE );

8086: Debug_Conc_Log('Resolve_Child_Entities - Calling Clean_Up_UDA_Row_Idents');
8087: Clean_Up_UDA_Row_Idents( p_batch_id => p_data_set_id,
8088: p_process_status => 1,
8089: p_ignore_item_num_upd => FND_API.G_FALSE,
8090: p_commit => FND_API.G_FALSE );
8091: Debug_Conc_Log('Resolve_Child_Entities - Clean_Up_UDA_Row_Idents Done.');
8092:
8093: Debug_Conc_Log('Resolve_Child_Entities - Resolving Style_Item_Flag');
8094: UPDATE MTL_SYSTEM_ITEMS_INTERFACE msii

Line 8116: IF FND_API.G_TRUE = p_commit THEN

8112:
8113: Debug_Conc_Log('Resolve_Child_Entities - Done Resolving Style_Item_Flag, rows processed='||SQL%ROWCOUNT);
8114:
8115: Debug_Conc_Log('Resolve_Child_Entities END');
8116: IF FND_API.G_TRUE = p_commit THEN
8117: Debug_Conc_Log('Resolve_Child_Entities COMMITING');
8118: COMMIT;
8119: END IF;
8120: RETURN;

Line 8271: IF FND_API.G_TRUE = p_commit THEN

8267: AND ORGANIZATION_ID = l_org_id;
8268:
8269: Debug_Conc_Log( 'Resolve_Child_Entities - After erroring out records without privilege' );
8270:
8271: IF FND_API.G_TRUE = p_commit THEN
8272: Debug_Conc_Log( 'Resolve_Child_Entities COMMITING' );
8273: COMMIT;
8274: END IF;
8275:

Line 9392: p_ignore_item_num_upd => FND_API.G_FALSE,

9388:
9389: Debug_Conc_Log('Resolve_Child_Entities - Calling Clean_Up_UDA_Row_Idents');
9390: Clean_Up_UDA_Row_Idents( p_batch_id => p_data_set_id,
9391: p_process_status => 1,
9392: p_ignore_item_num_upd => FND_API.G_FALSE,
9393: p_commit => FND_API.G_FALSE );
9394:
9395: Debug_Conc_Log('Resolve_Child_Entities - Clean_Up_UDA_Row_Idents Done.');
9396: ELSE

Line 9393: p_commit => FND_API.G_FALSE );

9389: Debug_Conc_Log('Resolve_Child_Entities - Calling Clean_Up_UDA_Row_Idents');
9390: Clean_Up_UDA_Row_Idents( p_batch_id => p_data_set_id,
9391: p_process_status => 1,
9392: p_ignore_item_num_upd => FND_API.G_FALSE,
9393: p_commit => FND_API.G_FALSE );
9394:
9395: Debug_Conc_Log('Resolve_Child_Entities - Clean_Up_UDA_Row_Idents Done.');
9396: ELSE
9397: Debug_Conc_Log('Resolve_Child_Entities - Not calling Merge_Batch_For_Import, because this batch is enabled for data pool');

Line 9422: IF FND_API.G_TRUE = p_commit THEN

9418:
9419: Debug_Conc_Log('Resolve_Child_Entities - Done Resolving Style_Item_Flag, rows processed='||SQL%ROWCOUNT);
9420:
9421: Debug_Conc_Log('Resolve_Child_Entities END');
9422: IF FND_API.G_TRUE = p_commit THEN
9423: Debug_Conc_Log('Resolve_Child_Entities COMMITING');
9424: COMMIT;
9425: END IF;
9426:

Line 10150: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

10146: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10147: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10148: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10149: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10150: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10151: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10152: )
10153: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10154: IS

Line 10157: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN

10153: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10154: IS
10155: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10156: BEGIN
10157: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN
10158: SELECT MAX( EIUAI.REVISION ) INTO l_rev_code
10159: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10160: WHERE EIUAI.SOURCE_SYSTEM_REFERENCE = p_source_system_reference
10161: AND EIUAI.SOURCE_SYSTEM_ID = p_source_system_id

Line 10220: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

10216: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10217: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10218: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10219: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10220: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10221: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10222: )
10223: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10224: IS

Line 10233: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN

10229: -- no need to check for the NO_DATA_FOUND exception, or initialize l_rev_code
10230:
10231: IF p_inventory_item_id IS NULL
10232: THEN
10233: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN
10234: SELECT MAX( EIUAI.REVISION )
10235: INTO l_rev_code
10236: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10237: WHERE EIUAI.ITEM_NUMBER = p_item_number

Line 10288: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN

10284: -- the aggregate function MAX always returns one (possibly null) row, so
10285: -- no need to check for the NO_DATA_FOUND exception, or initialize l_rev_code
10286: END IF;
10287: ELSE
10288: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN
10289: SELECT MAX( EIUAI.REVISION )
10290: INTO l_rev_code
10291: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10292: WHERE

Line 10362: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

10358: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10359: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
10360: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
10361: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10362: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10363: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10364: )
10365: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10366: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;

Line 10368: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN

10364: )
10365: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10366: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
10367: BEGIN
10368: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10369: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10370: INTO l_revision
10371: FROM
10372: MTL_ITEM_REVISIONS_INTERFACE MIRI

Line 10403: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

10399: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
10400: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
10401: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
10402: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
10403: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10404: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
10405: )
10406: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10407: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;

Line 10410: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN

10406: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE IS
10407: l_revision MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
10408: BEGIN
10409: IF p_inventory_item_id IS NULL THEN
10410: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10411: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST
10412: ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10413: INTO l_revision
10414: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

Line 10431: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN

10427: AND MIRI.REQUEST_ID = p_request_id
10428: AND MIRI.PROCESS_FLAG IN (3, 7);
10429: END IF;
10430: ELSE -- p_inventory_item_id is not null
10431: IF p_do_processed_rows_flag = FND_API.G_FALSE THEN
10432: SELECT MAX( REVISION ) KEEP ( DENSE_RANK FIRST
10433: ORDER BY MIRI.EFFECTIVITY_DATE DESC NULLS LAST , MIRI.REVISION DESC NULLS LAST )
10434: INTO l_revision
10435: FROM MTL_ITEM_REVISIONS_INTERFACE MIRI

Line 10532: , p_do_processed_rows_flag => FND_API.G_FALSE

10528: l_revision_code := GET_LATEST_EIUAI_REV_SS( p_batch_id => p_batch_id
10529: , p_source_system_id => p_source_system_id
10530: , p_source_system_reference => p_source_system_reference
10531: , p_organization_id => p_organization_id
10532: , p_do_processed_rows_flag => FND_API.G_FALSE
10533: );
10534: END IF;
10535:
10536: IF l_revision_code IS NOT NULL

Line 10676: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

10672: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10673: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10674: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10675: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10676: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10677: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10678: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10679: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10680: , p_use_pdh_keys_to_join IN BOOLEAN

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

10721: l_join_sql := ' AND EIUAI.SOURCE_SYSTEM_REFERENCE = :ss_ref '
10722: || ' AND EIUAI.SOURCE_SYSTEM_ID = :ss_id ';
10723: END CASE;
10724:
10725: l_do_processed_rows := ( p_do_processed_rows_flag = FND_API.G_TRUE );
10726: l_do_procd_rows_sql := ' AND EIUAI.PROCESS_STATUS'
10727: || CASE
10728: WHEN l_do_processed_rows THEN ' IN ( 3, 4 ) AND EIUAI.REQUEST_ID = :req_id '
10729: WHEN NOT l_do_processed_rows AND NOT p_use_pdh_keys_to_join THEN ' = 0 '

Line 10873: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

10869: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10870: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10871: , p_attr_type IN FLAG
10872: , p_from_internal_column IN FLAG
10873: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10874: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10875: )
10876: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10877: IS

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

10874: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10875: )
10876: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10877: IS
10878: l_get_value_col BOOLEAN := ( FND_API.G_TRUE = p_from_internal_column );
10879: BEGIN
10880: RETURN GET_REV_USR_ATTR_TO_CHAR
10881: (
10882: p_batch_id => p_batch_id

Line 10911: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

10907: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10908: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10909: , p_attr_type IN FLAG
10910: , p_from_internal_column IN FLAG
10911: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10912: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10913: )
10914: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10915: IS

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

10912: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10913: )
10914: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10915: IS
10916: l_get_value_col BOOLEAN := ( FND_API.G_TRUE = p_from_internal_column );
10917: BEGIN
10918: RETURN GET_REV_USR_ATTR_TO_CHAR
10919: (
10920: p_batch_id => p_batch_id

Line 10953: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

10949: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10950: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10951: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10952: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10953: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10954: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10955: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10956: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10957: , p_use_pdh_keys_to_join IN BOOLEAN

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

10994: l_join_sql := ' AND EIUAI.SOURCE_SYSTEM_REFERENCE = :ss_ref '
10995: || ' AND EIUAI.SOURCE_SYSTEM_ID = :ss_id ';
10996: END CASE;
10997:
10998: l_do_processed_rows := ( p_do_processed_rows_flag = FND_API.G_TRUE );
10999: l_do_procd_rows_sql := ' AND EIUAI.PROCESS_STATUS'
11000: || CASE
11001: WHEN l_do_processed_rows THEN ' IN ( 3, 4 ) AND EIUAI.REQUEST_ID = :req_id '
11002: WHEN NOT l_do_processed_rows AND NOT p_use_pdh_keys_to_join THEN ' = 0 '

Line 11122: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11118: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11119: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11120: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11121: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11122: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11123: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11124: )
11125: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11126: BEGIN

Line 11153: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11149: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11150: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11151: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11152: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11153: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11154: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11155: )
11156: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11157: BEGIN

Line 11189: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11185: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11186: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11187: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11188: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11189: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11190: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11191: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11192: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11193: , p_use_pdh_keys_to_join IN BOOLEAN

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

11231: AND EIUAI.SOURCE_SYSTEM_REFERENCE = :ss_ref
11232: AND EIUAI.SOURCE_SYSTEM_ID = :ss_id ';
11233: END CASE;
11234:
11235: l_do_processed_rows := ( p_do_processed_rows_flag = FND_API.G_TRUE );
11236: l_do_procd_rows_sql := ' AND EIUAI.PROCESS_STATUS'
11237: || CASE
11238: WHEN l_do_processed_rows THEN ' IN ( 3, 4 ) AND EIUAI.REQUEST_ID = :req_id '
11239: WHEN NOT l_do_processed_rows AND NOT p_use_pdh_keys_to_join THEN ' = 0 '

Line 11355: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11351: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11352: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11353: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11354: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11355: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11356: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11357: )
11358: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11359: BEGIN

Line 11387: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11383: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11384: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11385: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11386: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11387: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11388: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11389: )
11390: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11391: BEGIN

Line 11425: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11421: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11422: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11423: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11424: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL
11425: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11426: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11427: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11428: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11429: , p_use_pdh_keys_to_join IN BOOLEAN

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

11471: l_join_sql := ' AND EIUAI.SOURCE_SYSTEM_REFERENCE = :ss_ref '
11472: || ' AND EIUAI.SOURCE_SYSTEM_ID = :ss_id ';
11473: END CASE;
11474:
11475: l_do_processed_rows := ( p_do_processed_rows_flag = FND_API.G_TRUE );
11476: l_do_procd_rows_sql := ' AND EIUAI.PROCESS_STATUS'
11477: || CASE
11478: WHEN l_do_processed_rows THEN ' IN ( 3, 4 ) AND EIUAI.REQUEST_ID = :req_id '
11479: WHEN NOT l_do_processed_rows AND NOT p_use_pdh_keys_to_join THEN ' = 0 '

Line 11652: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

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

Line 11686: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11682: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11683: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11684: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11685: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11686: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11687: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11688: )
11689: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11690: BEGIN

Line 11724: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

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

Line 11756: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11752: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11753: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11754: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11755: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11756: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11757: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11758: )
11759: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11760: BEGIN

Line 11793: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11789: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11790: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11791: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11792: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11793: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11794: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11795: )
11796: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11797: BEGIN

Line 11825: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11821: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11822: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11823: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11824: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11825: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11826: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11827: )
11828: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11829: BEGIN

Line 11864: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11860: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11861: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11862: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11863: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11864: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11865: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11866: )
11867: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11868: BEGIN

Line 11898: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

11894: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11895: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11896: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11897: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11898: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11899: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11900: )
11901: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11902: BEGIN

Line 12188: 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 );

12184:
12185: -- attempt to get the latest revision from the revision interface table
12186: -- according to latest effectivity date; in the case of equal effectivity
12187: -- dates, return that with the "greatest" revision code (ASCII sort order)
12188: 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 );
12189:
12190: -- if the revision still could not be obtained, then obtain it from the
12191: -- user attrs interface table (ASCII sort order)
12192: IF (l_revision_code IS NULL) THEN

Line 12193: 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 );

12189:
12190: -- if the revision still could not be obtained, then obtain it from the
12191: -- user attrs interface table (ASCII sort order)
12192: IF (l_revision_code IS NULL) THEN
12193: 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 );
12194: END IF;
12195:
12196: RETURN l_revision_code;
12197: END GET_LATEST_REVISION_FUNC;

Line 12300: ,p_check_matching_table IN FLAG DEFAULT FND_API.G_FALSE

12296: ,p_source_system_reference IN MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
12297: ,p_new_status IN MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE
12298: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
12299: ,p_organization_id IN MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE DEFAULT NULL
12300: ,p_check_matching_table IN FLAG DEFAULT FND_API.G_FALSE
12301: ,errmsg OUT NOCOPY VARCHAR2
12302: ,retcode OUT NOCOPY VARCHAR2
12303: ) IS
12304: CURSOR cur_old_status IS

Line 12396: p_check_matching_table = FND_API.G_TRUE THEN

12392: END;
12393: END IF;
12394:
12395: IF p_new_status IN (G_CONF_MATCH, G_CONF_NEW, G_EXCLUDED) AND
12396: p_check_matching_table = FND_API.G_TRUE THEN
12397: errmsg := 'Invalid parameters: cannot check matching table when setting confirm_status to ' || p_new_status;
12398: retcode := 'F';
12399: RETURN;
12400: END IF;

Line 12403: l_need_resolve_unconf_status := FND_API.G_TRUE;

12399: RETURN;
12400: END IF;
12401:
12402: IF p_new_status IN (G_UNCONF_ACTION, G_UNEXCLUDE_ACTION) THEN
12403: l_need_resolve_unconf_status := FND_API.G_TRUE;
12404: END IF;
12405:
12406: IF l_need_resolve_unconf_status = FND_API.G_TRUE THEN
12407: SELECT decode(count(1), 0, G_UNCONF_NONE_MATCH, 1, G_UNCONF_SIGL_MATCH, G_UNCONF_MULT_match)

Line 12406: IF l_need_resolve_unconf_status = FND_API.G_TRUE THEN

12402: IF p_new_status IN (G_UNCONF_ACTION, G_UNEXCLUDE_ACTION) THEN
12403: l_need_resolve_unconf_status := FND_API.G_TRUE;
12404: END IF;
12405:
12406: IF l_need_resolve_unconf_status = FND_API.G_TRUE THEN
12407: SELECT decode(count(1), 0, G_UNCONF_NONE_MATCH, 1, G_UNCONF_SIGL_MATCH, G_UNCONF_MULT_match)
12408: INTO l_resolved_status
12409: FROM EGO_ITEM_MATCHES
12410: WHERE BATCH_ID = p_batch_id