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_NUMBER_TABLE

Line 35: g_bill_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

31: g_business_process_id NUMBER;
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();

Line 37: g_routing_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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();
41: g_sc_id NUMBER;

Line 40: g_completion_locid 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');
44:

Line 468: p_recall_line_ids IN JTF_NUMBER_TABLE,

464:
465: PROCEDURE GENERATE_RECALL_WORK (p_api_version IN NUMBER,
466: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
467: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
468: p_recall_line_ids IN JTF_NUMBER_TABLE,
469: p_sr_type_id IN NUMBER,
470: p_ro_type_id IN NUMBER DEFAULT NULL,
471: p_service_code_id IN NUMBER DEFAULT NULL,
472: p_wip_accounting_class IN VARCHAR2 DEFAULT NULL,

Line 534: WHERE crl.recall_line_id IN (SELECT * FROM TABLE(CAST(p_recall_line_ids as JTF_NUMBER_TABLE)))

530: SELECT csd_recall_lines_group_s1.NEXTVAL INTO l_group_id FROM dual;
531:
532: -- update the selected recall line id's as processing flag = 'Y';
533: UPDATE CSD_RECALL_LINES crl SET processing_flag = 'Y', processing_group_id = l_group_id
534: WHERE crl.recall_line_id IN (SELECT * FROM TABLE(CAST(p_recall_line_ids as JTF_NUMBER_TABLE)))
535: AND nvl(crl.processing_flag,'N') = 'N';
536:
537: COMMIT;
538:

Line 562: WHERE crl.recall_line_id IN (SELECT * FROM TABLE(CAST(p_recall_line_ids as JTF_NUMBER_TABLE)))

558: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Error in launching CP');
559: END IF;
560:
561: UPDATE CSD_RECALL_LINES crl SET processing_flag = 'N'
562: WHERE crl.recall_line_id IN (SELECT * FROM TABLE(CAST(p_recall_line_ids as JTF_NUMBER_TABLE)))
563: AND nvl(crl.processing_flag,'N') = 'Y'
564: AND crl.processing_group_id = l_group_id;
565:
566: COMMIT;

Line 1214: l_metric_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1210: retcode OUT NOCOPY VARCHAR2,
1211: p_recall_number IN VARCHAR2 DEFAULT NULL )
1212: IS
1213: l_exists NUMBER;
1214: l_metric_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1215: l_accumulated_cost JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
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();

Line 1215: l_accumulated_cost JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1211: p_recall_number IN VARCHAR2 DEFAULT NULL )
1212: IS
1213: l_exists NUMBER;
1214: l_metric_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1215: l_accumulated_cost JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
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();

Line 1216: l_wip_jobs_with_costs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1212: IS
1213: l_exists NUMBER;
1214: l_metric_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1215: l_accumulated_cost JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
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();

Line 1217: l_wip_jobs_without_costs JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1213: l_exists NUMBER;
1214: l_metric_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1215: l_accumulated_cost JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
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();

Line 1218: l_remaining_cost JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1214: l_metric_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1215: l_accumulated_cost JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
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

Line 1219: l_gen_num_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

1215: l_accumulated_cost JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
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

Line 1262: AND crm.metric_id NOT IN (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)));

1258: csd_recall_statuses_b crs
1259: WHERE crh.recall_number = crm.recall_number
1260: AND crh.recall_flow_status_id = crs.status_id
1261: AND crs.status_code <> 'C'
1262: AND crm.metric_id NOT IN (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)));
1263: END IF;
1264:
1265: -- number of units recalled.
1266: SELECT crh.recall_number,SUM(cii.quantity)

Line 1272: WHERE crm.metric_id IN (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))

1268: FROM csd_recall_metrics crm,
1269: csd_recall_headers_b crh,
1270: csd_recall_lines crl,
1271: csi_item_instances cii
1272: WHERE crm.metric_id IN (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))
1273: AND crm.recall_number = crh.recall_number
1274: AND crh.recall_id = crl.recall_id
1275: AND crl.instance_id = cii.instance_id
1276: GROUP BY crh.recall_number;

Line 1291: WHERE crm.metric_id IN (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))

1287: BULK COLLECT INTO l_recall_numbers,l_gen_num_tbl
1288: FROM csd_recall_metrics crm,
1289: csd_recall_headers_b crh,
1290: csd_recall_lines crl
1291: WHERE crm.metric_id IN (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))
1292: AND crm.recall_number = crh.recall_number
1293: AND crh.recall_id = crl.recall_id
1294: GROUP BY crh.recall_number;
1295:

Line 1313: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))

1309: csd_recall_lines crl,
1310: csd_repair_job_xref crj,
1311: wip_period_balances wpb
1312: WHERE crm.metric_id IN
1313: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))
1314: AND crm.recall_number = crh.recall_number
1315: AND crh.recall_id = crl.recall_id
1316: AND crl.repair_line_id = crj.repair_line_id
1317: AND crj.wip_entity_id = wpb.wip_entity_id

Line 1339: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)) )

1335: csd_recall_headers_b crh,
1336: csd_recall_lines crl,
1337: csd_repair_job_xref crj
1338: WHERE crm.metric_id IN
1339: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)) )
1340: AND crm.recall_number = crh.recall_number
1341: AND crh.recall_id = crl.recall_id
1342: AND crl.repair_line_id = crj.repair_line_id
1343: AND NOT EXISTS

Line 1366: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))

1362: csi_item_instances cii,
1363: cs_incidents_all_b sr,
1364: cs_incident_statuses_b cis
1365: WHERE crm.metric_id IN
1366: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))
1367: AND crm.recall_number = crh.recall_number
1368: AND crh.recall_id = crl.recall_id
1369: AND crl.instance_id = cii.instance_id
1370: AND crl.incident_id IS NOT NULL

Line 1424: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))

1420: cs_incidents_all_b sr,
1421: cs_incident_statuses_b cis,
1422: csi_item_instances cii
1423: WHERE crm.metric_id IN
1424: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))
1425: AND crm.recall_number = crh.recall_number
1426: AND crh.recall_id = crl.recall_id
1427: AND crl.incident_id = sr.incident_id
1428: AND sr.incident_status_id = cis.incident_status_id

Line 1467: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))

1463: csd_recall_lines crl,
1464: cs_incidents_all_b sr,
1465: cs_incident_statuses_b cis
1466: WHERE crm.metric_id IN
1467: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))
1468: AND crm.recall_number = crh.recall_number
1469: AND crh.recall_id = crl.recall_id
1470: AND crl.incident_id = sr.incident_id
1471: AND sr.incident_status_id = cis.incident_status_id

Line 1481: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))

1477: cs_incidents_all_b sr1,
1478: cs_incident_statuses_b cis1,
1479: csd_recall_metrics crm1
1480: WHERE crm1.metric_id IN
1481: (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)))
1482: AND crm1.recall_number = crh1.recall_number
1483: AND crh1.recall_id = crl1.recall_id
1484: AND crl1.owner_party_id = crl.owner_party_id
1485: AND crl1.incident_id = sr1.incident_id