[Home] [Help]
521:
522: select
523: incident_id
524: into x_incident_id
525: from csd_repairs
526: where repair_line_id = p_repair_line_id
527: and ((date_closed is null) OR (date_closed > sysdate));
528: EXCEPTION
529: WHEN NO_DATA_FOUND THEN
853: cr.unit_number,
854: crt.third_rma_txn_billing_type_id,
855: crt.third_ship_txn_billing_type_id,
856: crt.third_party_flag
857: FROM csd_repairs cr,
858: csd_repair_types_vl crt
859: where cr.repair_type_id = crt.repair_type_id
860: and cr.repair_line_id = p_rep_line_id;
861:
929:
930: -- yvchen: bug#13582572
931: CURSOR get_lot_number(p_repair_line_id IN NUMBER) IS
932: SELECT lot_number
933: FROM csd_repairs_v
934: WHERE repair_line_id = p_repair_line_id;
935:
936:
937: BEGIN
3794: SELECT
3795: quantity,
3796: customer_product_id,
3797: serial_number
3798: FROM csd_repairs
3799: where repair_line_id = p_rep_line_id;
3800: BEGIN
3801:
3802: FOR l_srl_num_rec in cur_srl_num_dtls(p_Repair_line_id) LOOP
3828: BEGIN
3829:
3830: select 'X'
3831: into l_dummy
3832: from csd_repairs
3833: where repair_line_id = p_repair_line_id;
3834: --bug#6681781, this is not valid validation for repair line id, don't need the last condition
3835: -- and ((date_closed is null) or (trunc(date_closed) >= trunc(sysdate)));
3836:
3958: BEGIN
3959:
3960: select b.org_id
3961: into l_org_id
3962: from csd_repairs a,
3963: cs_incidents_all_b b
3964: where a.incident_id = b.incident_id
3965: and a.repair_line_id = p_repair_line_id;
3966:
4123: */
4124:
4125: select t.business_process_id
4126: into l_bus_process_id
4127: from csd_repairs r,
4128: csd_repair_types_b t
4129: where r.repair_line_id = p_repair_line_id
4130: and r.repair_type_id = t.repair_type_id;
4131:
4280: x_charges_rec.bill_to_contact_id,
4281: x_charges_rec.ship_to_contact_id
4282: from cs_incidents_all_b
4283: where incident_id = decode(p_prod_txn_rec.incident_id,FND_API.G_MISS_NUM,
4284: (select incident_id from csd_repairs where repair_line_id = p_prod_txn_rec.repair_line_id),
4285: p_prod_txn_rec.incident_id );
4286: exception
4287: when no_data_found then
4288: null;
4349: BEGIN
4350:
4351: Select count(*)
4352: into l_rejected_quantity
4353: from csd_repairs
4354: where upper(approval_status) = 'R'
4355: and repair_group_id = p_repair_group_id;
4356:
4357: RETURN l_rejected_quantity;
4402: a.repair_mode,
4403: a.repair_type_id,
4404: b.repair_line_id,
4405: c.quantity_required
4406: FROM csd_repairs a,
4407: csd_product_transactions b,
4408: cs_estimate_details c
4409: where a.repair_line_id = b.repair_line_id
4410: and b.estimate_detail_id = c.estimate_detail_id
4435: INTO l_repair_mode,
4436: l_repair_type_id,
4437: l_repair_line_id,
4438: l_prod_txn_qty
4439: FROM csd_repairs a,
4440: csd_product_transactions b,
4441: cs_estimate_details c
4442: where a.repair_line_id = b.repair_line_id
4443: and b.estimate_detail_id = c.estimate_detail_id
4562:
4563: CURSOR repair_qty IS
4564: SELECT
4565: quantity
4566: FROM csd_repairs
4567: WHERE repair_line_id = p_repair_line_id;
4568:
4569: l_qty_by_type NUMBER := NULL;
4570: l_repair_qty NUMBER := NULL;
4735: BEGIN
4736: RETURN l_sr_rec;
4737: END sr_rec;
4738:
4739: FUNCTION repair_order_rec RETURN csd_repairs_pub.repln_rec_type
4740: IS
4741: l_ro_rec csd_repairs_pub.repln_rec_type;
4742: BEGIN
4743: RETURN l_ro_rec;
4737: END sr_rec;
4738:
4739: FUNCTION repair_order_rec RETURN csd_repairs_pub.repln_rec_type
4740: IS
4741: l_ro_rec csd_repairs_pub.repln_rec_type;
4742: BEGIN
4743: RETURN l_ro_rec;
4744: END repair_order_rec;
4745:
6112: If(p_Action_type = 'RMA') then
6113: begin
6114: Select max(ced.order_header_id)
6115: into l_add_to_order_id
6116: from csd_repairs dr,
6117: cs_estimate_details ced,
6118: oe_order_headers_all ooh,
6119: oe_order_types_v oot,
6120: cs_incidents_all_b sr -- swai: bug 5931926
6147: begin
6148:
6149: Select max(ced.order_header_id)
6150: into l_add_to_order_id
6151: from csd_repairs dr,
6152: cs_estimate_details ced,
6153: oe_order_headers_all ooh,
6154: oe_order_types_v oot,
6155: cs_incidents_all_b sr -- swai: bug 5931926