APPS.GMD_STATUS_PUB dependencies on GMD_STATUS_CODE

Line 626: IF (NOT gmd_status_code.check_parent_status(l_entity_name

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

Line 666: IF NOT ( GMD_STATUS_CODE.CHECK_DEPENDENT_STATUS

662: 'ROUTING',4,
663: 'VALIDITY',5) INTO l_entity_value
664: FROM sys.dual;
665:
666: IF NOT ( GMD_STATUS_CODE.CHECK_DEPENDENT_STATUS
667: (l_entity_value,
668: l_entity_id,
669: l_from_status,
670: P_to_status) ) THEN

Line 766: l_pending_status := GMD_STATUS_CODE.get_pending_status

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

Line 770: l_rework_status := GMD_STATUS_CODE.get_rework_status

766: l_pending_status := GMD_STATUS_CODE.get_pending_status
767: (p_from_status => l_from_status
768: ,p_to_status => P_to_status);
769:
770: l_rework_status := GMD_STATUS_CODE.get_rework_status
771: (p_from_status => l_from_status
772: ,p_to_status => P_to_status);
773:
774: IF (l_debug = 'Y') THEN