[Home] [Help]
367: INTO l_repair_group_id, l_group_quantity, l_group_ovn
368: FROM CSD_REPAIR_ORDER_GROUPS grp
369: WHERE EXISTS
370: (SELECT 'x'
371: FROM CSD_REPAIRS rep
372: WHERE rep.repair_group_id = grp.repair_group_id
373: AND rep.repair_line_id = p_repair_line_id);
374:
375: EXCEPTION
397:
398: BEGIN
399: SELECT COUNT(*)
400: INTO l_tot_approved
401: FROM CSD_REPAIRS
402: WHERE repair_group_id = l_repair_group_id
403: AND approval_status = 'A'
404: AND approval_required_flag = 'Y';
405: EXCEPTION
414:
415: BEGIN
416: SELECT COUNT(*)
417: INTO l_tot_rejected
418: FROM CSD_REPAIRS
419: WHERE repair_group_id = l_repair_group_id
420: AND approval_status = 'R'
421: AND approval_required_flag = 'Y';
422: EXCEPTION
431:
432: BEGIN
433: SELECT COUNT(*)
434: INTO l_tot_no_approval
435: FROM CSD_REPAIRS
436: WHERE repair_group_id = l_repair_group_id
437: AND approval_required_flag = 'N';
438: EXCEPTION
439: WHEN OTHERS THEN
888: CURSOR repair_estimate(p_est_id IN NUMBER) IS
889: SELECT a.repair_estimate_id,
890: a.object_version_number,
891: b.approval_status
892: FROM CSD_REPAIR_ESTIMATE a, CSD_REPAIRS b
893: WHERE a.repair_line_id = b.repair_line_id
894: AND a.repair_estimate_id = p_est_id;
895:
896: BEGIN
1208:
1209: BEGIN
1210: SELECT b.approval_status
1211: INTO l_approval_status
1212: FROM CSD_REPAIR_ESTIMATE a, CSD_REPAIRS b
1213: WHERE a.repair_line_id = b.repair_line_id
1214: AND a.repair_estimate_id = p_estimate_id;
1215: EXCEPTION
1216: WHEN NO_DATA_FOUND THEN
1535: -- Get the service request
1536: BEGIN
1537: SELECT incident_id
1538: INTO l_incident_id
1539: FROM CSD_REPAIRS
1540: WHERE repair_line_id = x_estimate_line_rec.repair_line_id;
1541: EXCEPTION
1542: WHEN NO_DATA_FOUND THEN
1543: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
2704: CLOSE get_default_template_name;
2705: -- no default tempalte defined, raise error
2706: IF (l_template_code is null) THEN
2707: Fnd_Message.SET_NAME('CSD', 'CSD_XDO_ESTRT_NO_TEMPLATE');
2708: Fnd_Message.SET_TOKEN('PROF_NAME', csd_repairs_util.get_user_profile_option_name('CSD_CUST_ESTRT_CON_NAME'));
2709: x_request_id := l_request_id;
2710: Fnd_Msg_Pub.ADD;
2711: RAISE Fnd_Api.G_EXC_ERROR;
2712: END IF;
2847:
2848: BEGIN
2849: SELECT original_source_header_id, original_source_reference
2850: INTO l_org_src_header_id, l_org_src_ref
2851: FROM CSD_REPAIRS
2852: WHERE repair_line_id = p_repair_line_id;
2853: EXCEPTION
2854: WHEN NO_DATA_FOUND THEN
2855: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
2985:
2986: BEGIN
2987: SELECT cia.incident_id, cia.customer_id, cia.account_id
2988: INTO l_incident_id, l_party_id, l_account_id
2989: FROM cs_incidents_all_b cia, CSD_REPAIRS cr
2990: WHERE cia.incident_id = cr.incident_id
2991: AND cr.repair_line_id = p_repair_line_id;
2992: EXCEPTION
2993: WHEN NO_DATA_FOUND THEN
4579: FROM cs_kb_set_links SetLinkTG, --link to task group
4580: cs_kb_set_links SetLinkRO, -- link to repair order
4581: cs_kb_sets_vl KBSets,
4582: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4583: CSD_REPAIRS repairs
4584: WHERE SetLinkRO.other_id = p_repair_line_id
4585: AND SetLinkRO.object_code = 'DR'
4586: AND SetLinkRO.link_type = 'S'
4587: AND SetLinkTG.set_id = SetLinkRO.set_id
6877: l_estimate_hdr_rec.estimate_reason_code || ']');
6878: RAISE Fnd_Api.G_EXC_ERROR;
6879: END IF;
6880:
6881: Csd_Repairs_Grp.UPDATE_APPROVAL_STATUS(p_repair_line_id => l_estimate_hdr_rec.repair_line_id,
6882: p_new_approval_status => l_approval_Status,
6883: p_old_approval_status => NULL,
6884: p_quantity => l_estimate_hdr_rec.repair_line_quantity,
6885: p_org_contact_id => NULL,
7303: l_estimate_hdr_rec.estimate_reason_code || ']');
7304: RAISE Fnd_Api.G_EXC_ERROR;
7305: END IF;
7306:
7307: Csd_Repairs_Grp.UPDATE_APPROVAL_STATUS(p_repair_line_id => l_estimate_hdr_rec.repair_line_id,
7308: p_new_approval_status => l_approval_Status,
7309: p_old_approval_status => NULL,
7310: p_quantity => l_estimate_hdr_rec.repair_line_quantity,
7311: p_org_contact_id => NULL,