APPS.OPI_DBI_RES_OPM_PKG dependencies on OPI_DBI_RES_AVAIL_STG

Line 109: --dbms_output.put_line('Preparing to Insert OPM Resource Availability into opi_dbi_res_avail_stg');

105: l_stmt_num := 10;
106:
107: -- populate availability for opm resource
108:
109: --dbms_output.put_line('Preparing to Insert OPM Resource Availability into opi_dbi_res_avail_stg');
110: --dbms_output.put_line('g_hr_uom := ' || g_hr_uom);
111: --dbms_output.put_line('g_global_start_date = ' || to_char(g_global_start_date));
112:
113: INSERT /*+ APPEND */ INTO opi_dbi_res_avail_stg

Line 113: INSERT /*+ APPEND */ INTO opi_dbi_res_avail_stg

109: --dbms_output.put_line('Preparing to Insert OPM Resource Availability into opi_dbi_res_avail_stg');
110: --dbms_output.put_line('g_hr_uom := ' || g_hr_uom);
111: --dbms_output.put_line('g_global_start_date = ' || to_char(g_global_start_date));
112:
113: INSERT /*+ APPEND */ INTO opi_dbi_res_avail_stg
114: ( resource_id, organization_id, department_id, transaction_date,
115: uom, avail_qty, avail_qty_g, avail_val_b, source,
116: creation_date, last_update_date, created_by,
117: last_updated_by, last_update_login)

Line 639: --dbms_output.put_line('Preparing to Insert OPM Resource Availability into opi_dbi_res_avail_stg');

635: --dbms_output.put_line('l_last_collection_date ' || l_last_collection_date );
636:
637: -- populate availability for opm resource
638:
639: --dbms_output.put_line('Preparing to Insert OPM Resource Availability into opi_dbi_res_avail_stg');
640: --dbms_output.put_line('g_hr_uom := ' || g_hr_uom);
641: --dbms_output.put_line('g_global_start_date = ' || to_char(g_global_start_date));
642:
643: INSERT INTO opi_dbi_res_avail_stg

Line 643: INSERT INTO opi_dbi_res_avail_stg

639: --dbms_output.put_line('Preparing to Insert OPM Resource Availability into opi_dbi_res_avail_stg');
640: --dbms_output.put_line('g_hr_uom := ' || g_hr_uom);
641: --dbms_output.put_line('g_global_start_date = ' || to_char(g_global_start_date));
642:
643: INSERT INTO opi_dbi_res_avail_stg
644: ( resource_id, organization_id, department_id, transaction_date,
645: uom, avail_qty, avail_qty_g, avail_val_b, source,
646: creation_date, last_update_date, created_by,
647: last_updated_by, last_update_login)