APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_WORKORDERS_S

Line 2547: SELECT AHL_WORKORDERS_S.NEXTVAL

2543: l_sr_summary VARCHAR2(240);
2544: l_sr_type VARCHAR2(30);
2545: BEGIN
2546:
2547: SELECT AHL_WORKORDERS_S.NEXTVAL
2548: INTO p_x_prd_workorder_rec.WORKORDER_ID
2549: FROM DUAL;
2550:
2551: IF p_x_prd_workorder_rec.MASTER_WORKORDER_FLAG = 'Y' AND p_x_prd_workorder_rec.VISIT_TASK_ID IS NULL THEN

Line 3774: UPDATE AHL_WORKORDERS SET

3770: END IF;
3771: END IF;
3772: -- End OGMA Issue # 105 - Balaji
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),