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_VARCHAR2_TABLE_100

Line 45: l_fm_serial_num_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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();
49: l_shipment_line_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 46: l_to_serial_num_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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();
49: l_shipment_line_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
50: l_shipment_num JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 50: l_shipment_num 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
54: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN

Line 491: p_source_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,

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,
495: x_msg_count OUT NOCOPY NUMBER,

Line 492: p_destination_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,

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,
495: x_msg_count OUT NOCOPY NUMBER,
496: x_msg_data OUT NOCOPY VARCHAR2,

Line 506: l_uom_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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;
509: l_material_accounts JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
510: l_success BOOLEAN := TRUE;

Line 511: l_source_subinvs 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);
514: x_status VARCHAR2(10);
515: x_dev_phase VARCHAR2(15);

Line 512: l_destination_subinvs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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);
514: x_status VARCHAR2(10);
515: x_dev_phase VARCHAR2(15);
516: x_dev_status VARCHAR2(10);

Line 786: l_source_subinvs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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
790:

Line 787: l_destination_subinvs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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
790:
791: -- create internal requisition.

Line 851: p_source_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,

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
855: lc_api_name VARCHAR2(80) := 'CSD_INTERNAL_ORDERS_PVT.create_internal_move_orders';

Line 852: p_destination_subinvs IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL

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
855: lc_api_name VARCHAR2(80) := 'CSD_INTERNAL_ORDERS_PVT.create_internal_move_orders';
856: x_msg_data VARCHAR2(2000);

Line 997: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,

993: p_order_header_id IN NUMBER,
994: p_orig_quantity IN NUMBER,
995: p_shipped_quantity IN NUMBER,
996: p_order_line_id IN NUMBER,
997: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
998: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
999: p_is_sn_range IN VARCHAR2,
1000: p_is_reservable IN VARCHAR2,
1001: p_lot_num IN VARCHAR2,

Line 998: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,

994: p_orig_quantity IN NUMBER,
995: p_shipped_quantity IN NUMBER,
996: p_order_line_id IN NUMBER,
997: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
998: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
999: p_is_sn_range IN VARCHAR2,
1000: p_is_reservable IN VARCHAR2,
1001: p_lot_num IN VARCHAR2,
1002: p_rev IN VARCHAR2,

Line 1277: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,

1273: p_order_header_id IN NUMBER,
1274: p_orig_quantity IN NUMBER,
1275: p_shipped_quantity IN NUMBER,
1276: p_order_line_id IN NUMBER,
1277: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
1278: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
1279: p_is_sn_range IN VARCHAR2,
1280: p_is_reservable IN VARCHAR2,
1281: p_lot_num IN VARCHAR2,

Line 1278: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,

1274: p_orig_quantity IN NUMBER,
1275: p_shipped_quantity IN NUMBER,
1276: p_order_line_id IN NUMBER,
1277: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
1278: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
1279: p_is_sn_range IN VARCHAR2,
1280: p_is_reservable IN VARCHAR2,
1281: p_lot_num IN VARCHAR2,
1282: p_rev IN VARCHAR2,

Line 1692: PROCEDURE IS_SERIAL_RANGE_VALID(p_sn_range_tbl IN JTF_VARCHAR2_TABLE_100,

1688: /* range invalid, then we break. */
1689: /* Returns: 1 if the range is valid, 0 if its not */
1690: /********************************************************************************************/
1691:
1692: PROCEDURE IS_SERIAL_RANGE_VALID(p_sn_range_tbl IN JTF_VARCHAR2_TABLE_100,
1693: p_inv_item_id IN NUMBER,
1694: p_current_org_id IN NUMBER,
1695: p_subinventory IN VARCHAR2 DEFAULT NULL,
1696: p_out OUT NOCOPY NUMBER)

Line 1698: l_db_sns JTF_VARCHAR2_TABLE_100;

1694: p_current_org_id IN NUMBER,
1695: p_subinventory IN VARCHAR2 DEFAULT NULL,
1696: p_out OUT NOCOPY NUMBER)
1697: IS
1698: l_db_sns JTF_VARCHAR2_TABLE_100;
1699: --l_in_sn_associative_array SN_ASSOCIATIVE_ARRAY;
1700: l_db_sn_associative_array SN_ASSOCIATIVE_ARRAY;
1701: l_limit CONSTANT NUMBER := 1000;
1702:

Line 1710: AND serial_number IN (SELECT * FROM TABLE(CAST(p_sn_range_tbl as JTF_VARCHAR2_TABLE_100)));

1706: WHERE inventory_item_id = p_inv_item_id
1707: AND current_organization_id = p_current_org_id
1708: AND current_status = 3 -- resides in stores.
1709: AND current_subinventory_code = nvl(p_subinventory,current_subinventory_code)
1710: AND serial_number IN (SELECT * FROM TABLE(CAST(p_sn_range_tbl as JTF_VARCHAR2_TABLE_100)));
1711:
1712: BEGIN
1713: -- bulk collect 1000 SN's at a time from the DB.
1714:

Line 1977: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,

1973: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1974: p_product_txn_id IN NUMBER,
1975: p_order_header_id IN NUMBER,
1976: p_order_line_id IN NUMBER,
1977: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
1978: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
1979: p_is_sn_range IN VARCHAR2,
1980: p_is_reservable IN VARCHAR2,
1981: p_lot_num IN VARCHAR2,

Line 1978: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,

1974: p_product_txn_id IN NUMBER,
1975: p_order_header_id IN NUMBER,
1976: p_order_line_id IN NUMBER,
1977: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
1978: p_to_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,
1979: p_is_sn_range IN VARCHAR2,
1980: p_is_reservable IN VARCHAR2,
1981: p_lot_num IN VARCHAR2,
1982: p_rev IN VARCHAR2,

Line 2006: l_fm_serial_number JTF_VARCHAR2_TABLE_100;

2002: l_reservation_id NUMBER;
2003: l_item_id NUMBER;
2004: l_org_id NUMBER;
2005: l_mmtt_temp_id NUMBER;
2006: l_fm_serial_number JTF_VARCHAR2_TABLE_100;
2007: l_to_serial_number JTF_VARCHAR2_TABLE_100;
2008: l_move_order_line_id NUMBER;
2009: l_delivery_status VARCHAR2(2);
2010: l_delivery_detail_id NUMBER;

Line 2007: l_to_serial_number JTF_VARCHAR2_TABLE_100;

2003: l_item_id NUMBER;
2004: l_org_id NUMBER;
2005: l_mmtt_temp_id NUMBER;
2006: l_fm_serial_number JTF_VARCHAR2_TABLE_100;
2007: l_to_serial_number JTF_VARCHAR2_TABLE_100;
2008: l_move_order_line_id NUMBER;
2009: l_delivery_status VARCHAR2(2);
2010: l_delivery_detail_id NUMBER;
2011: l_delivery_detail_id_new NUMBER;

Line 2619: l_internal_orders_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

2615: /*-----------------------------------------------------------------------------------------------------------*/
2616:
2617: FUNCTION GET_ALL_INTERNAL_ORDERS(p_repair_line_id IN NUMBER) RETURN VARCHAR2
2618: IS
2619: l_internal_orders_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2620: l_ret_string VARCHAR2(1000);
2621:
2622: BEGIN
2623: