DBA Data[Home] [Help]

APPS.PSP_MATRIX_DRIVER2_PKG dependencies on PSP_MATRIX_DRIVER2

Line 1: package body psp_matrix_driver2_pkg as

1: package body psp_matrix_driver2_pkg as
2: --$Header: PSPLSM2B.pls 115.8 2002/09/25 02:15:48 vdharmap ship $
3:
4: start_period BINARY_INTEGER:=1;
5: TYPE mat_tab IS TABLE OF DATE

Line 55: from psp_matrix_driver2

51: return null;
52: else
53: select sum(PERIOD_SCHEDULE_PERCENT)
54: into total
55: from psp_matrix_driver2
56: where period = st_date;
57: return total;
58: end if;
59: END;

Line 114: insert into psp_matrix_driver2(SCHEDULE_LINE_ID,

110: --dbms_output.put_line('reached here'||to_char(per));
111: end if;
112: per:=round(per,2);
113: --dbms_output.put_line(to_char(per));
114: insert into psp_matrix_driver2(SCHEDULE_LINE_ID,
115: PERIOD,
116: PERIOD_SCHEDULE_PERCENT) values
117: (sch_rec.l_id,
118: dat(i),

Line 125: end psp_matrix_driver2_pkg;

121: END LOOP;
122:
123: END load_table;
124:
125: end psp_matrix_driver2_pkg;