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_MASK_DETAILS_PKG dependencies on PA_PERIOD_MASK_DETAILS

Line 1: PACKAGE BODY PA_PERIOD_MASK_DETAILS_PKG AS

1: PACKAGE BODY PA_PERIOD_MASK_DETAILS_PKG AS
2: --$Header: PAFPPMDB.pls 120.2 2007/02/06 10:04:30 dthakker noship $
3: PROCEDURE INSERT_ROW(
4: x_rowid IN OUT NOCOPY ROWID,
5: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,

Line 5: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,

1: PACKAGE BODY PA_PERIOD_MASK_DETAILS_PKG AS
2: --$Header: PAFPPMDB.pls 120.2 2007/02/06 10:04:30 dthakker noship $
3: PROCEDURE INSERT_ROW(
4: x_rowid IN OUT NOCOPY ROWID,
5: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
6: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
7: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
8: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
9: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,

Line 6: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,

2: --$Header: PAFPPMDB.pls 120.2 2007/02/06 10:04:30 dthakker noship $
3: PROCEDURE INSERT_ROW(
4: x_rowid IN OUT NOCOPY ROWID,
5: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
6: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
7: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
8: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
9: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
10: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,

Line 7: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,

3: PROCEDURE INSERT_ROW(
4: x_rowid IN OUT NOCOPY ROWID,
5: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
6: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
7: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
8: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
9: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
10: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
11: x_creation_date IN pa_period_mask_details.creation_date%type,

Line 8: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,

4: x_rowid IN OUT NOCOPY ROWID,
5: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
6: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
7: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
8: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
9: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
10: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
11: x_creation_date IN pa_period_mask_details.creation_date%type,
12: x_created_by IN pa_period_mask_details.created_by%type,

Line 9: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,

5: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
6: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
7: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
8: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
9: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
10: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
11: x_creation_date IN pa_period_mask_details.creation_date%type,
12: x_created_by IN pa_period_mask_details.created_by%type,
13: x_last_update_login IN pa_period_mask_details.last_update_login%type,

Line 10: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,

6: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
7: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
8: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
9: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
10: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
11: x_creation_date IN pa_period_mask_details.creation_date%type,
12: x_created_by IN pa_period_mask_details.created_by%type,
13: x_last_update_login IN pa_period_mask_details.last_update_login%type,
14: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,

Line 11: x_creation_date IN pa_period_mask_details.creation_date%type,

7: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
8: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
9: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
10: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
11: x_creation_date IN pa_period_mask_details.creation_date%type,
12: x_created_by IN pa_period_mask_details.created_by%type,
13: x_last_update_login IN pa_period_mask_details.last_update_login%type,
14: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
15: x_last_update_date IN pa_period_mask_details.last_update_date%type

Line 12: x_created_by IN pa_period_mask_details.created_by%type,

8: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
9: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
10: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
11: x_creation_date IN pa_period_mask_details.creation_date%type,
12: x_created_by IN pa_period_mask_details.created_by%type,
13: x_last_update_login IN pa_period_mask_details.last_update_login%type,
14: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
15: x_last_update_date IN pa_period_mask_details.last_update_date%type
16: ) IS

Line 13: x_last_update_login IN pa_period_mask_details.last_update_login%type,

9: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
10: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
11: x_creation_date IN pa_period_mask_details.creation_date%type,
12: x_created_by IN pa_period_mask_details.created_by%type,
13: x_last_update_login IN pa_period_mask_details.last_update_login%type,
14: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
15: x_last_update_date IN pa_period_mask_details.last_update_date%type
16: ) IS
17:

Line 14: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,

10: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
11: x_creation_date IN pa_period_mask_details.creation_date%type,
12: x_created_by IN pa_period_mask_details.created_by%type,
13: x_last_update_login IN pa_period_mask_details.last_update_login%type,
14: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
15: x_last_update_date IN pa_period_mask_details.last_update_date%type
16: ) IS
17:
18: l_period_mask_id pa_period_mask_details.period_mask_id%type;

Line 15: x_last_update_date IN pa_period_mask_details.last_update_date%type

11: x_creation_date IN pa_period_mask_details.creation_date%type,
12: x_created_by IN pa_period_mask_details.created_by%type,
13: x_last_update_login IN pa_period_mask_details.last_update_login%type,
14: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
15: x_last_update_date IN pa_period_mask_details.last_update_date%type
16: ) IS
17:
18: l_period_mask_id pa_period_mask_details.period_mask_id%type;
19:

Line 18: l_period_mask_id pa_period_mask_details.period_mask_id%type;

14: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
15: x_last_update_date IN pa_period_mask_details.last_update_date%type
16: ) IS
17:
18: l_period_mask_id pa_period_mask_details.period_mask_id%type;
19:
20:
21: CURSOR C IS SELECT ROWID FROM PA_PERIOD_MASK_DETAILS
22: WHERE period_mask_id = l_period_mask_id;

Line 21: CURSOR C IS SELECT ROWID FROM PA_PERIOD_MASK_DETAILS

17:
18: l_period_mask_id pa_period_mask_details.period_mask_id%type;
19:
20:
21: CURSOR C IS SELECT ROWID FROM PA_PERIOD_MASK_DETAILS
22: WHERE period_mask_id = l_period_mask_id;
23:
24: cn_rowid ROWID;
25:

Line 33: INSERT INTO PA_PERIOD_MASK_DETAILS(

29: SELECT x_period_mask_id
30: INTO l_period_mask_id
31: FROM DUAL;
32:
33: INSERT INTO PA_PERIOD_MASK_DETAILS(
34: period_mask_id,
35: num_of_periods,
36: anchor_period_flag,
37: from_anchor_start,

Line 67: X_PERIOD_MASK_ID IN pa_period_mask_details.period_mask_id%type,

63:
64: END INSERT_ROW;
65:
66: PROCEDURE LOCK_ROW(
67: X_PERIOD_MASK_ID IN pa_period_mask_details.period_mask_id%type,
68: X_from_anchor_position IN pa_period_mask_details.from_anchor_position%type
69: ) IS
70: CURSOR c IS SELECT
71: period_mask_id,

Line 68: X_from_anchor_position IN pa_period_mask_details.from_anchor_position%type

64: END INSERT_ROW;
65:
66: PROCEDURE LOCK_ROW(
67: X_PERIOD_MASK_ID IN pa_period_mask_details.period_mask_id%type,
68: X_from_anchor_position IN pa_period_mask_details.from_anchor_position%type
69: ) IS
70: CURSOR c IS SELECT
71: period_mask_id,
72: num_of_periods,

Line 82: FROM pa_period_mask_details

78: created_by,
79: last_update_login,
80: last_updated_by,
81: last_update_date
82: FROM pa_period_mask_details
83: WHERE period_mask_id = x_period_mask_id
84: AND from_anchor_position = x_from_anchor_position
85: FOR UPDATE OF period_mask_id NOWAIT;
86:

Line 105: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,

101:
102: END LOCK_ROW;
103:
104: PROCEDURE UPDATE_ROW(
105: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
106: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
107: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
108: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
109: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,

Line 106: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,

102: END LOCK_ROW;
103:
104: PROCEDURE UPDATE_ROW(
105: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
106: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
107: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
108: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
109: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
110: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,

Line 107: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,

103:
104: PROCEDURE UPDATE_ROW(
105: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
106: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
107: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
108: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
109: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
110: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
111: x_creation_date IN pa_period_mask_details.creation_date%type,

Line 108: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,

104: PROCEDURE UPDATE_ROW(
105: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
106: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
107: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
108: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
109: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
110: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
111: x_creation_date IN pa_period_mask_details.creation_date%type,
112: x_created_by IN pa_period_mask_details.created_by%type,

Line 109: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,

105: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
106: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
107: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
108: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
109: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
110: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
111: x_creation_date IN pa_period_mask_details.creation_date%type,
112: x_created_by IN pa_period_mask_details.created_by%type,
113: x_last_update_login IN pa_period_mask_details.last_update_login%type,

Line 110: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,

106: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
107: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
108: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
109: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
110: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
111: x_creation_date IN pa_period_mask_details.creation_date%type,
112: x_created_by IN pa_period_mask_details.created_by%type,
113: x_last_update_login IN pa_period_mask_details.last_update_login%type,
114: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,

Line 111: x_creation_date IN pa_period_mask_details.creation_date%type,

107: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
108: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
109: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
110: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
111: x_creation_date IN pa_period_mask_details.creation_date%type,
112: x_created_by IN pa_period_mask_details.created_by%type,
113: x_last_update_login IN pa_period_mask_details.last_update_login%type,
114: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
115: x_last_update_date IN pa_period_mask_details.last_update_date%type

Line 112: x_created_by IN pa_period_mask_details.created_by%type,

108: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
109: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
110: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
111: x_creation_date IN pa_period_mask_details.creation_date%type,
112: x_created_by IN pa_period_mask_details.created_by%type,
113: x_last_update_login IN pa_period_mask_details.last_update_login%type,
114: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
115: x_last_update_date IN pa_period_mask_details.last_update_date%type
116: ) IS

Line 113: x_last_update_login IN pa_period_mask_details.last_update_login%type,

109: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
110: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
111: x_creation_date IN pa_period_mask_details.creation_date%type,
112: x_created_by IN pa_period_mask_details.created_by%type,
113: x_last_update_login IN pa_period_mask_details.last_update_login%type,
114: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
115: x_last_update_date IN pa_period_mask_details.last_update_date%type
116: ) IS
117: BEGIN

Line 114: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,

110: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
111: x_creation_date IN pa_period_mask_details.creation_date%type,
112: x_created_by IN pa_period_mask_details.created_by%type,
113: x_last_update_login IN pa_period_mask_details.last_update_login%type,
114: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
115: x_last_update_date IN pa_period_mask_details.last_update_date%type
116: ) IS
117: BEGIN
118:

Line 115: x_last_update_date IN pa_period_mask_details.last_update_date%type

111: x_creation_date IN pa_period_mask_details.creation_date%type,
112: x_created_by IN pa_period_mask_details.created_by%type,
113: x_last_update_login IN pa_period_mask_details.last_update_login%type,
114: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
115: x_last_update_date IN pa_period_mask_details.last_update_date%type
116: ) IS
117: BEGIN
118:
119: UPDATE pa_period_mask_details

Line 119: UPDATE pa_period_mask_details

115: x_last_update_date IN pa_period_mask_details.last_update_date%type
116: ) IS
117: BEGIN
118:
119: UPDATE pa_period_mask_details
120: SET num_of_periods = X_NUM_OF_PERIODS,
121: anchor_period_flag = X_ANCHOR_PERIOD_FLAG,
122: from_anchor_start = X_FROM_ANCHOR_START,
123: from_anchor_end = X_FROM_ANCHOR_END,

Line 140: X_PERIOD_MASK_ID IN pa_period_mask_details.period_mask_id%type,

136:
137: END UPDATE_ROW;
138:
139: PROCEDURE DELETE_ROW(
140: X_PERIOD_MASK_ID IN pa_period_mask_details.period_mask_id%type,
141: X_from_anchor_position IN pa_period_mask_details.from_anchor_position%type
142: ) IS
143: BEGIN
144: DELETE FROM PA_PERIOD_MASK_DETAILS

Line 141: X_from_anchor_position IN pa_period_mask_details.from_anchor_position%type

137: END UPDATE_ROW;
138:
139: PROCEDURE DELETE_ROW(
140: X_PERIOD_MASK_ID IN pa_period_mask_details.period_mask_id%type,
141: X_from_anchor_position IN pa_period_mask_details.from_anchor_position%type
142: ) IS
143: BEGIN
144: DELETE FROM PA_PERIOD_MASK_DETAILS
145: WHERE period_mask_id = X_PERIOD_MASK_ID AND

Line 144: DELETE FROM PA_PERIOD_MASK_DETAILS

140: X_PERIOD_MASK_ID IN pa_period_mask_details.period_mask_id%type,
141: X_from_anchor_position IN pa_period_mask_details.from_anchor_position%type
142: ) IS
143: BEGIN
144: DELETE FROM PA_PERIOD_MASK_DETAILS
145: WHERE period_mask_id = X_PERIOD_MASK_ID AND
146: from_anchor_position = x_from_anchor_position;
147:
148: IF (SQL%NOTFOUND) THEN

Line 158: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,

154:
155:
156: PROCEDURE LOAD_ROW(
157:
158: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
159: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
160: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
161: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
162: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,

Line 159: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,

155:
156: PROCEDURE LOAD_ROW(
157:
158: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
159: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
160: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
161: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
162: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
163: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,

Line 160: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,

156: PROCEDURE LOAD_ROW(
157:
158: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
159: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
160: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
161: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
162: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
163: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
164: x_creation_date IN pa_period_mask_details.creation_date%type,

Line 161: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,

157:
158: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
159: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
160: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
161: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
162: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
163: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
164: x_creation_date IN pa_period_mask_details.creation_date%type,
165: x_created_by IN pa_period_mask_details.created_by%type,

Line 162: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,

158: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
159: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
160: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
161: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
162: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
163: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
164: x_creation_date IN pa_period_mask_details.creation_date%type,
165: x_created_by IN pa_period_mask_details.created_by%type,
166: x_last_update_login IN pa_period_mask_details.last_update_login%type,

Line 163: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,

159: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
160: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
161: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
162: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
163: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
164: x_creation_date IN pa_period_mask_details.creation_date%type,
165: x_created_by IN pa_period_mask_details.created_by%type,
166: x_last_update_login IN pa_period_mask_details.last_update_login%type,
167: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,

Line 164: x_creation_date IN pa_period_mask_details.creation_date%type,

160: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
161: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
162: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
163: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
164: x_creation_date IN pa_period_mask_details.creation_date%type,
165: x_created_by IN pa_period_mask_details.created_by%type,
166: x_last_update_login IN pa_period_mask_details.last_update_login%type,
167: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
168: x_last_update_date IN pa_period_mask_details.last_update_date%type,

Line 165: x_created_by IN pa_period_mask_details.created_by%type,

161: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
162: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
163: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
164: x_creation_date IN pa_period_mask_details.creation_date%type,
165: x_created_by IN pa_period_mask_details.created_by%type,
166: x_last_update_login IN pa_period_mask_details.last_update_login%type,
167: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
168: x_last_update_date IN pa_period_mask_details.last_update_date%type,
169: x_owner IN varchar2)

Line 166: x_last_update_login IN pa_period_mask_details.last_update_login%type,

162: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
163: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
164: x_creation_date IN pa_period_mask_details.creation_date%type,
165: x_created_by IN pa_period_mask_details.created_by%type,
166: x_last_update_login IN pa_period_mask_details.last_update_login%type,
167: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
168: x_last_update_date IN pa_period_mask_details.last_update_date%type,
169: x_owner IN varchar2)
170: IS

Line 167: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,

163: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
164: x_creation_date IN pa_period_mask_details.creation_date%type,
165: x_created_by IN pa_period_mask_details.created_by%type,
166: x_last_update_login IN pa_period_mask_details.last_update_login%type,
167: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
168: x_last_update_date IN pa_period_mask_details.last_update_date%type,
169: x_owner IN varchar2)
170: IS
171:

Line 168: x_last_update_date IN pa_period_mask_details.last_update_date%type,

164: x_creation_date IN pa_period_mask_details.creation_date%type,
165: x_created_by IN pa_period_mask_details.created_by%type,
166: x_last_update_login IN pa_period_mask_details.last_update_login%type,
167: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
168: x_last_update_date IN pa_period_mask_details.last_update_date%type,
169: x_owner IN varchar2)
170: IS
171:
172: X_ROWID ROWID;

Line 176: PA_PERIOD_MASK_DETAILS_PKG.UPDATE_ROW(

172: X_ROWID ROWID;
173:
174: BEGIN
175:
176: PA_PERIOD_MASK_DETAILS_PKG.UPDATE_ROW(
177: X_PERIOD_MASK_ID => X_PERIOD_MASK_ID ,
178: X_NUM_OF_PERIODS => X_NUM_OF_PERIODS,
179: X_ANCHOR_PERIOD_FLAG => X_ANCHOR_PERIOD_FLAG,
180: X_FROM_ANCHOR_START => X_FROM_ANCHOR_START,

Line 192: PA_PERIOD_MASK_DETAILS_PKG.INSERT_ROW(

188:
189:
190: EXCEPTION
191: WHEN no_data_found then
192: PA_PERIOD_MASK_DETAILS_PKG.INSERT_ROW(
193: X_ROWID => X_ROWID ,
194: X_PERIOD_MASK_ID => X_PERIOD_MASK_ID,
195: X_NUM_OF_PERIODS => X_NUM_OF_PERIODS,
196: X_ANCHOR_PERIOD_FLAG => X_ANCHOR_PERIOD_FLAG,

Line 210: END PA_PERIOD_MASK_DETAILS_PKG;

206:
207: END LOAD_ROW;
208:
209:
210: END PA_PERIOD_MASK_DETAILS_PKG;