APPS.EAM_PROCESS_CLEARANCE_PVT dependencies on WIP_CONSTANTS

Line 410: IF (l_work_clearance_header_rec.SYSTEM_STATUS in (wip_constants.comp_chrg,wip_constants.comp_nochrg)) THEN

406: END IF; --end of check for workflow enabled
407:
408: -- Put clearance completion details if status is changed to complete
409:
410: IF (l_work_clearance_header_rec.SYSTEM_STATUS in (wip_constants.comp_chrg,wip_constants.comp_nochrg)) THEN
411:
412: IF (l_old_wc_header_rec.SYSTEM_STATUS = wip_constants.draft) THEN
413: RAISE l_clearance_status_change;
414: ELSE

Line 412: IF (l_old_wc_header_rec.SYSTEM_STATUS = wip_constants.draft) THEN

408: -- Put clearance completion details if status is changed to complete
409:
410: IF (l_work_clearance_header_rec.SYSTEM_STATUS in (wip_constants.comp_chrg,wip_constants.comp_nochrg)) THEN
411:
412: IF (l_old_wc_header_rec.SYSTEM_STATUS = wip_constants.draft) THEN
413: RAISE l_clearance_status_change;
414: ELSE
415: l_work_clearance_header_rec.COMPLETION_DATE := NVL(p_work_clearance_header_rec.COMPLETION_DATE,sysdate);
416: END IF;

Line 420: IF (l_work_clearance_header_rec.SYSTEM_STATUS = wip_constants.released) THEN

416: END IF;
417: END IF;
418:
419: -- Remove clearance completion details if status is changed to released
420: IF (l_work_clearance_header_rec.SYSTEM_STATUS = wip_constants.released) THEN
421:
422: IF (l_old_wc_header_rec.SYSTEM_STATUS in (wip_constants.comp_chrg,wip_constants.comp_nochrg)) THEN
423: l_work_clearance_header_rec.COMPLETION_DATE := null;
424: END IF;

Line 422: IF (l_old_wc_header_rec.SYSTEM_STATUS in (wip_constants.comp_chrg,wip_constants.comp_nochrg)) THEN

418:
419: -- Remove clearance completion details if status is changed to released
420: IF (l_work_clearance_header_rec.SYSTEM_STATUS = wip_constants.released) THEN
421:
422: IF (l_old_wc_header_rec.SYSTEM_STATUS in (wip_constants.comp_chrg,wip_constants.comp_nochrg)) THEN
423: l_work_clearance_header_rec.COMPLETION_DATE := null;
424: END IF;
425: END IF;
426:

Line 845: -- IF (l_work_permit_header_rec.STATUS_TYPE = wip_constants.comp_chrg) THEN

841: IF l_wc_header_rec.SCHEDULED_REESTAB_END_DATE < SYSDATE THEN
842: l_wc_header_rec.SCHEDULED_REESTAB_END_DATE :=SYSDATE;
843: END IF;
844:
845: -- IF (l_work_permit_header_rec.STATUS_TYPE = wip_constants.comp_chrg) THEN
846: l_wc_header_rec.SYSTEM_STATUS :=wip_constants.draft;
847: l_wc_header_rec.USER_DEFINED_STATUS :=217; --new user defined status for clearance as per changes made to eam_safety_usr_def_statuses_b
848: -- END IF;
849:

Line 846: l_wc_header_rec.SYSTEM_STATUS :=wip_constants.draft;

842: l_wc_header_rec.SCHEDULED_REESTAB_END_DATE :=SYSDATE;
843: END IF;
844:
845: -- IF (l_work_permit_header_rec.STATUS_TYPE = wip_constants.comp_chrg) THEN
846: l_wc_header_rec.SYSTEM_STATUS :=wip_constants.draft;
847: l_wc_header_rec.USER_DEFINED_STATUS :=217; --new user defined status for clearance as per changes made to eam_safety_usr_def_statuses_b
848: -- END IF;
849:
850: