APPS.CSD_LOGISTICS_UTIL dependencies on CSD_REPAIRS

Line 1195: FROM cs_incidents_b_sec sr, csd_repairs dra

1191:
1192: -- Define a cursor that gets customer_id AND currency_Code for a given repair_line_Id
1193: CURSOR RO_Cur_Type(p_Repair_Line_Id NUMBER) IS
1194: SELECT sr.Customer_Id, dra.Currency_Code
1195: FROM cs_incidents_b_sec sr, csd_repairs dra
1196: WHERE dra.incident_id = sr.incident_id and dra.Repair_Line_Id = p_Repair_Line_Id;
1197:
1198: -- Define SR Cursor Type
1199: CURSOR SR_Cur_Type(p_Incident_id NUMBER) IS

Line 2059: FROM CSD_REPAIRS

2055: -- Get the incident Id for the repair line
2056: BEGIN
2057: SELECT incident_id
2058: INTO l_incident_id
2059: FROM CSD_REPAIRS
2060: WHERE repair_line_id = p_repair_line_id;
2061: EXCEPTION
2062: WHEN OTHERS THEN
2063: Fnd_Message.SET_NAME('CSD', 'CSD_INV_REP_LINE_ID');

Line 2653: FROM cs_incidents_all_b cs, csd_repairs csd

2649:
2650: -- swai: bug 6001057
2651: CURSOR sr_account_cu (l_repair_line_id NUMBER) is
2652: SELECT account_id
2653: FROM cs_incidents_all_b cs, csd_repairs csd
2654: WHERE cs.incident_id = csd.incident_id
2655: AND repair_line_id = l_repair_line_id;
2656:
2657:

Line 2810: UPDATE CSD_REPAIRS

2806: Fnd_Msg_Pub.ADD;
2807: RAISE CREATE_ORDER;
2808: END IF;
2809:
2810: UPDATE CSD_REPAIRS
2811: SET ro_txn_status = 'OM_SUBMITTED'
2812: WHERE repair_line_id =
2813: p_product_txn_rec.REPAIR_LINE_ID;
2814: IF SQL%NOTFOUND

Line 2970: FROM cs_incidents_all_b cs, csd_repairs csd

2966:
2967: -- swai: bug 6001057
2968: CURSOR sr_account_cu (l_repair_line_id NUMBER) is
2969: SELECT account_id
2970: FROM cs_incidents_all_b cs, csd_repairs csd
2971: WHERE cs.incident_id = csd.incident_id
2972: AND repair_line_id = l_repair_line_id;
2973:
2974: BEGIN

Line 3201: UPDATE CSD_REPAIRS

3197: -- Fix for bug#4020651
3198: Csd_Update_Programs_Pvt.prod_txn_status_upd(p_repair_line_id => p_product_txn_rec.repair_line_id,
3199: p_commit => Fnd_Api.g_false);
3200:
3201: UPDATE CSD_REPAIRS
3202: SET ro_txn_status = 'OM_BOOKED'
3203: WHERE repair_line_id =
3204: p_product_txn_rec.REPAIR_LINE_ID;
3205: IF SQL%NOTFOUND

Line 3237: UPDATE CSD_REPAIRS

3233: -- Fix for bug#4020651
3234: Csd_Update_Programs_Pvt.prod_txn_status_upd(p_repair_line_id => p_product_txn_rec.repair_line_id,
3235: p_commit => Fnd_Api.g_false);
3236:
3237: UPDATE CSD_REPAIRS
3238: SET ro_txn_status = 'OM_BOOKED'
3239: WHERE repair_line_id =
3240: p_product_txn_rec.REPAIR_LINE_ID;
3241: IF SQL%NOTFOUND

Line 3633: UPDATE CSD_REPAIRS

3629: RAISE RELEASE_ORDER;
3630: END IF;
3631: END IF;
3632:
3633: UPDATE CSD_REPAIRS
3634: SET ro_txn_status = 'OM_RELEASED'
3635: WHERE repair_line_id =
3636: p_product_txn_rec.REPAIR_LINE_ID;
3637: IF SQL%NOTFOUND

Line 3819: UPDATE CSD_REPAIRS

3815: RAISE SHIP_ORDER;
3816: END IF;
3817: END IF;
3818:
3819: UPDATE CSD_REPAIRS
3820: SET ro_txn_status = 'OM_SHIPPED'
3821: WHERE repair_line_id =
3822: p_product_txn_rec.REPAIR_LINE_ID;
3823: IF SQL%NOTFOUND

Line 3855: UPDATE CSD_REPAIRS

3851: RAISE SHIP_ORDER;
3852: END IF;
3853: END IF;
3854:
3855: UPDATE CSD_REPAIRS
3856: SET ro_txn_status = 'OM_SHIPPED'
3857: WHERE repair_line_id =
3858: p_product_txn_rec.REPAIR_LINE_ID;
3859: IF SQL%NOTFOUND

Line 3891: UPDATE CSD_REPAIRS

3887: RAISE SHIP_ORDER;
3888: END IF;
3889: END IF;
3890:
3891: UPDATE CSD_REPAIRS
3892: SET ro_txn_status = 'OM_BOOKED'
3893: WHERE repair_line_id =
3894: p_product_txn_rec.REPAIR_LINE_ID;
3895: IF SQL%NOTFOUND