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_REPAIR_MANAGER_UTIL dependencies on JTF_NUMBER_TABLE

Line 202: l_incident_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

198: procedure write_cp_output(p_group_id in number);
199: procedure write_cp_output(p_group_id in number)
200: is
201:
202: l_incident_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
203: l_repair_line_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
204:
205: l_repair_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
206: l_incident_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 203: l_repair_line_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

199: procedure write_cp_output(p_group_id in number)
200: is
201:
202: l_incident_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
203: l_repair_line_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
204:
205: l_repair_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
206: l_incident_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
207: l_serial_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 227: (select * from table(cast(l_repair_line_ids as JTF_NUMBER_TABLE)))

223: cs_incidents_all_b cs,
224: csi_item_instances csi
225: where cr.incident_id = cs.incident_id
226: and cr.repair_line_id in
227: (select * from table(cast(l_repair_line_ids as JTF_NUMBER_TABLE)))
228: and cr.customer_product_id = csi.instance_id(+);
229: end if;
230:
231: fnd_file.put_line(fnd_file.output,rpad('Successful Records',30,' '));

Line 256: p_repair_line_ids IN JTF_NUMBER_TABLE,

252: PROCEDURE create_internal_orders(p_api_version IN NUMBER,
253: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
254: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
255: p_repln_tbl IN csd_repairs_pub.repln_tbl_type,
256: p_repair_line_ids IN JTF_NUMBER_TABLE,
257: x_return_status OUT NOCOPY VARCHAR2,
258: x_msg_count OUT NOCOPY NUMBER,
259: x_msg_data OUT NOCOPY VARCHAR2)
260: IS

Line 276: l_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

272: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;
273: TYPE generic_num_assoc_arry IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
274: l_destn_org_tbl generic_num_assoc_arry;
275: l_destn_loc_tbl generic_num_assoc_arry;
276: l_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
277: l_default_rule_id NUMBER;
278: l_included_item_ids generic_num_assoc_arry;
279: l_order_header_id NUMBER;
280: l_order_line_id NUMBER;

Line 285: l_ord_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

281: l_req_hdr_id NUMBER;
282: l_delivery_detail_id NUMBER;
283: errbuf VARCHAR2(2000);
284: retcode NUMBER;
285: l_ord_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
286: l_ord_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
287: l_ord_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
288: l_ord_destination_locs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
289: l_ord_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 286: l_ord_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

282: l_delivery_detail_id NUMBER;
283: errbuf VARCHAR2(2000);
284: retcode NUMBER;
285: l_ord_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
286: l_ord_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
287: l_ord_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
288: l_ord_destination_locs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
289: l_ord_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
290: l_ord_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 287: l_ord_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

283: errbuf VARCHAR2(2000);
284: retcode NUMBER;
285: l_ord_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
286: l_ord_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
287: l_ord_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
288: l_ord_destination_locs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
289: l_ord_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
290: l_ord_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
291: l_ord_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 288: l_ord_destination_locs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

284: retcode NUMBER;
285: l_ord_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
286: l_ord_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
287: l_ord_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
288: l_ord_destination_locs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
289: l_ord_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
290: l_ord_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
291: l_ord_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
292: l_index NUMBER := 0;

Line 289: l_ord_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

285: l_ord_product_txn_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
286: l_ord_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
287: l_ord_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
288: l_ord_destination_locs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
289: l_ord_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
290: l_ord_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
291: l_ord_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
292: l_index NUMBER := 0;
293:

Line 290: l_ord_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

286: l_ord_destination_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
287: l_ord_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
288: l_ord_destination_locs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
289: l_ord_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
290: l_ord_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
291: l_ord_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
292: l_index NUMBER := 0;
293:
294: BEGIN

Line 291: l_ord_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

287: l_ord_destination_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
288: l_ord_destination_locs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
289: l_ord_source_ous JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
290: l_ord_source_orgs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
291: l_ord_quantitys JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
292: l_index NUMBER := 0;
293:
294: BEGIN
295: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

Line 513: WHERE product_transaction_id IN (SELECT * FROM TABLE(CAST(l_ord_product_txn_ids AS JTF_NUMBER_TABLE)))

509: END IF;
510: -- update the values for the other product transaction lines also.
511: FOR i IN (SELECT req_header_id,req_line_id,order_header_id,order_line_id,inventory_item_id,delivery_detail_id
512: FROM csd_product_transactions
513: WHERE product_transaction_id IN (SELECT * FROM TABLE(CAST(l_ord_product_txn_ids AS JTF_NUMBER_TABLE)))
514: )
515: LOOP
516: UPDATE csd_product_transactions SET req_header_id = i.req_header_id,req_line_id = i.req_line_id,
517: order_header_id = i.order_header_id,order_line_id = i.order_line_id,delivery_detail_id = i.delivery_detail_id

Line 518: WHERE product_transaction_id IN (SELECT * FROM TABLE(CAST(l_product_txn_ids AS JTF_NUMBER_TABLE)))

514: )
515: LOOP
516: UPDATE csd_product_transactions SET req_header_id = i.req_header_id,req_line_id = i.req_line_id,
517: order_header_id = i.order_header_id,order_line_id = i.order_line_id,delivery_detail_id = i.delivery_detail_id
518: WHERE product_transaction_id IN (SELECT * FROM TABLE(CAST(l_product_txn_ids AS JTF_NUMBER_TABLE)))
519: AND req_header_id IS NULL;
520: END LOOP;
521:
522: EXCEPTION

Line 703: p_repair_line_ids IN JTF_NUMBER_TABLE,

699: /******************************************************************************/
700: PROCEDURE mass_update_repair_orders(p_api_version IN NUMBER DEFAULT 1.0,
701: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
702: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
703: p_repair_line_ids IN JTF_NUMBER_TABLE,
704: p_from_ro_status IN JTF_NUMBER_TABLE,
705: p_orig_ro_type_ids IN JTF_NUMBER_TABLE,
706: p_ro_obj_ver_nos IN JTF_NUMBER_TABLE,
707: p_to_ro_status IN NUMBER DEFAULT NULL,

Line 704: p_from_ro_status IN JTF_NUMBER_TABLE,

700: PROCEDURE mass_update_repair_orders(p_api_version IN NUMBER DEFAULT 1.0,
701: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
702: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
703: p_repair_line_ids IN JTF_NUMBER_TABLE,
704: p_from_ro_status IN JTF_NUMBER_TABLE,
705: p_orig_ro_type_ids IN JTF_NUMBER_TABLE,
706: p_ro_obj_ver_nos IN JTF_NUMBER_TABLE,
707: p_to_ro_status IN NUMBER DEFAULT NULL,
708: p_ro_type_id IN NUMBER DEFAULT NULL,

Line 705: p_orig_ro_type_ids IN JTF_NUMBER_TABLE,

701: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
702: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
703: p_repair_line_ids IN JTF_NUMBER_TABLE,
704: p_from_ro_status IN JTF_NUMBER_TABLE,
705: p_orig_ro_type_ids IN JTF_NUMBER_TABLE,
706: p_ro_obj_ver_nos IN JTF_NUMBER_TABLE,
707: p_to_ro_status IN NUMBER DEFAULT NULL,
708: p_ro_type_id IN NUMBER DEFAULT NULL,
709: p_ro_owner_id IN NUMBER DEFAULT NULL,

Line 706: p_ro_obj_ver_nos IN JTF_NUMBER_TABLE,

702: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
703: p_repair_line_ids IN JTF_NUMBER_TABLE,
704: p_from_ro_status IN JTF_NUMBER_TABLE,
705: p_orig_ro_type_ids IN JTF_NUMBER_TABLE,
706: p_ro_obj_ver_nos IN JTF_NUMBER_TABLE,
707: p_to_ro_status IN NUMBER DEFAULT NULL,
708: p_ro_type_id IN NUMBER DEFAULT NULL,
709: p_ro_owner_id IN NUMBER DEFAULT NULL,
710: p_ro_org_id IN NUMBER DEFAULT NULL,

Line 738: l_repobj_ver JTF_NUMBER_TABLE := p_ro_obj_ver_nos;

734: l_api_name constant varchar2(100) := 'CSD_REPAIR_MANAGER_UTIL.MASS_UPDATE_REPAIR_ORDERS';
735: TYPE l_repln_rec_tbl_type is table of Csd_Repairs_Pub.REPLN_Rec_Type
736: index by binary_integer;
737: l_repln_rec_tbl l_repln_rec_tbl_type;
738: l_repobj_ver JTF_NUMBER_TABLE := p_ro_obj_ver_nos;
739: --l_repair_line_ids JTF_NUMBER_TABLE;
740: l_update_ros boolean default false;
741: x_object_version_number number;
742: x_jtf_note_id number;

Line 739: --l_repair_line_ids JTF_NUMBER_TABLE;

735: TYPE l_repln_rec_tbl_type is table of Csd_Repairs_Pub.REPLN_Rec_Type
736: index by binary_integer;
737: l_repln_rec_tbl l_repln_rec_tbl_type;
738: l_repobj_ver JTF_NUMBER_TABLE := p_ro_obj_ver_nos;
739: --l_repair_line_ids JTF_NUMBER_TABLE;
740: l_update_ros boolean default false;
741: x_object_version_number number;
742: x_jtf_note_id number;
743:

Line 1203: p_repair_line_ids IN JTF_NUMBER_TABLE,

1199: /******************************************************************************/
1200: PROCEDURE mass_create_attachments(p_api_version IN NUMBER DEFAULT 1.0,
1201: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1202: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1203: p_repair_line_ids IN JTF_NUMBER_TABLE,
1204: p_attach_type IN VARCHAR2,
1205: p_attach_cat_id IN NUMBER,
1206: p_attach_descr IN VARCHAR2 DEFAULT NULL,
1207: p_attach_title IN VARCHAR2,

Line 1444: p_item_ids IN JTF_NUMBER_TABLE,

1440: /******************************************************************************/
1441: PROCEDURE mass_create_repair_orders(p_api_version IN NUMBER DEFAULT 1.0,
1442: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1443: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1444: p_item_ids IN JTF_NUMBER_TABLE,
1445: p_serial_numbers IN JTF_VARCHAR2_TABLE_100,
1446: p_quantity IN JTF_NUMBER_TABLE,
1447: p_uom_code IN JTF_VARCHAR2_TABLE_100,
1448: p_external_ref IN JTF_VARCHAR2_TABLE_100,

Line 1446: p_quantity IN JTF_NUMBER_TABLE,

1442: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1443: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1444: p_item_ids IN JTF_NUMBER_TABLE,
1445: p_serial_numbers IN JTF_VARCHAR2_TABLE_100,
1446: p_quantity IN JTF_NUMBER_TABLE,
1447: p_uom_code IN JTF_VARCHAR2_TABLE_100,
1448: p_external_ref IN JTF_VARCHAR2_TABLE_100,
1449: p_lot_nums IN JTF_VARCHAR2_TABLE_100,
1450: p_item_revisions IN JTF_VARCHAR2_TABLE_100,

Line 1451: p_repair_type_ids IN JTF_NUMBER_TABLE,

1447: p_uom_code IN JTF_VARCHAR2_TABLE_100,
1448: p_external_ref IN JTF_VARCHAR2_TABLE_100,
1449: p_lot_nums IN JTF_VARCHAR2_TABLE_100,
1450: p_item_revisions IN JTF_VARCHAR2_TABLE_100,
1451: p_repair_type_ids IN JTF_NUMBER_TABLE,
1452: p_instance_ids IN JTF_NUMBER_TABLE,
1453: p_serial_ctrl_flag IN JTF_NUMBER_TABLE,
1454: p_rev_ctrl_flag IN JTF_NUMBER_TABLE,
1455: p_ib_ctrl_flag IN JTF_VARCHAR2_TABLE_100,

Line 1452: p_instance_ids IN JTF_NUMBER_TABLE,

1448: p_external_ref IN JTF_VARCHAR2_TABLE_100,
1449: p_lot_nums IN JTF_VARCHAR2_TABLE_100,
1450: p_item_revisions IN JTF_VARCHAR2_TABLE_100,
1451: p_repair_type_ids IN JTF_NUMBER_TABLE,
1452: p_instance_ids IN JTF_NUMBER_TABLE,
1453: p_serial_ctrl_flag IN JTF_NUMBER_TABLE,
1454: p_rev_ctrl_flag IN JTF_NUMBER_TABLE,
1455: p_ib_ctrl_flag IN JTF_VARCHAR2_TABLE_100,
1456: p_party_id IN NUMBER,

Line 1453: p_serial_ctrl_flag IN JTF_NUMBER_TABLE,

1449: p_lot_nums IN JTF_VARCHAR2_TABLE_100,
1450: p_item_revisions IN JTF_VARCHAR2_TABLE_100,
1451: p_repair_type_ids IN JTF_NUMBER_TABLE,
1452: p_instance_ids IN JTF_NUMBER_TABLE,
1453: p_serial_ctrl_flag IN JTF_NUMBER_TABLE,
1454: p_rev_ctrl_flag IN JTF_NUMBER_TABLE,
1455: p_ib_ctrl_flag IN JTF_VARCHAR2_TABLE_100,
1456: p_party_id IN NUMBER,
1457: p_account_id IN NUMBER,

Line 1454: p_rev_ctrl_flag IN JTF_NUMBER_TABLE,

1450: p_item_revisions IN JTF_VARCHAR2_TABLE_100,
1451: p_repair_type_ids IN JTF_NUMBER_TABLE,
1452: p_instance_ids IN JTF_NUMBER_TABLE,
1453: p_serial_ctrl_flag IN JTF_NUMBER_TABLE,
1454: p_rev_ctrl_flag IN JTF_NUMBER_TABLE,
1455: p_ib_ctrl_flag IN JTF_VARCHAR2_TABLE_100,
1456: p_party_id IN NUMBER,
1457: p_account_id IN NUMBER,
1458: x_return_status OUT NOCOPY VARCHAR2,

Line 1470: l_repair_line_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1466: l_repln_tbl csd_repairs_pub.repln_tbl_type;
1467:
1468: x_repair_line_id number;
1469: l_sr_rec sr_rec_type;
1470: l_repair_line_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1471:
1472: BEGIN
1473:
1474: -- standard stuff.

Line 1576: l_repair_line_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1572: x_repair_line_id number;
1573: x_return_status varchar2(3);
1574: x_msg_data varchar2(2000);
1575: x_msg_count number;
1576: l_repair_line_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1577:
1578: begin
1579: -- the program logic.
1580: -- Step 1. Check if there is bare minimum information required to create the