DBA Data[Home] [Help]

APPS.CSD_MIGRATE_FROM_115X_PKG3 dependencies on CSD_REPAIR_ACTUAL_LINES

Line 180: FROM csd_repair_actual_lines cral

176: AND ced.order_line_id is null
177: AND ced.original_source_code = 'DR'
178: AND ced.source_code = 'DR'
179: AND NOT EXISTS ( SELECT 'x'
180: FROM csd_repair_actual_lines cral
181: WHERE cral.estimate_detail_id = cr.estimate_detail_id)
182: AND ced.estimate_detail_id >= p_start_est_det_id
183: AND ced.estimate_detail_id <= p_end_est_det_id;
184: */

Line 201: FROM csd_repair_actual_lines cral

197: AND ced.order_line_id is null
198: AND ced.original_source_code = 'DR'
199: AND ced.source_code = 'DR'
200: AND NOT EXISTS ( SELECT 'x'
201: FROM csd_repair_actual_lines cral
202: WHERE cral.estimate_detail_id = crel.estimate_detail_id)
203: AND cr.repair_line_id >= p_start_rep_line_id
204: AND cr.repair_line_id <= p_end_rep_line_id;
205: -- gilam: end bug fix 3410303 - changed query

Line 965: FROM csd_repair_actual_lines cral

961: AND ced.order_line_id is not null
962: AND ced.original_source_code = 'DR'
963: AND ced.source_code = 'DR'
964: AND NOT EXISTS ( SELECT 'x'
965: FROM csd_repair_actual_lines cral
966: WHERE cral.estimate_detail_id = cr.estimate_detail_id)
967: AND ced.estimate_detail_id >= p_start_est_det_id
968: AND ced.estimate_detail_id <= p_end_est_det_id;
969: */

Line 1204: FROM csd_repair_actual_lines cral

1200: AND ced.order_line_id is not null
1201: AND ced.original_source_code = 'DR'
1202: AND ced.source_code = 'DR'
1203: AND NOT EXISTS ( SELECT 'x'
1204: FROM csd_repair_actual_lines cral
1205: WHERE cral.estimate_detail_id = crel.estimate_detail_id)
1206: AND cr.repair_line_id >= p_start_rep_line_id
1207: AND cr.repair_line_id <= p_end_rep_line_id;
1208: -- gilam: end bug fix 3410303 - changed query

Line 1734: -- insert the record into CSD_REPAIR_ACTUAL_LINES

1730:
1731: BEGIN
1732:
1733: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to
1734: -- insert the record into CSD_REPAIR_ACTUAL_LINES
1735: -- this is Depot Actual line created from the Estimate line
1736:
1737: -- gilam: clear out actual line id when creating new row
1738: x_actual_line_id := null;

Line 1742: CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(

1738: x_actual_line_id := null;
1739:
1740: -- gilam: changed actual source code to ESTIMATE and
1741: -- actual source id to repair estimate line id
1742: CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(
1743: px_REPAIR_ACTUAL_LINE_ID => x_actual_line_id
1744: ,p_OBJECT_VERSION_NUMBER => 1
1745: ,p_ESTIMATE_DETAIL_ID => l_old_est_detail_id
1746: ,p_REPAIR_ACTUAL_ID => l_actual_id

Line 1804: || 'CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row Failed - For Estimate Detail Id:'

1800:
1801: EXCEPTION
1802: WHEN OTHERS THEN
1803: v_error_text := substr(sqlerrm, 1, 1000)
1804: || 'CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row Failed - For Estimate Detail Id:'
1805: || l_old_est_detail_id
1806: || ' Loop for Estimate Detail Id: '
1807: || v_ESTIMATE_DETAIL_ID(j);
1808: RAISE error_process;

Line 2112: -- insert the record into CSD_REPAIR_ACTUAL_LINES

2108:
2109: BEGIN
2110:
2111: -- Call table handler CSD_REPAIR_ACTUALS_LINES_PKG.Insert_Row to
2112: -- insert the record into CSD_REPAIR_ACTUAL_LINES
2113: -- this is Depot Actual line created from the Estimate line
2114:
2115: -- gilam: clear out actual line id when creating new row
2116: x_actual_line_id := null;

Line 2120: CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(

2116: x_actual_line_id := null;
2117:
2118: -- gilam: changed actual source code to ESTIMATE and
2119: -- actual source id to repair estimate line id
2120: CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row(
2121: px_REPAIR_ACTUAL_LINE_ID => x_actual_line_id
2122: ,p_OBJECT_VERSION_NUMBER => 1
2123: ,p_ESTIMATE_DETAIL_ID => l_old_est_detail_id
2124: ,p_REPAIR_ACTUAL_ID => l_actual_id

Line 2182: || 'CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row Failed - For Estimate Detail Id:'

2178:
2179: EXCEPTION
2180: WHEN OTHERS THEN
2181: v_error_text := substr(sqlerrm, 1, 1000)
2182: || 'CSD_REPAIR_ACTUAL_LINES_PKG.Insert_Row Failed - For Estimate Detail Id:'
2183: || l_old_est_detail_id
2184: || ' Loop for Estimate Detail Id: '
2185: || est_det_arr(j).estimate_detail_id;
2186: RAISE error_process;