eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_PROCESS_PVT dependencies on CSD_REPAIRS

Line 895: FROM csd_repairs cr,

891: SELECT cr.serial_number,
892: wdd.delivery_detail_id,
893: wdd.requested_quantity,
894: mtl.serial_number_control_code
895: FROM csd_repairs cr,
896: mtl_system_items_b mtl,
897: cs_estimate_details ced,
898: wsh_delivery_details wdd,
899: --Changed to view from table, bug: 4341784

Line 2427: FROM cs_incidents_all_b cs, csd_repairs csd

2423:
2424: -- swai: bug 6001057
2425: CURSOR sr_account_cu (l_repair_line_id NUMBER) is
2426: SELECT account_id
2427: FROM cs_incidents_all_b cs, csd_repairs csd
2428: WHERE cs.incident_id = csd.incident_id
2429: AND repair_line_id = l_repair_line_id;
2430:
2431: --R12 Development Changes Begin

Line 2551: -- Validate the repair line ID if it exists in csd_repairs

2547: p_api_name => l_api_name);
2548:
2549: Debug('Validate repair line id', l_mod_name, 1);
2550:
2551: -- Validate the repair line ID if it exists in csd_repairs
2552: IF NOT
2553: (Csd_Process_Util.Validate_rep_line_id(p_repair_line_id => x_product_txn_rec.repair_line_id))
2554: THEN
2555: RAISE Fnd_Api.G_EXC_ERROR;

Line 2641: -- Get service request from csd_repairs table

2637: RAISE Fnd_Api.G_EXC_ERROR;
2638: END;
2639: END IF;
2640:
2641: -- Get service request from csd_repairs table
2642: -- using repair order
2643: BEGIN
2644: SELECT incident_id,
2645: original_source_reference,

Line 2652: FROM csd_repairs

2648: INTO l_incident_id,
2649: l_orig_src_reference,
2650: l_orig_src_header_id,
2651: l_orig_src_line_id
2652: FROM csd_repairs
2653: WHERE repair_line_id = x_product_txn_rec.repair_line_id;
2654: EXCEPTION
2655: WHEN OTHERS THEN
2656: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');

Line 3099: UPDATE csd_repairs

3095: x_product_txn_rec.PRODUCT_TRANSACTION_ID,
3096: l_mod_name,
3097: 1);
3098:
3099: UPDATE csd_repairs
3100: SET ro_txn_status = 'CHARGE_ENTERED'
3101: WHERE repair_line_id = x_product_txn_rec.REPAIR_LINE_ID;
3102: IF SQL%NOTFOUND
3103: THEN

Line 3228: UPDATE csd_repairs

3224: Fnd_Msg_Pub.ADD;
3225: RAISE CREATE_ORDER;
3226: END IF;
3227:
3228: UPDATE csd_repairs
3229: SET ro_txn_status = 'OM_SUBMITTED'
3230: WHERE repair_line_id =
3231: x_product_txn_rec.REPAIR_LINE_ID;
3232: IF SQL%NOTFOUND

Line 3580: --Update csd_repairs with status

3576: -- Fix for bug#4020651
3577: Csd_Update_Programs_Pvt.prod_txn_status_upd(p_repair_line_id => x_product_txn_rec.repair_line_id,
3578: p_commit => Fnd_Api.g_false);
3579:
3580: --Update csd_repairs with status
3581: UPDATE csd_repairs
3582: SET ro_txn_status = 'OM_BOOKED'
3583: WHERE repair_line_id =
3584: x_product_txn_rec.REPAIR_LINE_ID;

Line 3581: UPDATE csd_repairs

3577: Csd_Update_Programs_Pvt.prod_txn_status_upd(p_repair_line_id => x_product_txn_rec.repair_line_id,
3578: p_commit => Fnd_Api.g_false);
3579:
3580: --Update csd_repairs with status
3581: UPDATE csd_repairs
3582: SET ro_txn_status = 'OM_BOOKED'
3583: WHERE repair_line_id =
3584: x_product_txn_rec.REPAIR_LINE_ID;
3585: IF SQL%NOTFOUND

Line 3835: UPDATE csd_repairs

3831: RAISE RELEASE_ORDER;
3832: END IF;
3833: END IF;
3834:
3835: UPDATE csd_repairs
3836: SET ro_txn_status = 'OM_RELEASED'
3837: WHERE repair_line_id =
3838: x_product_txn_rec.REPAIR_LINE_ID;
3839: IF SQL%NOTFOUND

Line 3870: UPDATE csd_repairs

3866: RAISE RELEASE_ORDER;
3867: END IF;
3868: END IF;
3869:
3870: UPDATE csd_repairs
3871: SET ro_txn_status = 'OM_BOOKED'
3872: WHERE repair_line_id =
3873: x_product_txn_rec.REPAIR_LINE_ID;
3874: IF SQL%NOTFOUND

Line 3976: UPDATE csd_repairs

3972: RAISE SHIP_ORDER;
3973: END IF;
3974: END IF;
3975:
3976: UPDATE csd_repairs
3977: SET ro_txn_status = 'OM_SHIPPED'
3978: WHERE repair_line_id =
3979: x_product_txn_rec.REPAIR_LINE_ID;
3980: IF SQL%NOTFOUND

Line 4033: UPDATE csd_repairs

4029: -- swai: bug 5931926 - 12.0.2 added 3rd party action type
4030: IF (x_product_txn_rec.action_type IN ('RMA', 'WALK_IN_RECEIPT', 'RMA_THIRD_PTY')) AND
4031: (x_product_txn_rec.action_code = 'CUST_PROD')
4032: THEN
4033: UPDATE csd_repairs
4034: SET auto_process_rma = 'N'
4035: WHERE repair_line_id = x_product_txn_rec.repair_line_id;
4036: END IF;
4037: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

Line 4055: UPDATE csd_repairs

4051: -- swai: bug 5931926 - 12.0.2 added 3rd party action type
4052: IF (x_product_txn_rec.action_type IN ('RMA', 'WALK_IN_RECEIPT', 'RMA_THIRD_PTY')) AND
4053: (x_product_txn_rec.action_code = 'CUST_PROD')
4054: THEN
4055: UPDATE csd_repairs
4056: SET auto_process_rma = 'N'
4057: WHERE repair_line_id = x_product_txn_rec.repair_line_id;
4058: END IF;
4059: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

Line 4257: -- Validate the repair line ID if it exists in csd_repairs

4253: THEN
4254: Csd_Gen_Utility_Pvt.ADD('Validate repair line id');
4255: END IF;
4256:
4257: -- Validate the repair line ID if it exists in csd_repairs
4258: IF NOT
4259: (Csd_Process_Util.Validate_rep_line_id(p_repair_line_id => x_product_txn_rec.repair_line_id))
4260: THEN
4261: RAISE Fnd_Api.G_EXC_ERROR;

Line 4342: -- Get service request id from csd_repairs table

4338: RAISE Fnd_Api.G_EXC_ERROR;
4339: END;
4340: END IF;
4341:
4342: -- Get service request id from csd_repairs table
4343: -- using repair order
4344: BEGIN
4345: SELECT incident_id
4346: INTO l_incident_id

Line 4347: FROM csd_repairs

4343: -- using repair order
4344: BEGIN
4345: SELECT incident_id
4346: INTO l_incident_id
4347: FROM csd_repairs
4348: WHERE repair_line_id = x_product_txn_rec.repair_line_id;
4349: EXCEPTION
4350: WHEN OTHERS THEN
4351: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');

Line 4603: UPDATE csd_repairs

4599: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
4600: Csd_Gen_Utility_Pvt.ADD('REPAIR_ORDER_ID =' ||
4601: x_product_txn_rec.repair_line_id);
4602:
4603: UPDATE csd_repairs
4604: SET ro_txn_status = 'OM_SUBMITTED'
4605: WHERE repair_line_id = x_product_txn_rec.REPAIR_LINE_ID;
4606: IF SQL%NOTFOUND
4607: THEN

Line 7333: l_ro_rec Csd_Repairs_Pub.REPLN_Rec_Type;

7329: l_msg_index NUMBER;
7330: l_return_status VARCHAR2(3);
7331: l_validate_flag BOOLEAN;
7332: l_grp_rec Csd_Repair_Groups_Pvt.REPAIR_ORDER_GROUP_REC;
7333: l_ro_rec Csd_Repairs_Pub.REPLN_Rec_Type;
7334: l_open_ro_cnt NUMBER;
7335: l_repair_group_id NUMBER;
7336: l_grp_count NUMBER;
7337: l_status VARCHAR2(10) := 'CLOSED';

Line 7362: FROM csd_repairs

7358: AND crog.incident_id = p_incident_id;
7359:
7360: CURSOR get_ro_order(p_repair_group_id IN NUMBER) IS
7361: SELECT repair_line_id
7362: FROM csd_repairs
7363: WHERE repair_group_id = p_repair_group_id;
7364:
7365: BEGIN
7366: --------------------------------------

Line 7454: FROM csd_repairs

7450:
7451: BEGIN
7452: SELECT object_version_number
7453: INTO l_ro_obj_version_number
7454: FROM csd_repairs
7455: WHERE repair_line_id = ro.repair_line_id;
7456: EXCEPTION
7457: WHEN OTHERS THEN
7458: RAISE Fnd_Api.G_EXC_ERROR;

Line 7470: Csd_Repairs_Pub.Update_Repair_Order(P_Api_Version_Number => 1.0,

7466: Csd_Gen_Utility_Pvt.ADD('Update Repair Line Id =' ||
7467: ro.repair_line_id);
7468: END IF;
7469:
7470: Csd_Repairs_Pub.Update_Repair_Order(P_Api_Version_Number => 1.0,
7471: P_Init_Msg_List => 'T',
7472: P_Commit => 'F',
7473: p_validation_level => 0,
7474: p_REPAIR_LINE_ID => ro.repair_line_id,

Line 7548: FROM csd_repairs

7544:
7545: BEGIN
7546: SELECT object_version_number
7547: INTO l_ro_obj_version_number
7548: FROM csd_repairs
7549: WHERE repair_line_id = ro.repair_line_id;
7550: EXCEPTION
7551: WHEN OTHERS THEN
7552: RAISE Fnd_Api.G_EXC_ERROR;

Line 7564: Csd_Repairs_Pub.Update_Repair_Order(P_Api_Version_Number => 1.0,

7560: Csd_Gen_Utility_Pvt.ADD('Update Repair Line Id =' ||
7561: ro.repair_line_id);
7562: END IF;
7563:
7564: Csd_Repairs_Pub.Update_Repair_Order(P_Api_Version_Number => 1.0,
7565: P_Init_Msg_List => 'T',
7566: P_Commit => 'F',
7567: p_validation_level => 0,
7568: p_REPAIR_LINE_ID => ro.repair_line_id,

Line 7637: FROM csd_repairs

7633: BEGIN
7634:
7635: SELECT COUNT(*)
7636: INTO l_open_ro_cnt
7637: FROM csd_repairs
7638: WHERE incident_id = p_incident_id
7639: AND status <> 'C';
7640:
7641: EXCEPTION

Line 7771: FROM csd_repairs

7767:
7768: BEGIN
7769: SELECT object_version_number
7770: INTO l_ro_obj_version_number
7771: FROM csd_repairs
7772: WHERE repair_line_id = p_repair_line_id;
7773: EXCEPTION
7774: WHEN OTHERS THEN
7775: RAISE Fnd_Api.G_EXC_ERROR;

Line 7782: Csd_Repairs_Pub.Update_Repair_Order(P_Api_Version_Number => 1.0,

7778: l_ro_rec.object_version_number := l_ro_obj_version_number;
7779: l_ro_rec.status := 'C';
7780:
7781: -- Update the Repair Order
7782: Csd_Repairs_Pub.Update_Repair_Order(P_Api_Version_Number => 1.0,
7783: P_Init_Msg_List => 'T',
7784: P_Commit => 'F',
7785: p_validation_level => 0,
7786: p_REPAIR_LINE_ID => p_repair_line_id,

Line 7804: FROM csd_repairs

7800: BEGIN
7801:
7802: SELECT repair_group_id, incident_id
7803: INTO l_repair_group_id, l_incident_id
7804: FROM csd_repairs
7805: WHERE repair_line_id = p_repair_line_id;
7806:
7807: IF (l_repair_group_id IS NOT NULL)
7808: THEN

Line 7811: FROM csd_repairs

7807: IF (l_repair_group_id IS NOT NULL)
7808: THEN
7809: SELECT COUNT(*)
7810: INTO l_grp_count
7811: FROM csd_repairs
7812: WHERE status = 'C'
7813: AND repair_group_id = l_repair_group_id;
7814: END IF;
7815:

Line 7871: FROM csd_repairs

7867: BEGIN
7868:
7869: SELECT COUNT(*)
7870: INTO l_open_ro_cnt
7871: FROM csd_repairs
7872: WHERE incident_id = l_incident_id
7873: AND status <> 'C';
7874:
7875: EXCEPTION

Line 8048: FROM CSD_REPAIRS

8044:
8045: --Cursor to get the count of repair orders for the given SR
8046: CURSOR RO_CUR(p_incident_Id NUMBER) IS
8047: SELECT COUNT(*) ro_count
8048: FROM CSD_REPAIRS
8049: WHERE INCIDENT_ID = p_incident_Id;
8050:
8051: BEGIN
8052:

Line 8575: FROM csd_repairs

8571: -- get the incident id for the repair line
8572: BEGIN
8573: SELECT incident_id
8574: INTO l_incident_id
8575: FROM csd_repairs
8576: WHERE repair_line_id = l_repair_line_id;
8577: EXCEPTION
8578: WHEN NO_DATA_FOUND THEN
8579: Fnd_Message.set_name('CSD', 'CSD_API_INV_REP_LINE_ID');

Line 8831: update csd_repairs

8827: END IF;
8828: /****************************
8829: RO is not udpated as it is does not make sense to update RO record
8830: when ever its product transactions are released. Not applicable to internal ROs.
8831: update csd_repairs
8832: set ro_txn_status = 'OM_RELEASED' ,
8833: object_version_number = Object_Version_Number + 1,
8834: Last_Update_Date = Sysdate,
8835: Last_Updated_By = Fnd_Global.User_Id,

Line 9021: Update csd_repairs

9017: No need to update repairs block when ever its product transaction
9018: line is shipped. One repair order line can have more then one product
9019: transaction line and if we update RO when ever it is released or
9020: shipped then ro_txn_Status will not be of much use.
9021: Update csd_repairs
9022: Set ro_txn_status = 'OM_SHIPPED' ,
9023: object_version_number = Object_Version_Number + 1,
9024: Last_Update_Date = Sysdate,
9025: Last_Updated_By = Fnd_Global.User_Id,

Line 9207: Csd_Gen_Utility_Pvt.ADD('Querying csd_repairs_v view');

9203: END IF;
9204: BEGIN
9205: IF (g_debug > 0)
9206: THEN
9207: Csd_Gen_Utility_Pvt.ADD('Querying csd_repairs_v view');
9208: END IF;
9209: SELECT dra.status,
9210: dra.Quantity,
9211: dra.Inventory_Item_Id,

Line 9221: FROM csd_repairs dra, fnd_lookups fndl2, csd_repair_types_vl drtvl

9217: l_Inventory_Item_id,
9218: l_RO_Repair_Type_Ref,
9219: l_RO_Number,
9220: l_RO_Status_Meaning
9221: FROM csd_repairs dra, fnd_lookups fndl2, csd_repair_types_vl drtvl
9222: WHERE repair_line_id = p_Repair_line_id
9223: and dra.repair_type_id = drtvl.repair_type_id
9224: and dra.status = fndl2.lookup_code
9225: and fndl2.lookup_type = 'CSD_REPAIR_STATUS';

Line 9277: FROM mtl_system_items_vl items, csd_repairs dra

9273: WHEN NO_DATA_FOUND THEN
9274: -- Get Item Name
9275: SELECT items.concatenated_segments
9276: INTO l_Item_Name
9277: FROM mtl_system_items_vl items, csd_repairs dra
9278: WHERE dra.repair_line_id = p_Repair_Line_Id
9279: and dra.inventory_item_id = items.inventory_item_id
9280: and items.organization_id = cs_std.get_item_valdn_orgzn_id;
9281: