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.PSP_ORG_DLS_PKG dependencies on DBMS_SQL

Line 142: l_Cur_Handle1 := dbms_sql.open_cursor;

138:
139:
140: -- dbms_output.put_line('start date is ' || to_char(l_Time_Period_Start_Date));
141:
142: l_Cur_Handle1 := dbms_sql.open_cursor;
143:
144: --dbms_output.put_line('tried opening cursor,....valueis ' || to_char(l_Cur_Handle1));
145:
146: dbms_sql.parse(l_cur_handle1, 'Select DISTINCT a.Assignment_ID ASSIGNMENT_ID,

Line 146: dbms_sql.parse(l_cur_handle1, 'Select DISTINCT a.Assignment_ID ASSIGNMENT_ID,

142: l_Cur_Handle1 := dbms_sql.open_cursor;
143:
144: --dbms_output.put_line('tried opening cursor,....valueis ' || to_char(l_Cur_Handle1));
145:
146: dbms_sql.parse(l_cur_handle1, 'Select DISTINCT a.Assignment_ID ASSIGNMENT_ID,
147: a.Organization_ID ORGANIZATION_ID,
148: a.Person_ID PERSON_ID
149: from PER_ASSIGNMENTS_F a
150: where ' || g_organization_str || '

Line 164: >= :p_end_date ))))', dbms_sql.V7);

160: and SCHI.SCHEDULE_HIERARCHY_ID = SCHL.SCHEDULE_HIERARCHY_ID
161: and ((SCHL.SCHEDULE_BEGIN_DATE between :p_start_date and :p_end_date )
162: or (SCHL.SCHEDULE_END_DATE between :p_start_date and :p_end_date )
163: or (SCHL.SCHEDULE_BEGIN_DATE <= :p_start_date and SCHL.SCHEDULE_END_DATE
164: >= :p_end_date ))))', dbms_sql.V7);
165:
166: dbms_sql.bind_variable(l_cur_handle1, ':p_start_date', p_start_date);
167: dbms_sql.bind_variable(l_cur_handle1, ':p_end_date', p_end_date);
168:

Line 166: dbms_sql.bind_variable(l_cur_handle1, ':p_start_date', p_start_date);

162: or (SCHL.SCHEDULE_END_DATE between :p_start_date and :p_end_date )
163: or (SCHL.SCHEDULE_BEGIN_DATE <= :p_start_date and SCHL.SCHEDULE_END_DATE
164: >= :p_end_date ))))', dbms_sql.V7);
165:
166: dbms_sql.bind_variable(l_cur_handle1, ':p_start_date', p_start_date);
167: dbms_sql.bind_variable(l_cur_handle1, ':p_end_date', p_end_date);
168:
169: dbms_sql.define_column(l_cur_handle1, 1, l_Assignment_ID);
170: dbms_sql.define_column(l_cur_handle1, 2, l_Organization_ID);

Line 167: dbms_sql.bind_variable(l_cur_handle1, ':p_end_date', p_end_date);

163: or (SCHL.SCHEDULE_BEGIN_DATE <= :p_start_date and SCHL.SCHEDULE_END_DATE
164: >= :p_end_date ))))', dbms_sql.V7);
165:
166: dbms_sql.bind_variable(l_cur_handle1, ':p_start_date', p_start_date);
167: dbms_sql.bind_variable(l_cur_handle1, ':p_end_date', p_end_date);
168:
169: dbms_sql.define_column(l_cur_handle1, 1, l_Assignment_ID);
170: dbms_sql.define_column(l_cur_handle1, 2, l_Organization_ID);
171: dbms_sql.define_column(l_cur_handle1, 3, l_Person_ID);

Line 169: dbms_sql.define_column(l_cur_handle1, 1, l_Assignment_ID);

165:
166: dbms_sql.bind_variable(l_cur_handle1, ':p_start_date', p_start_date);
167: dbms_sql.bind_variable(l_cur_handle1, ':p_end_date', p_end_date);
168:
169: dbms_sql.define_column(l_cur_handle1, 1, l_Assignment_ID);
170: dbms_sql.define_column(l_cur_handle1, 2, l_Organization_ID);
171: dbms_sql.define_column(l_cur_handle1, 3, l_Person_ID);
172:
173: l_total_rows := dbms_sql.execute(l_cur_handle1);

Line 170: dbms_sql.define_column(l_cur_handle1, 2, l_Organization_ID);

166: dbms_sql.bind_variable(l_cur_handle1, ':p_start_date', p_start_date);
167: dbms_sql.bind_variable(l_cur_handle1, ':p_end_date', p_end_date);
168:
169: dbms_sql.define_column(l_cur_handle1, 1, l_Assignment_ID);
170: dbms_sql.define_column(l_cur_handle1, 2, l_Organization_ID);
171: dbms_sql.define_column(l_cur_handle1, 3, l_Person_ID);
172:
173: l_total_rows := dbms_sql.execute(l_cur_handle1);
174: while dbms_sql.fetch_rows(l_cur_handle1) > 0

Line 171: dbms_sql.define_column(l_cur_handle1, 3, l_Person_ID);

167: dbms_sql.bind_variable(l_cur_handle1, ':p_end_date', p_end_date);
168:
169: dbms_sql.define_column(l_cur_handle1, 1, l_Assignment_ID);
170: dbms_sql.define_column(l_cur_handle1, 2, l_Organization_ID);
171: dbms_sql.define_column(l_cur_handle1, 3, l_Person_ID);
172:
173: l_total_rows := dbms_sql.execute(l_cur_handle1);
174: while dbms_sql.fetch_rows(l_cur_handle1) > 0
175: LOOP

Line 173: l_total_rows := dbms_sql.execute(l_cur_handle1);

169: dbms_sql.define_column(l_cur_handle1, 1, l_Assignment_ID);
170: dbms_sql.define_column(l_cur_handle1, 2, l_Organization_ID);
171: dbms_sql.define_column(l_cur_handle1, 3, l_Person_ID);
172:
173: l_total_rows := dbms_sql.execute(l_cur_handle1);
174: while dbms_sql.fetch_rows(l_cur_handle1) > 0
175: LOOP
176: dbms_sql.column_value(l_cur_handle1, 1, l_Assignment_ID);
177: dbms_sql.column_value(l_cur_handle1, 2, l_Organization_ID);

Line 174: while dbms_sql.fetch_rows(l_cur_handle1) > 0

170: dbms_sql.define_column(l_cur_handle1, 2, l_Organization_ID);
171: dbms_sql.define_column(l_cur_handle1, 3, l_Person_ID);
172:
173: l_total_rows := dbms_sql.execute(l_cur_handle1);
174: while dbms_sql.fetch_rows(l_cur_handle1) > 0
175: LOOP
176: dbms_sql.column_value(l_cur_handle1, 1, l_Assignment_ID);
177: dbms_sql.column_value(l_cur_handle1, 2, l_Organization_ID);
178: dbms_sql.column_value(l_cur_handle1, 3, l_Person_ID);

Line 176: dbms_sql.column_value(l_cur_handle1, 1, l_Assignment_ID);

172:
173: l_total_rows := dbms_sql.execute(l_cur_handle1);
174: while dbms_sql.fetch_rows(l_cur_handle1) > 0
175: LOOP
176: dbms_sql.column_value(l_cur_handle1, 1, l_Assignment_ID);
177: dbms_sql.column_value(l_cur_handle1, 2, l_Organization_ID);
178: dbms_sql.column_value(l_cur_handle1, 3, l_Person_ID);
179: -- Obtain the Part of Period1 that is covered by a PSP
180: -- Default Labor Schedule. Add corresponding records to PSP_REP_ORG_DLS

Line 177: dbms_sql.column_value(l_cur_handle1, 2, l_Organization_ID);

173: l_total_rows := dbms_sql.execute(l_cur_handle1);
174: while dbms_sql.fetch_rows(l_cur_handle1) > 0
175: LOOP
176: dbms_sql.column_value(l_cur_handle1, 1, l_Assignment_ID);
177: dbms_sql.column_value(l_cur_handle1, 2, l_Organization_ID);
178: dbms_sql.column_value(l_cur_handle1, 3, l_Person_ID);
179: -- Obtain the Part of Period1 that is covered by a PSP
180: -- Default Labor Schedule. Add corresponding records to PSP_REP_ORG_DLS
181: -- table

Line 178: dbms_sql.column_value(l_cur_handle1, 3, l_Person_ID);

174: while dbms_sql.fetch_rows(l_cur_handle1) > 0
175: LOOP
176: dbms_sql.column_value(l_cur_handle1, 1, l_Assignment_ID);
177: dbms_sql.column_value(l_cur_handle1, 2, l_Organization_ID);
178: dbms_sql.column_value(l_cur_handle1, 3, l_Person_ID);
179: -- Obtain the Part of Period1 that is covered by a PSP
180: -- Default Labor Schedule. Add corresponding records to PSP_REP_ORG_DLS
181: -- table
182: Add_If_Within_DLS(v_Organization_ID => l_Organization_ID,

Line 191: dbms_sql.close_cursor(l_cur_handle1);

187: --dbms_output.put_line('After calling the Table_Insert Procedure');
188: END LOOP;
189: --dbms_output.put_line('Have to insert Assignments : ' || v_Assgn_List_To_Add || ' to Report');
190:
191: dbms_sql.close_cursor(l_cur_handle1);
192:
193: /*******************************************************************************************************
194: Next, we need to check if all assignments that have scheduling code of 'ET', have schedule begin
195: and end dates that fully encapsulate the selected time period. If they do, then, we NEED NOT

Line 271: l_cur_handle := dbms_sql.open_cursor;

267: retVal Number := 0;
268: Begin
269:
270:
271: l_cur_handle := dbms_sql.open_cursor;
272: -- dbms_output.put_line('About to parse Assignment Level SQL');
273: dbms_sql.parse(l_cur_handle, 'SELECT DISTINCT a.ASSIGNMENT_ID ASSIGNMENT_ID,
274: a.ORGANIZATION_ID ORGANIZATION_ID,
275: b.PERSON_ID PERSON_ID,

Line 273: dbms_sql.parse(l_cur_handle, 'SELECT DISTINCT a.ASSIGNMENT_ID ASSIGNMENT_ID,

269:
270:
271: l_cur_handle := dbms_sql.open_cursor;
272: -- dbms_output.put_line('About to parse Assignment Level SQL');
273: dbms_sql.parse(l_cur_handle, 'SELECT DISTINCT a.ASSIGNMENT_ID ASSIGNMENT_ID,
274: a.ORGANIZATION_ID ORGANIZATION_ID,
275: b.PERSON_ID PERSON_ID,
276: c.ELEMENT_TYPE_ID ELEMENT_TYPE_ID,
277: d.SCHEDULE_LINE_ID SCHEDULE_LINE_ID,

Line 303: dbms_sql.V7);

299: or :p_end_date <= f.SCHEDULE_END_DATE
300: or ( :p_start_date <= f.SCHEDULE_BEGIN_DATE and
301: :p_END_DATE >= f.SCHEDULE_END_DATE))
302: and ' || g_organization_str ,
303: dbms_sql.V7);
304: dbms_sql.bind_variable(l_cur_handle, ':p_start_date', p_start_date);
305: dbms_sql.bind_variable(l_cur_handle, ':p_end_date', p_end_date);
306:
307:

Line 304: dbms_sql.bind_variable(l_cur_handle, ':p_start_date', p_start_date);

300: or ( :p_start_date <= f.SCHEDULE_BEGIN_DATE and
301: :p_END_DATE >= f.SCHEDULE_END_DATE))
302: and ' || g_organization_str ,
303: dbms_sql.V7);
304: dbms_sql.bind_variable(l_cur_handle, ':p_start_date', p_start_date);
305: dbms_sql.bind_variable(l_cur_handle, ':p_end_date', p_end_date);
306:
307:
308: -- dbms_output.put_line('About to define numeric columns.');

Line 305: dbms_sql.bind_variable(l_cur_handle, ':p_end_date', p_end_date);

301: :p_END_DATE >= f.SCHEDULE_END_DATE))
302: and ' || g_organization_str ,
303: dbms_sql.V7);
304: dbms_sql.bind_variable(l_cur_handle, ':p_start_date', p_start_date);
305: dbms_sql.bind_variable(l_cur_handle, ':p_end_date', p_end_date);
306:
307:
308: -- dbms_output.put_line('About to define numeric columns.');
309: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);

Line 309: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);

305: dbms_sql.bind_variable(l_cur_handle, ':p_end_date', p_end_date);
306:
307:
308: -- dbms_output.put_line('About to define numeric columns.');
309: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);
310: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);
311: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);
312: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);
313: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);

Line 310: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);

306:
307:
308: -- dbms_output.put_line('About to define numeric columns.');
309: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);
310: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);
311: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);
312: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);
313: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);
314:

Line 311: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);

307:
308: -- dbms_output.put_line('About to define numeric columns.');
309: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);
310: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);
311: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);
312: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);
313: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);
314:
315: -- dbms_output.put_line('About to define Date columns.');

Line 312: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);

308: -- dbms_output.put_line('About to define numeric columns.');
309: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);
310: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);
311: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);
312: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);
313: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);
314:
315: -- dbms_output.put_line('About to define Date columns.');
316: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);

Line 313: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);

309: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);
310: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);
311: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);
312: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);
313: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);
314:
315: -- dbms_output.put_line('About to define Date columns.');
316: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);
317: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);

Line 316: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);

312: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);
313: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);
314:
315: -- dbms_output.put_line('About to define Date columns.');
316: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);
317: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);
318: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
319: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
320:

Line 317: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);

313: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);
314:
315: -- dbms_output.put_line('About to define Date columns.');
316: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);
317: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);
318: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
319: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
320:
321: l_total_rows := dbms_sql.execute(l_cur_handle);

Line 318: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);

314:
315: -- dbms_output.put_line('About to define Date columns.');
316: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);
317: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);
318: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
319: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
320:
321: l_total_rows := dbms_sql.execute(l_cur_handle);
322: while dbms_sql.fetch_rows(l_cur_handle) > 0

Line 319: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);

315: -- dbms_output.put_line('About to define Date columns.');
316: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);
317: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);
318: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
319: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
320:
321: l_total_rows := dbms_sql.execute(l_cur_handle);
322: while dbms_sql.fetch_rows(l_cur_handle) > 0
323: LOOP

Line 321: l_total_rows := dbms_sql.execute(l_cur_handle);

317: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);
318: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
319: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
320:
321: l_total_rows := dbms_sql.execute(l_cur_handle);
322: while dbms_sql.fetch_rows(l_cur_handle) > 0
323: LOOP
324: -- dbms_output.put_line('Inside loop of Assignment Level Schedules');
325: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);

Line 322: while dbms_sql.fetch_rows(l_cur_handle) > 0

318: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
319: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
320:
321: l_total_rows := dbms_sql.execute(l_cur_handle);
322: while dbms_sql.fetch_rows(l_cur_handle) > 0
323: LOOP
324: -- dbms_output.put_line('Inside loop of Assignment Level Schedules');
325: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
326: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);

Line 325: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);

321: l_total_rows := dbms_sql.execute(l_cur_handle);
322: while dbms_sql.fetch_rows(l_cur_handle) > 0
323: LOOP
324: -- dbms_output.put_line('Inside loop of Assignment Level Schedules');
325: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
326: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
327: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
328: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
329: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);

Line 326: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);

322: while dbms_sql.fetch_rows(l_cur_handle) > 0
323: LOOP
324: -- dbms_output.put_line('Inside loop of Assignment Level Schedules');
325: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
326: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
327: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
328: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
329: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
330: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);

Line 327: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);

323: LOOP
324: -- dbms_output.put_line('Inside loop of Assignment Level Schedules');
325: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
326: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
327: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
328: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
329: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
330: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
331: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);

Line 328: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);

324: -- dbms_output.put_line('Inside loop of Assignment Level Schedules');
325: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
326: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
327: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
328: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
329: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
330: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
331: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
332: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);

Line 329: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);

325: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
326: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
327: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
328: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
329: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
330: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
331: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
332: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);
333: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);

Line 330: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);

326: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
327: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
328: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
329: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
330: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
331: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
332: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);
333: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);
334:

Line 331: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);

327: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
328: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
329: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
330: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
331: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
332: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);
333: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);
334:
335:

Line 332: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);

328: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
329: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
330: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
331: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
332: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);
333: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);
334:
335:
336: retVal := Process_Glob_Elem_Schedule(l_Assignment_ID, l_Element_Type_ID,

Line 333: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);

329: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
330: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
331: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
332: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);
333: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);
334:
335:
336: retVal := Process_Glob_Elem_Schedule(l_Assignment_ID, l_Element_Type_ID,
337: l_Time_Period_Start_Date, l_Time_Period_End_Date, l_GE_Period1_Start,

Line 455: l_cur_handle := dbms_sql.open_cursor;

451: b_Goto_Next_Assignment boolean;
452: b_Goto_NExt_Element_Type boolean;
453: retVal Number := 0;
454: Begin
455: l_cur_handle := dbms_sql.open_cursor;
456: dbms_sql.parse(l_cur_handle, 'SELECT DISTINCT a.ASSIGNMENT_ID ASSIGNMENT_ID,
457: a.ORGANIZATION_ID ORGANIZATION_ID,
458: b.PERSON_ID PERSON_ID,
459: f.ELEMENT_TYPE_ID ELEMENT_TYPE_ID,

Line 456: dbms_sql.parse(l_cur_handle, 'SELECT DISTINCT a.ASSIGNMENT_ID ASSIGNMENT_ID,

452: b_Goto_NExt_Element_Type boolean;
453: retVal Number := 0;
454: Begin
455: l_cur_handle := dbms_sql.open_cursor;
456: dbms_sql.parse(l_cur_handle, 'SELECT DISTINCT a.ASSIGNMENT_ID ASSIGNMENT_ID,
457: a.ORGANIZATION_ID ORGANIZATION_ID,
458: b.PERSON_ID PERSON_ID,
459: f.ELEMENT_TYPE_ID ELEMENT_TYPE_ID,
460: d.SCHEDULE_LINE_ID SCHEDULE_LINE_ID,

Line 497: dbms_sql.V7);

493: or :p_end_date <= g.SCHEDULE_END_DATE
494: or (:p_start_date <= g.SCHEDULE_BEGIN_DATE and
495: :p_end_date >= g.SCHEDULE_END_DATE))
496: and ' || g_organization_str,
497: dbms_sql.V7);
498:
499: dbms_sql.bind_variable(l_cur_handle, ':p_start_date', p_start_date);
500: dbms_sql.bind_variable(l_cur_handle, ':p_end_date', p_end_date);
501:

Line 499: dbms_sql.bind_variable(l_cur_handle, ':p_start_date', p_start_date);

495: :p_end_date >= g.SCHEDULE_END_DATE))
496: and ' || g_organization_str,
497: dbms_sql.V7);
498:
499: dbms_sql.bind_variable(l_cur_handle, ':p_start_date', p_start_date);
500: dbms_sql.bind_variable(l_cur_handle, ':p_end_date', p_end_date);
501:
502: -- dbms_output.put_line('About to define numeric columns.');
503: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);

Line 500: dbms_sql.bind_variable(l_cur_handle, ':p_end_date', p_end_date);

496: and ' || g_organization_str,
497: dbms_sql.V7);
498:
499: dbms_sql.bind_variable(l_cur_handle, ':p_start_date', p_start_date);
500: dbms_sql.bind_variable(l_cur_handle, ':p_end_date', p_end_date);
501:
502: -- dbms_output.put_line('About to define numeric columns.');
503: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);
504: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);

Line 503: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);

499: dbms_sql.bind_variable(l_cur_handle, ':p_start_date', p_start_date);
500: dbms_sql.bind_variable(l_cur_handle, ':p_end_date', p_end_date);
501:
502: -- dbms_output.put_line('About to define numeric columns.');
503: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);
504: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);
505: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);
506: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);
507: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);

Line 504: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);

500: dbms_sql.bind_variable(l_cur_handle, ':p_end_date', p_end_date);
501:
502: -- dbms_output.put_line('About to define numeric columns.');
503: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);
504: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);
505: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);
506: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);
507: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);
508:

Line 505: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);

501:
502: -- dbms_output.put_line('About to define numeric columns.');
503: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);
504: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);
505: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);
506: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);
507: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);
508:
509: -- dbms_output.put_line('About to define Date columns.');

Line 506: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);

502: -- dbms_output.put_line('About to define numeric columns.');
503: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);
504: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);
505: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);
506: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);
507: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);
508:
509: -- dbms_output.put_line('About to define Date columns.');
510: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);

Line 507: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);

503: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);
504: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);
505: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);
506: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);
507: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);
508:
509: -- dbms_output.put_line('About to define Date columns.');
510: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);
511: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);

Line 510: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);

506: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);
507: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);
508:
509: -- dbms_output.put_line('About to define Date columns.');
510: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);
511: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);
512: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
513: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
514:

Line 511: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);

507: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);
508:
509: -- dbms_output.put_line('About to define Date columns.');
510: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);
511: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);
512: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
513: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
514:
515: l_total_rows := dbms_sql.execute(l_cur_handle);

Line 512: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);

508:
509: -- dbms_output.put_line('About to define Date columns.');
510: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);
511: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);
512: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
513: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
514:
515: l_total_rows := dbms_sql.execute(l_cur_handle);
516: while dbms_sql.fetch_rows(l_cur_handle) > 0

Line 513: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);

509: -- dbms_output.put_line('About to define Date columns.');
510: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);
511: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);
512: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
513: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
514:
515: l_total_rows := dbms_sql.execute(l_cur_handle);
516: while dbms_sql.fetch_rows(l_cur_handle) > 0
517: LOOP

Line 515: l_total_rows := dbms_sql.execute(l_cur_handle);

511: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);
512: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
513: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
514:
515: l_total_rows := dbms_sql.execute(l_cur_handle);
516: while dbms_sql.fetch_rows(l_cur_handle) > 0
517: LOOP
518: -- dbms_output.put_line('Inside Loop of Element Group Schedules');
519: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);

Line 516: while dbms_sql.fetch_rows(l_cur_handle) > 0

512: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
513: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
514:
515: l_total_rows := dbms_sql.execute(l_cur_handle);
516: while dbms_sql.fetch_rows(l_cur_handle) > 0
517: LOOP
518: -- dbms_output.put_line('Inside Loop of Element Group Schedules');
519: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
520: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);

Line 519: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);

515: l_total_rows := dbms_sql.execute(l_cur_handle);
516: while dbms_sql.fetch_rows(l_cur_handle) > 0
517: LOOP
518: -- dbms_output.put_line('Inside Loop of Element Group Schedules');
519: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
520: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
521: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
522: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
523: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);

Line 520: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);

516: while dbms_sql.fetch_rows(l_cur_handle) > 0
517: LOOP
518: -- dbms_output.put_line('Inside Loop of Element Group Schedules');
519: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
520: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
521: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
522: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
523: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
524: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);

Line 521: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);

517: LOOP
518: -- dbms_output.put_line('Inside Loop of Element Group Schedules');
519: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
520: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
521: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
522: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
523: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
524: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
525: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);

Line 522: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);

518: -- dbms_output.put_line('Inside Loop of Element Group Schedules');
519: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
520: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
521: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
522: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
523: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
524: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
525: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
526: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);

Line 523: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);

519: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
520: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
521: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
522: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
523: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
524: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
525: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
526: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);
527: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);

Line 524: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);

520: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
521: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
522: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
523: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
524: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
525: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
526: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);
527: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);
528:

Line 525: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);

521: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
522: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
523: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
524: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
525: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
526: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);
527: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);
528:
529: retVal := Process_Glob_Elem_Schedule(l_Assignment_ID, l_Element_Type_ID,

Line 526: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);

522: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
523: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
524: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
525: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
526: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);
527: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);
528:
529: retVal := Process_Glob_Elem_Schedule(l_Assignment_ID, l_Element_Type_ID,
530: l_Time_Period_Start_Date, l_Time_Period_End_Date, l_GE_Period1_Start,

Line 527: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);

523: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
524: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
525: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
526: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);
527: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);
528:
529: retVal := Process_Glob_Elem_Schedule(l_Assignment_ID, l_Element_Type_ID,
530: l_Time_Period_Start_Date, l_Time_Period_End_Date, l_GE_Period1_Start,
531: l_GE_Period1_End, l_GE_Period2_Start, l_GE_Period2_End);

Line 724: l_cur_handle := dbms_sql.open_cursor;

720: b_Goto_Next_Assignment boolean;
721: b_Goto_NExt_Element_Type boolean;
722: retVal Number := 0;
723: Begin
724: l_cur_handle := dbms_sql.open_cursor;
725: dbms_sql.parse(l_cur_handle, 'SELECT DISTINCT a.ASSIGNMENT_ID ASSIGNMENT_ID,
726: a.ORGANIZATION_ID ORGANIZATION_ID,
727: b.PERSON_ID PERSON_ID,
728: c.ELEMENT_TYPE_ID ELEMENT_TYPE_ID,

Line 725: dbms_sql.parse(l_cur_handle, 'SELECT DISTINCT a.ASSIGNMENT_ID ASSIGNMENT_ID,

721: b_Goto_NExt_Element_Type boolean;
722: retVal Number := 0;
723: Begin
724: l_cur_handle := dbms_sql.open_cursor;
725: dbms_sql.parse(l_cur_handle, 'SELECT DISTINCT a.ASSIGNMENT_ID ASSIGNMENT_ID,
726: a.ORGANIZATION_ID ORGANIZATION_ID,
727: b.PERSON_ID PERSON_ID,
728: c.ELEMENT_TYPE_ID ELEMENT_TYPE_ID,
729: d.SCHEDULE_LINE_ID SCHEDULE_LINE_ID,

Line 756: dbms_sql.V7);

752: or :p_end_date <= f.SCHEDULE_END_DATE
753: or ( :p_start_date <= f.SCHEDULE_BEGIN_DATE and
754: :p_end_date >= f.SCHEDULE_END_DATE))
755: and c.ELEMENT_TYPE_ID IN ' || g_element_type_id_str,
756: dbms_sql.V7);
757:
758: dbms_sql.bind_variable(l_cur_handle, ':p_start_date', p_start_date);
759: dbms_sql.bind_variable(l_cur_handle, ':p_end_date', p_end_date);
760:

Line 758: dbms_sql.bind_variable(l_cur_handle, ':p_start_date', p_start_date);

754: :p_end_date >= f.SCHEDULE_END_DATE))
755: and c.ELEMENT_TYPE_ID IN ' || g_element_type_id_str,
756: dbms_sql.V7);
757:
758: dbms_sql.bind_variable(l_cur_handle, ':p_start_date', p_start_date);
759: dbms_sql.bind_variable(l_cur_handle, ':p_end_date', p_end_date);
760:
761: --dbms_output.put_line('About to define numeric columns.');
762: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);

Line 759: dbms_sql.bind_variable(l_cur_handle, ':p_end_date', p_end_date);

755: and c.ELEMENT_TYPE_ID IN ' || g_element_type_id_str,
756: dbms_sql.V7);
757:
758: dbms_sql.bind_variable(l_cur_handle, ':p_start_date', p_start_date);
759: dbms_sql.bind_variable(l_cur_handle, ':p_end_date', p_end_date);
760:
761: --dbms_output.put_line('About to define numeric columns.');
762: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);
763: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);

Line 762: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);

758: dbms_sql.bind_variable(l_cur_handle, ':p_start_date', p_start_date);
759: dbms_sql.bind_variable(l_cur_handle, ':p_end_date', p_end_date);
760:
761: --dbms_output.put_line('About to define numeric columns.');
762: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);
763: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);
764: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);
765: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);
766: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);

Line 763: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);

759: dbms_sql.bind_variable(l_cur_handle, ':p_end_date', p_end_date);
760:
761: --dbms_output.put_line('About to define numeric columns.');
762: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);
763: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);
764: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);
765: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);
766: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);
767:

Line 764: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);

760:
761: --dbms_output.put_line('About to define numeric columns.');
762: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);
763: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);
764: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);
765: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);
766: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);
767:
768: -- dbms_output.put_line('About to define Date columns.');

Line 765: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);

761: --dbms_output.put_line('About to define numeric columns.');
762: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);
763: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);
764: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);
765: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);
766: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);
767:
768: -- dbms_output.put_line('About to define Date columns.');
769: --dbms_output.put_line('After calling the Table_Insert Procedure');

Line 766: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);

762: dbms_sql.define_column(l_cur_handle, 1, l_Assignment_ID);
763: dbms_sql.define_column(l_cur_handle, 2, l_Organization_ID);
764: dbms_sql.define_column(l_cur_handle, 3, l_Person_ID);
765: dbms_sql.define_column(l_cur_handle, 4, l_Element_Type_ID);
766: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);
767:
768: -- dbms_output.put_line('About to define Date columns.');
769: --dbms_output.put_line('After calling the Table_Insert Procedure');
770: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);

Line 770: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);

766: dbms_sql.define_column(l_cur_handle, 5, l_Schedule_Line_ID);
767:
768: -- dbms_output.put_line('About to define Date columns.');
769: --dbms_output.put_line('After calling the Table_Insert Procedure');
770: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);
771: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);
772: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
773: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
774:

Line 771: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);

767:
768: -- dbms_output.put_line('About to define Date columns.');
769: --dbms_output.put_line('After calling the Table_Insert Procedure');
770: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);
771: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);
772: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
773: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
774:
775: l_total_rows := dbms_sql.execute(l_cur_handle);

Line 772: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);

768: -- dbms_output.put_line('About to define Date columns.');
769: --dbms_output.put_line('After calling the Table_Insert Procedure');
770: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);
771: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);
772: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
773: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
774:
775: l_total_rows := dbms_sql.execute(l_cur_handle);
776: while dbms_sql.fetch_rows(l_cur_handle) > 0

Line 773: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);

769: --dbms_output.put_line('After calling the Table_Insert Procedure');
770: dbms_sql.define_column(l_cur_handle, 6, l_Schedule_Begin_Date);
771: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);
772: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
773: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
774:
775: l_total_rows := dbms_sql.execute(l_cur_handle);
776: while dbms_sql.fetch_rows(l_cur_handle) > 0
777: LOOP

Line 775: l_total_rows := dbms_sql.execute(l_cur_handle);

771: dbms_sql.define_column(l_cur_handle, 7, l_Schedule_End_Date);
772: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
773: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
774:
775: l_total_rows := dbms_sql.execute(l_cur_handle);
776: while dbms_sql.fetch_rows(l_cur_handle) > 0
777: LOOP
778: -- dbms_output.put_line('Inside Loop of ET Schedules');
779: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);

Line 776: while dbms_sql.fetch_rows(l_cur_handle) > 0

772: dbms_sql.define_column(l_cur_handle, 8, l_Time_Period_Start_Date);
773: dbms_sql.define_column(l_cur_handle, 9, l_Time_Period_End_Date);
774:
775: l_total_rows := dbms_sql.execute(l_cur_handle);
776: while dbms_sql.fetch_rows(l_cur_handle) > 0
777: LOOP
778: -- dbms_output.put_line('Inside Loop of ET Schedules');
779: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
780: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);

Line 779: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);

775: l_total_rows := dbms_sql.execute(l_cur_handle);
776: while dbms_sql.fetch_rows(l_cur_handle) > 0
777: LOOP
778: -- dbms_output.put_line('Inside Loop of ET Schedules');
779: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
780: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
781: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
782: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
783: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);

Line 780: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);

776: while dbms_sql.fetch_rows(l_cur_handle) > 0
777: LOOP
778: -- dbms_output.put_line('Inside Loop of ET Schedules');
779: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
780: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
781: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
782: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
783: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
784: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);

Line 781: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);

777: LOOP
778: -- dbms_output.put_line('Inside Loop of ET Schedules');
779: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
780: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
781: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
782: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
783: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
784: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
785: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);

Line 782: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);

778: -- dbms_output.put_line('Inside Loop of ET Schedules');
779: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
780: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
781: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
782: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
783: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
784: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
785: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
786: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);

Line 783: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);

779: dbms_sql.column_value(l_cur_handle, 1, l_Assignment_ID);
780: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
781: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
782: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
783: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
784: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
785: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
786: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);
787: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);

Line 784: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);

780: dbms_sql.column_value(l_cur_handle, 2, l_Organization_ID);
781: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
782: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
783: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
784: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
785: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
786: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);
787: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);
788:

Line 785: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);

781: dbms_sql.column_value(l_cur_handle, 3, l_Person_ID);
782: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
783: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
784: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
785: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
786: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);
787: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);
788:
789: retVal := Process_Glob_Elem_Schedule(l_Assignment_ID, l_Element_Type_ID,

Line 786: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);

782: dbms_sql.column_value(l_cur_handle, 4, l_Element_Type_ID);
783: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
784: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
785: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
786: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);
787: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);
788:
789: retVal := Process_Glob_Elem_Schedule(l_Assignment_ID, l_Element_Type_ID,
790: l_Time_Period_Start_Date, l_Time_Period_End_Date, l_GE_Period1_Start,

Line 787: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);

783: dbms_sql.column_value(l_cur_handle, 5, l_Schedule_Line_ID);
784: dbms_sql.column_value(l_cur_handle, 6, l_Schedule_Begin_Date);
785: dbms_sql.column_value(l_cur_handle, 7, l_Schedule_End_Date);
786: dbms_sql.column_value(l_cur_handle, 8, l_Time_Period_Start_Date);
787: dbms_sql.column_value(l_cur_handle, 9, l_Time_Period_End_Date);
788:
789: retVal := Process_Glob_Elem_Schedule(l_Assignment_ID, l_Element_Type_ID,
790: l_Time_Period_Start_Date, l_Time_Period_End_Date, l_GE_Period1_Start,
791: l_GE_Period1_End, l_GE_Period2_Start, l_GE_Period2_End);

Line 1106: dbms_sql.close_cursor(l_cur_handle);

1102: End If;
1103: End If;
1104:
1105: END LOOP;
1106: dbms_sql.close_cursor(l_cur_handle);
1107:
1108: End Process_All_ET_Schedules;
1109: /*******************************************************************************************************
1110: This is a private procedure that is called to actually insert data to the intermediate