APPS.GMD_STATUS_PUB dependencies on GMD_STATUS_CODE

Line 622: IF (NOT gmd_status_code.check_parent_status(l_entity_name

618: IF (l_debug = 'Y') THEN
619: gmd_debug.put_line('Checking the Parent status dependency for '||l_entity_name);
620: END IF;
621: IF (to_number(l_to_status_type) IN (800, 1000)) THEN
622: IF (NOT gmd_status_code.check_parent_status(l_entity_name
623: ,l_entity_id)) THEN
624: SELECT DECODE(l_entity_name,
625: 'FORMULA','GMD_FORMULA_INUSE',
626: 'RECIPE','GMD_RECIPE_BTCH_DEP',

Line 662: IF NOT ( GMD_STATUS_CODE.CHECK_DEPENDENT_STATUS

658: 'ROUTING',4,
659: 'VALIDITY',5) INTO l_entity_value
660: FROM sys.dual;
661:
662: IF NOT ( GMD_STATUS_CODE.CHECK_DEPENDENT_STATUS
663: (l_entity_value,
664: l_entity_id,
665: l_from_status,
666: P_to_status) ) THEN

Line 762: l_pending_status := GMD_STATUS_CODE.get_pending_status

758: IF (l_debug = 'Y') THEN
759: gmd_debug.put_line('About to get the pending and rework status ');
760: END IF;
761: /* Added the following code as part of ERES Implementation */
762: l_pending_status := GMD_STATUS_CODE.get_pending_status
763: (p_from_status => l_from_status
764: ,p_to_status => P_to_status);
765:
766: l_rework_status := GMD_STATUS_CODE.get_rework_status

Line 766: l_rework_status := GMD_STATUS_CODE.get_rework_status

762: l_pending_status := GMD_STATUS_CODE.get_pending_status
763: (p_from_status => l_from_status
764: ,p_to_status => P_to_status);
765:
766: l_rework_status := GMD_STATUS_CODE.get_rework_status
767: (p_from_status => l_from_status
768: ,p_to_status => P_to_status);
769:
770: IF (l_debug = 'Y') THEN