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_PERIOD_MASKS_PKG dependencies on PA_PERIOD_MASKS_B

Line 5: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,

1: PACKAGE BODY PA_PERIOD_MASKS_PKG as
2: --$Header: PAFPPMTB.pls 120.2 2005/06/07 02:08:31 appldev $
3: PROCEDURE INSERT_ROW(
4: X_ROWID IN OUT NOCOPY rowid,
5: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
6: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
7: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
8: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
9: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,

Line 6: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,

2: --$Header: PAFPPMTB.pls 120.2 2005/06/07 02:08:31 appldev $
3: PROCEDURE INSERT_ROW(
4: X_ROWID IN OUT NOCOPY rowid,
5: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
6: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
7: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
8: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
9: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
10: X_CREATED_BY IN pa_period_masks_b.created_by%type,

Line 7: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,

3: PROCEDURE INSERT_ROW(
4: X_ROWID IN OUT NOCOPY rowid,
5: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
6: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
7: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
8: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
9: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
10: X_CREATED_BY IN pa_period_masks_b.created_by%type,
11: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,

Line 8: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,

4: X_ROWID IN OUT NOCOPY rowid,
5: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
6: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
7: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
8: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
9: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
10: X_CREATED_BY IN pa_period_masks_b.created_by%type,
11: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
12: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,

Line 9: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,

5: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
6: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
7: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
8: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
9: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
10: X_CREATED_BY IN pa_period_masks_b.created_by%type,
11: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
12: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
13: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,

Line 10: X_CREATED_BY IN pa_period_masks_b.created_by%type,

6: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
7: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
8: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
9: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
10: X_CREATED_BY IN pa_period_masks_b.created_by%type,
11: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
12: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
13: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
14: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,

Line 11: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,

7: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
8: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
9: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
10: X_CREATED_BY IN pa_period_masks_b.created_by%type,
11: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
12: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
13: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
14: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
15: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,

Line 12: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,

8: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
9: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
10: X_CREATED_BY IN pa_period_masks_b.created_by%type,
11: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
12: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
13: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
14: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
15: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
16: X_NAME IN pa_period_masks_tl.name%type,

Line 13: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,

9: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
10: X_CREATED_BY IN pa_period_masks_b.created_by%type,
11: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
12: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
13: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
14: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
15: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
16: X_NAME IN pa_period_masks_tl.name%type,
17: X_DESCRIPTION IN pa_period_masks_tl.description%type)

Line 14: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,

10: X_CREATED_BY IN pa_period_masks_b.created_by%type,
11: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
12: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
13: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
14: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
15: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
16: X_NAME IN pa_period_masks_tl.name%type,
17: X_DESCRIPTION IN pa_period_masks_tl.description%type)
18: IS

Line 15: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,

11: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
12: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
13: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
14: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
15: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
16: X_NAME IN pa_period_masks_tl.name%type,
17: X_DESCRIPTION IN pa_period_masks_tl.description%type)
18: IS
19:

Line 20: l_period_mask_id pa_period_masks_b.period_mask_id%type;

16: X_NAME IN pa_period_masks_tl.name%type,
17: X_DESCRIPTION IN pa_period_masks_tl.description%type)
18: IS
19:
20: l_period_mask_id pa_period_masks_b.period_mask_id%type;
21:
22:
23: CURSOR C IS SELECT ROWID FROM PA_PERIOD_MASKS_B
24: WHERE period_mask_id = l_period_mask_id;

Line 23: CURSOR C IS SELECT ROWID FROM PA_PERIOD_MASKS_B

19:
20: l_period_mask_id pa_period_masks_b.period_mask_id%type;
21:
22:
23: CURSOR C IS SELECT ROWID FROM PA_PERIOD_MASKS_B
24: WHERE period_mask_id = l_period_mask_id;
25:
26: BEGIN
27:

Line 32: INSERT INTO PA_PERIOD_MASKS_B(

28: SELECT NVL(x_period_mask_id,pa_period_masks_s.nextval)
29: INTO l_period_mask_id
30: FROM DUAL;
31:
32: INSERT INTO PA_PERIOD_MASKS_B(
33: period_mask_id,
34: effective_start_date,
35: effective_end_date,
36: time_phase_code,

Line 99: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type

95:
96: END INSERT_ROW;
97:
98: PROCEDURE LOCK_ROW(
99: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type
100: ) IS
101: CURSOR c IS SELECT
102: period_mask_id
103: FROM pa_period_masks_b

Line 103: FROM pa_period_masks_b

99: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type
100: ) IS
101: CURSOR c IS SELECT
102: period_mask_id
103: FROM pa_period_masks_b
104: WHERE period_mask_id = x_period_mask_id
105: FOR UPDATE of period_mask_id NOWAIT;
106:
107: recinfo c%ROWTYPE;

Line 138: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,

134:
135:
136:
137: PROCEDURE UPDATE_ROW(
138: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
139: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
140: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
141: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
142: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,

Line 139: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,

135:
136:
137: PROCEDURE UPDATE_ROW(
138: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
139: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
140: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
141: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
142: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
143: X_CREATED_BY IN pa_period_masks_b.created_by%type,

Line 140: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,

136:
137: PROCEDURE UPDATE_ROW(
138: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
139: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
140: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
141: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
142: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
143: X_CREATED_BY IN pa_period_masks_b.created_by%type,
144: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,

Line 141: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,

137: PROCEDURE UPDATE_ROW(
138: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
139: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
140: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
141: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
142: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
143: X_CREATED_BY IN pa_period_masks_b.created_by%type,
144: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
145: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,

Line 142: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,

138: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
139: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
140: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
141: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
142: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
143: X_CREATED_BY IN pa_period_masks_b.created_by%type,
144: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
145: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
146: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,

Line 143: X_CREATED_BY IN pa_period_masks_b.created_by%type,

139: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
140: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
141: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
142: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
143: X_CREATED_BY IN pa_period_masks_b.created_by%type,
144: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
145: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
146: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
147: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,

Line 144: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,

140: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
141: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
142: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
143: X_CREATED_BY IN pa_period_masks_b.created_by%type,
144: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
145: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
146: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
147: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
148: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,

Line 145: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,

141: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
142: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
143: X_CREATED_BY IN pa_period_masks_b.created_by%type,
144: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
145: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
146: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
147: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
148: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
149: X_NAME IN pa_period_masks_tl.name%type,

Line 146: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,

142: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
143: X_CREATED_BY IN pa_period_masks_b.created_by%type,
144: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
145: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
146: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
147: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
148: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
149: X_NAME IN pa_period_masks_tl.name%type,
150: X_DESCRIPTION IN pa_period_masks_tl.description%type)

Line 147: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,

143: X_CREATED_BY IN pa_period_masks_b.created_by%type,
144: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
145: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
146: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
147: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
148: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
149: X_NAME IN pa_period_masks_tl.name%type,
150: X_DESCRIPTION IN pa_period_masks_tl.description%type)
151: IS

Line 148: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,

144: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
145: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
146: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
147: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
148: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
149: X_NAME IN pa_period_masks_tl.name%type,
150: X_DESCRIPTION IN pa_period_masks_tl.description%type)
151: IS
152: BEGIN

Line 154: UPDATE pa_period_masks_b

150: X_DESCRIPTION IN pa_period_masks_tl.description%type)
151: IS
152: BEGIN
153:
154: UPDATE pa_period_masks_b
155: SET effective_start_date = X_EFFECTIVE_START_DATE,
156: effective_end_date = X_EFFECTIVE_END_DATE,
157: time_phase_code = X_TIME_PHASE_CODE,
158: creation_date = X_CREATION_DATE,

Line 190: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type

186: END UPDATE_ROW;
187:
188:
189: PROCEDURE DELETE_ROW(
190: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type
191: ) IS
192: BEGIN
193:
194: DELETE FROM PA_PERIOD_MASKS_TL

Line 205: DELETE FROM PA_PERIOD_MASKS_B

201: IF (SQL%NOTFOUND) THEN
202: RAISE no_data_found;
203: END IF;
204:
205: DELETE FROM PA_PERIOD_MASKS_B
206: WHERE period_mask_id = X_PERIOD_MASK_ID;
207:
208: IF (SQL%NOTFOUND) THEN
209: RAISE no_data_found;

Line 222: FROM pa_period_masks_b b /* 4397924: Referring to the base table */

218:
219: DELETE FROM pa_period_masks_tl t
220: WHERE NOT EXISTS
221: (SELECT null
222: FROM pa_period_masks_b b /* 4397924: Referring to the base table */
223: WHERE b.period_mask_id = t.period_mask_id);
224:
225: UPDATE pa_period_masks_tl t
226: SET (name,description) =

Line 277: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,

273: END ADD_LANGUAGE;
274:
275:
276: PROCEDURE TRANSLATE_ROW(
277: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
278: X_OWNER IN VARCHAR2,
279: X_NAME IN pa_period_masks_tl.name%type,
280: X_DESCRIPTION IN pa_period_masks_tl.description%type
281: ) IS

Line 302: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,

298:
299: END TRANSLATE_ROW;
300:
301: PROCEDURE LOAD_ROW(
302: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
303: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
304: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
305: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
306: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,

Line 303: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,

299: END TRANSLATE_ROW;
300:
301: PROCEDURE LOAD_ROW(
302: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
303: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
304: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
305: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
306: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
307: X_CREATED_BY IN pa_period_masks_b.created_by%type,

Line 304: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,

300:
301: PROCEDURE LOAD_ROW(
302: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
303: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
304: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
305: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
306: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
307: X_CREATED_BY IN pa_period_masks_b.created_by%type,
308: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,

Line 305: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,

301: PROCEDURE LOAD_ROW(
302: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
303: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
304: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
305: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
306: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
307: X_CREATED_BY IN pa_period_masks_b.created_by%type,
308: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
309: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,

Line 306: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,

302: X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
303: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
304: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
305: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
306: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
307: X_CREATED_BY IN pa_period_masks_b.created_by%type,
308: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
309: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
310: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,

Line 307: X_CREATED_BY IN pa_period_masks_b.created_by%type,

303: X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
304: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
305: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
306: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
307: X_CREATED_BY IN pa_period_masks_b.created_by%type,
308: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
309: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
310: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
311: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,

Line 308: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,

304: X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
305: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
306: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
307: X_CREATED_BY IN pa_period_masks_b.created_by%type,
308: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
309: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
310: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
311: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
312: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,

Line 309: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,

305: X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
306: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
307: X_CREATED_BY IN pa_period_masks_b.created_by%type,
308: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
309: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
310: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
311: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
312: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
313: X_NAME IN pa_period_masks_tl.name%type,

Line 310: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,

306: X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
307: X_CREATED_BY IN pa_period_masks_b.created_by%type,
308: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
309: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
310: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
311: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
312: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
313: X_NAME IN pa_period_masks_tl.name%type,
314: X_DESCRIPTION IN pa_period_masks_tl.description%type,

Line 311: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,

307: X_CREATED_BY IN pa_period_masks_b.created_by%type,
308: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
309: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
310: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
311: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
312: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
313: X_NAME IN pa_period_masks_tl.name%type,
314: X_DESCRIPTION IN pa_period_masks_tl.description%type,
315: X_OWNER IN VARCHAR2 )

Line 312: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,

308: X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
309: X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
310: X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
311: X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
312: X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
313: X_NAME IN pa_period_masks_tl.name%type,
314: X_DESCRIPTION IN pa_period_masks_tl.description%type,
315: X_OWNER IN VARCHAR2 )
316: IS