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_RECALLS_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 36: g_alt_bill JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

32: g_repair_mode VARCHAR2(10);
33:
34: g_bill_details_cached BOOLEAN := FALSE;
35: g_bill_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
36: g_alt_bill JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
37: g_routing_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
38: g_alt_routing JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
39: g_completion_subinv JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
40: g_completion_locid JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 38: g_alt_routing JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

34: g_bill_details_cached BOOLEAN := FALSE;
35: g_bill_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
36: g_alt_bill JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
37: g_routing_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
38: g_alt_routing JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
39: g_completion_subinv JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
40: g_completion_locid JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
41: g_sc_id NUMBER;
42: g_upgrade_item_id NUMBER;

Line 39: g_completion_subinv JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

35: g_bill_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
36: g_alt_bill JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
37: g_routing_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
38: g_alt_routing JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
39: g_completion_subinv JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
40: g_completion_locid JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
41: g_sc_id NUMBER;
42: g_upgrade_item_id NUMBER;
43: g_job_prefix VARCHAR2(30) := fnd_profile.value('CSD_DEFAULT_JOB_PREFIX');

Line 1220: l_recall_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1216: l_wip_jobs_with_costs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1217: l_wip_jobs_without_costs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1218: l_remaining_cost JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1219: l_gen_num_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1220: l_recall_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1221: l_recall_numbers_temp JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1222: BEGIN
1223: -- check if the line exists for the recall number if passed else we will bring the metrics
1224: -- table in synch with all the recalls.

Line 1221: l_recall_numbers_temp JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1217: l_wip_jobs_without_costs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1218: l_remaining_cost JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1219: l_gen_num_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1220: l_recall_numbers JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1221: l_recall_numbers_temp JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1222: BEGIN
1223: -- check if the line exists for the recall number if passed else we will bring the metrics
1224: -- table in synch with all the recalls.
1225: IF p_recall_number IS NOT NULL

Line 1395: ( SELECT * FROM TABLE(CAST(l_recall_numbers_temp AS JTF_VARCHAR2_TABLE_100)))

1391: FROM csd_recall_headers_b crh,
1392: csd_recall_lines crl,
1393: csd_repair_job_xref crj
1394: WHERE crh.recall_number IN
1395: ( SELECT * FROM TABLE(CAST(l_recall_numbers_temp AS JTF_VARCHAR2_TABLE_100)))
1396: AND crh.recall_id = crl.recall_id
1397: AND crl.repair_line_id = crj.repair_line_id
1398: AND EXISTS (
1399: SELECT 'exists'

Line 1439: (SELECT * FROM TABLE(CAST(l_recall_numbers AS JTF_VARCHAR2_TABLE_100))) ;

1435: FORALL i IN 1 ..l_metric_ids.COUNT
1436: UPDATE csd_recall_metrics SET remediated_units = 0
1437: WHERE metric_id = l_metric_ids(i)
1438: AND recall_number NOT IN
1439: (SELECT * FROM TABLE(CAST(l_recall_numbers AS JTF_VARCHAR2_TABLE_100))) ;
1440: END IF;
1441:
1442: IF l_recall_numbers.COUNT > 0
1443: THEN

Line 1498: (SELECT * FROM TABLE(CAST(l_recall_numbers AS JTF_VARCHAR2_TABLE_100))) ;

1494: FORALL i IN 1 ..l_metric_ids.COUNT
1495: UPDATE csd_recall_metrics SET customers_remediated = 0
1496: WHERE metric_id = l_metric_ids(i)
1497: AND recall_number NOT IN
1498: (SELECT * FROM TABLE(CAST(l_recall_numbers AS JTF_VARCHAR2_TABLE_100))) ;
1499: END IF;
1500:
1501: IF l_recall_numbers.COUNT <> 0
1502: THEN