APPS.GMDQSPEC_APPROVAL_WF_PKG dependencies on GMD_QC_STATUS

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

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

Line 73: ,GMD_QC_STATUS QCSTAT

69: ,SPEC.BASE_SPEC_ID
70: FROM GMD_SPECIFICATIONS SPEC
71: ,IC_ITEM_MST ITEM
72: ,SY_ORGN_MST ORGN
73: ,GMD_QC_STATUS QCSTAT
74: WHERE SPEC.ITEM_ID = ITEM.ITEM_ID (+)
75: AND ORGN.ORGN_CODE = SPEC.OWNER_ORGN_CODE
76: AND SPEC.SPEC_STATUS = QCSTAT.STATUS_CODE
77: AND SPEC.SPEC_ID = lSpecId;*/

Line 105: ,GMD_QC_STATUS QCSTAT

101: ,SPEC.BASE_SPEC_ID
102: FROM GMD_SPECIFICATIONS SPEC
103: ,mtl_system_items_kfv ITEM
104: ,mtl_parameters ORGN
105: ,GMD_QC_STATUS QCSTAT
106: ,MTL_ORGANIZATIONS MO
107: WHERE SPEC.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID (+)
108: AND ORGN.ORGANIZATION_ID = SPEC.OWNER_ORGANIZATION_ID
109: AND SPEC.OWNER_ORGANIZATION_ID = nvl(ITEM.ORGANIZATION_ID ,SPEC.OWNER_ORGANIZATION_ID)

Line 137: ,GMD_QC_STATUS QCSTAT

133: FROM
134: GMD_SPECIFICATIONS SPEC
135: ,mtl_system_items_kfv ITEM
136: ,mtl_parameters ORGN
137: ,GMD_QC_STATUS QCSTAT
138: --,MTL_ORGANIZATIONS MO
139: ,HR_ALL_ORGANIZATION_UNITS_TL HR -- sql id
140: WHERE SPEC.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID (+)
141: AND ORGN.ORGANIZATION_ID = SPEC.OWNER_ORGANIZATION_ID

Line 710: FROM GMD_QC_STATUS

706: FUNCTION GET_STATUS_MEANING(P_STATUS_CODE NUMBER,
707: P_ENTITY_TYPE VARCHAR2) RETURN VARCHAR2 IS
708: CURSOR GET_STAT_MEANING IS
709: SELECT MEANING
710: FROM GMD_QC_STATUS
711: WHERE STATUS_CODE = P_STATUS_CODE
712: AND ENTITY_TYPE = P_ENTITY_TYPE;
713: l_status_meaning GMD_QC_STATUS.MEANING%TYPE;
714: BEGIN

Line 713: l_status_meaning GMD_QC_STATUS.MEANING%TYPE;

709: SELECT MEANING
710: FROM GMD_QC_STATUS
711: WHERE STATUS_CODE = P_STATUS_CODE
712: AND ENTITY_TYPE = P_ENTITY_TYPE;
713: l_status_meaning GMD_QC_STATUS.MEANING%TYPE;
714: BEGIN
715: OPEN GET_STAT_MEANING;
716: FETCH GET_STAT_MEANING INTO l_status_meaning;
717: CLOSE GET_STAT_MEANING;