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_MIGRATE_FROM_115X_PKG3 dependencies on CS_ESTIMATE_DETAILS

Line 34: FROM csd_repair_estimate_lines crel, cs_estimate_details ced

30: FROM csd_repairs cr
31: , csd_repair_estimate cre
32: WHERE cr.repair_line_id = cre.repair_line_id
33: AND EXISTS ( SELECT 'x'
34: FROM csd_repair_estimate_lines crel, cs_estimate_details ced
35: WHERE cre.repair_estimate_id = crel.repair_estimate_id
36: AND crel.estimate_detail_id = ced.estimate_detail_id
37: AND ced.order_line_id is not null)
38: AND NOT EXISTS ( SELECT 'x'

Line 148: /* description : procedure for migrating ESTIMATES data in CS_ESTIMATE_DETAILS */

144:
145:
146: /*-------------------------------------------------------------------------------*/
147: /* procedure name: CSD_CHARGE_ESTIMATE_LINES_MIG3 */
148: /* description : procedure for migrating ESTIMATES data in CS_ESTIMATE_DETAILS */
149: /* table from 11.5.9 to 11.5.10 */
150: /* purpose : Step 1 Data Migration document for Actuals */
151: /* Update all the 1159 not interfaced to OM charge lines in */
152: /* cs_estimate_details table to charge_line_type = ESTIMATE */

Line 152: /* cs_estimate_details table to charge_line_type = ESTIMATE */

148: /* description : procedure for migrating ESTIMATES data in CS_ESTIMATE_DETAILS */
149: /* table from 11.5.9 to 11.5.10 */
150: /* purpose : Step 1 Data Migration document for Actuals */
151: /* Update all the 1159 not interfaced to OM charge lines in */
152: /* cs_estimate_details table to charge_line_type = ESTIMATE */
153: /* from charge_line_type = ACTUAL */
154: /*-------------------------------------------------------------------------------*/
155:
156: PROCEDURE csd_charge_estimate_lines_mig3(p_slab_number IN NUMBER DEFAULT 1)

Line 172: FROM cs_estimate_details ced

168: /*
169: CURSOR get_est_lines(p_start_est_det_id number, p_end_est_det_id number)
170: IS
171: SELECT ced.estimate_detail_id
172: FROM cs_estimate_details ced
173: , csd_repair_estimate_lines cr
174: WHERE cr.estimate_detail_id = ced.estimate_detail_id
175: AND ced.charge_line_type = 'ACTUAL'
176: AND ced.order_line_id is null

Line 189: FROM cs_estimate_details ced

185:
186: CURSOR get_est_lines(p_start_rep_line_id number, p_end_rep_line_id number)
187: IS
188: SELECT ced.estimate_detail_id
189: FROM cs_estimate_details ced
190: , csd_repairs cr
191: , csd_repair_estimate cre
192: , csd_repair_estimate_lines crel
193: WHERE cr.repair_line_id = cre.repair_line_id

Line 215: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CS_ESTIMATE_DETAILS',

211: BEGIN
212:
213: -- gilam: bug 3410383 - changed slab table to csd_repairs
214: /*
215: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CS_ESTIMATE_DETAILS',
216: 'CSD',
217: p_slab_number,
218: v_min,
219: v_max);

Line 248: UPDATE CS_ESTIMATE_DETAILS

244: SAVEPOINT CSD_ESTIMATE_LINES;
245:
246: BEGIN
247:
248: UPDATE CS_ESTIMATE_DETAILS
249: SET CHARGE_LINE_TYPE = 'ESTIMATE'
250: WHERE ESTIMATE_DETAIL_ID = est_lines_arr(j);
251:
252: IF SQL%NOTFOUND

Line 272: 'CS_ESTIMATE_DETAILS',

268: UPGRADE_DATETIME,
269: ERROR_MESSAGE,
270: MIGRATION_PHASE)
271: VALUES ('CSD_REPAIR_ESTIMATE_LINES',
272: 'CS_ESTIMATE_DETAILS',
273: est_lines_arr(j),
274: sysdate,
275: v_error_text,
276: '11.5.10');

Line 280: raise_application_error( -20000, 'Error while migrating ESTIMATES data in CS_ESTIMATE_DETAILS: Error while Updating CS_ESTIMATE_DETAILS. '|| v_error_text);

276: '11.5.10');
277:
278: commit;
279:
280: raise_application_error( -20000, 'Error while migrating ESTIMATES data in CS_ESTIMATE_DETAILS: Error while Updating CS_ESTIMATE_DETAILS. '|| v_error_text);
281:
282: END;
283: END LOOP;
284: COMMIT;

Line 297: /* description : procedure for migrating ESTIMATES data in CS_ESTIMATE_DETAILS */

293: END csd_charge_estimate_lines_mig3;
294:
295: /*-------------------------------------------------------------------------------*/
296: /* procedure name: CSD_REPAIR_ESTIMATE_LINES_MIG3 */
297: /* description : procedure for migrating ESTIMATES data in CS_ESTIMATE_DETAILS */
298: /* table from 11.5.9 to 11.5.10 */
299: /* purpose : Mandatory Step for all CSD_REPAIR_ESTIMATE_LINES records */
300: /* Update all records in 1159 CSD_REPAIR_ESTIMATE_LINES table for*/
301: /* New Cols Added : EST_LINE_SOURCE_TYPE_CODE = 'MANUAL' */

Line 418: raise_application_error( -20000, 'Error while migrating ESTIMATES data in CS_ESTIMATE_DETAILS: Error while Updating CSD_REPAIR_ESTIMATE_LINES. '|| v_error_text);

414: v_error_text,
415: '11.5.10');
416: commit;
417:
418: raise_application_error( -20000, 'Error while migrating ESTIMATES data in CS_ESTIMATE_DETAILS: Error while Updating CSD_REPAIR_ESTIMATE_LINES. '|| v_error_text);
419:
420: END;
421: END LOOP;
422: COMMIT;

Line 452: -- TYPE EST_DET_REC_ARRAY_TYPE IS VARRAY(1000) OF CS.CS_ESTIMATE_DETAILS%ROWTYPE;

448:
449: PROCEDURE csd_acttoest_charge_line_mig3(p_slab_number IN NUMBER DEFAULT 1)
450: IS
451:
452: -- TYPE EST_DET_REC_ARRAY_TYPE IS VARRAY(1000) OF CS.CS_ESTIMATE_DETAILS%ROWTYPE;
453: -- est_det_arr EST_DET_REC_ARRAY_TYPE;
454:
455: -- gilam: bug 3362408/3362418 - commented out all the columns that are not used in insert_row
456: -- as some of the columns have been dropped in 11.5.10 by Charges

Line 957: FROM cs_estimate_details ced

953: ced.submit_restriction_message,
954: ced.submit_error_message,
955: ced.line_submitted,
956: ced.submit_from_system
957: FROM cs_estimate_details ced
958: , csd_repair_estimate_lines cr
959: WHERE cr.estimate_detail_id = ced.estimate_detail_id
960: AND ced.charge_line_type = 'ACTUAL'
961: AND ced.order_line_id is not null

Line 1192: FROM cs_estimate_details ced

1188: ,ced.contract_line_id
1189: ,ced.rate_type_code
1190: --sangigup
1191:
1192: FROM cs_estimate_details ced
1193: , csd_repairs cr
1194: , csd_repair_estimate cre
1195: , csd_repair_estimate_lines crel
1196: WHERE cr.repair_line_id = cre.repair_line_id

Line 1218: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CS_ESTIMATE_DETAILS',

1214: BEGIN
1215:
1216: -- gilam: bug 3410383 - changed slab table to csd_repairs
1217: /*
1218: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CS_ESTIMATE_DETAILS',
1219: 'CSD',
1220: p_slab_number,
1221: v_min,
1222: v_max);

Line 1492: FROM CS_ESTIMATE_DETAILS

1488:
1489: -- charges display sequence number
1490: SELECT max(line_number) + 1
1491: INTO l_line_num
1492: FROM CS_ESTIMATE_DETAILS
1493: WHERE incident_id = v_INCIDENT_ID(j);
1494:
1495: l_line_num := NVL(l_line_num,1);
1496:

Line 1499: SELECT cs_estimate_details_s.nextval

1495: l_line_num := NVL(l_line_num,1);
1496:
1497: -- This is newly created Charge lines (type - Estimate) estimate_detail_id
1498: -- l_ed_id is our l_new_est_detail_id
1499: SELECT cs_estimate_details_s.nextval
1500: INTO l_new_est_detail_id
1501: FROM SYS.DUAL;
1502:
1503: -- get the actual header id : only one actual header for each repair line

Line 1519: CS_ESTIMATE_DETAILS_PKG.Insert_Row(

1515:
1516: BEGIN
1517: -- Now copy the Actual line to Estimate charge line
1518:
1519: CS_ESTIMATE_DETAILS_PKG.Insert_Row(
1520: p_org_id => v_ORG_ID(j),
1521: p_incident_id => v_INCIDENT_ID(j),
1522: p_original_source_id => v_ORIGINAL_SOURCE_ID(j),
1523: p_original_source_code => v_ORIGINAL_SOURCE_CODE(j),

Line 1726: || 'CS_ESTIMATE_DETAILS_PKG.Insert_Row Failed - For Estimate Detail Id:'

1722:
1723: EXCEPTION
1724: WHEN OTHERS THEN
1725: v_error_text := substr(sqlerrm, 1, 1000)
1726: || 'CS_ESTIMATE_DETAILS_PKG.Insert_Row Failed - For Estimate Detail Id:'
1727: || v_ESTIMATE_DETAIL_ID(j);
1728: RAISE error_process;
1729: END;
1730:

Line 1853: 'CS_ESTIMATE_DETAILS',

1849: UPGRADE_DATETIME,
1850: ERROR_MESSAGE,
1851: MIGRATION_PHASE)
1852: VALUES ('CSD_REPAIR_ESTIMATE_LINES',
1853: 'CS_ESTIMATE_DETAILS',
1854: v_ESTIMATE_DETAIL_ID(j),
1855: sysdate,
1856: v_error_text,
1857: '11.5.10');

Line 1876: FROM CS_ESTIMATE_DETAILS

1872:
1873: -- charges display sequence number
1874: SELECT max(line_number) + 1
1875: INTO l_line_num
1876: FROM CS_ESTIMATE_DETAILS
1877: WHERE incident_id = est_det_arr(j).incident_id;
1878:
1879: l_line_num := NVL(l_line_num,1);
1880:

Line 1883: SELECT cs_estimate_details_s.nextval

1879: l_line_num := NVL(l_line_num,1);
1880:
1881: -- This is newly created Charge lines (type - Estimate) estimate_detail_id
1882: -- l_ed_id is our l_new_est_detail_id
1883: SELECT cs_estimate_details_s.nextval
1884: INTO l_new_est_detail_id
1885: FROM SYS.DUAL;
1886:
1887: -- get the actual header id : only one actual header for each repair line

Line 1902: CS_ESTIMATE_DETAILS_PKG.Insert_Row(

1898: WHERE estimate_detail_id = l_old_est_detail_id;
1899:
1900: BEGIN
1901: -- Now copy the Actual line to Estimate charge line
1902: CS_ESTIMATE_DETAILS_PKG.Insert_Row(
1903: p_org_id => est_det_arr(j).org_id,
1904: p_incident_id => est_det_arr(j).incident_id,
1905: p_original_source_id => est_det_arr(j).original_source_id,
1906: p_original_source_code => est_det_arr(j).original_source_code,

Line 2104: || 'CS_ESTIMATE_DETAILS_PKG.Insert_Row Failed - For Estimate Detail Id:'

2100:
2101: EXCEPTION
2102: WHEN OTHERS THEN
2103: v_error_text := substr(sqlerrm, 1, 1000)
2104: || 'CS_ESTIMATE_DETAILS_PKG.Insert_Row Failed - For Estimate Detail Id:'
2105: || est_det_arr(j).estimate_detail_id;
2106: RAISE error_process;
2107: END;
2108:

Line 2231: 'CS_ESTIMATE_DETAILS',

2227: UPGRADE_DATETIME,
2228: ERROR_MESSAGE,
2229: MIGRATION_PHASE)
2230: VALUES ('CSD_REPAIR_ESTIMATE_LINES',
2231: 'CS_ESTIMATE_DETAILS',
2232: est_det_arr(j).estimate_detail_id,
2233: sysdate,
2234: v_error_text,
2235: '11.5.10');

Line 2593: FROM csd_repair_estimate_lines rel, cs_estimate_details ced

2589: IS
2590: SELECT rel.repair_estimate_line_id estimate_line_id, rel.item_cost item_cost,
2591: rel.original_cost original_cost, ced.currency_code, ced.creation_date ,
2592: ced.unit_of_measure_code, ced.estimate_detail_id, rel.resource_id, rel.rowid
2593: FROM csd_repair_estimate_lines rel, cs_estimate_details ced
2594: WHERE rel.estimate_detail_id = ced.estimate_detail_id
2595: and (
2596: ( rel.item_cost is not null and rel.original_cost is null)
2597: OR ( rel.item_cost is null and rel.original_cost is not null)

Line 2614: FROM mtl_system_items MSI, cs_estimate_details ced

2610: --Cursor to get primary_uom_code for the estimate line item.
2611: CURSOR cur_getUOMForEstLineItem(p_estimate_detail_id NUMBER)
2612: IS
2613: SELECT primary_uom_code
2614: FROM mtl_system_items MSI, cs_estimate_details ced
2615: WHERE CED.estimate_detail_id = p_estimate_detail_id
2616: AND MSI.inventory_item_id = CED.inventory_item_id
2617: AND MSI.organization_id = cs_std.get_item_valdn_orgzn_id;
2618:

Line 2624: cs_estimate_details ESTD,

2620: CURSOR cur_getBillCategoryType (p_estimate_detail_id number)
2621: IS
2622: SELECT BCAT.billing_category
2623: FROM csd_repair_estimate_lines ESTL,
2624: cs_estimate_details ESTD,
2625: cs_txn_billing_types TXNT,
2626: cs_billing_type_categories BCAT
2627: WHERE ESTL.repair_estimate_line_id = p_estimate_detail_id
2628: AND ESTD.estimate_detail_id = ESTL.estimate_detail_id

Line 3380: cs_estimate_details ced ,

3376: NULL -- non_source_serial_number
3377: From csd_product_transactions cpt ,
3378: csd_repairs cr ,
3379: csd_repair_types_b crt,
3380: cs_estimate_details ced ,
3381: oe_order_headers_all ooha,
3382: oe_order_lines_all oola ,
3383: mtl_system_items_b msi
3384: Where cpt.product_transaction_id >= p_Start_Slab