APPS.BOM_RTG_APPLET_PKG dependencies on BOM_OPERATION_NETWORKS

Line 91: INSERT INTO BOM_OPERATION_NETWORKS(

87: x_error_msg => l_error_msg
88: );
89:
90: IF (l_return_code = 'S') THEN
91: INSERT INTO BOM_OPERATION_NETWORKS(
92: from_op_seq_id,
93: to_op_seq_id,
94: transition_type,
95: planning_pct,

Line 161: UPDATE BOM_OPERATION_NETWORKS

157: x_error_msg => l_error_msg
158: );
159:
160: IF (l_return_code = 'S') THEN
161: UPDATE BOM_OPERATION_NETWORKS
162: SET
163: transition_type = x_transition_type,
164: planning_pct = x_planning_pct,
165: last_update_date = NVL(x_last_update_date, SYSDATE),

Line 174: DELETE FROM BOM_OPERATION_NETWORKS

170:
171: ELSIF (x_transaction_type = 'delete') THEN
172: -- Call Lock row before deletion
173:
174: DELETE FROM BOM_OPERATION_NETWORKS
175: WHERE from_op_seq_id = x_from_op_seq_id
176: and to_op_seq_id = x_to_op_seq_id;
177: END IF;
178:

Line 219: FROM BOM_OPERATION_NETWORKS

215: -- Only one primary
216: IF (x_transition_type = 1) THEN
217: SELECT count(*)
218: INTO primary_exists
219: FROM BOM_OPERATION_NETWORKS
220: WHERE from_op_seq_id = x_from_op_seq_id
221: and transition_type = 1;
222: END IF;
223:

Line 227: FROM BOM_OPERATION_NETWORKS

223:
224: -- Only one link between the same nodes
225: SELECT count(*)
226: INTO link_exists
227: FROM BOM_OPERATION_NETWORKS
228: WHERE from_op_seq_id = x_from_op_seq_id
229: and to_op_seq_id = x_to_op_seq_id;
230:
231: -- Sum of planning_pct should be <= 100

Line 234: FROM BOM_OPERATION_NETWORKS

230:
231: -- Sum of planning_pct should be <= 100
232: SELECT sum(planning_pct)
233: INTO sum_planning_pct
234: FROM BOM_OPERATION_NETWORKS
235: WHERE from_op_seq_id = x_from_op_seq_id
236: AND transition_type IN (1, 2);
237:
238: ELSIF (x_transaction_type = 'update') THEN

Line 244: FROM BOM_OPERATION_NETWORKS

240: SELECT from_op_seq_id, to_op_seq_id,
241: transition_type, planning_pct
242: INTO l_from_op_seq_id, l_to_op_seq_id,
243: l_transition_type, l_planning_pct
244: FROM BOM_OPERATION_NETWORKS
245: WHERE from_op_seq_id = x_from_op_seq_id
246: and to_op_seq_id = x_to_op_seq_id
247: and transition_type IN (1, 2);
248: EXCEPTION

Line 254: FROM BOM_OPERATION_NETWORKS

250: SELECT from_op_seq_id, to_op_seq_id,
251: transition_type, planning_pct
252: INTO l_from_op_seq_id, l_to_op_seq_id,
253: l_transition_type, l_planning_pct
254: FROM BOM_OPERATION_NETWORKS
255: WHERE from_op_seq_id = x_from_op_seq_id
256: and to_op_seq_id = x_to_op_seq_id
257: and transition_type = 3;
258: END;

Line 264: FROM BOM_OPERATION_NETWORKS

260: IF (l_transition_type <> x_transition_type
261: and l_transition_type <> 1 and x_transition_type = 1) THEN
262: SELECT count(*)
263: INTO primary_exists
264: FROM BOM_OPERATION_NETWORKS
265: WHERE from_op_seq_id = x_from_op_seq_id
266: and to_op_seq_id <> x_to_op_seq_id
267: and transition_type = 1;
268: END IF;

Line 276: FROM BOM_OPERATION_NETWORKS

272: -- Sum of planning_pct should be <= 100
273: if l_transition_type <> 3 then
274: SELECT sum(planning_pct) - l_planning_pct
275: INTO sum_planning_pct
276: FROM BOM_OPERATION_NETWORKS
277: WHERE from_op_seq_id = x_from_op_seq_id
278: AND transition_type IN (1, 2);
279: else
280: sum_planning_pct := l_planning_pct;