DBA Data[Home] [Help]

APPS.WMS_RULE_PICK_PKG1 dependencies on WMS_RULE_1

Line 30: WMS_RULE_1.open_curs(

26: x_result OUT NOCOPY NUMBER) is
27:
28: BEGIN
29: IF p_rule_id = 1 THEN
30: WMS_RULE_1.open_curs(
31: p_cursor,
32: p_organization_id,
33: p_inventory_item_id,
34: p_transaction_type_id,

Line 162: WMS_RULE_15.open_curs(

158: p_project_id,
159: p_task_id,
160: x_result );
161: ELSIF p_rule_id = 15 THEN
162: WMS_RULE_15.open_curs(
163: p_cursor,
164: p_organization_id,
165: p_inventory_item_id,
166: p_transaction_type_id,

Line 184: WMS_RULE_14.open_curs(

180: p_project_id,
181: p_task_id,
182: x_result );
183: ELSIF p_rule_id = 14 THEN
184: WMS_RULE_14.open_curs(
185: p_cursor,
186: p_organization_id,
187: p_inventory_item_id,
188: p_transaction_type_id,

Line 206: WMS_RULE_16.open_curs(

202: p_project_id,
203: p_task_id,
204: x_result );
205: ELSIF p_rule_id = 16 THEN
206: WMS_RULE_16.open_curs(
207: p_cursor,
208: p_organization_id,
209: p_inventory_item_id,
210: p_transaction_type_id,

Line 228: WMS_RULE_17.open_curs(

224: p_project_id,
225: p_task_id,
226: x_result );
227: ELSIF p_rule_id = 17 THEN
228: WMS_RULE_17.open_curs(
229: p_cursor,
230: p_organization_id,
231: p_inventory_item_id,
232: p_transaction_type_id,

Line 250: WMS_RULE_18.open_curs(

246: p_project_id,
247: p_task_id,
248: x_result );
249: ELSIF p_rule_id = 18 THEN
250: WMS_RULE_18.open_curs(
251: p_cursor,
252: p_organization_id,
253: p_inventory_item_id,
254: p_transaction_type_id,

Line 296: WMS_RULE_1.fetch_one_row(

292: x_return_status OUT NOCOPY NUMBER) is
293:
294: BEGIN
295: IF p_rule_id = 1 THEN
296: WMS_RULE_1.fetch_one_row(
297: p_cursor,
298: x_revision,
299: x_lot_number,
300: x_lot_expiration_date,

Line 404: WMS_RULE_15.fetch_one_row(

400: x_consist_string,
401: x_order_by_string,
402: x_return_status );
403: ELSIF p_rule_id = 15 THEN
404: WMS_RULE_15.fetch_one_row(
405: p_cursor,
406: x_revision,
407: x_lot_number,
408: x_lot_expiration_date,

Line 422: WMS_RULE_14.fetch_one_row(

418: x_consist_string,
419: x_order_by_string,
420: x_return_status );
421: ELSIF p_rule_id = 14 THEN
422: WMS_RULE_14.fetch_one_row(
423: p_cursor,
424: x_revision,
425: x_lot_number,
426: x_lot_expiration_date,

Line 440: WMS_RULE_16.fetch_one_row(

436: x_consist_string,
437: x_order_by_string,
438: x_return_status );
439: ELSIF p_rule_id = 16 THEN
440: WMS_RULE_16.fetch_one_row(
441: p_cursor,
442: x_revision,
443: x_lot_number,
444: x_lot_expiration_date,

Line 458: WMS_RULE_17.fetch_one_row(

454: x_consist_string,
455: x_order_by_string,
456: x_return_status );
457: ELSIF p_rule_id = 17 THEN
458: WMS_RULE_17.fetch_one_row(
459: p_cursor,
460: x_revision,
461: x_lot_number,
462: x_lot_expiration_date,

Line 476: WMS_RULE_18.fetch_one_row(

472: x_consist_string,
473: x_order_by_string,
474: x_return_status );
475: ELSIF p_rule_id = 18 THEN
476: WMS_RULE_18.fetch_one_row(
477: p_cursor,
478: x_revision,
479: x_lot_number,
480: x_lot_expiration_date,

Line 505: WMS_RULE_1.fetch_available_rows(

501: x_return_status OUT NOCOPY NUMBER) is
502:
503: BEGIN
504: IF p_rule_id = 1 THEN
505: WMS_RULE_1.fetch_available_rows(
506: p_cursor,
507: x_return_status );
508: ELSIF p_rule_id = 2 THEN
509: WMS_RULE_2.fetch_available_rows(

Line 529: WMS_RULE_15.fetch_available_rows(

525: WMS_RULE_6.fetch_available_rows(
526: p_cursor,
527: x_return_status );
528: ELSIF p_rule_id = 15 THEN
529: WMS_RULE_15.fetch_available_rows(
530: p_cursor,
531: x_return_status );
532: ELSIF p_rule_id = 14 THEN
533: WMS_RULE_14.fetch_available_rows(

Line 533: WMS_RULE_14.fetch_available_rows(

529: WMS_RULE_15.fetch_available_rows(
530: p_cursor,
531: x_return_status );
532: ELSIF p_rule_id = 14 THEN
533: WMS_RULE_14.fetch_available_rows(
534: p_cursor,
535: x_return_status );
536: ELSIF p_rule_id = 16 THEN
537: WMS_RULE_16.fetch_available_rows(

Line 537: WMS_RULE_16.fetch_available_rows(

533: WMS_RULE_14.fetch_available_rows(
534: p_cursor,
535: x_return_status );
536: ELSIF p_rule_id = 16 THEN
537: WMS_RULE_16.fetch_available_rows(
538: p_cursor,
539: x_return_status );
540: ELSIF p_rule_id = 17 THEN
541: WMS_RULE_17.fetch_available_rows(

Line 541: WMS_RULE_17.fetch_available_rows(

537: WMS_RULE_16.fetch_available_rows(
538: p_cursor,
539: x_return_status );
540: ELSIF p_rule_id = 17 THEN
541: WMS_RULE_17.fetch_available_rows(
542: p_cursor,
543: x_return_status );
544: ELSIF p_rule_id = 18 THEN
545: WMS_RULE_18.fetch_available_rows(

Line 545: WMS_RULE_18.fetch_available_rows(

541: WMS_RULE_17.fetch_available_rows(
542: p_cursor,
543: x_return_status );
544: ELSIF p_rule_id = 18 THEN
545: WMS_RULE_18.fetch_available_rows(
546: p_cursor,
547: x_return_status );
548:
549: END IF;

Line 557: WMS_RULE_1.close_curs(p_cursor);

553: PROCEDURE EXECUTE_CLOSE_RULE (p_rule_id IN NUMBER,
554: p_cursor IN WMS_RULE_PVT.Cv_pick_type) is
555: BEGIN
556: IF p_rule_id = 1 THEN
557: WMS_RULE_1.close_curs(p_cursor);
558: ELSIF p_rule_id = 2 THEN
559: WMS_RULE_2.close_curs(p_cursor);
560: ELSIF p_rule_id = 3 THEN
561: WMS_RULE_3.close_curs(p_cursor);

Line 569: WMS_RULE_15.close_curs(p_cursor);

565: WMS_RULE_5.close_curs(p_cursor);
566: ELSIF p_rule_id = 6 THEN
567: WMS_RULE_6.close_curs(p_cursor);
568: ELSIF p_rule_id = 15 THEN
569: WMS_RULE_15.close_curs(p_cursor);
570: ELSIF p_rule_id = 14 THEN
571: WMS_RULE_14.close_curs(p_cursor);
572: ELSIF p_rule_id = 16 THEN
573: WMS_RULE_16.close_curs(p_cursor);

Line 571: WMS_RULE_14.close_curs(p_cursor);

567: WMS_RULE_6.close_curs(p_cursor);
568: ELSIF p_rule_id = 15 THEN
569: WMS_RULE_15.close_curs(p_cursor);
570: ELSIF p_rule_id = 14 THEN
571: WMS_RULE_14.close_curs(p_cursor);
572: ELSIF p_rule_id = 16 THEN
573: WMS_RULE_16.close_curs(p_cursor);
574: ELSIF p_rule_id = 17 THEN
575: WMS_RULE_17.close_curs(p_cursor);

Line 573: WMS_RULE_16.close_curs(p_cursor);

569: WMS_RULE_15.close_curs(p_cursor);
570: ELSIF p_rule_id = 14 THEN
571: WMS_RULE_14.close_curs(p_cursor);
572: ELSIF p_rule_id = 16 THEN
573: WMS_RULE_16.close_curs(p_cursor);
574: ELSIF p_rule_id = 17 THEN
575: WMS_RULE_17.close_curs(p_cursor);
576: ELSIF p_rule_id = 18 THEN
577: WMS_RULE_18.close_curs(p_cursor);

Line 575: WMS_RULE_17.close_curs(p_cursor);

571: WMS_RULE_14.close_curs(p_cursor);
572: ELSIF p_rule_id = 16 THEN
573: WMS_RULE_16.close_curs(p_cursor);
574: ELSIF p_rule_id = 17 THEN
575: WMS_RULE_17.close_curs(p_cursor);
576: ELSIF p_rule_id = 18 THEN
577: WMS_RULE_18.close_curs(p_cursor);
578:
579: END IF;

Line 577: WMS_RULE_18.close_curs(p_cursor);

573: WMS_RULE_16.close_curs(p_cursor);
574: ELSIF p_rule_id = 17 THEN
575: WMS_RULE_17.close_curs(p_cursor);
576: ELSIF p_rule_id = 18 THEN
577: WMS_RULE_18.close_curs(p_cursor);
578:
579: END IF;
580: END EXECUTE_CLOSE_RULE;
581: END WMS_RULE_PICK_PKG1;