DBA Data[Home] [Help]

APPS.CSD_MIGRATE_FROM_115X_PKG3 dependencies on DUAL

Line 458: -- gilam: define each column individually

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
457:
458: -- gilam: define each column individually
459: TYPE NumTabTypeI IS TABLE OF NUMBER
460: INDEX by Binary_Integer;
461: v_LINE_NUMBER NumTabTypeI ;
462: v_QUANTITY_REQUIRED NumTabTypeI ;

Line 1248: -- gilam: changed FETCH stmt to fetch into individual tables

1244:
1245: -- gilam: bug 3362408/3362418 - commented out all the columns that are not used in insert_row
1246: -- as some of the columns have been dropped in 11.5.10 by Charges
1247:
1248: -- gilam: changed FETCH stmt to fetch into individual tables
1249: FETCH get_charge_est_details BULK COLLECT
1250: INTO
1251: v_ESTIMATE_DETAIL_ID ,
1252: v_LAST_UPDATE_DATE ,

Line 1501: FROM SYS.DUAL;

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
1504: SELECT repair_actual_id
1505: INTO l_actual_id

Line 1885: FROM SYS.DUAL;

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
1888: SELECT repair_actual_id
1889: INTO l_actual_id