DBA Data[Home] [Help]

APPS.CSD_WIP_JOB_PVT dependencies on JTF_NUMBER_TABLE

Line 1542: l_repair_line_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1538: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1539: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
1540: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_wip_job_pvt.submit_wip_mass_load_conc.';
1541: -- subhat, bug#13586864 changes.
1542: l_repair_line_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1543: l_operation_seq_num NUMBER := 0;
1544:
1545: CURSOR job_details IS
1546: SELECT cr.repair_line_id,

Line 1558: (SELECT * FROM TABLE(CAST(l_repair_line_ids AS JTF_NUMBER_TABLE))) ro_lines,

1554: msi.primary_uom_code,
1555: cr.quantity,
1556: cr.serial_number
1557: FROM csd_repairs cr,
1558: (SELECT * FROM TABLE(CAST(l_repair_line_ids AS JTF_NUMBER_TABLE))) ro_lines,
1559: csd_repair_job_xref crj,
1560: wip_discrete_jobs wdj,
1561: mtl_system_items_b msi,
1562: wip_entities we

Line 2545: p_repair_line_ids IN JTF_NUMBER_TABLE,

2541: x_return_status OUT NOCOPY VARCHAR2,
2542: x_msg_count OUT NOCOPY NUMBER,
2543: x_msg_data OUT NOCOPY VARCHAR2,
2544: px_job_names IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2545: p_repair_line_ids IN JTF_NUMBER_TABLE,
2546: p_inventory_item_ids IN JTF_NUMBER_TABLE,
2547: p_quantities IN JTF_NUMBER_TABLE,
2548: p_inventory_org_id IN NUMBER,
2549: p_start_date IN DATE,

Line 2546: p_inventory_item_ids IN JTF_NUMBER_TABLE,

2542: x_msg_count OUT NOCOPY NUMBER,
2543: x_msg_data OUT NOCOPY VARCHAR2,
2544: px_job_names IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2545: p_repair_line_ids IN JTF_NUMBER_TABLE,
2546: p_inventory_item_ids IN JTF_NUMBER_TABLE,
2547: p_quantities IN JTF_NUMBER_TABLE,
2548: p_inventory_org_id IN NUMBER,
2549: p_start_date IN DATE,
2550: p_end_date IN DATE,

Line 2547: p_quantities IN JTF_NUMBER_TABLE,

2543: x_msg_data OUT NOCOPY VARCHAR2,
2544: px_job_names IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
2545: p_repair_line_ids IN JTF_NUMBER_TABLE,
2546: p_inventory_item_ids IN JTF_NUMBER_TABLE,
2547: p_quantities IN JTF_NUMBER_TABLE,
2548: p_inventory_org_id IN NUMBER,
2549: p_start_date IN DATE,
2550: p_end_date IN DATE,
2551: p_accouting_class IN VARCHAR2,

Line 2569: l_bill_ref_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2565: lc_api_version NUMBER := 1.0;
2566: l_job_header_tbl job_header_tbl;
2567: l_job_header_index NUMBER := 1;
2568: l_sc_sql_executed BOOLEAN := FALSE;
2569: l_bill_ref_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2570: l_route_ref_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2571: l_alt_bills JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2572: l_alt_routes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2573: l_completion_subinvs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 2570: l_route_ref_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2566: l_job_header_tbl job_header_tbl;
2567: l_job_header_index NUMBER := 1;
2568: l_sc_sql_executed BOOLEAN := FALSE;
2569: l_bill_ref_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2570: l_route_ref_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2571: l_alt_bills JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2572: l_alt_routes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2573: l_completion_subinvs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2574: l_completion_locs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 2574: l_completion_locs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

2570: l_route_ref_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2571: l_alt_bills JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2572: l_alt_routes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2573: l_completion_subinvs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
2574: l_completion_locs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
2575: lx_job_name VARCHAR2(30);
2576: l_group_id NUMBER := 0;
2577: l_job_status NUMBER;
2578: l_mrp_net_qty_profile VARCHAR2(1) := nvl(fnd_profile.value('CSD_WIP_MRP_NET_QTY'),'N');