APPS.GMD_ICR01USR_XMLP_PKG dependencies on STANDARD

Line 91: FUNCTION STANDARD_QTYFORMULA(FORMULA_ID IN NUMBER

87: WHEN NO_DATA_FOUND THEN
88: RETURN (NULL);
89: END FORM_QTYCFFORMULA;
90:
91: FUNCTION STANDARD_QTYFORMULA(FORMULA_ID IN NUMBER
92: ,LEVEL_NUM IN NUMBER) RETURN NUMBER IS
93: STANDARDQTY NUMBER;
94: BEGIN
95: SELECT

Line 93: STANDARDQTY NUMBER;

89: END FORM_QTYCFFORMULA;
90:
91: FUNCTION STANDARD_QTYFORMULA(FORMULA_ID IN NUMBER
92: ,LEVEL_NUM IN NUMBER) RETURN NUMBER IS
93: STANDARDQTY NUMBER;
94: BEGIN
95: SELECT
96: DISTINCT
97: STD_QTY

Line 98: INTO STANDARDQTY

94: BEGIN
95: SELECT
96: DISTINCT
97: STD_QTY
98: INTO STANDARDQTY
99: FROM
100: FM_IBOM_DTL
101: WHERE LINE_TYPE = 1
102: AND TOP_FORMULA_ID = P_FORMULA_ID

Line 103: AND FORMULA_ID = STANDARD_QTYFORMULA.FORMULA_ID

99: FROM
100: FM_IBOM_DTL
101: WHERE LINE_TYPE = 1
102: AND TOP_FORMULA_ID = P_FORMULA_ID
103: AND FORMULA_ID = STANDARD_QTYFORMULA.FORMULA_ID
104: AND LEVEL_NUM = STANDARD_QTYFORMULA.LEVEL_NUM
105: AND FM_IBOM_DTL.INVENTORY_ITEM_ID = (
106: SELECT
107: FM_MATL_DTL.INVENTORY_ITEM_ID

Line 104: AND LEVEL_NUM = STANDARD_QTYFORMULA.LEVEL_NUM

100: FM_IBOM_DTL
101: WHERE LINE_TYPE = 1
102: AND TOP_FORMULA_ID = P_FORMULA_ID
103: AND FORMULA_ID = STANDARD_QTYFORMULA.FORMULA_ID
104: AND LEVEL_NUM = STANDARD_QTYFORMULA.LEVEL_NUM
105: AND FM_IBOM_DTL.INVENTORY_ITEM_ID = (
106: SELECT
107: FM_MATL_DTL.INVENTORY_ITEM_ID
108: FROM

Line 110: WHERE FORMULA_ID = STANDARD_QTYFORMULA.FORMULA_ID

106: SELECT
107: FM_MATL_DTL.INVENTORY_ITEM_ID
108: FROM
109: FM_MATL_DTL
110: WHERE FORMULA_ID = STANDARD_QTYFORMULA.FORMULA_ID
111: AND LINE_TYPE = 1
112: AND LINE_NO = 1 )
113: AND LINE_NO = 1;
114: RETURN (STANDARDQTY);

Line 114: RETURN (STANDARDQTY);

110: WHERE FORMULA_ID = STANDARD_QTYFORMULA.FORMULA_ID
111: AND LINE_TYPE = 1
112: AND LINE_NO = 1 )
113: AND LINE_NO = 1;
114: RETURN (STANDARDQTY);
115: RETURN NULL;
116: EXCEPTION
117: WHEN NO_DATA_FOUND THEN
118: RETURN (NULL);

Line 119: END STANDARD_QTYFORMULA;

115: RETURN NULL;
116: EXCEPTION
117: WHEN NO_DATA_FOUND THEN
118: RETURN (NULL);
119: END STANDARD_QTYFORMULA;
120:
121: FUNCTION UOMCFFORMULA(EXPLODE_SEQ IN VARCHAR2) RETURN VARCHAR2 IS
122: UOM1 VARCHAR2(4);
123: BEGIN