DBA Data[Home] [Help]

APPS.IEU_WR_PUB dependencies on FND_GLOBAL

Line 2538: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

2534: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');
2535: FORALL i in 1..l_task_status_rec.l_task_id_list.COUNT SAVE EXCEPTIONS
2536: update IEU_UWQM_ITEMS
2537: set status_id = l_task_status_rec.l_status_id_list(i),
2538: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2539: LAST_UPDATE_DATE = SYSDATE,
2540: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2541: where workitem_obj_code = 'TASK'
2542: and workitem_pk_id = l_task_status_rec.l_task_id_list(i)

Line 2540: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

2536: update IEU_UWQM_ITEMS
2537: set status_id = l_task_status_rec.l_status_id_list(i),
2538: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2539: LAST_UPDATE_DATE = SYSDATE,
2540: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
2541: where workitem_obj_code = 'TASK'
2542: and workitem_pk_id = l_task_status_rec.l_task_id_list(i)
2543: and source_object_type_code = l_parent_obj_code;
2544:

Line 7543: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

7539: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');
7540: FORALL i in 1..l_task_status_rec.l_task_id_list.COUNT SAVE EXCEPTIONS
7541: update IEU_UWQM_ITEMS
7542: set status_id = l_task_status_rec.l_status_id_list(i),
7543: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7544: LAST_UPDATE_DATE = SYSDATE,
7545: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7546: where workitem_obj_code = 'TASK'
7547: and workitem_pk_id = l_task_status_rec.l_task_id_list(i)

Line 7545: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

7541: update IEU_UWQM_ITEMS
7542: set status_id = l_task_status_rec.l_status_id_list(i),
7543: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7544: LAST_UPDATE_DATE = SYSDATE,
7545: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
7546: where workitem_obj_code = 'TASK'
7547: and workitem_pk_id = l_task_status_rec.l_task_id_list(i)
7548: and source_object_type_code = l_parent_obj_code;
7549:

Line 11909: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

11905: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');
11906: FORALL i in 1..l_task_status_rec.l_task_id_list.COUNT SAVE EXCEPTIONS
11907: update IEU_UWQM_ITEMS
11908: set status_id = l_task_status_rec.l_status_id_list(i),
11909: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
11910: LAST_UPDATE_DATE = SYSDATE,
11911: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
11912: where workitem_obj_code = 'TASK'
11913: and workitem_pk_id = l_task_status_rec.l_task_id_list(i)

Line 11911: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

11907: update IEU_UWQM_ITEMS
11908: set status_id = l_task_status_rec.l_status_id_list(i),
11909: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
11910: LAST_UPDATE_DATE = SYSDATE,
11911: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
11912: where workitem_obj_code = 'TASK'
11913: and workitem_pk_id = l_task_status_rec.l_task_id_list(i)
11914: and source_object_type_code = l_parent_obj_code;
11915:

Line 12137: p_user_id => FND_GLOBAL.USER_ID,

12133: p_api_version => 1.0,
12134: p_init_msg_list => FND_API.G_TRUE,
12135: p_commit => FND_API.G_FALSE,
12136: p_processing_set_id => P_PROCESSING_SET_ID,
12137: p_user_id => FND_GLOBAL.USER_ID,
12138: p_login_id => FND_GLOBAL.LOGIN_ID,
12139: x_msg_count => l_msg_count,
12140: x_msg_data => l_msg_data,
12141: x_return_status => l_return_status);

Line 12138: p_login_id => FND_GLOBAL.LOGIN_ID,

12134: p_init_msg_list => FND_API.G_TRUE,
12135: p_commit => FND_API.G_FALSE,
12136: p_processing_set_id => P_PROCESSING_SET_ID,
12137: p_user_id => FND_GLOBAL.USER_ID,
12138: p_login_id => FND_GLOBAL.LOGIN_ID,
12139: x_msg_count => l_msg_count,
12140: x_msg_data => l_msg_data,
12141: x_return_status => l_return_status);
12142:

Line 12724: , LAST_UPDATED_BY = FND_GLOBAL.USER_ID

12720: FORALL i in l_wr_item_status_rec.WORKITEM_OBJ_CODE_LST.FIRST..l_wr_item_status_rec.WORKITEM_OBJ_CODE_LST.LAST SAVE EXCEPTIONS
12721:
12722: UPDATE IEU_UWQM_ITEMS
12723: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
12724: , LAST_UPDATED_BY = FND_GLOBAL.USER_ID
12725: , LAST_UPDATE_DATE = SYSDATE
12726: , LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
12727: , STATUS_UPDATE_USER_ID = FND_GLOBAL.USER_ID
12728: , STATUS_ID = l_wr_item_status_rec.STATUS_ID_LIST(i)

Line 12726: , LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

12722: UPDATE IEU_UWQM_ITEMS
12723: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
12724: , LAST_UPDATED_BY = FND_GLOBAL.USER_ID
12725: , LAST_UPDATE_DATE = SYSDATE
12726: , LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
12727: , STATUS_UPDATE_USER_ID = FND_GLOBAL.USER_ID
12728: , STATUS_ID = l_wr_item_status_rec.STATUS_ID_LIST(i)
12729: WHERE WORKITEM_OBJ_CODE = l_wr_item_status_rec.WORKITEM_OBJ_CODE_LST(i)
12730: AND WORKITEM_PK_ID = l_wr_item_status_rec.WORKITEM_PK_ID_LST(i);

Line 12727: , STATUS_UPDATE_USER_ID = FND_GLOBAL.USER_ID

12723: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
12724: , LAST_UPDATED_BY = FND_GLOBAL.USER_ID
12725: , LAST_UPDATE_DATE = SYSDATE
12726: , LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
12727: , STATUS_UPDATE_USER_ID = FND_GLOBAL.USER_ID
12728: , STATUS_ID = l_wr_item_status_rec.STATUS_ID_LIST(i)
12729: WHERE WORKITEM_OBJ_CODE = l_wr_item_status_rec.WORKITEM_OBJ_CODE_LST(i)
12730: AND WORKITEM_PK_ID = l_wr_item_status_rec.WORKITEM_PK_ID_LST(i);
12731:

Line 12931: , LAST_UPDATED_BY = FND_GLOBAL.USER_ID

12927: BEGIN
12928: FORALL i in 1..l_wr_item_status_rec.WORK_ITEM_ID_LIST.COUNT SAVE EXCEPTIONS
12929: UPDATE IEU_UWQM_ITEMS
12930: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
12931: , LAST_UPDATED_BY = FND_GLOBAL.USER_ID
12932: , LAST_UPDATE_DATE = SYSDATE
12933: , LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
12934: , STATUS_UPDATE_USER_ID = FND_GLOBAL.USER_ID
12935: , STATUS_ID = 3

Line 12933: , LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

12929: UPDATE IEU_UWQM_ITEMS
12930: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
12931: , LAST_UPDATED_BY = FND_GLOBAL.USER_ID
12932: , LAST_UPDATE_DATE = SYSDATE
12933: , LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
12934: , STATUS_UPDATE_USER_ID = FND_GLOBAL.USER_ID
12935: , STATUS_ID = 3
12936: WHERE WORK_ITEM_ID = l_wr_item_status_rec.WORK_ITEM_ID_LIST(i);
12937: EXCEPTION

Line 12934: , STATUS_UPDATE_USER_ID = FND_GLOBAL.USER_ID

12930: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
12931: , LAST_UPDATED_BY = FND_GLOBAL.USER_ID
12932: , LAST_UPDATE_DATE = SYSDATE
12933: , LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
12934: , STATUS_UPDATE_USER_ID = FND_GLOBAL.USER_ID
12935: , STATUS_ID = 3
12936: WHERE WORK_ITEM_ID = l_wr_item_status_rec.WORK_ITEM_ID_LIST(i);
12937: EXCEPTION
12938: WHEN dml_errors THEN