DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on FND_GLOBAL

Line 2612: p_x_prd_workorder_rec.LAST_UPDATED_BY :=FND_GLOBAL.user_id;

2608: END IF;
2609: --Balaji added for BAE ER # 4462462 - End.
2610: p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER :=1;
2611: p_x_prd_workorder_rec.LAST_UPDATE_DATE :=SYSDATE;
2612: p_x_prd_workorder_rec.LAST_UPDATED_BY :=FND_GLOBAL.user_id;
2613: p_x_prd_workorder_rec.CREATION_DATE :=SYSDATE;
2614: p_x_prd_workorder_rec.CREATED_BY :=FND_GLOBAL.user_id;
2615: p_x_prd_workorder_rec.LAST_UPDATE_LOGIN :=FND_GLOBAL.user_id;
2616: p_x_prd_workorder_rec.WIP_ENTITY_ID :=NULL;

Line 2614: p_x_prd_workorder_rec.CREATED_BY :=FND_GLOBAL.user_id;

2610: p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER :=1;
2611: p_x_prd_workorder_rec.LAST_UPDATE_DATE :=SYSDATE;
2612: p_x_prd_workorder_rec.LAST_UPDATED_BY :=FND_GLOBAL.user_id;
2613: p_x_prd_workorder_rec.CREATION_DATE :=SYSDATE;
2614: p_x_prd_workorder_rec.CREATED_BY :=FND_GLOBAL.user_id;
2615: p_x_prd_workorder_rec.LAST_UPDATE_LOGIN :=FND_GLOBAL.user_id;
2616: p_x_prd_workorder_rec.WIP_ENTITY_ID :=NULL;
2617: --p_x_prd_workorder_rec.STATUS_CODE :=G_JOB_STATUS_UNRELEASED; -- Unreleased
2618:

Line 2615: p_x_prd_workorder_rec.LAST_UPDATE_LOGIN :=FND_GLOBAL.user_id;

2611: p_x_prd_workorder_rec.LAST_UPDATE_DATE :=SYSDATE;
2612: p_x_prd_workorder_rec.LAST_UPDATED_BY :=FND_GLOBAL.user_id;
2613: p_x_prd_workorder_rec.CREATION_DATE :=SYSDATE;
2614: p_x_prd_workorder_rec.CREATED_BY :=FND_GLOBAL.user_id;
2615: p_x_prd_workorder_rec.LAST_UPDATE_LOGIN :=FND_GLOBAL.user_id;
2616: p_x_prd_workorder_rec.WIP_ENTITY_ID :=NULL;
2617: --p_x_prd_workorder_rec.STATUS_CODE :=G_JOB_STATUS_UNRELEASED; -- Unreleased
2618:
2619: IF p_x_prd_workorder_rec.MASTER_WORKORDER_FLAG IS NULL OR

Line 3777: LAST_UPDATED_BY =NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.user_id),

3773:
3774: UPDATE AHL_WORKORDERS SET
3775: OBJECT_VERSION_NUMBER =p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER + 1,
3776: LAST_UPDATE_DATE =NVL(p_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
3777: LAST_UPDATED_BY =NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.user_id),
3778: LAST_UPDATE_LOGIN =NVL(p_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.user_id),
3779: STATUS_CODE =p_x_prd_workorder_rec.STATUS_CODE,
3780: ACTUAL_START_DATE =p_x_prd_workorder_rec.ACTUAL_START_DATE,
3781: ACTUAL_END_DATE =p_x_prd_workorder_rec.ACTUAL_END_DATE,

Line 3778: LAST_UPDATE_LOGIN =NVL(p_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.user_id),

3774: UPDATE AHL_WORKORDERS SET
3775: OBJECT_VERSION_NUMBER =p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER + 1,
3776: LAST_UPDATE_DATE =NVL(p_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
3777: LAST_UPDATED_BY =NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.user_id),
3778: LAST_UPDATE_LOGIN =NVL(p_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.user_id),
3779: STATUS_CODE =p_x_prd_workorder_rec.STATUS_CODE,
3780: ACTUAL_START_DATE =p_x_prd_workorder_rec.ACTUAL_START_DATE,
3781: ACTUAL_END_DATE =p_x_prd_workorder_rec.ACTUAL_END_DATE,
3782: CONFIRM_FAILURE_FLAG =p_x_prd_workorder_rec.CONFIRM_FAILURE_FLAG,

Line 3841: NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.USER_ID),

3837: (
3838: AHL_WORKORDER_TXNS_S.NEXTVAL,
3839: NVL(p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER,1),
3840: NVL(p_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
3841: NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
3842: NVL(p_x_prd_workorder_rec.CREATION_DATE,SYSDATE),
3843: NVL(p_x_prd_workorder_rec.CREATED_BY,FND_GLOBAL.USER_ID),
3844: NVL(p_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID),
3845: p_x_prd_workorder_rec.WORKORDER_ID,

Line 3843: NVL(p_x_prd_workorder_rec.CREATED_BY,FND_GLOBAL.USER_ID),

3839: NVL(p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER,1),
3840: NVL(p_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
3841: NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
3842: NVL(p_x_prd_workorder_rec.CREATION_DATE,SYSDATE),
3843: NVL(p_x_prd_workorder_rec.CREATED_BY,FND_GLOBAL.USER_ID),
3844: NVL(p_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID),
3845: p_x_prd_workorder_rec.WORKORDER_ID,
3846: 0,
3847: p_x_prd_workorder_rec.STATUS_CODE,

Line 3844: NVL(p_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID),

3840: NVL(p_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
3841: NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
3842: NVL(p_x_prd_workorder_rec.CREATION_DATE,SYSDATE),
3843: NVL(p_x_prd_workorder_rec.CREATED_BY,FND_GLOBAL.USER_ID),
3844: NVL(p_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID),
3845: p_x_prd_workorder_rec.WORKORDER_ID,
3846: 0,
3847: p_x_prd_workorder_rec.STATUS_CODE,
3848: p_x_prd_workorder_rec.SCHEDULED_START_DATE,

Line 4854: last_updated_by = Fnd_Global.USER_ID,

4850: UPDATE AHL_WORKORDERS
4851: SET wip_entity_id = l_eam_wo_tbl(i).wip_entity_id,
4852: object_version_number = p_x_prd_workorder_tbl(i).object_version_number + 1,
4853: last_update_date = SYSDATE,
4854: last_updated_by = Fnd_Global.USER_ID,
4855: last_update_login = Fnd_Global.LOGIN_ID
4856:
4857: WHERE workorder_id = p_x_prd_workorder_tbl(i).workorder_id;
4858:

Line 4855: last_update_login = Fnd_Global.LOGIN_ID

4851: SET wip_entity_id = l_eam_wo_tbl(i).wip_entity_id,
4852: object_version_number = p_x_prd_workorder_tbl(i).object_version_number + 1,
4853: last_update_date = SYSDATE,
4854: last_updated_by = Fnd_Global.USER_ID,
4855: last_update_login = Fnd_Global.LOGIN_ID
4856:
4857: WHERE workorder_id = p_x_prd_workorder_tbl(i).workorder_id;
4858:
4859: IF ( G_DEBUG = 'Y' ) THEN

Line 4889: last_updated_by = Fnd_Global.USER_ID,

4885: UPDATE AHL_WORKORDERS
4886: SET status_code = l_eam_wo_tbl(i).status_type,
4887: object_version_number = p_x_prd_workorder_tbl(i).object_version_number + 1,
4888: last_update_date = SYSDATE,
4889: last_updated_by = Fnd_Global.USER_ID,
4890: last_update_login = Fnd_Global.LOGIN_ID
4891:
4892: WHERE workorder_id = p_x_prd_workorder_tbl(i).workorder_id;
4893:

Line 4890: last_update_login = Fnd_Global.LOGIN_ID

4886: SET status_code = l_eam_wo_tbl(i).status_type,
4887: object_version_number = p_x_prd_workorder_tbl(i).object_version_number + 1,
4888: last_update_date = SYSDATE,
4889: last_updated_by = Fnd_Global.USER_ID,
4890: last_update_login = Fnd_Global.LOGIN_ID
4891:
4892: WHERE workorder_id = p_x_prd_workorder_tbl(i).workorder_id;
4893:
4894: END IF;

Line 8018: --l_user_id := FND_GLOBAL.user_id;

8014:
8015: IF p_trunover_notes_tbl(i).employee_name IS NULL THEN
8016: FND_MESSAGE.set_name('AHL','AHL_PRD_EMP_NULL_TRNTS');
8017: FND_MSG_PUB.ADD;
8018: --l_user_id := FND_GLOBAL.user_id;
8019: ELSE
8020: matchFound := FALSE;
8021: FOR emp_rec IN get_user_id_csr(p_trunover_notes_tbl(i).employee_name,
8022: p_trunover_notes_tbl(i).org_id) LOOP