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_FORECASTITEM_PVT dependencies on PA_FORECAST_GLOB

Line 36: p_ErrHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,

32: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
33: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
34:
35: PROCEDURE Create_ForeCast_Item(
36: p_ErrHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
37: p_process_mode IN VARCHAR2,
38: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
39: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
40: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865

Line 53: x_AsgnDtlRec OUT NOCOPY PA_FORECAST_GLOB.AsgnDtlRecord, /* 2674619 - Nocopy change */

49: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
50:
51: PROCEDURE Get_Assignment_Dtls(
52: p_assignment_id IN NUMBER,
53: x_AsgnDtlRec OUT NOCOPY PA_FORECAST_GLOB.AsgnDtlRecord, /* 2674619 - Nocopy change */
54: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
55: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
56: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
57:

Line 70: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,

66: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
67: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
68:
69: PROCEDURE Generate_Requirement_FI(
70: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
71: p_process_mode IN VARCHAR2,
72: p_start_date IN DATE,
73: p_end_date IN DATE,
74: p_ErrHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,

Line 74: p_ErrHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,

70: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
71: p_process_mode IN VARCHAR2,
72: p_start_date IN DATE,
73: p_end_date IN DATE,
74: p_ErrHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
75: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
76: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
77: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
78:

Line 80: p_ScheduleTab IN PA_FORECAST_GLOB.SCHEDULETABTYP,

76: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
77: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
78:
79: PROCEDURE Initialize_Day_FI(
80: p_ScheduleTab IN PA_FORECAST_GLOB.SCHEDULETABTYP,
81: p_process_mode IN VARCHAR2,
82: p_start_date IN DATE,
83: p_end_date IN DATE,
84: x_FIDayTab OUT NOCOPY PA_FORECAST_GLOB.FIDaytabtyp, /* 2674619 - Nocopy change */

Line 84: x_FIDayTab OUT NOCOPY PA_FORECAST_GLOB.FIDaytabtyp, /* 2674619 - Nocopy change */

80: p_ScheduleTab IN PA_FORECAST_GLOB.SCHEDULETABTYP,
81: p_process_mode IN VARCHAR2,
82: p_start_date IN DATE,
83: p_end_date IN DATE,
84: x_FIDayTab OUT NOCOPY PA_FORECAST_GLOB.FIDaytabtyp, /* 2674619 - Nocopy change */
85: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
86: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
87: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
88:

Line 90: p_ScheduleTab IN PA_FORECAST_GLOB.SCHEDULETABTYP,

86: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
87: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
88:
89: PROCEDURE Build_Day_FI(
90: p_ScheduleTab IN PA_FORECAST_GLOB.SCHEDULETABTYP,
91: p_start_date IN DATE,
92: p_end_date IN DATE,
93: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDaytabtyp, /* 2674619 - Nocopy change */
94: p_AsgType IN VARCHAR2,

Line 93: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDaytabtyp, /* 2674619 - Nocopy change */

89: PROCEDURE Build_Day_FI(
90: p_ScheduleTab IN PA_FORECAST_GLOB.SCHEDULETABTYP,
91: p_start_date IN DATE,
92: p_end_date IN DATE,
93: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDaytabtyp, /* 2674619 - Nocopy change */
94: p_AsgType IN VARCHAR2,
95: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
96: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
97: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865

Line 122: x_dbFIHdrTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */

118: p_assignment_id IN NUMBER,
119: p_resource_id IN NUMBER,
120: p_start_date IN DATE,
121: p_end_date IN DATE,
122: x_dbFIHdrTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
123: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
124: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
125: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
126:

Line 132: x_dbFIDtlTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */

128: p_assignment_id IN NUMBER,
129: p_resource_id IN NUMBER,
130: p_start_date IN DATE,
131: p_end_date IN DATE,
132: x_dbFIDtlTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
133: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
134: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
135: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
136:

Line 138: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,

134: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
135: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
136:
137: PROCEDURE Build_FI_Hdr_Req(
138: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
139: p_DBHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
140: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */
141: x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
142: x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */

Line 139: p_DBHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,

135: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
136:
137: PROCEDURE Build_FI_Hdr_Req(
138: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
139: p_DBHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
140: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */
141: x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
142: x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
143: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865

Line 140: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */

136:
137: PROCEDURE Build_FI_Hdr_Req(
138: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
139: p_DBHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
140: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */
141: x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
142: x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
143: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
144: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865

Line 141: x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */

137: PROCEDURE Build_FI_Hdr_Req(
138: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
139: p_DBHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
140: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */
141: x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
142: x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
143: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
144: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
145: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865

Line 142: x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */

138: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
139: p_DBHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
140: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */
141: x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
142: x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
143: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
144: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
145: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
146:

Line 148: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,

144: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
145: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
146:
147: PROCEDURE Build_FI_Dtl_Req(
148: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
149: p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,
150: p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,
151: x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
152: x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */

Line 149: p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,

145: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
146:
147: PROCEDURE Build_FI_Dtl_Req(
148: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
149: p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,
150: p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,
151: x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
152: x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
153: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865

Line 150: p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,

146:
147: PROCEDURE Build_FI_Dtl_Req(
148: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
149: p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,
150: p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,
151: x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
152: x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
153: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
154: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865

Line 151: x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */

147: PROCEDURE Build_FI_Dtl_Req(
148: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
149: p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,
150: p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,
151: x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
152: x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
153: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
154: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
155: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865

Line 152: x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */

148: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
149: p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,
150: p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,
151: x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
152: x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
153: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
154: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
155: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
156:

Line 158: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,

154: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
155: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
156:
157: PROCEDURE Generate_Assignment_FI(
158: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
159: p_process_mode IN VARCHAR2,
160: p_start_date IN DATE,
161: p_end_date IN DATE,
162: p_ErrHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,

Line 162: p_ErrHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,

158: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
159: p_process_mode IN VARCHAR2,
160: p_start_date IN DATE,
161: p_end_date IN DATE,
162: p_ErrHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
163: x_res_start_date OUT NOCOPY DATE, --Bug: 4537865
164: x_res_end_date OUT NOCOPY DATE, --Bug: 4537865
165: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
166: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865

Line 217: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,

213: x_msg_data OUT NOCOPY VARCHAR2);
214: --Bug: 4537865
215:
216: PROCEDURE Build_FI_Hdr_Asg(
217: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
218: p_DBHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
219: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */
220: x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
221: x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */

Line 218: p_DBHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,

214: --Bug: 4537865
215:
216: PROCEDURE Build_FI_Hdr_Asg(
217: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
218: p_DBHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
219: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */
220: x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
221: x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
222: --Bug: 4537865

Line 219: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */

215:
216: PROCEDURE Build_FI_Hdr_Asg(
217: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
218: p_DBHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
219: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */
220: x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
221: x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
222: --Bug: 4537865
223: x_return_status OUT NOCOPY VARCHAR2,

Line 220: x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */

216: PROCEDURE Build_FI_Hdr_Asg(
217: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
218: p_DBHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
219: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */
220: x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
221: x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
222: --Bug: 4537865
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,

Line 221: x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */

217: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
218: p_DBHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
219: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */
220: x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
221: x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
222: --Bug: 4537865
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,
225: x_msg_data OUT NOCOPY VARCHAR2);

Line 229: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,

225: x_msg_data OUT NOCOPY VARCHAR2);
226: --Bug: 4537865
227:
228: PROCEDURE Build_FI_Dtl_Asg(
229: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
230: p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,
231: p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,
232: x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
233: x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */

Line 230: p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,

226: --Bug: 4537865
227:
228: PROCEDURE Build_FI_Dtl_Asg(
229: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
230: p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,
231: p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,
232: x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
233: x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
234: --Bug: 4537865

Line 231: p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,

227:
228: PROCEDURE Build_FI_Dtl_Asg(
229: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
230: p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,
231: p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,
232: x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
233: x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
234: --Bug: 4537865
235: x_return_status OUT NOCOPY VARCHAR2,

Line 232: x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */

228: PROCEDURE Build_FI_Dtl_Asg(
229: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
230: p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,
231: p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,
232: x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
233: x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
234: --Bug: 4537865
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_count OUT NOCOPY NUMBER,

Line 233: x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */

229: p_asgndtlrec IN PA_FORECAST_GLOB.AsgnDtlRecord,
230: p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,
231: p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,
232: x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
233: x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
234: --Bug: 4537865
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_count OUT NOCOPY NUMBER,
237: x_msg_data OUT NOCOPY VARCHAR2);

Line 246: p_ErrHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,

242: p_resource_id IN NUMBER,
243: p_start_date IN OUT NOCOPY DATE, --Bug: 4537865
244: p_end_date IN OUT NOCOPY DATE, --Bug: 4537865
245: p_process_mode IN VARCHAR2,
246: p_ErrHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
247: p_date_validation IN VARCHAR2 := 'Y',
248: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
249: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
250: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865

Line 256: x_dbFIHdrTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */

252: PROCEDURE Fetch_FI_Hdr_Res(
253: p_resource_id IN NUMBER,
254: p_start_date IN DATE,
255: p_end_date IN DATE,
256: x_dbFIHdrTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
257: --Bug: 4537865
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2);

Line 267: x_dbFIDtlTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */

263: PROCEDURE Fetch_FI_Dtl_Res(
264: p_resource_id IN NUMBER,
265: p_start_date IN DATE,
266: p_end_date IN DATE,
267: x_dbFIDtlTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
268: x_return_status OUT NOCOPY VARCHAR2, --Bug: 4537865
269: x_msg_count OUT NOCOPY NUMBER, --Bug: 4537865
270: x_msg_data OUT NOCOPY VARCHAR2); --Bug: 4537865
271:

Line 276: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */

272: PROCEDURE Build_FI_Hdr_Res(
273: p_resource_id IN NUMBER,
274: p_start_date IN DATE,
275: p_end_date IN DATE,
276: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */
277: p_DBHdrTab IN PA_FORECAST_GLOB.FIHDRTabTyp,
278: x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
279: x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
280: --Bug: 4537865

Line 277: p_DBHdrTab IN PA_FORECAST_GLOB.FIHDRTabTyp,

273: p_resource_id IN NUMBER,
274: p_start_date IN DATE,
275: p_end_date IN DATE,
276: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */
277: p_DBHdrTab IN PA_FORECAST_GLOB.FIHDRTabTyp,
278: x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
279: x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
280: --Bug: 4537865
281: x_return_status OUT NOCOPY VARCHAR2,

Line 278: x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */

274: p_start_date IN DATE,
275: p_end_date IN DATE,
276: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */
277: p_DBHdrTab IN PA_FORECAST_GLOB.FIHDRTabTyp,
278: x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
279: x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
280: --Bug: 4537865
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,

Line 279: x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */

275: p_end_date IN DATE,
276: p_FIDayTab IN OUT NOCOPY PA_FORECAST_GLOB.FIDayTabTyp, /* 2674619 - Nocopy change */
277: p_DBHdrTab IN PA_FORECAST_GLOB.FIHDRTabTyp,
278: x_FIHdrInsTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
279: x_FIHdrUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIHdrTabTyp, /* 2674619 - Nocopy change */
280: --Bug: 4537865
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,
283: x_msg_data OUT NOCOPY VARCHAR2);

Line 288: p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,

284: --Bug: 4537865
285:
286: PROCEDURE Build_FI_Dtl_Res(
287: p_resource_id IN NUMBER,
288: p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,
289: p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,
290: x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
291: x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
292: --Bug: 4537865

Line 289: p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,

285:
286: PROCEDURE Build_FI_Dtl_Res(
287: p_resource_id IN NUMBER,
288: p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,
289: p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,
290: x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
291: x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
292: --Bug: 4537865
293: x_return_status OUT NOCOPY VARCHAR2,

Line 290: x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */

286: PROCEDURE Build_FI_Dtl_Res(
287: p_resource_id IN NUMBER,
288: p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,
289: p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,
290: x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
291: x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
292: --Bug: 4537865
293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,

Line 291: x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */

287: p_resource_id IN NUMBER,
288: p_DBDtlTab IN PA_FORECAST_GLOB.FIDtlTabTyp,
289: p_FIDayTab IN PA_FORECAST_GLOB.FIDayTabTyp,
290: x_FIDtlInsTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
291: x_FIDtlUpdTab OUT NOCOPY PA_FORECAST_GLOB.FIDtlTabTyp, /* 2674619 - Nocopy change */
292: --Bug: 4537865
293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,
295: x_msg_data OUT NOCOPY VARCHAR2);

Line 299: p_ErrHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,

295: x_msg_data OUT NOCOPY VARCHAR2);
296: --Bug: 4537865
297:
298: PROCEDURE Resource_UnAsg_Error_Process(
299: p_ErrHdrTab IN PA_FORECAST_GLOB.FIHdrTabTyp,
300: p_process_mode IN VARCHAR2,
301: --Bug: 4537865
302: x_return_status OUT NOCOPY VARCHAR2,
303: x_msg_count OUT NOCOPY NUMBER,

Line 308: p_AsgnDtlRec IN PA_FORECAST_GLOB.AsgnDtlRecord,

304: x_msg_data OUT NOCOPY VARCHAR2);
305: --Bug: 4537865
306:
307: PROCEDURE FI_Error_Process(
308: p_AsgnDtlRec IN PA_FORECAST_GLOB.AsgnDtlRecord,
309: p_Process_Mode IN VARCHAR2,
310: p_Start_date IN DATE,
311: p_End_date IN DATE,
312: --Bug: 4537865