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 633: FROM GMD_QC_STATUS

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

Line 636: l_status_meaning GMD_QC_STATUS.MEANING%TYPE;

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

Line 651: FROM GMD_QC_STATUS

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

Line 654: l_status_meaning GMD_QC_STATUS.MEANING%TYPE;

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