eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_INTERNAL_ORDERS_PVT dependencies on JTF_NUMBER_TABLE

Line 27: l_hdr_interface_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

23: PROCEDURE populate_rcv_int_tables(p_product_txn_id IN NUMBER,
24: p_receiving_subinv IN VARCHAR2,
25: x_request_group_id OUT NOCOPY NUMBER)
26: IS
27: l_hdr_interface_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
28: l_to_org_id NUMBER;
29: l_destn_ou NUMBER;
30: l_process_sts_pending CONSTANT VARCHAR2(10) := 'PENDING';
31: l_txn_type_new CONSTANT VARCHAR2(10) := 'NEW';

Line 39: l_quantity JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

35: l_serial_control_flag NUMBER;
36: l_primary_uom VARCHAR2(5);
37: l_inventory_item_id NUMBER;
38: l_subinventory VARCHAR2(30);
39: l_quantity JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
40: l_uom VARCHAR2(15);
41: l_from_org NUMBER;
42: l_requisition_line_id NUMBER;
43: l_deliver_to_location_id NUMBER;

Line 44: l_intf_txn_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

40: l_uom VARCHAR2(15);
41: l_from_org NUMBER;
42: l_requisition_line_id NUMBER;
43: l_deliver_to_location_id NUMBER;
44: l_intf_txn_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
45: l_fm_serial_num_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
46: l_to_serial_num_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
47: lc_api_name CONSTANT VARCHAR2(100) := 'CSD_INTERNAL_ORDERS_PVT.populate_rcv_int_tables';
48: l_shipment_header_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 48: l_shipment_header_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

44: l_intf_txn_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
45: l_fm_serial_num_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
46: l_to_serial_num_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
47: lc_api_name CONSTANT VARCHAR2(100) := 'CSD_INTERNAL_ORDERS_PVT.populate_rcv_int_tables';
48: l_shipment_header_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
49: l_shipment_line_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
50: l_shipment_num JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
51: l_shipped_date JTF_DATE_TABLE := JTF_DATE_TABLE();
52:

Line 49: l_shipment_line_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

45: l_fm_serial_num_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
46: l_to_serial_num_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
47: lc_api_name CONSTANT VARCHAR2(100) := 'CSD_INTERNAL_ORDERS_PVT.populate_rcv_int_tables';
48: l_shipment_header_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
49: l_shipment_line_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
50: l_shipment_num JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
51: l_shipped_date JTF_DATE_TABLE := JTF_DATE_TABLE();
52:
53: BEGIN

Line 412: l_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

408: x_return_status OUT NOCOPY VARCHAR2)
409: IS
410: lc_api_name CONSTANT VARCHAR2(80) := 'CSD_INTERNAL_ORDERS_PVT.create_internal_requisition';
411: lc_api_version CONSTANT NUMBER := 1.0;
412: l_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
413: l_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
414: l_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
415: l_destination_loc_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
416: l_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 413: l_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

409: IS
410: lc_api_name CONSTANT VARCHAR2(80) := 'CSD_INTERNAL_ORDERS_PVT.create_internal_requisition';
411: lc_api_version CONSTANT NUMBER := 1.0;
412: l_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
413: l_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
414: l_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
415: l_destination_loc_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
416: l_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
417: l_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 414: l_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

410: lc_api_name CONSTANT VARCHAR2(80) := 'CSD_INTERNAL_ORDERS_PVT.create_internal_requisition';
411: lc_api_version CONSTANT NUMBER := 1.0;
412: l_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
413: l_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
414: l_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
415: l_destination_loc_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
416: l_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
417: l_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
418: l_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 415: l_destination_loc_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

411: lc_api_version CONSTANT NUMBER := 1.0;
412: l_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
413: l_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
414: l_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
415: l_destination_loc_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
416: l_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
417: l_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
418: l_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
419:

Line 416: l_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

412: l_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
413: l_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
414: l_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
415: l_destination_loc_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
416: l_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
417: l_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
418: l_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
419:
420: BEGIN

Line 417: l_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

413: l_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
414: l_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
415: l_destination_loc_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
416: l_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
417: l_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
418: l_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
419:
420: BEGIN
421:

Line 418: l_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

414: l_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
415: l_destination_loc_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
416: l_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
417: l_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
418: l_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
419:
420: BEGIN
421:
422: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN

Line 483: p_product_txn_ids IN JTF_NUMBER_TABLE,

479: PROCEDURE create_internal_requisition(
480: p_api_version IN NUMBER,
481: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
482: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
483: p_product_txn_ids IN JTF_NUMBER_TABLE,
484: p_destination_ous IN JTF_NUMBER_TABLE,
485: p_destination_orgs IN JTF_NUMBER_TABLE,
486: p_destination_loc_ids IN JTF_NUMBER_TABLE,
487: p_source_ous IN JTF_NUMBER_TABLE,

Line 484: p_destination_ous IN JTF_NUMBER_TABLE,

480: p_api_version IN NUMBER,
481: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
482: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
483: p_product_txn_ids IN JTF_NUMBER_TABLE,
484: p_destination_ous IN JTF_NUMBER_TABLE,
485: p_destination_orgs IN JTF_NUMBER_TABLE,
486: p_destination_loc_ids IN JTF_NUMBER_TABLE,
487: p_source_ous IN JTF_NUMBER_TABLE,
488: p_source_orgs IN JTF_NUMBER_TABLE,

Line 485: p_destination_orgs IN JTF_NUMBER_TABLE,

481: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
482: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
483: p_product_txn_ids IN JTF_NUMBER_TABLE,
484: p_destination_ous IN JTF_NUMBER_TABLE,
485: p_destination_orgs IN JTF_NUMBER_TABLE,
486: p_destination_loc_ids IN JTF_NUMBER_TABLE,
487: p_source_ous IN JTF_NUMBER_TABLE,
488: p_source_orgs IN JTF_NUMBER_TABLE,
489: p_need_by_date IN DATE,

Line 486: p_destination_loc_ids IN JTF_NUMBER_TABLE,

482: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
483: p_product_txn_ids IN JTF_NUMBER_TABLE,
484: p_destination_ous IN JTF_NUMBER_TABLE,
485: p_destination_orgs IN JTF_NUMBER_TABLE,
486: p_destination_loc_ids IN JTF_NUMBER_TABLE,
487: p_source_ous IN JTF_NUMBER_TABLE,
488: p_source_orgs IN JTF_NUMBER_TABLE,
489: p_need_by_date IN DATE,
490: p_quantitys IN JTF_NUMBER_TABLE,

Line 487: p_source_ous IN JTF_NUMBER_TABLE,

483: p_product_txn_ids IN JTF_NUMBER_TABLE,
484: p_destination_ous IN JTF_NUMBER_TABLE,
485: p_destination_orgs IN JTF_NUMBER_TABLE,
486: p_destination_loc_ids IN JTF_NUMBER_TABLE,
487: p_source_ous IN JTF_NUMBER_TABLE,
488: p_source_orgs IN JTF_NUMBER_TABLE,
489: p_need_by_date IN DATE,
490: p_quantitys IN JTF_NUMBER_TABLE,
491: p_source_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,

Line 488: p_source_orgs IN JTF_NUMBER_TABLE,

484: p_destination_ous IN JTF_NUMBER_TABLE,
485: p_destination_orgs IN JTF_NUMBER_TABLE,
486: p_destination_loc_ids IN JTF_NUMBER_TABLE,
487: p_source_ous IN JTF_NUMBER_TABLE,
488: p_source_orgs IN JTF_NUMBER_TABLE,
489: p_need_by_date IN DATE,
490: p_quantitys IN JTF_NUMBER_TABLE,
491: p_source_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,
492: p_destination_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,

Line 490: p_quantitys IN JTF_NUMBER_TABLE,

486: p_destination_loc_ids IN JTF_NUMBER_TABLE,
487: p_source_ous IN JTF_NUMBER_TABLE,
488: p_source_orgs IN JTF_NUMBER_TABLE,
489: p_need_by_date IN DATE,
490: p_quantitys IN JTF_NUMBER_TABLE,
491: p_source_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,
492: p_destination_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,
493: x_requisition OUT NOCOPY VARCHAR2,
494: x_requisition_id OUT NOCOPY NUMBER,

Line 504: l_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

500: lc_api_version CONSTANT NUMBER := 1.0;
501: l_user_id NUMBER := fnd_global.user_id;
502: l_person_id NUMBER;
503: l_currency_code VARCHAR2(15);
504: l_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
505: l_item_descriptions JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
506: l_uom_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
507: l_inventory_item_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
508: l_request_id NUMBER;

Line 507: l_inventory_item_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

503: l_currency_code VARCHAR2(15);
504: l_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
505: l_item_descriptions JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
506: l_uom_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
507: l_inventory_item_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
508: l_request_id NUMBER;
509: l_material_accounts JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
510: l_success BOOLEAN := TRUE;
511: l_source_subinvs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 509: l_material_accounts JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

505: l_item_descriptions JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
506: l_uom_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
507: l_inventory_item_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
508: l_request_id NUMBER;
509: l_material_accounts JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
510: l_success BOOLEAN := TRUE;
511: l_source_subinvs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
512: l_destination_subinvs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
513: x_phase VARCHAR2(15);

Line 779: l_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

775: p_destination_subinv IN VARCHAR2 DEFAULT NULL
776: )
777: IS
778: lc_api_name VARCHAR2(80) := 'CSD_INTERNAL_ORDERS_PVT.create_internal_move_orders';
779: l_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
780: l_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
781: l_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
782: l_destination_loc_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
783: l_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 780: l_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

776: )
777: IS
778: lc_api_name VARCHAR2(80) := 'CSD_INTERNAL_ORDERS_PVT.create_internal_move_orders';
779: l_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
780: l_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
781: l_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
782: l_destination_loc_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
783: l_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
784: l_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 781: l_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

777: IS
778: lc_api_name VARCHAR2(80) := 'CSD_INTERNAL_ORDERS_PVT.create_internal_move_orders';
779: l_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
780: l_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
781: l_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
782: l_destination_loc_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
783: l_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
784: l_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
785: l_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 782: l_destination_loc_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

778: lc_api_name VARCHAR2(80) := 'CSD_INTERNAL_ORDERS_PVT.create_internal_move_orders';
779: l_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
780: l_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
781: l_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
782: l_destination_loc_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
783: l_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
784: l_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
785: l_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
786: l_source_subinvs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 783: l_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

779: l_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
780: l_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
781: l_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
782: l_destination_loc_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
783: l_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
784: l_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
785: l_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
786: l_source_subinvs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
787: l_destination_subinvs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 784: l_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

780: l_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
781: l_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
782: l_destination_loc_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
783: l_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
784: l_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
785: l_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
786: l_source_subinvs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
787: l_destination_subinvs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
788:

Line 785: l_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

781: l_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
782: l_destination_loc_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
783: l_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
784: l_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
785: l_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
786: l_source_subinvs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
787: l_destination_subinvs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
788:
789: BEGIN

Line 843: p_product_txn_ids IN JTF_NUMBER_TABLE,

839:
840: PROCEDURE create_internal_move_orders(
841: errbuf OUT NOCOPY VARCHAR2,
842: retcode OUT NOCOPY VARCHAR2,
843: p_product_txn_ids IN JTF_NUMBER_TABLE,
844: p_destination_ous IN JTF_NUMBER_TABLE,
845: p_destination_orgs IN JTF_NUMBER_TABLE,
846: p_destination_loc_ids IN JTF_NUMBER_TABLE,
847: p_source_ous IN JTF_NUMBER_TABLE,

Line 844: p_destination_ous IN JTF_NUMBER_TABLE,

840: PROCEDURE create_internal_move_orders(
841: errbuf OUT NOCOPY VARCHAR2,
842: retcode OUT NOCOPY VARCHAR2,
843: p_product_txn_ids IN JTF_NUMBER_TABLE,
844: p_destination_ous IN JTF_NUMBER_TABLE,
845: p_destination_orgs IN JTF_NUMBER_TABLE,
846: p_destination_loc_ids IN JTF_NUMBER_TABLE,
847: p_source_ous IN JTF_NUMBER_TABLE,
848: p_source_orgs IN JTF_NUMBER_TABLE,

Line 845: p_destination_orgs IN JTF_NUMBER_TABLE,

841: errbuf OUT NOCOPY VARCHAR2,
842: retcode OUT NOCOPY VARCHAR2,
843: p_product_txn_ids IN JTF_NUMBER_TABLE,
844: p_destination_ous IN JTF_NUMBER_TABLE,
845: p_destination_orgs IN JTF_NUMBER_TABLE,
846: p_destination_loc_ids IN JTF_NUMBER_TABLE,
847: p_source_ous IN JTF_NUMBER_TABLE,
848: p_source_orgs IN JTF_NUMBER_TABLE,
849: p_need_by_date IN DATE,

Line 846: p_destination_loc_ids IN JTF_NUMBER_TABLE,

842: retcode OUT NOCOPY VARCHAR2,
843: p_product_txn_ids IN JTF_NUMBER_TABLE,
844: p_destination_ous IN JTF_NUMBER_TABLE,
845: p_destination_orgs IN JTF_NUMBER_TABLE,
846: p_destination_loc_ids IN JTF_NUMBER_TABLE,
847: p_source_ous IN JTF_NUMBER_TABLE,
848: p_source_orgs IN JTF_NUMBER_TABLE,
849: p_need_by_date IN DATE,
850: p_quantitys IN JTF_NUMBER_TABLE,

Line 847: p_source_ous IN JTF_NUMBER_TABLE,

843: p_product_txn_ids IN JTF_NUMBER_TABLE,
844: p_destination_ous IN JTF_NUMBER_TABLE,
845: p_destination_orgs IN JTF_NUMBER_TABLE,
846: p_destination_loc_ids IN JTF_NUMBER_TABLE,
847: p_source_ous IN JTF_NUMBER_TABLE,
848: p_source_orgs IN JTF_NUMBER_TABLE,
849: p_need_by_date IN DATE,
850: p_quantitys IN JTF_NUMBER_TABLE,
851: p_source_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,

Line 848: p_source_orgs IN JTF_NUMBER_TABLE,

844: p_destination_ous IN JTF_NUMBER_TABLE,
845: p_destination_orgs IN JTF_NUMBER_TABLE,
846: p_destination_loc_ids IN JTF_NUMBER_TABLE,
847: p_source_ous IN JTF_NUMBER_TABLE,
848: p_source_orgs IN JTF_NUMBER_TABLE,
849: p_need_by_date IN DATE,
850: p_quantitys IN JTF_NUMBER_TABLE,
851: p_source_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,
852: p_destination_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL

Line 850: p_quantitys IN JTF_NUMBER_TABLE,

846: p_destination_loc_ids IN JTF_NUMBER_TABLE,
847: p_source_ous IN JTF_NUMBER_TABLE,
848: p_source_orgs IN JTF_NUMBER_TABLE,
849: p_need_by_date IN DATE,
850: p_quantitys IN JTF_NUMBER_TABLE,
851: p_source_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,
852: p_destination_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL
853: )
854: IS

Line 910: WHERE product_transaction_id IN (SELECT * FROM TABLE(CAST(p_product_txn_ids AS JTF_NUMBER_TABLE)));

906: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
907: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Requisition created.Update prod txn tbl with req id='||x_requisition_id);
908: END IF;
909: UPDATE csd_product_transactions SET req_header_id = x_requisition_id
910: WHERE product_transaction_id IN (SELECT * FROM TABLE(CAST(p_product_txn_ids AS JTF_NUMBER_TABLE)));
911:
912: -- Step 3. Launch the Create Internal Orders program.
913: -- the code is factored and the create sales orders CP programs have been grouped together to avoid
914: -- code duplication.

Line 1003: p_quantity_tbl IN JTF_NUMBER_TABLE,

999: p_is_sn_range IN VARCHAR2,
1000: p_is_reservable IN VARCHAR2,
1001: p_lot_num IN VARCHAR2,
1002: p_rev IN VARCHAR2,
1003: p_quantity_tbl IN JTF_NUMBER_TABLE,
1004: p_picking_rule_id IN NUMBER DEFAULT NULL,
1005: p_picking_subinv IN VARCHAR2 DEFAULT NULL,
1006: p_pick_from_org IN NUMBER DEFAULT NULL,
1007: x_msg_count OUT NOCOPY NUMBER,

Line 1283: p_quantity_tbl IN JTF_NUMBER_TABLE,

1279: p_is_sn_range IN VARCHAR2,
1280: p_is_reservable IN VARCHAR2,
1281: p_lot_num IN VARCHAR2,
1282: p_rev IN VARCHAR2,
1283: p_quantity_tbl IN JTF_NUMBER_TABLE,
1284: x_msg_count OUT NOCOPY NUMBER,
1285: x_msg_data OUT NOCOPY VARCHAR2,
1286: x_return_status OUT NOCOPY VARCHAR2)
1287: IS

Line 1983: p_quantity_tbl IN JTF_NUMBER_TABLE,

1979: p_is_sn_range IN VARCHAR2,
1980: p_is_reservable IN VARCHAR2,
1981: p_lot_num IN VARCHAR2,
1982: p_rev IN VARCHAR2,
1983: p_quantity_tbl IN JTF_NUMBER_TABLE,
1984: p_picking_rule_id IN NUMBER DEFAULT NULL,
1985: p_picking_subinv IN VARCHAR2 DEFAULT NULL,
1986: p_pick_from_org IN NUMBER DEFAULT NULL,
1987: x_msg_count OUT NOCOPY NUMBER,