DBA Data[Home] [Help]

APPS.PA_SCHEDULE_UTILS dependencies on PA_SCHEDULE_GLOB

Line 4: PROCEDURE copy_schedule_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

1: PACKAGE PA_SCHEDULE_UTILS as
2: /* $Header: PARGUTLS.pls 120.1 2005/08/19 16:53:47 mwasowic noship $ */
3:
4: PROCEDURE copy_schedule_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
5: p_start_id IN NUMBER,
6: p_end_id IN NUMBER,
7: x_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
8: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 7: x_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

3:
4: PROCEDURE copy_schedule_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
5: p_start_id IN NUMBER,
6: p_end_id IN NUMBER,
7: x_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
8: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
10: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
11:

Line 19: PROCEDURE add_schedule_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

15: -- array processing.
16: -- Parameters :
17: -- p_sch_record_tab - Table of schedule details Records
18:
19: PROCEDURE add_schedule_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
20: p_start_id IN NUMBER,
21: p_end_id IN NUMBER,
22: px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
23: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 22: px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

18:
19: PROCEDURE add_schedule_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
20: p_start_id IN NUMBER,
21: p_end_id IN NUMBER,
22: px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
23: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
24: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
25: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
26:

Line 36: px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

32: -- p_sch_record_tab - Table of schedule details Records
33:
34: PROCEDURE mark_del_sch_rec_tab ( p_start_id IN NUMBER,
35: p_end_id IN NUMBER,
36: px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
37: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
38: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
39: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
40:

Line 48: PROCEDURE sep_del_sch_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,

44: -- array processing.
45: -- Parameters :
46: -- px_sch_record_tab - Table of schedule details Records
47:
48: PROCEDURE sep_del_sch_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
49: x_del_sch_rec_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
50: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
51: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
52: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 49: x_del_sch_rec_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

45: -- Parameters :
46: -- px_sch_record_tab - Table of schedule details Records
47:
48: PROCEDURE sep_del_sch_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
49: x_del_sch_rec_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
50: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
51: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
52: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
53: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 50: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

46: -- px_sch_record_tab - Table of schedule details Records
47:
48: PROCEDURE sep_del_sch_rec_tab ( p_sch_record_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp,
49: x_del_sch_rec_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
50: x_sch_record_tab OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
51: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
52: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
53: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
54:

Line 62: PROCEDURE update_sch_rec_tab ( px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

58: -- array processing.
59: -- Parameters :
60: -- p_sch_record_tab - Table of schedule details Records
61:
62: PROCEDURE update_sch_rec_tab ( px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
63: p_project_id IN NUMBER DEFAULT NULL,
64: p_calendar_id IN NUMBER DEFAULT NULL,
65: p_assignment_id IN NUMBER DEFAULT NULL,
66: p_schedule_type_code IN VARCHAR2 DEFAULT NULL,

Line 90: PROCEDURE apply_percentage ( px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,

86: -- array processing.
87: -- Parameters :
88: -- px_sch_record_tab - Table of schedule details Records
89:
90: PROCEDURE apply_percentage ( px_sch_record_tab IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleTabTyp,
91: p_percentage IN NUMBER ,
92: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
93: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
94: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 104: PROCEDURE copy_except_record ( p_except_record IN PA_SCHEDULE_GLOB.SchExceptRecord,

100: -- array processing.
101: -- Parameters :
102: -- px_sch_record_tab - Table of schedule details Records
103:
104: PROCEDURE copy_except_record ( p_except_record IN PA_SCHEDULE_GLOB.SchExceptRecord,
105: x_except_record OUT NOCOPY PA_SCHEDULE_GLOB.SchExceptRecord,
106: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
107: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
108: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 105: x_except_record OUT NOCOPY PA_SCHEDULE_GLOB.SchExceptRecord,

101: -- Parameters :
102: -- px_sch_record_tab - Table of schedule details Records
103:
104: PROCEDURE copy_except_record ( p_except_record IN PA_SCHEDULE_GLOB.SchExceptRecord,
105: x_except_record OUT NOCOPY PA_SCHEDULE_GLOB.SchExceptRecord,
106: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
107: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
108: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
109:

Line 115: PROCEDURE update_except_record( px_except_record IN OUT NOCOPY PA_SCHEDULE_GLOB.SchExceptRecord,

111: -- Procedure : Copy_Except_Record
112: -- Purpose :It copy the record in array processing.
113: -- Parameters :
114:
115: PROCEDURE update_except_record( px_except_record IN OUT NOCOPY PA_SCHEDULE_GLOB.SchExceptRecord,
116: p_project_id IN NUMBER DEFAULT NULL,
117: p_calendar_id IN NUMBER DEFAULT NULL,
118: p_assignment_id IN NUMBER DEFAULT NULL,
119: p_schedule_type_code IN VARCHAR2 DEFAULT NULL,

Line 159: wr_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp);

155: PROCEDURE debug(p_msg IN VARCHAR2);
156:
157: PROCEDURE log_message( level1 IN NUMBER,
158: msg1 IN VARCHAR2,
159: wr_tab IN PA_SCHEDULE_GLOB.ScheduleTabTyp);
160: --
161: -- Procedure : Log_message
162: -- Purpose : This procedure will print value of structure of passing array with the given lavel
163: -- it is oveloaded procedure