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_UTIL_PVT dependencies on FND_GLOBAL

Line 1240: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1236: errbuf OUT NOCOPY VARCHAR2,
1237: p_batch_id NUMBER,
1238: p_copy_options_exist VARCHAR2)
1239: IS
1240: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1241: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1242: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1243: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1244: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 1241: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

1237: p_batch_id NUMBER,
1238: p_copy_options_exist VARCHAR2)
1239: IS
1240: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1241: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1242: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1243: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1244: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1245: l_err_msg VARCHAR2(4000);

Line 1242: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

1238: p_copy_options_exist VARCHAR2)
1239: IS
1240: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1241: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1242: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1243: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1244: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1245: l_err_msg VARCHAR2(4000);
1246: l_copy_first VARCHAR2(1);

Line 1243: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

1239: IS
1240: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1241: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1242: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1243: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1244: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1245: l_err_msg VARCHAR2(4000);
1246: l_copy_first VARCHAR2(1);
1247: l_return_status VARCHAR2(1) := '0';

Line 1244: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

1240: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1241: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1242: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1243: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1244: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1245: l_err_msg VARCHAR2(4000);
1246: l_copy_first VARCHAR2(1);
1247: l_return_status VARCHAR2(1) := '0';
1248: BEGIN

Line 1486: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

1482: PROCEDURE Copy_New_Cat_Assgns_From_Style(retcode OUT NOCOPY VARCHAR2,
1483: errbuf OUT NOCOPY VARCHAR2,
1484: p_batch_id NUMBER)
1485: IS
1486: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1487: l_def_style_catg_option VARCHAR2(1);
1488: l_pdh_ss_id NUMBER := EGO_IMPORT_PVT.Get_Pdh_Source_System_Id;
1489: BEGIN
1490: RETCODE := '0';

Line 1644: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1640: errbuf OUT NOCOPY VARCHAR2,
1641: p_batch_id NUMBER,
1642: p_copy_options_exist VARCHAR2)
1643: IS
1644: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1645: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1646: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1647: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1648: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 1645: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

1641: p_batch_id NUMBER,
1642: p_copy_options_exist VARCHAR2)
1643: IS
1644: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1645: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1646: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1647: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1648: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1649: l_err_msg VARCHAR2(4000);

Line 1646: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

1642: p_copy_options_exist VARCHAR2)
1643: IS
1644: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1645: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1646: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1647: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1648: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1649: l_err_msg VARCHAR2(4000);
1650: l_return_status INTEGER;

Line 1647: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

1643: IS
1644: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1645: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1646: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1647: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1648: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1649: l_err_msg VARCHAR2(4000);
1650: l_return_status INTEGER;
1651: l_ret_status VARCHAR2(10);

Line 1648: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

1644: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1645: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1646: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1647: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1648: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1649: l_err_msg VARCHAR2(4000);
1650: l_return_status INTEGER;
1651: l_ret_status VARCHAR2(10);
1652: l_copy_first VARCHAR2(1);

Line 3636: l_user_id NUMBER := FND_GLOBAL.USER_ID;

3632: IS
3633: l_item_master_dl_id NUMBER;
3634: l_enabled_for_data_pool VARCHAR2(1);
3635: l_item_detail_tbl ITEM_DETAIL_TBL;
3636: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3637: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3638: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
3639: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
3640: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 3637: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

3633: l_item_master_dl_id NUMBER;
3634: l_enabled_for_data_pool VARCHAR2(1);
3635: l_item_detail_tbl ITEM_DETAIL_TBL;
3636: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3637: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3638: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
3639: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
3640: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
3641: l_ret_code VARCHAR2(10);

Line 3638: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

3634: l_enabled_for_data_pool VARCHAR2(1);
3635: l_item_detail_tbl ITEM_DETAIL_TBL;
3636: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3637: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3638: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
3639: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
3640: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
3641: l_ret_code VARCHAR2(10);
3642: l_err_buf VARCHAR2(4000);

Line 3639: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

3635: l_item_detail_tbl ITEM_DETAIL_TBL;
3636: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3637: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3638: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
3639: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
3640: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
3641: l_ret_code VARCHAR2(10);
3642: l_err_buf VARCHAR2(4000);
3643: BEGIN

Line 3640: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

3636: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3637: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3638: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
3639: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
3640: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
3641: l_ret_code VARCHAR2(10);
3642: l_err_buf VARCHAR2(4000);
3643: BEGIN
3644: Debug_Conc_Log('Validate_Timestamp_With_Prod: Starting p_batch_id='||p_batch_id);

Line 3927: l_user_id NUMBER := FND_GLOBAL.USER_ID;

3923: PROCEDURE Preprocess_Import(retcode OUT NOCOPY VARCHAR2,
3924: errbuf OUT NOCOPY VARCHAR2,
3925: p_batch_id NUMBER)
3926: IS
3927: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3928: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3929: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
3930: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
3931: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 3928: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

3924: errbuf OUT NOCOPY VARCHAR2,
3925: p_batch_id NUMBER)
3926: IS
3927: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3928: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3929: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
3930: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
3931: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
3932: l_err_msg VARCHAR2(4000);

Line 3929: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

3925: p_batch_id NUMBER)
3926: IS
3927: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3928: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3929: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
3930: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
3931: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
3932: l_err_msg VARCHAR2(4000);
3933: l_return_status INTEGER;

Line 3930: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

3926: IS
3927: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3928: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3929: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
3930: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
3931: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
3932: l_err_msg VARCHAR2(4000);
3933: l_return_status INTEGER;
3934: l_copy_first VARCHAR2(1);

Line 3931: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

3927: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3928: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3929: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
3930: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
3931: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
3932: l_err_msg VARCHAR2(4000);
3933: l_return_status INTEGER;
3934: l_copy_first VARCHAR2(1);
3935: l_copy_option_exists VARCHAR2(1);

Line 4729: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

4725: l_object_id NUMBER;
4726: l_ret_status VARCHAR2(10);
4727: l_def_style_people_option VARCHAR2(1);
4728: l_copy_people_option VARCHAR2(1);
4729: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
4730: l_sql VARCHAR2(32000);
4731: l_item_id_sql VARCHAR2(1000);
4732:
4733: l_inventory_item_id NUMBER;

Line 4772: WHERE USER_ID = FND_GLOBAL.USER_ID;

4768: Debug_Conc_Log('Default_Item_People: l_menu_id-'||l_menu_id);
4769:
4770: SELECT 'HZ_PARTY:'||PARTY_ID INTO l_party_key
4771: FROM EGO_USER_V
4772: WHERE USER_ID = FND_GLOBAL.USER_ID;
4773:
4774: Debug_Conc_Log('Default_Item_People: l_party_key-'||l_party_key);
4775:
4776: SELECT OBJECT_ID INTO l_object_id

Line 4922: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

4918: l_errorcode VARCHAR2(10);
4919: l_object_id NUMBER;
4920: l_ret_status VARCHAR2(10);
4921: l_def_style_people_option VARCHAR2(1);
4922: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
4923: BEGIN
4924: Debug_Conc_Log('Copy_Item_People_From_Style: Starting');
4925: RETCODE := '0';
4926: l_def_style_people_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_PEOPLE');

Line 5028: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

5024: l_msg_data VARCHAR2(4000);
5025: l_ret_status VARCHAR2(10);
5026: l_def_style_project_option VARCHAR2(1);
5027: l_copy_people_option VARCHAR2(1);
5028: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5029: l_inventory_item_id NUMBER;
5030: l_organization_id NUMBER;
5031: BEGIN
5032: Debug_Conc_Log('Copy_LC_Projects: Starting');

Line 5304: l_user_id NUMBER := FND_GLOBAL.USER_ID;

5300: l_sequence NUMBER;
5301: l_select_flag VARCHAR2(1);
5302: l_error NUMBER := 0;
5303: l_sysdate DATE := sysdate;
5304: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5305: l_batch_exists NUMBER := 0;
5306: BEGIN
5307: IF ((p_batch_id IS NULL) OR (p_batch_id = 0)) THEN
5308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5473: l_user_id NUMBER := FND_GLOBAL.USER_ID;

5469: l_attr_disp_value VARCHAR2(1000);
5470: l_style_item_flag VARCHAR2(1);
5471: l_variant VARCHAR2(1);
5472:
5473: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5474: l_batch_exists NUMBER := 0;
5475: l_error NUMBER := 0;
5476: BEGIN
5477:

Line 5667: l_user_id NUMBER := FND_GLOBAL.USER_ID;

5663: IS
5664: l_item_master_dl_id NUMBER;
5665: l_enabled_for_data_pool VARCHAR2(1);
5666: l_item_detail_tbl ITEM_DETAIL_TBL;
5667: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5668: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5669: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5670: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5671: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 5668: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

5664: l_item_master_dl_id NUMBER;
5665: l_enabled_for_data_pool VARCHAR2(1);
5666: l_item_detail_tbl ITEM_DETAIL_TBL;
5667: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5668: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5669: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5670: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5671: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5672: l_ret_code VARCHAR2(10);

Line 5669: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

5665: l_enabled_for_data_pool VARCHAR2(1);
5666: l_item_detail_tbl ITEM_DETAIL_TBL;
5667: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5668: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5669: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5670: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5671: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5672: l_ret_code VARCHAR2(10);
5673: l_err_buf VARCHAR2(4000);

Line 5670: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

5666: l_item_detail_tbl ITEM_DETAIL_TBL;
5667: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5668: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5669: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5670: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5671: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5672: l_ret_code VARCHAR2(10);
5673: l_err_buf VARCHAR2(4000);
5674: BEGIN

Line 5671: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

5667: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5668: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5669: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
5670: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
5671: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5672: l_ret_code VARCHAR2(10);
5673: l_err_buf VARCHAR2(4000);
5674: BEGIN
5675: Debug_Conc_Log('Validate_Timestamp_In_Batch: Starting p_batch_id='||p_batch_id);

Line 5966: l_user_id NUMBER := FND_GLOBAL.USER_ID;

5962: p_batch_id IN NUMBER)
5963: IS
5964: l_item_master_dl_id NUMBER;
5965: l_enabled_for_data_pool VARCHAR2(1);
5966: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5967: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5968: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5969: BEGIN
5970: Debug_Conc_Log('Update_Timestamp_In_Prod: Starting p_batch_id='||p_batch_id);

Line 5967: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

5963: IS
5964: l_item_master_dl_id NUMBER;
5965: l_enabled_for_data_pool VARCHAR2(1);
5966: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5967: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5968: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5969: BEGIN
5970: Debug_Conc_Log('Update_Timestamp_In_Prod: Starting p_batch_id='||p_batch_id);
5971: BEGIN

Line 5968: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

5964: l_item_master_dl_id NUMBER;
5965: l_enabled_for_data_pool VARCHAR2(1);
5966: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5967: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
5968: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5969: BEGIN
5970: Debug_Conc_Log('Update_Timestamp_In_Prod: Starting p_batch_id='||p_batch_id);
5971: BEGIN
5972: SELECT NVL(ENABLED_FOR_DATA_POOL, 'N') INTO l_enabled_for_data_pool

Line 6112: AND msii.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID

6108: MTL_PARAMETERS mp
6109: WHERE msii.SET_PROCESS_ID = p_batch_id
6110: AND msii.PROCESS_FLAG = 7
6111: AND msii.TRANSACTION_TYPE = 'CREATE'
6112: AND msii.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
6113: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID
6114: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
6115: AND ( msii.STYLE_ITEM_FLAG = 'Y'
6116: OR msii.STYLE_ITEM_FLAG IS NULL );

Line 6164: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

6160: p_batch_id IN NUMBER )
6161: IS
6162: l_item_dl_id NUMBER;
6163: l_item_object_id NUMBER;
6164: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
6165: BEGIN
6166: Debug_Conc_Log('Clean_Dirty_SKUs : Starting ');
6167: SELECT OBJECT_ID INTO l_item_object_id
6168: FROM FND_OBJECTS