36: BEGIN
37:
38: SELECT WIP_CONSTANTS.YES
39: INTO P_RESOURCES_CHARGED
40: FROM DUAL
41: WHERE EXISTS (SELECT 'X'
42: FROM WIP_OPERATION_RESOURCES
43: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
44: AND WIP_ENTITY_ID = P_WIP_ENTITY_ID
54: BEGIN
55:
56: SELECT WIP_CONSTANTS.YES
57: INTO P_MATERIAL_ISSUED
58: FROM DUAL
59: WHERE EXISTS (SELECT 'X'
60: FROM WIP_REQUIREMENT_OPERATIONS
61: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
62: AND WIP_ENTITY_ID = P_WIP_ENTITY_ID
71: BEGIN
72:
73: SELECT WIP_CONSTANTS.YES
74: INTO P_MTL_TXNS_TEMP
75: FROM DUAL
76: WHERE EXISTS (SELECT 1
77: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
78: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
79: AND TRANSACTION_SOURCE_ID = P_WIP_ENTITY_ID
88: BEGIN
89:
90: SELECT WIP_CONSTANTS.YES
91: INTO P_UNCOSTED_MTL_TXNS
92: FROM DUAL
93: WHERE EXISTS (SELECT 1
94: FROM MTL_MATERIAL_TRANSACTIONS
95: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
96: AND TRANSACTION_SOURCE_ID = P_WIP_ENTITY_ID
106: BEGIN
107:
108: SELECT WIP_CONSTANTS.YES
109: INTO P_PO_REQ_LINES
110: FROM DUAL
111: WHERE EXISTS (SELECT 1
112: FROM PO_REQUISITION_LINES_ALL
113: WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
114: AND DESTINATION_ORGANIZATION_ID = P_ORGANIZATION_ID);
122: BEGIN
123:
124: SELECT WIP_CONSTANTS.YES
125: INTO P_PO_REQ_INTERFACE
126: FROM DUAL
127: WHERE EXISTS (SELECT 1
128: FROM PO_REQUISITIONS_INTERFACE_ALL
129: WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
130: AND DESTINATION_ORGANIZATION_ID = P_ORGANIZATION_ID);
138: BEGIN
139:
140: SELECT WIP_CONSTANTS.YES
141: INTO P_MOVE_TXN_INTERFACE
142: FROM DUAL
143: WHERE EXISTS (SELECT 1
144: FROM WIP_MOVE_TXN_INTERFACE
145: WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
146: AND ORGANIZATION_ID = P_ORGANIZATION_ID);
154: BEGIN
155:
156: SELECT WIP_CONSTANTS.YES
157: INTO P_COST_TXN_INTERFACE
158: FROM DUAL
159: WHERE EXISTS (SELECT 1
160: FROM WIP_COST_TXN_INTERFACE
161: WHERE WIP_ENTITY_ID = P_WIP_ENTITY_ID
162: AND ORGANIZATION_ID = P_ORGANIZATION_ID);