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.PA_SCHEDULE_PVT dependencies on PA_SCHEDULE_GLOB

Line 29: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

25: PROCEDURE get_existing_schedule ( p_calendar_id IN NUMBER,
26: p_assignment_id IN NUMBER,
27: p_start_date IN DATE,
28: p_end_date IN DATE,
29: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
30: x_difference_days IN NUMBER,
31: x_shift_unit_code IN VARCHAR2,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,

Line 42: l_curr_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;

38:
39: l_st_dt_done BOOLEAN; -- Temp variable
40: l_end_dt_done BOOLEAN; -- Temp variable
41: l_x_sch_copy_done BOOLEAN; -- Temp variable
42: l_curr_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
43: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
44: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
45:
46:

Line 43: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;

39: l_st_dt_done BOOLEAN; -- Temp variable
40: l_end_dt_done BOOLEAN; -- Temp variable
41: l_x_sch_copy_done BOOLEAN; -- Temp variable
42: l_curr_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
43: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
44: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
45:
46:
47: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES.calendar_id%TYPE

Line 44: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;

40: l_end_dt_done BOOLEAN; -- Temp variable
41: l_x_sch_copy_done BOOLEAN; -- Temp variable
42: l_curr_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
43: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
44: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
45:
46:
47: TYPE calendar_id_tbl IS TABLE OF PA_SCHEDULES.calendar_id%TYPE
48: INDEX BY BINARY_INTEGER;

Line 195: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

191:
192: PROCEDURE get_calendar_schedule ( p_calendar_id IN NUMBER,
193: p_start_date IN DATE,
194: p_end_date IN DATE,
195: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
196: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
197: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
198: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
199: IS

Line 206: l_curr_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;

202:
203: l_st_dt_done BOOLEAN; -- Temp variable
204: l_end_dt_done BOOLEAN; -- Temp variable
205: l_x_sch_copy_done BOOLEAN; -- Temp variable
206: l_curr_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
207: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
208: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
209:
210: -- This cursor will select the schedule records of the passing calendar

Line 207: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;

203: l_st_dt_done BOOLEAN; -- Temp variable
204: l_end_dt_done BOOLEAN; -- Temp variable
205: l_x_sch_copy_done BOOLEAN; -- Temp variable
206: l_curr_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
207: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
208: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
209:
210: -- This cursor will select the schedule records of the passing calendar
211: /* Bug - 1846658- Following lines are commented to incorporate the BULK SELECT to enhance the performance*/

Line 208: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;

204: l_end_dt_done BOOLEAN; -- Temp variable
205: l_x_sch_copy_done BOOLEAN; -- Temp variable
206: l_curr_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
207: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
208: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
209:
210: -- This cursor will select the schedule records of the passing calendar
211: /* Bug - 1846658- Following lines are commented to incorporate the BULK SELECT to enhance the performance*/
212:

Line 468: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

464:
465: PROCEDURE get_assignment_schedule ( p_assignment_id IN NUMBER,
466: p_start_date IN DATE,
467: p_end_date IN DATE,
468: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
469: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
470: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
471: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
472: IS

Line 479: l_curr_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;

475:
476: l_st_dt_done BOOLEAN;
477: l_end_dt_done BOOLEAN;
478: l_x_sch_copy_done BOOLEAN;
479: l_curr_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
480: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
481: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
482:
483: -- This cursor will select only those records of passing assignment which are open or staffed.

Line 480: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;

476: l_st_dt_done BOOLEAN;
477: l_end_dt_done BOOLEAN;
478: l_x_sch_copy_done BOOLEAN;
479: l_curr_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
480: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
481: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
482:
483: -- This cursor will select only those records of passing assignment which are open or staffed.
484: -- 1561861 Added 'STAFFED_ADMIN_ASSIGNMENT' to the where clause'.

Line 481: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;

477: l_end_dt_done BOOLEAN;
478: l_x_sch_copy_done BOOLEAN;
479: l_curr_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
480: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
481: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
482:
483: -- This cursor will select only those records of passing assignment which are open or staffed.
484: -- 1561861 Added 'STAFFED_ADMIN_ASSIGNMENT' to the where clause'.
485: /* Bug - 1846658- Following lines are commented to incorporate the BULK SELECT to enhance the performance*/

Line 889: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

885: -- X_Sch_Record_Tab SCHEDULETABTYP YES It stores schedule for that assignment
886: --
887:
888: PROCEDURE get_assignment_schedule ( p_assignment_id IN NUMBER,
889: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
890: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
891: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
892: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
893: IS

Line 899: l_curr_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;

895: J NUMBER;
896: l_st_dt_done BOOLEAN;
897: l_end_dt_done BOOLEAN;
898: l_x_sch_copy_done BOOLEAN;
899: l_curr_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
900: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
901: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
902:
903: -- This cursor will select the schedule records corresponding to the passing assignment id

Line 900: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;

896: l_st_dt_done BOOLEAN;
897: l_end_dt_done BOOLEAN;
898: l_x_sch_copy_done BOOLEAN;
899: l_curr_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
900: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
901: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
902:
903: -- This cursor will select the schedule records corresponding to the passing assignment id
904: -- 1561861 Added 'STAFFED_ADMIN_ASSIGNMENT' to the where clause.

Line 901: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;

897: l_end_dt_done BOOLEAN;
898: l_x_sch_copy_done BOOLEAN;
899: l_curr_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
900: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
901: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
902:
903: -- This cursor will select the schedule records corresponding to the passing assignment id
904: -- 1561861 Added 'STAFFED_ADMIN_ASSIGNMENT' to the where clause.
905: /* Bug - 1846658- Following lines are commented to incorporate the BULK SELECT to enhance the performance*/

Line 1109: x_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

1105: PROCEDURE get_resource_schedule ( p_source_id IN NUMBER,
1106: p_source_type IN VARCHAR2,
1107: p_start_date IN DATE,
1108: p_end_date IN DATE,
1109: x_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
1110: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1111: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1112: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
1113: IS

Line 1131: l_cur_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;

1127: l_tc_start_date DATE;
1128:
1129: l_invalid_source_id EXCEPTION;
1130:
1131: l_cur_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
1132: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
1133: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
1134:
1135: -- jmarques: 1786935: Modified cursor to include resource_type_code

Line 1132: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;

1128:
1129: l_invalid_source_id EXCEPTION;
1130:
1131: l_cur_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
1132: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
1133: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
1134:
1135: -- jmarques: 1786935: Modified cursor to include resource_type_code
1136: -- since resource_id is not unique. Also, added calendar_id > 0

Line 1133: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;

1129: l_invalid_source_id EXCEPTION;
1130:
1131: l_cur_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
1132: l_out_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
1133: l_temp_schedule_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
1134:
1135: -- jmarques: 1786935: Modified cursor to include resource_type_code
1136: -- since resource_id is not unique. Also, added calendar_id > 0
1137: -- condition so that calendar_id, resource_id index would be used.

Line 1174: l_Sch_Record_Tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

1170: -- jmarques: 2196924: local vars
1171: l_ResStartDateTab PA_FORECAST_GLOB.DateTabTyp;
1172: l_ResEndDateTab PA_FORECAST_GLOB.DateTabTyp;
1173: i NUMBER;
1174: l_Sch_Record_Tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
1175: l_cap_start_date DATE;
1176: l_cap_end DATE;
1177: l_cap_start_index NUMBER;
1178: l_cap_end_index NUMBER;

Line 1943: PROCEDURE apply_schedule_change( p_chg_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

1939: -- e.g I , U
1940: -- P_Del_Sch_Record_Tab SCHEDULETABTYP YES It has the schedule record which are marked for deletion
1941: --
1942:
1943: PROCEDURE apply_schedule_change( p_chg_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
1944: p_del_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
1945: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1946: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1947: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 1944: p_del_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

1940: -- P_Del_Sch_Record_Tab SCHEDULETABTYP YES It has the schedule record which are marked for deletion
1941: --
1942:
1943: PROCEDURE apply_schedule_change( p_chg_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
1944: p_del_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
1945: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1946: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1947: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
1948: IS

Line 1950: l_upd_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- variable used for storing the records kept for updation

1946: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1947: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
1948: IS
1949: l_I NUMBER;
1950: l_upd_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- variable used for storing the records kept for updation
1951: l_ins_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- variable used for storing the records kept for insertion
1952: BEGIN
1953: -- storing status for tracking the error
1954: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1951: l_ins_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- variable used for storing the records kept for insertion

1947: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
1948: IS
1949: l_I NUMBER;
1950: l_upd_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- variable used for storing the records kept for updation
1951: l_ins_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- variable used for storing the records kept for insertion
1952: BEGIN
1953: -- storing status for tracking the error
1954: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1955: -- checking if the passing records is empty or not

Line 2034: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

2030: -- X_Sch_Record_Tab SCHEDULETABTYP YES It store the new schedule
2031: --
2032:
2033: PROCEDURE create_new_schedule(
2034: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2035: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2036: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2037: x_difference_days IN NUMBER, -- Added for bug 7663765
2038: x_shift_unit_code IN VARCHAR2, -- Added for bug 7663765

Line 2035: p_sch_record IN pa_schedule_glob.ScheduleRecord,

2031: --
2032:
2033: PROCEDURE create_new_schedule(
2034: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2035: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2036: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2037: x_difference_days IN NUMBER, -- Added for bug 7663765
2038: x_shift_unit_code IN VARCHAR2, -- Added for bug 7663765
2039: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 2036: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

2032:
2033: PROCEDURE create_new_schedule(
2034: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2035: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2036: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2037: x_difference_days IN NUMBER, -- Added for bug 7663765
2038: x_shift_unit_code IN VARCHAR2, -- Added for bug 7663765
2039: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2040: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2153: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

2149: -- X_Sch_Record_Tab SCHEDULETABTYP YES It store the new schedule
2150: --
2151:
2152: PROCEDURE create_new_calendar(
2153: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2154: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2155: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2156: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2157: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2154: p_sch_record IN pa_schedule_glob.ScheduleRecord,

2150: --
2151:
2152: PROCEDURE create_new_calendar(
2153: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2154: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2155: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2156: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2157: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2158: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2155: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

2151:
2152: PROCEDURE create_new_calendar(
2153: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2154: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2155: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2156: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2157: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2158: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2159: )

Line 2221: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

2217: -- X_Sch_Record_Tab SCHEDULETABTYP YES It store the new schedule
2218: --
2219:
2220: PROCEDURE create_new_hours(
2221: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2222: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2223: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2224: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2225: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2222: p_sch_record IN pa_schedule_glob.ScheduleRecord,

2218: --
2219:
2220: PROCEDURE create_new_hours(
2221: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2222: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2223: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2224: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2225: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2226: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 2223: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

2219:
2220: PROCEDURE create_new_hours(
2221: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2222: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2223: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2224: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2225: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2226: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
2227: IS

Line 2511: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

2507: -- X_Sch_Record_Tab SCHEDULETABTYP YES It store the new schedule
2508: --
2509:
2510: PROCEDURE create_new_duration(
2511: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2512: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2513: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2514: x_difference_days IN NUMBER, -- Added for bug 7663765
2515: x_shift_unit_code IN VARCHAR2, -- Added for bug 7663765

Line 2512: p_sch_record IN pa_schedule_glob.ScheduleRecord,

2508: --
2509:
2510: PROCEDURE create_new_duration(
2511: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2512: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2513: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2514: x_difference_days IN NUMBER, -- Added for bug 7663765
2515: x_shift_unit_code IN VARCHAR2, -- Added for bug 7663765
2516: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 2513: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

2509:
2510: PROCEDURE create_new_duration(
2511: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2512: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2513: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2514: x_difference_days IN NUMBER, -- Added for bug 7663765
2515: x_shift_unit_code IN VARCHAR2, -- Added for bug 7663765
2516: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2517: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2675: l_temp_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

2671: where project_id = p_project_id and
2672: assignment_id = p_assignment_id
2673: order by start_date;
2674:
2675: l_temp_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2676: l_del_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2677: l_final_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2678:
2679: l_I NUMBER;

Line 2676: l_del_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

2672: assignment_id = p_assignment_id
2673: order by start_date;
2674:
2675: l_temp_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2676: l_del_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2677: l_final_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2678:
2679: l_I NUMBER;
2680: l_J NUMBER;

Line 2677: l_final_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

2673: order by start_date;
2674:
2675: l_temp_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2676: l_del_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2677: l_final_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
2678:
2679: l_I NUMBER;
2680: l_J NUMBER;
2681: l_K NUMBER;

Line 2864: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

2860: -- X_Sch_Record_Tab SCHEDULETABTYP YES It store the new schedule
2861: --
2862:
2863: PROCEDURE create_new_pattern(
2864: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2865: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2866: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2867: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2868: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2865: p_sch_record IN pa_schedule_glob.ScheduleRecord,

2861: --
2862:
2863: PROCEDURE create_new_pattern(
2864: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2865: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2866: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2867: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2868: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2869: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2866: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

2862:
2863: PROCEDURE create_new_pattern(
2864: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2865: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2866: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2867: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2868: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2869: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2870: )

Line 2923: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

2919: -- X_Sch_Record_Tab SCHEDULETABTYP YES It store the new schedule
2920: --
2921:
2922: PROCEDURE create_new_status(
2923: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2924: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2925: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2926: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2927: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2924: p_sch_record IN pa_schedule_glob.ScheduleRecord,

2920: --
2921:
2922: PROCEDURE create_new_status(
2923: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2924: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2925: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2926: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2927: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2928: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2925: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

2921:
2922: PROCEDURE create_new_status(
2923: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2924: p_sch_record IN pa_schedule_glob.ScheduleRecord,
2925: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2926: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2927: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2928: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2929: )

Line 2994: ( p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,

2990: -- X_Sch_Record_Tab SCHEDULETABTYP YES It store the new schedule
2991: --
2992:
2993: PROCEDURE apply_change_duration
2994: ( p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,
2995: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2996: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2997: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2998: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2995: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

2991: --
2992:
2993: PROCEDURE apply_change_duration
2994: ( p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,
2995: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2996: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2997: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2998: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2999: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 2996: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

2992:
2993: PROCEDURE apply_change_duration
2994: ( p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,
2995: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
2996: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
2997: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2998: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2999: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3000: IS

Line 3001: l_temp_p_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

2997: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2998: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2999: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3000: IS
3001: l_temp_p_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3002: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3003: l_temp_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3004: l_temp_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
3005: l_I NUMBER;

Line 3002: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

2998: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2999: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3000: IS
3001: l_temp_p_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3002: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3003: l_temp_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3004: l_temp_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
3005: l_I NUMBER;
3006: l_temp_first NUMBER;

Line 3003: l_temp_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

2999: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3000: IS
3001: l_temp_p_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3002: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3003: l_temp_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3004: l_temp_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
3005: l_I NUMBER;
3006: l_temp_first NUMBER;
3007: l_temp_last NUMBER;

Line 3004: l_temp_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;

3000: IS
3001: l_temp_p_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3002: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3003: l_temp_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3004: l_temp_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
3005: l_I NUMBER;
3006: l_temp_first NUMBER;
3007: l_temp_last NUMBER;
3008: l_stat_date_done BOOLEAN;

Line 3413: ( p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,

3409: --
3410:
3411:
3412: PROCEDURE apply_other_changes
3413: ( p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,
3414: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
3415: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
3416: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3417: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3414: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,

3410:
3411:
3412: PROCEDURE apply_other_changes
3413: ( p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,
3414: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
3415: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
3416: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3417: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3418: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 3415: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,

3411:
3412: PROCEDURE apply_other_changes
3413: ( p_sch_record_tab IN pa_schedule_glob.ScheduleTabTyp,
3414: p_sch_except_record IN pa_schedule_glob.SchExceptRecord,
3415: x_sch_record_tab IN OUT NOCOPY pa_schedule_glob.ScheduleTabTyp,
3416: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3417: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3418: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3419: IS

Line 3421: l_temp_p_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

3417: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3418: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3419: IS
3420:
3421: l_temp_p_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3422: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3423: l_temp_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3424: l_temp_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
3425: l_I NUMBER;

Line 3422: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

3418: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3419: IS
3420:
3421: l_temp_p_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3422: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3423: l_temp_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3424: l_temp_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
3425: l_I NUMBER;
3426: l_sch_first NUMBER;

Line 3423: l_temp_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

3419: IS
3420:
3421: l_temp_p_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3422: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3423: l_temp_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3424: l_temp_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
3425: l_I NUMBER;
3426: l_sch_first NUMBER;
3427: l_sch_last NUMBER;

Line 3424: l_temp_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;

3420:
3421: l_temp_p_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3422: l_out_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3423: l_temp_tr_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
3424: l_temp_except_rec PA_SCHEDULE_GLOB.SchExceptRecord;
3425: l_I NUMBER;
3426: l_sch_first NUMBER;
3427: l_sch_last NUMBER;
3428: l_chg_exp_start_date DATE;

Line 3681: chg_tr_sch_rec_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

3677: --
3678:
3679: PROCEDURE apply_assignment_change (
3680: p_record_version_number IN NUMBER,
3681: chg_tr_sch_rec_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
3682: sch_except_record_tab IN PA_SCHEDULE_GLOB.SchExceptTabTyp,
3683: p_called_by_proj_party IN VARCHAR2 := 'N', -- Added for Bug 6631033
3684: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3685: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3682: sch_except_record_tab IN PA_SCHEDULE_GLOB.SchExceptTabTyp,

3678:
3679: PROCEDURE apply_assignment_change (
3680: p_record_version_number IN NUMBER,
3681: chg_tr_sch_rec_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
3682: sch_except_record_tab IN PA_SCHEDULE_GLOB.SchExceptTabTyp,
3683: p_called_by_proj_party IN VARCHAR2 := 'N', -- Added for Bug 6631033
3684: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3685: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3686: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 4042: l_x_schedule_tab_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;

4038: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4039: )
4040: IS
4041:
4042: l_x_schedule_tab_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
4043: l_new_schedule_tab_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
4044:
4045: l_start_date DATE;
4046: l_end_date DATE;

Line 4043: l_new_schedule_tab_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;

4039: )
4040: IS
4041:
4042: l_x_schedule_tab_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
4043: l_new_schedule_tab_rec PA_SCHEDULE_GLOB.ScheduleTabTyp;
4044:
4045: l_start_date DATE;
4046: l_end_date DATE;
4047:

Line 4242: l_x_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

4238: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
4239:
4240: l_assignment_id PA_PROJECT_ASSIGNMENTS.assignment_id%TYPE;
4241: l_assignment_id_tbl PA_ASSIGNMENTS_PUB.assignment_id_tbl_type;
4242: l_x_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
4243: l_current_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
4244: l_temp_number NUMBER;
4245: BEGIN
4246: l_assignment_id_tbl := p_assignment_id_tbl;

Line 4243: l_current_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

4239:
4240: l_assignment_id PA_PROJECT_ASSIGNMENTS.assignment_id%TYPE;
4241: l_assignment_id_tbl PA_ASSIGNMENTS_PUB.assignment_id_tbl_type;
4242: l_x_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
4243: l_current_sch_rec_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
4244: l_temp_number NUMBER;
4245: BEGIN
4246: l_assignment_id_tbl := p_assignment_id_tbl;
4247: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4556: l_x_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- Temporary variable to store the

4552: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4553: )
4554: IS
4555:
4556: l_x_sch_record_tab PA_SCHEDULE_GLOB.ScheduleTabTyp; -- Temporary variable to store the
4557: -- schedule type table of records
4558:
4559: l_req_start_date PA_PROJECT_ASSIGNMENTS.start_date%TYPE;
4560: l_req_end_date pa_project_assignments.end_date%TYPE;

Line 4563: l_new_schedule_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;

4559: l_req_start_date PA_PROJECT_ASSIGNMENTS.start_date%TYPE;
4560: l_req_end_date pa_project_assignments.end_date%TYPE;
4561: l_calendar_id pa_project_assignments.calendar_id%TYPE;
4562:
4563: l_new_schedule_tab PA_SCHEDULE_GLOB.ScheduleTabTyp;
4564:
4565: l_start_date DATE;
4566: l_end_date DATE;
4567: l_total_hours NUMBER; -- Bug 5126919

Line 8020: p_schedule_tbl IN PA_SCHEDULE_GLOB.ScheduleTabTyp ,

8016: --Bug 5126919: Added parameter x_total_hours which will contain the total hours for which the x_schedule_tbl
8017: --will be prepared.
8018: PROCEDURE sum_task_assignments (
8019: p_task_assignments_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
8020: p_schedule_tbl IN PA_SCHEDULE_GLOB.ScheduleTabTyp ,
8021: p_start_date IN DATE ,
8022: p_end_date IN DATE ,
8023: x_total_hours OUT NOCOPY NUMBER , -- Bug 5126919
8024: x_schedule_tbl OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp , --File.Sql.39 bug 4440895

Line 8024: x_schedule_tbl OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp , --File.Sql.39 bug 4440895

8020: p_schedule_tbl IN PA_SCHEDULE_GLOB.ScheduleTabTyp ,
8021: p_start_date IN DATE ,
8022: p_end_date IN DATE ,
8023: x_total_hours OUT NOCOPY NUMBER , -- Bug 5126919
8024: x_schedule_tbl OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp , --File.Sql.39 bug 4440895
8025: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
8026: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
8027: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8028: )

Line 8081: l_schedule_record PA_SCHEDULE_GLOB.ScheduleRecord;

8077: summation_counter NUMBER;
8078: schedule_counter NUMBER;
8079: task_counter NUMBER;
8080:
8081: l_schedule_record PA_SCHEDULE_GLOB.ScheduleRecord;
8082: l_empty_schedule_record PA_SCHEDULE_GLOB.ScheduleRecord;
8083: l_debug_mode VARCHAR2(20) := 'N'; -- 4387388
8084:
8085: CURSOR C1 IS

Line 8082: l_empty_schedule_record PA_SCHEDULE_GLOB.ScheduleRecord;

8078: schedule_counter NUMBER;
8079: task_counter NUMBER;
8080:
8081: l_schedule_record PA_SCHEDULE_GLOB.ScheduleRecord;
8082: l_empty_schedule_record PA_SCHEDULE_GLOB.ScheduleRecord;
8083: l_debug_mode VARCHAR2(20) := 'N'; -- 4387388
8084:
8085: CURSOR C1 IS
8086: SELECT a.start_date, a.end_date, NVL(a.quantity,0),

Line 8390: -- P_Schedule_Tbl PA_SCHEDULE_GLOB.ScheduleRecord YES Schedule Record

8386:
8387: -- This procedure sets the number of hours in a given schedule record for a particular day of the week
8388: -- Input parameters
8389: -- Parameters Type Required Description
8390: -- P_Schedule_Tbl PA_SCHEDULE_GLOB.ScheduleRecord YES Schedule Record
8391: -- P_Day_Of_Week PA_SCHEDULE_PVT.DayOfWeekType YES Day of the week
8392: -- P_Hours NUMBER YES Hours for that day
8393: --
8394: -- Out parameters

Line 8397: p_schedule_record IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleRecord ,

8393: --
8394: -- Out parameters
8395: --
8396: PROCEDURE set_hours_by_day_of_week (
8397: p_schedule_record IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleRecord ,
8398: p_day_of_week IN PA_SCHEDULE_PVT.DayOfWeekType ,
8399: p_hours IN NUMBER) IS
8400: BEGIN
8401: IF p_day_of_week = 'MON' THEN

Line 9326: -- P_Schedule_Record PA_SCHEDULE_GLOB.ScheduleRecord YES Schedule Record

9322:
9323: -- This function returns the number of hours in a given schedule record for a particular day of the week
9324: -- Input parameters
9325: -- Parameters Type Required Description
9326: -- P_Schedule_Record PA_SCHEDULE_GLOB.ScheduleRecord YES Schedule Record
9327: -- P_Day_Of_Week PA_SCHEDULE_PVT.DayOfWeekType YES Day of the week
9328: --
9329: -- Out parameters
9330: -- NUMBER YES Number of hours schedule on that day

Line 9333: p_schedule_record IN PA_SCHEDULE_GLOB.ScheduleRecord ,

9329: -- Out parameters
9330: -- NUMBER YES Number of hours schedule on that day
9331: --
9332: FUNCTION get_hours_by_day_of_week (
9333: p_schedule_record IN PA_SCHEDULE_GLOB.ScheduleRecord ,
9334: p_day_of_week IN PA_SCHEDULE_PVT.DayOfWeekType )
9335: RETURN NUMBER IS
9336: l_hours NUMBER := 0;
9337: BEGIN