[Home] [Help]
153: BEGIN
154:
155: select 'X'
156: into l_dummy
157: from cs_incidents_all_b
158: where incident_id = p_incident_id;
159: -- swai: bug 7273784 - start_date_active and end_date_active
160: -- are obsoleted by service team
161: -- and sysdate between nvl(start_date_active,sysdate)
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:
3967: RETURN l_org_id;
4115:
4116: -- Forward port bug# 2756313
4117: /* select b.business_process_id
4118: into l_bus_process_id
4119: from cs_incidents_all_b a,
4120: cs_incident_types_b b
4121: where a.incident_type_id = b.incident_type_id
4122: and a.incident_id = p_incident_id;
4123: */
4278: decode(ship_to_site_id,p_prod_txn_rec.ship_to_org_id,ship_to_contact_id)
4279: into
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
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
6121: where dr.repair_line_id = p_repair_line_id
6122: and ced.incident_id = dr.incident_id
6123: and ced.order_header_id is not null
6124: and ooh.open_flag = 'Y'
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
6156: where dr.repair_line_id = p_repair_line_id
6157: and ced.incident_id = dr.incident_id
6158: and ced.order_header_id is not null
6159: and ooh.open_flag = 'Y'