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 633: FROM csd_repairs

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

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

804: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
805: THEN
806: fnd_log.STRING (fnd_log.level_event,
807: 'CSD.PLSQL.CSD_MASS_RCV_PVT.Process_RO',
808: '------------------Calling csd_repairs_pvt.create_repair_order'
809: );
810: END IF;
811:
812: csd_repairs_pvt.create_repair_order

Line 812: csd_repairs_pvt.create_repair_order

808: '------------------Calling csd_repairs_pvt.create_repair_order'
809: );
810: END IF;
811:
812: csd_repairs_pvt.create_repair_order
813: (p_api_version_number => 1.0,
814: p_commit => fnd_api.g_false,
815: p_init_msg_list => fnd_api.g_false,
816: p_validation_level => p_validation_level,

Line 1102: FROM csd_repairs

1098: CURSOR cur_ro_details (p_repair_line_id NUMBER)
1099: IS
1100: SELECT incident_id, original_source_reference,
1101: original_source_header_id, original_source_line_id
1102: FROM csd_repairs
1103: WHERE repair_line_id = p_repair_line_id;
1104:
1105: CURSOR cur_pricelist_details (p_price_list_id NUMBER)
1106: IS

Line 1144: FROM csd_repairs cr,

1140:
1141: CURSOR cur_order_header (p_incident_id NUMBER)
1142: IS
1143: SELECT MAX (ced.order_header_id)
1144: FROM csd_repairs cr,
1145: csd_product_transactions cpt,
1146: cs_estimate_details ced
1147: WHERE cr.incident_id = p_incident_id
1148: AND cpt.repair_line_id = cr.repair_line_id

Line 1270: -- Get service request from csd_repairs table

1266:
1267: --Check if the input business_process_id is valid and if it is invalid get the business_process_id from the repair_type.
1268: --Set error if the business process is invalid.
1269:
1270: -- Get service request from csd_repairs table
1271: -- using repair order
1272: OPEN cur_ro_details (p_product_txn_rec.repair_line_id);
1273:
1274: FETCH cur_ro_details

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

1851: END IF;
1852:
1853: -- THis api will interface and book the charge line
1854: ------------------------------------------------------------------------------------
1855: --Update the status in CSD_PRODUCT_TXNS table and CSD_REPAIRS table. If the
1856: --interface_to_oe_flag is 'Y' and book_order_flag is 'Y' then --set the
1857: --prod_txn_status to 'BOOKED' and ro_txn_status to 'OM_BOOKED'. If
1858: --interface_to_oe_flag is 'Y' and book_order_flag is 'N' set
1859: --the prod_txn_status to 'SUBMITTED' and ro_txn_status to 'OM_SUBMITTED'. If

Line 1991: UPDATE csd_repairs

1987: 'Updating repair status[' || l_ro_txn_status || ']'
1988: );
1989: END IF;
1990:
1991: UPDATE csd_repairs
1992: SET ro_txn_status = l_ro_txn_status
1993: WHERE repair_line_id = p_product_txn_rec.repair_line_id;
1994:
1995: IF SQL%NOTFOUND

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

2463: 'Validate repair line id'
2464: );
2465: END IF;
2466:
2467: -- Validate the repair line ID if it exists in csd_repairs
2468: IF NOT (csd_process_util.validate_rep_line_id
2469: (p_repair_line_id => p_product_txn_rec.repair_line_id)
2470: )
2471: THEN