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 1397: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1393: errbuf OUT NOCOPY VARCHAR2,
1394: p_batch_id NUMBER,
1395: p_copy_options_exist VARCHAR2)
1396: IS
1397: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1398: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1399: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1400: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1401: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 1398: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

1394: p_batch_id NUMBER,
1395: p_copy_options_exist VARCHAR2)
1396: IS
1397: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1398: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1399: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1400: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1401: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1402: l_err_msg VARCHAR2(4000);

Line 1399: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

1395: p_copy_options_exist VARCHAR2)
1396: IS
1397: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1398: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1399: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1400: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1401: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1402: l_err_msg VARCHAR2(4000);
1403: l_copy_first VARCHAR2(1);

Line 1400: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

1396: IS
1397: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1398: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1399: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1400: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1401: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1402: l_err_msg VARCHAR2(4000);
1403: l_copy_first VARCHAR2(1);
1404: l_return_status VARCHAR2(1) := '0';

Line 1401: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

1397: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1398: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1399: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1400: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1401: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1402: l_err_msg VARCHAR2(4000);
1403: l_copy_first VARCHAR2(1);
1404: l_return_status VARCHAR2(1) := '0';
1405: BEGIN

Line 1656: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

1652: PROCEDURE Copy_New_Cat_Assgns_From_Style(retcode OUT NOCOPY VARCHAR2,
1653: errbuf OUT NOCOPY VARCHAR2,
1654: p_batch_id NUMBER)
1655: IS
1656: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1657: l_def_style_catg_option VARCHAR2(1);
1658: l_pdh_ss_id NUMBER := EGO_IMPORT_PVT.Get_Pdh_Source_System_Id;
1659: BEGIN
1660: RETCODE := '0';

Line 1814: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1810: errbuf OUT NOCOPY VARCHAR2,
1811: p_batch_id NUMBER,
1812: p_copy_options_exist VARCHAR2)
1813: IS
1814: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1815: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1816: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1817: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1818: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 1815: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

1811: p_batch_id NUMBER,
1812: p_copy_options_exist VARCHAR2)
1813: IS
1814: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1815: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1816: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1817: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1818: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1819: l_err_msg VARCHAR2(4000);

Line 1816: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

1812: p_copy_options_exist VARCHAR2)
1813: IS
1814: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1815: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1816: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1817: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1818: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1819: l_err_msg VARCHAR2(4000);
1820: l_return_status INTEGER;

Line 1817: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

1813: IS
1814: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1815: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1816: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1817: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1818: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1819: l_err_msg VARCHAR2(4000);
1820: l_return_status INTEGER;
1821: l_ret_status VARCHAR2(10);

Line 1818: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

1814: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1815: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1816: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
1817: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1818: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1819: l_err_msg VARCHAR2(4000);
1820: l_return_status INTEGER;
1821: l_ret_status VARCHAR2(10);
1822: l_copy_first VARCHAR2(1);

Line 3839: l_user_id NUMBER := FND_GLOBAL.USER_ID;

3835: IS
3836: l_item_master_dl_id NUMBER;
3837: l_enabled_for_data_pool VARCHAR2(1);
3838: l_item_detail_tbl ITEM_DETAIL_TBL;
3839: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3840: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3841: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
3842: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
3843: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 3840: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

3836: l_item_master_dl_id NUMBER;
3837: l_enabled_for_data_pool VARCHAR2(1);
3838: l_item_detail_tbl ITEM_DETAIL_TBL;
3839: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3840: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3841: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
3842: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
3843: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
3844: l_ret_code VARCHAR2(10);

Line 3841: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

3837: l_enabled_for_data_pool VARCHAR2(1);
3838: l_item_detail_tbl ITEM_DETAIL_TBL;
3839: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3840: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3841: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
3842: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
3843: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
3844: l_ret_code VARCHAR2(10);
3845: l_err_buf VARCHAR2(4000);

Line 3842: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

3838: l_item_detail_tbl ITEM_DETAIL_TBL;
3839: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3840: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3841: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
3842: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
3843: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
3844: l_ret_code VARCHAR2(10);
3845: l_err_buf VARCHAR2(4000);
3846: BEGIN

Line 3843: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

3839: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3840: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3841: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
3842: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
3843: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
3844: l_ret_code VARCHAR2(10);
3845: l_err_buf VARCHAR2(4000);
3846: BEGIN
3847: Debug_Conc_Log('Validate_Timestamp_With_Prod: Starting p_batch_id='||p_batch_id);

Line 4357: FND_GLOBAL.CONC_REQUEST_ID, -- Bug 10112500

4353: */ -- Bug 13720439 - End
4354: a.item_catalog_group_id,
4355: attr_group_type,
4356: attr_group_id,
4357: FND_GLOBAL.CONC_REQUEST_ID, -- Bug 10112500
4358: fnd_global.user_id,
4359: SYSDATE,
4360: fnd_global.user_id,
4361: SYSDATE

Line 4358: fnd_global.user_id,

4354: a.item_catalog_group_id,
4355: attr_group_type,
4356: attr_group_id,
4357: FND_GLOBAL.CONC_REQUEST_ID, -- Bug 10112500
4358: fnd_global.user_id,
4359: SYSDATE,
4360: fnd_global.user_id,
4361: SYSDATE
4362: FROM ego_itm_usr_attr_intrfc a,

Line 4360: fnd_global.user_id,

4356: attr_group_id,
4357: FND_GLOBAL.CONC_REQUEST_ID, -- Bug 10112500
4358: fnd_global.user_id,
4359: SYSDATE,
4360: fnd_global.user_id,
4361: SYSDATE
4362: FROM ego_itm_usr_attr_intrfc a,
4363: /* Bug 10112500 - Start */
4364: mtl_system_items_interface msii,

Line 4468: FND_GLOBAL.CONC_REQUEST_ID, /* Bug 10112500 */

4464: 43101,
4465: 'EGO_ITEMMGMT_GROUP',
4466: l_attr_group_id(i),
4467: j.item_catalog_group_id, /* Bug 12553744 */
4468: FND_GLOBAL.CONC_REQUEST_ID, /* Bug 10112500 */
4469: fnd_global.user_id,
4470: SYSDATE,
4471: fnd_global.user_id,
4472: SYSDATE

Line 4469: fnd_global.user_id,

4465: 'EGO_ITEMMGMT_GROUP',
4466: l_attr_group_id(i),
4467: j.item_catalog_group_id, /* Bug 12553744 */
4468: FND_GLOBAL.CONC_REQUEST_ID, /* Bug 10112500 */
4469: fnd_global.user_id,
4470: SYSDATE,
4471: fnd_global.user_id,
4472: SYSDATE
4473: FROM mtl_system_items_interface msii,

Line 4471: fnd_global.user_id,

4467: j.item_catalog_group_id, /* Bug 12553744 */
4468: FND_GLOBAL.CONC_REQUEST_ID, /* Bug 10112500 */
4469: fnd_global.user_id,
4470: SYSDATE,
4471: fnd_global.user_id,
4472: SYSDATE
4473: FROM mtl_system_items_interface msii,
4474: mtl_parameters mp
4475: WHERE msii.set_process_id = p_batch_id

Line 4547: l_user_id NUMBER := FND_GLOBAL.USER_ID;

4543: PROCEDURE Preprocess_Import(retcode OUT NOCOPY VARCHAR2,
4544: errbuf OUT NOCOPY VARCHAR2,
4545: p_batch_id NUMBER)
4546: IS
4547: l_user_id NUMBER := FND_GLOBAL.USER_ID;
4548: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
4549: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
4550: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
4551: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 4548: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

4544: errbuf OUT NOCOPY VARCHAR2,
4545: p_batch_id NUMBER)
4546: IS
4547: l_user_id NUMBER := FND_GLOBAL.USER_ID;
4548: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
4549: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
4550: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
4551: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
4552: l_err_msg VARCHAR2(4000);

Line 4549: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

4545: p_batch_id NUMBER)
4546: IS
4547: l_user_id NUMBER := FND_GLOBAL.USER_ID;
4548: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
4549: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
4550: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
4551: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
4552: l_err_msg VARCHAR2(4000);
4553: l_return_status INTEGER;

Line 4550: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

4546: IS
4547: l_user_id NUMBER := FND_GLOBAL.USER_ID;
4548: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
4549: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
4550: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
4551: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
4552: l_err_msg VARCHAR2(4000);
4553: l_return_status INTEGER;
4554: l_copy_first VARCHAR2(1);

Line 4551: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

4547: l_user_id NUMBER := FND_GLOBAL.USER_ID;
4548: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
4549: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
4550: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
4551: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
4552: l_err_msg VARCHAR2(4000);
4553: l_return_status INTEGER;
4554: l_copy_first VARCHAR2(1);
4555: l_copy_option_exists VARCHAR2(1);

Line 4863: ,REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID

4859: ,PROG_INT_NUM2 = NULL
4860: ,PROG_INT_NUM3 = NULL
4861: ,PROG_INT_CHAR1 = 'N'
4862: ,PROG_INT_CHAR2 = 'N'
4863: ,REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
4864: ,PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID
4865: ,PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID
4866: ,PROGRAM_UPDATE_DATE = SYSDATE
4867: WHERE PROCESS_STATUS = 2

Line 4864: ,PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID

4860: ,PROG_INT_NUM3 = NULL
4861: ,PROG_INT_CHAR1 = 'N'
4862: ,PROG_INT_CHAR2 = 'N'
4863: ,REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
4864: ,PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID
4865: ,PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID
4866: ,PROGRAM_UPDATE_DATE = SYSDATE
4867: WHERE PROCESS_STATUS = 2
4868: AND DATA_SET_ID = p_batch_id

Line 4865: ,PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID

4861: ,PROG_INT_CHAR1 = 'N'
4862: ,PROG_INT_CHAR2 = 'N'
4863: ,REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
4864: ,PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID
4865: ,PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID
4866: ,PROGRAM_UPDATE_DATE = SYSDATE
4867: WHERE PROCESS_STATUS = 2
4868: AND DATA_SET_ID = p_batch_id
4869: AND TRANSACTION_TYPE = 'CREATE'

Line 5479: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

5475: l_object_id NUMBER;
5476: l_ret_status VARCHAR2(10);
5477: l_def_style_people_option VARCHAR2(1);
5478: l_copy_people_option VARCHAR2(1);
5479: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5480: l_sql VARCHAR2(32000);
5481: l_item_id_sql VARCHAR2(1000);
5482:
5483: l_inventory_item_id NUMBER;

Line 5522: WHERE USER_ID = FND_GLOBAL.USER_ID;

5518: Debug_Conc_Log('Default_Item_People: l_menu_id-'||l_menu_id);
5519:
5520: SELECT 'HZ_PARTY:'||PARTY_ID INTO l_party_key
5521: FROM EGO_USER_V
5522: WHERE USER_ID = FND_GLOBAL.USER_ID;
5523:
5524: Debug_Conc_Log('Default_Item_People: l_party_key-'||l_party_key);
5525:
5526: SELECT OBJECT_ID INTO l_object_id

Line 5672: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

5668: l_errorcode VARCHAR2(10);
5669: l_object_id NUMBER;
5670: l_ret_status VARCHAR2(10);
5671: l_def_style_people_option VARCHAR2(1);
5672: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5673: BEGIN
5674: Debug_Conc_Log('Copy_Item_People_From_Style: Starting');
5675: RETCODE := '0';
5676: l_def_style_people_option := EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_DEFAULT_STYLE_PEOPLE');

Line 5778: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

5774: l_msg_data VARCHAR2(4000);
5775: l_ret_status VARCHAR2(10);
5776: l_def_style_project_option VARCHAR2(1);
5777: l_copy_people_option VARCHAR2(1);
5778: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
5779: l_inventory_item_id NUMBER;
5780: l_organization_id NUMBER;
5781: BEGIN
5782: Debug_Conc_Log('Copy_LC_Projects: Starting');

Line 6088: l_user_id NUMBER := FND_GLOBAL.USER_ID;

6084: l_sequence NUMBER;
6085: l_select_flag VARCHAR2(1);
6086: l_error NUMBER := 0;
6087: l_sysdate DATE := sysdate;
6088: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6089: l_batch_exists NUMBER := 0;
6090: BEGIN
6091: IF ((p_batch_id IS NULL) OR (p_batch_id = 0)) THEN
6092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6257: l_user_id NUMBER := FND_GLOBAL.USER_ID;

6253: l_attr_disp_value VARCHAR2(1000);
6254: l_style_item_flag VARCHAR2(1);
6255: l_variant VARCHAR2(1);
6256:
6257: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6258: l_batch_exists NUMBER := 0;
6259: l_error NUMBER := 0;
6260: BEGIN
6261:

Line 6451: l_user_id NUMBER := FND_GLOBAL.USER_ID;

6447: IS
6448: l_item_master_dl_id NUMBER;
6449: l_enabled_for_data_pool VARCHAR2(1);
6450: l_item_detail_tbl ITEM_DETAIL_TBL;
6451: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6452: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
6453: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
6454: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
6455: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 6452: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

6448: l_item_master_dl_id NUMBER;
6449: l_enabled_for_data_pool VARCHAR2(1);
6450: l_item_detail_tbl ITEM_DETAIL_TBL;
6451: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6452: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
6453: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
6454: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
6455: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
6456: l_ret_code VARCHAR2(10);

Line 6453: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;

6449: l_enabled_for_data_pool VARCHAR2(1);
6450: l_item_detail_tbl ITEM_DETAIL_TBL;
6451: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6452: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
6453: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
6454: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
6455: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
6456: l_ret_code VARCHAR2(10);
6457: l_err_buf VARCHAR2(4000);

Line 6454: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

6450: l_item_detail_tbl ITEM_DETAIL_TBL;
6451: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6452: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
6453: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
6454: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
6455: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
6456: l_ret_code VARCHAR2(10);
6457: l_err_buf VARCHAR2(4000);
6458: BEGIN

Line 6455: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

6451: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6452: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
6453: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
6454: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
6455: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
6456: l_ret_code VARCHAR2(10);
6457: l_err_buf VARCHAR2(4000);
6458: BEGIN
6459: Debug_Conc_Log('Validate_Timestamp_In_Batch: Starting p_batch_id='||p_batch_id);

Line 6750: l_user_id NUMBER := FND_GLOBAL.USER_ID;

6746: p_batch_id IN NUMBER)
6747: IS
6748: l_item_master_dl_id NUMBER;
6749: l_enabled_for_data_pool VARCHAR2(1);
6750: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6751: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
6752: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
6753: BEGIN
6754: Debug_Conc_Log('Update_Timestamp_In_Prod: Starting p_batch_id='||p_batch_id);

Line 6751: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

6747: IS
6748: l_item_master_dl_id NUMBER;
6749: l_enabled_for_data_pool VARCHAR2(1);
6750: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6751: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
6752: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
6753: BEGIN
6754: Debug_Conc_Log('Update_Timestamp_In_Prod: Starting p_batch_id='||p_batch_id);
6755: BEGIN

Line 6752: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

6748: l_item_master_dl_id NUMBER;
6749: l_enabled_for_data_pool VARCHAR2(1);
6750: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6751: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
6752: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
6753: BEGIN
6754: Debug_Conc_Log('Update_Timestamp_In_Prod: Starting p_batch_id='||p_batch_id);
6755: BEGIN
6756: SELECT NVL(ENABLED_FOR_DATA_POOL, 'N') INTO l_enabled_for_data_pool

Line 6896: AND msii.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID

6892: MTL_PARAMETERS mp
6893: WHERE msii.SET_PROCESS_ID = p_batch_id
6894: AND msii.PROCESS_FLAG = 7
6895: AND msii.TRANSACTION_TYPE = 'CREATE'
6896: AND msii.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
6897: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID
6898: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
6899: AND ( msii.STYLE_ITEM_FLAG = 'Y'
6900: OR msii.STYLE_ITEM_FLAG IS NULL );

Line 6948: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

6944: p_batch_id IN NUMBER )
6945: IS
6946: l_item_dl_id NUMBER;
6947: l_item_object_id NUMBER;
6948: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
6949: BEGIN
6950: Debug_Conc_Log('Clean_Dirty_SKUs : Starting ');
6951: SELECT OBJECT_ID INTO l_item_object_id
6952: FROM FND_OBJECTS