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_MASS_RCV_PVT dependencies on CSD_REPAIRS

Line 60: l_repair_order_tbl csd_repairs_pub.repln_tbl_type;

56: l_api_name CONSTANT VARCHAR2 (30) := 'MASS_CREATE_RO';
57: l_return_status VARCHAR2 (1);
58: l_msg_count NUMBER;
59: l_msg_data VARCHAR2 (2000);
60: l_repair_order_tbl csd_repairs_pub.repln_tbl_type;
61: l_prod_txn_tbl csd_process_pvt.product_txn_tbl;
62: l_incident_id NUMBER;
63: l_count_sn NUMBER;
64: l_ro_qty NUMBER;

Line 88: FROM csd_repairs

84:
85: CURSOR cur_repair_order( p_repln_id NUMBER)
86: IS
87: SELECT inventory_item_id, status, quantity
88: FROM csd_repairs
89: WHERE repair_line_id = p_repln_id;
90:
91: BEGIN
92:

Line 290: csd_repairs_pvt.copy_attachments

286: || ']'
287: );
288: END IF;
289: l_count_sn_success := l_count_sn_success + 1;
290: csd_repairs_pvt.copy_attachments
291: (p_api_version => 1.0,
292: p_commit => fnd_api.g_false,
293: p_init_msg_list => fnd_api.g_false,
294: p_validation_level => fnd_api.g_valid_level_full,

Line 387: csd_repairs_pvt.copy_attachments

383: --Insert a record in CSD_MASS_RO_SN_ERRORS with the error message.
384: IF (l_return_status = fnd_api.g_ret_sts_success)
385: THEN
386: l_count_sn_success := l_count_sn_success + 1;
387: csd_repairs_pvt.copy_attachments
388: (p_api_version => 1.0,
389: p_commit => fnd_api.g_false,
390: p_init_msg_list => fnd_api.g_false,
391: p_validation_level => fnd_api.g_valid_level_full,

Line 444: --Delete record from CSD_REPAIRS for the input p_repair_order_line_id.

440:
441:
442:
443:
444: --Delete record from CSD_REPAIRS for the input p_repair_order_line_id.
445: IF (l_event_level >= l_debug_level)
446: THEN
447: fnd_log.STRING (l_event_level,
448: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',

Line 467: csd_repairs_pvt.delete_repair_order

463: 'deleting the draft repair order'
464: );
465: END IF;
466:
467: csd_repairs_pvt.delete_repair_order
468: (p_api_version_number => 1.0,
469: p_init_msg_list => fnd_api.g_false,
470: p_commit => fnd_api.g_false,
471: p_validation_level => fnd_api.g_valid_level_full,

Line 484: 'Updating the CSD_REPAIRS table quantity'

480: IF (l_event_level >= l_debug_level)
481: THEN
482: fnd_log.STRING (l_event_level,
483: 'CSD.PLSQL.CSD_MASS_RCV_PVT.MASS_CREATE_RO',
484: 'Updating the CSD_REPAIRS table quantity'
485: );
486: END IF;
487:
488: UPDATE csd_repairs

Line 488: UPDATE csd_repairs

484: 'Updating the CSD_REPAIRS table quantity'
485: );
486: END IF;
487:
488: UPDATE csd_repairs
489: SET quantity = quantity - l_count_sn_success,
490: last_update_date = SYSDATE,
491: last_update_login = fnd_global.login_id,
492: last_updated_by = fnd_global.user_id

Line 596: l_repair_order_rec csd_repairs_pub.repln_rec_type;

592: l_repair_number VARCHAR2 (30);
593: l_repair_type_ref VARCHAR2 (30);
594: l_product_txn_rec csd_process_pvt.product_txn_rec;
595: c_refurbishment_type_ref CONSTANT VARCHAR2 (30) := 'RF';
596: l_repair_order_rec csd_repairs_pub.repln_rec_type;
597:
598: -- swai: 12.1.1 bug 7176940 service bulletin check
599: l_ro_sc_ids_tbl CSD_RO_BULLETINS_PVT.CSD_RO_SC_IDS_TBL_TYPE;
600:

Line 634: FROM csd_repairs

630: attribute16,attribute17,attribute18, -- bug#7497907, 12.1 FP, subhat
631: attribute19,attribute20,attribute21,attribute22,attribute23,
632: attribute24,attribute25,attribute26,attribute27,attribute28,attribute29,
633: attribute30
634: FROM csd_repairs
635: WHERE repair_line_id = p_repln_id;
636:
637: BEGIN
638: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 814: '------------------Calling csd_repairs_pvt.create_repair_order'

810: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
811: THEN
812: fnd_log.STRING (fnd_log.level_event,
813: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
814: '------------------Calling csd_repairs_pvt.create_repair_order'
815: );
816: END IF;
817:
818: csd_repairs_pvt.create_repair_order

Line 818: csd_repairs_pvt.create_repair_order

814: '------------------Calling csd_repairs_pvt.create_repair_order'
815: );
816: END IF;
817:
818: csd_repairs_pvt.create_repair_order
819: (p_api_version_number => 1.0,
820: p_commit => fnd_api.g_false,
821: p_init_msg_list => fnd_api.g_false,
822: p_validation_level => p_validation_level,

Line 1108: FROM csd_repairs

1104: CURSOR cur_ro_details (p_repair_line_id NUMBER)
1105: IS
1106: SELECT incident_id, original_source_reference,
1107: original_source_header_id, original_source_line_id
1108: FROM csd_repairs
1109: WHERE repair_line_id = p_repair_line_id;
1110:
1111: CURSOR cur_pricelist_details (p_price_list_id NUMBER)
1112: IS

Line 1150: FROM csd_repairs cr,

1146:
1147: CURSOR cur_order_header (p_incident_id NUMBER)
1148: IS
1149: SELECT MAX (ced.order_header_id)
1150: FROM csd_repairs cr,
1151: csd_product_transactions cpt,
1152: cs_estimate_details ced
1153: WHERE cr.incident_id = p_incident_id
1154: AND cpt.repair_line_id = cr.repair_line_id

Line 1276: -- Get service request from csd_repairs table

1272:
1273: --Check if the input business_process_id is valid and if it is invalid get the business_process_id from the repair_type.
1274: --Set error if the business process is invalid.
1275:
1276: -- Get service request from csd_repairs table
1277: -- using repair order
1278: OPEN cur_ro_details (p_product_txn_rec.repair_line_id);
1279:
1280: FETCH cur_ro_details

Line 1861: --Update the status in CSD_PRODUCT_TXNS table and CSD_REPAIRS table. If the

1857: END IF;
1858:
1859: -- THis api will interface and book the charge line
1860: ------------------------------------------------------------------------------------
1861: --Update the status in CSD_PRODUCT_TXNS table and CSD_REPAIRS table. If the
1862: --interface_to_oe_flag is 'Y' and book_order_flag is 'Y' then --set the
1863: --prod_txn_status to 'BOOKED' and ro_txn_status to 'OM_BOOKED'. If
1864: --interface_to_oe_flag is 'Y' and book_order_flag is 'N' set
1865: --the prod_txn_status to 'SUBMITTED' and ro_txn_status to 'OM_SUBMITTED'. If

Line 1997: UPDATE csd_repairs

1993: 'Updating repair status[' || l_ro_txn_status || ']'
1994: );
1995: END IF;
1996:
1997: UPDATE csd_repairs
1998: SET ro_txn_status = l_ro_txn_status
1999: WHERE repair_line_id = p_product_txn_rec.repair_line_id;
2000:
2001: IF SQL%NOTFOUND

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

2480: 'Validate repair line id'
2481: );
2482: END IF;
2483:
2484: -- Validate the repair line ID if it exists in csd_repairs
2485: IF NOT (csd_process_util.validate_rep_line_id
2486: (p_repair_line_id => p_product_txn_rec.repair_line_id)
2487: )
2488: THEN