DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_WORKORDERS_S

Line 3344: SELECT AHL_WORKORDERS_S.NEXTVAL

3340: l_sr_summary VARCHAR2(240);
3341: l_sr_type VARCHAR2(90);
3342: BEGIN
3343:
3344: SELECT AHL_WORKORDERS_S.NEXTVAL
3345: INTO p_x_prd_workorder_rec.WORKORDER_ID
3346: FROM DUAL;
3347:
3348: IF p_x_prd_workorder_rec.MASTER_WORKORDER_FLAG = 'Y' AND p_x_prd_workorder_rec.VISIT_TASK_ID IS NULL THEN

Line 5143: UPDATE AHL_WORKORDERS SET

5139:
5140: -- end check if any material requirement for WO is AOG, then WO cant me modified to non AOG
5141:
5142:
5143: UPDATE AHL_WORKORDERS SET
5144: OBJECT_VERSION_NUMBER =p_x_prd_workorder_rec.OBJECT_VERSION_NUMBER + 1,
5145: LAST_UPDATE_DATE =NVL(p_x_prd_workorder_rec.LAST_UPDATE_DATE,SYSDATE),
5146: LAST_UPDATED_BY =NVL(p_x_prd_workorder_rec.LAST_UPDATED_BY,FND_GLOBAL.user_id),
5147: LAST_UPDATE_LOGIN =NVL(p_x_prd_workorder_rec.LAST_UPDATE_LOGIN,FND_GLOBAL.user_id),