APPS.GML_GMLUNALC_XMLP_PKG dependencies on IC_TRAN_PND

Line 115: IC_TRAN_PND

111: ,0)),
112: SUM(NVL(TRANS_QTY2
113: ,0))
114: FROM
115: IC_TRAN_PND
116: WHERE ITEM_ID = CF_1FORMULA.ITEM_ID
117: AND WHSE_CODE = CF_1FORMULA.WHSE_CODE
118: AND COMPLETED_IND = 0
119: AND DELETE_MARK = 0

Line 131: IC_TRAN_PND

127: ,0)),
128: SUM(NVL(TRANS_QTY2
129: ,0))
130: FROM
131: IC_TRAN_PND
132: WHERE ITEM_ID = CF_1FORMULA.ITEM_ID
133: AND WHSE_CODE = CF_1FORMULA.WHSE_CODE
134: AND COMPLETED_IND = 0
135: AND DELETE_MARK = 0

Line 388: CURSOR CHECK_IC_TRAN_PND IS

384: ITEM_UM
385: FROM
386: IC_ITEM_MST
387: WHERE ITEM_ID = CF_UNALLOCATED_INVENTORYFORMUL.ITEM_ID;
388: CURSOR CHECK_IC_TRAN_PND IS
389: SELECT
390: PND.LINE_ID
391: FROM
392: IC_TRAN_PND PND

Line 392: IC_TRAN_PND PND

388: CURSOR CHECK_IC_TRAN_PND IS
389: SELECT
390: PND.LINE_ID
391: FROM
392: IC_TRAN_PND PND
393: WHERE PND.DOC_TYPE = 'OMSO'
394: AND PND.COMPLETED_IND = 0
395: AND PND.DELETE_MARK = 0
396: AND PND.TRANS_QTY < 0

Line 401: OPEN CHECK_IC_TRAN_PND;

397: AND LINE_ID = CF_UNALLOCATED_INVENTORYFORMUL.LINE_ID;
398: BEGIN
399: /*SRW.MESSAGE('1'
400: ,'in unallocated_inventory conversion function')*/NULL;
401: OPEN CHECK_IC_TRAN_PND;
402: FETCH CHECK_IC_TRAN_PND
403: INTO L_LINE_ID;
404: CLOSE CHECK_IC_TRAN_PND;
405: IF (NVL(L_LINE_ID

Line 402: FETCH CHECK_IC_TRAN_PND

398: BEGIN
399: /*SRW.MESSAGE('1'
400: ,'in unallocated_inventory conversion function')*/NULL;
401: OPEN CHECK_IC_TRAN_PND;
402: FETCH CHECK_IC_TRAN_PND
403: INTO L_LINE_ID;
404: CLOSE CHECK_IC_TRAN_PND;
405: IF (NVL(L_LINE_ID
406: ,0) = 0) THEN

Line 404: CLOSE CHECK_IC_TRAN_PND;

400: ,'in unallocated_inventory conversion function')*/NULL;
401: OPEN CHECK_IC_TRAN_PND;
402: FETCH CHECK_IC_TRAN_PND
403: INTO L_LINE_ID;
404: CLOSE CHECK_IC_TRAN_PND;
405: IF (NVL(L_LINE_ID
406: ,0) = 0) THEN
407: RETURN (CF_UNALLOCATED_INVENTORYFORMUL.UNALLOCATED_INVENTORY);
408: ELSE