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 2963: FROM cs_incidents_all_b cs, csd_repairs csd

2959:
2960: -- swai: bug 6001057
2961: CURSOR sr_account_cu (l_repair_line_id NUMBER) is
2962: SELECT account_id
2963: FROM cs_incidents_all_b cs, csd_repairs csd
2964: WHERE cs.incident_id = csd.incident_id
2965: AND repair_line_id = l_repair_line_id;
2966:
2967: BEGIN

Line 3187: UPDATE CSD_REPAIRS

3183: -- Fix for bug#4020651
3184: Csd_Update_Programs_Pvt.prod_txn_status_upd(p_repair_line_id => p_product_txn_rec.repair_line_id,
3185: p_commit => Fnd_Api.g_false);
3186:
3187: UPDATE CSD_REPAIRS
3188: SET ro_txn_status = 'OM_BOOKED'
3189: WHERE repair_line_id =
3190: p_product_txn_rec.REPAIR_LINE_ID;
3191: IF SQL%NOTFOUND

Line 3223: UPDATE CSD_REPAIRS

3219: -- Fix for bug#4020651
3220: Csd_Update_Programs_Pvt.prod_txn_status_upd(p_repair_line_id => p_product_txn_rec.repair_line_id,
3221: p_commit => Fnd_Api.g_false);
3222:
3223: UPDATE CSD_REPAIRS
3224: SET ro_txn_status = 'OM_BOOKED'
3225: WHERE repair_line_id =
3226: p_product_txn_rec.REPAIR_LINE_ID;
3227: IF SQL%NOTFOUND

Line 3619: UPDATE CSD_REPAIRS

3615: RAISE RELEASE_ORDER;
3616: END IF;
3617: END IF;
3618:
3619: UPDATE CSD_REPAIRS
3620: SET ro_txn_status = 'OM_RELEASED'
3621: WHERE repair_line_id =
3622: p_product_txn_rec.REPAIR_LINE_ID;
3623: IF SQL%NOTFOUND

Line 3805: UPDATE CSD_REPAIRS

3801: RAISE SHIP_ORDER;
3802: END IF;
3803: END IF;
3804:
3805: UPDATE CSD_REPAIRS
3806: SET ro_txn_status = 'OM_SHIPPED'
3807: WHERE repair_line_id =
3808: p_product_txn_rec.REPAIR_LINE_ID;
3809: IF SQL%NOTFOUND

Line 3841: UPDATE CSD_REPAIRS

3837: RAISE SHIP_ORDER;
3838: END IF;
3839: END IF;
3840:
3841: UPDATE CSD_REPAIRS
3842: SET ro_txn_status = 'OM_SHIPPED'
3843: WHERE repair_line_id =
3844: p_product_txn_rec.REPAIR_LINE_ID;
3845: IF SQL%NOTFOUND

Line 3877: UPDATE CSD_REPAIRS

3873: RAISE SHIP_ORDER;
3874: END IF;
3875: END IF;
3876:
3877: UPDATE CSD_REPAIRS
3878: SET ro_txn_status = 'OM_BOOKED'
3879: WHERE repair_line_id =
3880: p_product_txn_rec.REPAIR_LINE_ID;
3881: IF SQL%NOTFOUND