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_ESTIMATE_PVT dependencies on CSD_REPAIRS

Line 382: FROM CSD_REPAIRS rep

378: INTO l_repair_group_id, l_group_quantity, l_group_ovn
379: FROM CSD_REPAIR_ORDER_GROUPS grp
380: WHERE EXISTS
381: (SELECT 'x'
382: FROM CSD_REPAIRS rep
383: WHERE rep.repair_group_id = grp.repair_group_id
384: AND rep.repair_line_id = p_repair_line_id);
385:
386: EXCEPTION

Line 412: FROM CSD_REPAIRS

408:
409: BEGIN
410: SELECT COUNT(*)
411: INTO l_tot_approved
412: FROM CSD_REPAIRS
413: WHERE repair_group_id = l_repair_group_id
414: AND approval_status = 'A'
415: AND approval_required_flag = 'Y';
416: EXCEPTION

Line 429: FROM CSD_REPAIRS

425:
426: BEGIN
427: SELECT COUNT(*)
428: INTO l_tot_rejected
429: FROM CSD_REPAIRS
430: WHERE repair_group_id = l_repair_group_id
431: AND approval_status = 'R'
432: AND approval_required_flag = 'Y';
433: EXCEPTION

Line 446: FROM CSD_REPAIRS

442:
443: BEGIN
444: SELECT COUNT(*)
445: INTO l_tot_no_approval
446: FROM CSD_REPAIRS
447: WHERE repair_group_id = l_repair_group_id
448: AND approval_required_flag = 'N';
449: EXCEPTION
450: WHEN OTHERS THEN

Line 903: FROM CSD_REPAIR_ESTIMATE a, CSD_REPAIRS b

899: CURSOR repair_estimate(p_est_id IN NUMBER) IS
900: SELECT a.repair_estimate_id,
901: a.object_version_number,
902: b.approval_status
903: FROM CSD_REPAIR_ESTIMATE a, CSD_REPAIRS b
904: WHERE a.repair_line_id = b.repair_line_id
905: AND a.repair_estimate_id = p_est_id;
906:
907: BEGIN

Line 1223: FROM CSD_REPAIR_ESTIMATE a, CSD_REPAIRS b

1219:
1220: BEGIN
1221: SELECT b.approval_status
1222: INTO l_approval_status
1223: FROM CSD_REPAIR_ESTIMATE a, CSD_REPAIRS b
1224: WHERE a.repair_line_id = b.repair_line_id
1225: AND a.repair_estimate_id = p_estimate_id;
1226: EXCEPTION
1227: WHEN NO_DATA_FOUND THEN

Line 1550: FROM CSD_REPAIRS

1546: -- Get the service request
1547: BEGIN
1548: SELECT incident_id
1549: INTO l_incident_id
1550: FROM CSD_REPAIRS
1551: WHERE repair_line_id = x_estimate_line_rec.repair_line_id;
1552: EXCEPTION
1553: WHEN NO_DATA_FOUND THEN
1554: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');

Line 2719: Fnd_Message.SET_TOKEN('PROF_NAME', csd_repairs_util.get_user_profile_option_name('CSD_CUST_ESTRT_CON_NAME'));

2715: CLOSE get_default_template_name;
2716: -- no default tempalte defined, raise error
2717: IF (l_template_code is null) THEN
2718: Fnd_Message.SET_NAME('CSD', 'CSD_XDO_ESTRT_NO_TEMPLATE');
2719: Fnd_Message.SET_TOKEN('PROF_NAME', csd_repairs_util.get_user_profile_option_name('CSD_CUST_ESTRT_CON_NAME'));
2720: x_request_id := l_request_id;
2721: Fnd_Msg_Pub.ADD;
2722: RAISE Fnd_Api.G_EXC_ERROR;
2723: END IF;

Line 2862: FROM CSD_REPAIRS

2858:
2859: BEGIN
2860: SELECT original_source_header_id, original_source_reference
2861: INTO l_org_src_header_id, l_org_src_ref
2862: FROM CSD_REPAIRS
2863: WHERE repair_line_id = p_repair_line_id;
2864: EXCEPTION
2865: WHEN NO_DATA_FOUND THEN
2866: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');

Line 3000: FROM cs_incidents_all_b cia, CSD_REPAIRS cr

2996:
2997: BEGIN
2998: SELECT cia.incident_id, cia.customer_id, cia.account_id
2999: INTO l_incident_id, l_party_id, l_account_id
3000: FROM cs_incidents_all_b cia, CSD_REPAIRS cr
3001: WHERE cia.incident_id = cr.incident_id
3002: AND cr.repair_line_id = p_repair_line_id;
3003: EXCEPTION
3004: WHEN NO_DATA_FOUND THEN

Line 3228: FROM CSD_REPAIRS

3224:
3225: --bug#11902612
3226: CURSOR c_default_po(p_repair_line_id NUMBER) IS
3227: SELECT default_po_num
3228: FROM CSD_REPAIRS
3229: WHERE repair_line_id = p_repair_line_id;
3230: --bug#11902612
3231:
3232: BEGIN

Line 4617: CSD_REPAIRS repairs

4613: FROM cs_kb_set_links SetLinkTG, --link to task group
4614: cs_kb_set_links SetLinkRO, -- link to repair order
4615: cs_kb_sets_vl KBSets,
4616: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4617: CSD_REPAIRS repairs
4618: WHERE SetLinkRO.other_id = p_repair_line_id
4619: AND SetLinkRO.object_code = 'DR'
4620: AND SetLinkRO.link_type = 'S'
4621: AND SetLinkTG.set_id = SetLinkRO.set_id

Line 6915: Csd_Repairs_Grp.UPDATE_APPROVAL_STATUS(p_repair_line_id => l_estimate_hdr_rec.repair_line_id,

6911: l_estimate_hdr_rec.estimate_reason_code || ']');
6912: RAISE Fnd_Api.G_EXC_ERROR;
6913: END IF;
6914:
6915: Csd_Repairs_Grp.UPDATE_APPROVAL_STATUS(p_repair_line_id => l_estimate_hdr_rec.repair_line_id,
6916: p_new_approval_status => l_approval_Status,
6917: p_old_approval_status => NULL,
6918: p_quantity => l_estimate_hdr_rec.repair_line_quantity,
6919: p_org_contact_id => NULL,

Line 7361: Csd_Repairs_Grp.UPDATE_APPROVAL_STATUS(p_repair_line_id => l_estimate_hdr_rec.repair_line_id,

7357: l_estimate_hdr_rec.estimate_reason_code || ']');
7358: RAISE Fnd_Api.G_EXC_ERROR;
7359: END IF;
7360:
7361: Csd_Repairs_Grp.UPDATE_APPROVAL_STATUS(p_repair_line_id => l_estimate_hdr_rec.repair_line_id,
7362: p_new_approval_status => l_approval_Status,
7363: p_old_approval_status => NULL,
7364: p_quantity => l_estimate_hdr_rec.repair_line_quantity,
7365: p_org_contact_id => NULL,

Line 7551: l_default_po_number csd_repairs.default_po_num%type; -- po number from RO should be defaulted

7547: -- Stores default contract and pricelist info.
7548: l_default_contract_line_id NUMBER := NULL;
7549: l_default_price_list_hdr_id NUMBER := NULL;
7550:
7551: l_default_po_number csd_repairs.default_po_num%type; -- po number from RO should be defaulted
7552:
7553: -- Keeps the count of WIP jobs
7554: l_wip_count NUMBER := 0;
7555:

Line 8413: from csd_repairs

8409: -- PO number from RO should be defaulted on estimate lines created from WIP.
8410: begin
8411: select default_po_num
8412: into l_default_po_number
8413: from csd_repairs
8414: where repair_line_id = p_repair_line_id;
8415: exception
8416: when no_data_found then
8417: l_default_po_number := Null;