APPS.GMD_SS_APPROVAL_WF_PKG dependencies on GMD_QC_STATUS

Line 27: *** GMD_QC_STATUS_NEXT and populates workflow attributes **

23: *** This procedure is associated with GMDQMSAP_ISAPROVAL_REQUIRED workflow. **
24: *** This code will execute when Stability Status Business Event is raised. **
25: *** This verifies whether approval required for this transaction or not **
26: *** If approval is required then udated spec status to pending as defined **
27: *** GMD_QC_STATUS_NEXT and populates workflow attributes **
28: ********************************************************************************/
29:
30: PROCEDURE IS_APPROVAL_REQ (
31: p_itemtype IN VARCHAR2,

Line 79: gmd_Qc_status b,

75: a.SCHEDULED_START_DATE , a.SCHEDULED_END_DATE , a.REVISED_START_DATE ,
76: a.REVISED_END_DATE , a.ACTUAL_START_DATE , a.ACTUAL_END_DATE ,
77: a.RECOMMENDED_SHELF_LIFE , a.RECOMMENDED_SHELF_LIFE_UNIT , a.DELETE_MARK , a.LAST_UPDATED_BY
78: from gmd_stability_studies a,
79: gmd_Qc_status b,
80: mtl_system_items_kfv c,
81: gmd_specifications d,
82: mtl_parameters e,
83: mtl_parameters f

Line 634: FROM GMD_QC_STATUS

630: FUNCTION GET_STATUS_MEANING(P_STATUS_CODE NUMBER,
631: P_ENTITY_TYPE VARCHAR2) RETURN VARCHAR2 IS
632: CURSOR GET_STAT_MEANING IS
633: SELECT MEANING
634: FROM GMD_QC_STATUS
635: WHERE STATUS_CODE = P_STATUS_CODE
636: AND ENTITY_TYPE = P_ENTITY_TYPE;
637: l_status_meaning GMD_QC_STATUS.MEANING%TYPE;
638: BEGIN

Line 637: l_status_meaning GMD_QC_STATUS.MEANING%TYPE;

633: SELECT MEANING
634: FROM GMD_QC_STATUS
635: WHERE STATUS_CODE = P_STATUS_CODE
636: AND ENTITY_TYPE = P_ENTITY_TYPE;
637: l_status_meaning GMD_QC_STATUS.MEANING%TYPE;
638: BEGIN
639: OPEN GET_STAT_MEANING;
640: FETCH GET_STAT_MEANING INTO l_status_meaning;
641: CLOSE GET_STAT_MEANING;

Line 652: FROM GMD_QC_STATUS

648: target_status number;
649:
650: CURSOR GET_STAT_MEANING IS
651: SELECT MEANING
652: FROM GMD_QC_STATUS
653: WHERE STATUS_CODE = target_status
654: AND ENTITY_TYPE = P_ENTITY_TYPE;
655: l_status_meaning GMD_QC_STATUS.MEANING%TYPE;
656:

Line 655: l_status_meaning GMD_QC_STATUS.MEANING%TYPE;

651: SELECT MEANING
652: FROM GMD_QC_STATUS
653: WHERE STATUS_CODE = target_status
654: AND ENTITY_TYPE = P_ENTITY_TYPE;
655: l_status_meaning GMD_QC_STATUS.MEANING%TYPE;
656:
657: BEGIN
658:
659: if (p_status_code = 200) then