DBA Data[Home] [Help]

APPS.CSD_WIP_JOB_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 2544: px_job_names IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

2540: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
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,

Line 2571: l_alt_bills JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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();
2575: lx_job_name VARCHAR2(30);

Line 2572: l_alt_routes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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();
2575: lx_job_name VARCHAR2(30);
2576: l_group_id NUMBER := 0;

Line 2573: l_completion_subinvs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

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();
2575: lx_job_name VARCHAR2(30);
2576: l_group_id NUMBER := 0;
2577: l_job_status NUMBER;

Line 2601: px_job_names := jtf_varchar2_table_100();

2597: THEN
2598: fnd_msg_pub.initialize;
2599: END IF;
2600:
2601: px_job_names := jtf_varchar2_table_100();
2602:
2603: -- initialize the sql executed variable.
2604: l_sc_sql_executed := FALSE;
2605: -- set the return status to success.