1: PACKAGE PA_PERIOD_MASK_DETAILS_PKG AUTHID CURRENT_USER AS
2: --$Header: PAFPPMDS.pls 120.1 2005/08/19 16:28:17 mwasowic noship $
3: PROCEDURE insert_row(
4: x_rowid IN OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
5: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
1: PACKAGE PA_PERIOD_MASK_DETAILS_PKG AUTHID CURRENT_USER AS
2: --$Header: PAFPPMDS.pls 120.1 2005/08/19 16:28:17 mwasowic noship $
3: PROCEDURE insert_row(
4: x_rowid IN OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
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,
2: --$Header: PAFPPMDS.pls 120.1 2005/08/19 16:28:17 mwasowic noship $
3: PROCEDURE insert_row(
4: x_rowid IN OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
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,
3: PROCEDURE insert_row(
4: x_rowid IN OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
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,
4: x_rowid IN OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
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,
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,
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,
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
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: );
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: );
17:
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: );
17:
18:
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: );
17:
18:
19: -- locks record into PA_PERIOD_MASK_DETAILS table
15: x_last_update_date IN pa_period_mask_details.last_update_date%type
16: );
17:
18:
19: -- locks record into PA_PERIOD_MASK_DETAILS table
20:
21: PROCEDURE lock_row(
22: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
23: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type);
18:
19: -- locks record into PA_PERIOD_MASK_DETAILS table
20:
21: PROCEDURE lock_row(
22: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
23: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type);
24:
25: -- updates record into PA_PERIOD_MASK_DETAILS table
26:
19: -- locks record into PA_PERIOD_MASK_DETAILS table
20:
21: PROCEDURE lock_row(
22: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
23: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type);
24:
25: -- updates record into PA_PERIOD_MASK_DETAILS table
26:
27: PROCEDURE update_row(
21: PROCEDURE lock_row(
22: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
23: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type);
24:
25: -- updates record into PA_PERIOD_MASK_DETAILS table
26:
27: PROCEDURE update_row(
28: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
29: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
24:
25: -- updates record into PA_PERIOD_MASK_DETAILS table
26:
27: PROCEDURE update_row(
28: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
29: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
30: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
31: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
32: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
25: -- updates record into PA_PERIOD_MASK_DETAILS table
26:
27: PROCEDURE update_row(
28: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
29: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
30: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
31: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
32: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
33: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
26:
27: PROCEDURE update_row(
28: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
29: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
30: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
31: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
32: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
33: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
34: x_creation_date IN pa_period_mask_details.creation_date%type,
27: PROCEDURE update_row(
28: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
29: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
30: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
31: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
32: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
33: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
34: x_creation_date IN pa_period_mask_details.creation_date%type,
35: x_created_by IN pa_period_mask_details.created_by%type,
28: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
29: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
30: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
31: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
32: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
33: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
34: x_creation_date IN pa_period_mask_details.creation_date%type,
35: x_created_by IN pa_period_mask_details.created_by%type,
36: x_last_update_login IN pa_period_mask_details.last_update_login%type,
29: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
30: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
31: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
32: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
33: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
34: x_creation_date IN pa_period_mask_details.creation_date%type,
35: x_created_by IN pa_period_mask_details.created_by%type,
36: x_last_update_login IN pa_period_mask_details.last_update_login%type,
37: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
30: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
31: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
32: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
33: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
34: x_creation_date IN pa_period_mask_details.creation_date%type,
35: x_created_by IN pa_period_mask_details.created_by%type,
36: x_last_update_login IN pa_period_mask_details.last_update_login%type,
37: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
38: x_last_update_date IN pa_period_mask_details.last_update_date%type);
31: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
32: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
33: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
34: x_creation_date IN pa_period_mask_details.creation_date%type,
35: x_created_by IN pa_period_mask_details.created_by%type,
36: x_last_update_login IN pa_period_mask_details.last_update_login%type,
37: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
38: x_last_update_date IN pa_period_mask_details.last_update_date%type);
39:
32: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
33: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
34: x_creation_date IN pa_period_mask_details.creation_date%type,
35: x_created_by IN pa_period_mask_details.created_by%type,
36: x_last_update_login IN pa_period_mask_details.last_update_login%type,
37: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
38: x_last_update_date IN pa_period_mask_details.last_update_date%type);
39:
40: -- deletes record into PA_PERIOD_MASK_DETAILS table
33: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
34: x_creation_date IN pa_period_mask_details.creation_date%type,
35: x_created_by IN pa_period_mask_details.created_by%type,
36: x_last_update_login IN pa_period_mask_details.last_update_login%type,
37: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
38: x_last_update_date IN pa_period_mask_details.last_update_date%type);
39:
40: -- deletes record into PA_PERIOD_MASK_DETAILS table
41:
34: x_creation_date IN pa_period_mask_details.creation_date%type,
35: x_created_by IN pa_period_mask_details.created_by%type,
36: x_last_update_login IN pa_period_mask_details.last_update_login%type,
37: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
38: x_last_update_date IN pa_period_mask_details.last_update_date%type);
39:
40: -- deletes record into PA_PERIOD_MASK_DETAILS table
41:
42: PROCEDURE delete_row(
36: x_last_update_login IN pa_period_mask_details.last_update_login%type,
37: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
38: x_last_update_date IN pa_period_mask_details.last_update_date%type);
39:
40: -- deletes record into PA_PERIOD_MASK_DETAILS table
41:
42: PROCEDURE delete_row(
43: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
44: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type);
39:
40: -- deletes record into PA_PERIOD_MASK_DETAILS table
41:
42: PROCEDURE delete_row(
43: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
44: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type);
45:
46: -- load records into PA_PERIOD_MASK_DETAILS table
47:
40: -- deletes record into PA_PERIOD_MASK_DETAILS table
41:
42: PROCEDURE delete_row(
43: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
44: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type);
45:
46: -- load records into PA_PERIOD_MASK_DETAILS table
47:
48:
42: PROCEDURE delete_row(
43: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
44: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type);
45:
46: -- load records into PA_PERIOD_MASK_DETAILS table
47:
48:
49: PROCEDURE load_row(
50: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
46: -- load records into PA_PERIOD_MASK_DETAILS table
47:
48:
49: PROCEDURE load_row(
50: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
51: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
52: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
53: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
54: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
47:
48:
49: PROCEDURE load_row(
50: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
51: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
52: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
53: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
54: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
55: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
48:
49: PROCEDURE load_row(
50: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
51: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
52: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
53: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
54: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
55: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
56: x_creation_date IN pa_period_mask_details.creation_date%type,
49: PROCEDURE load_row(
50: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
51: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
52: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
53: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
54: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
55: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
56: x_creation_date IN pa_period_mask_details.creation_date%type,
57: x_created_by IN pa_period_mask_details.created_by%type,
50: x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
51: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
52: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
53: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
54: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
55: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
56: x_creation_date IN pa_period_mask_details.creation_date%type,
57: x_created_by IN pa_period_mask_details.created_by%type,
58: x_last_update_login IN pa_period_mask_details.last_update_login%type,
51: x_num_of_periods IN pa_period_mask_details.num_of_periods%type,
52: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
53: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
54: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
55: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
56: x_creation_date IN pa_period_mask_details.creation_date%type,
57: x_created_by IN pa_period_mask_details.created_by%type,
58: x_last_update_login IN pa_period_mask_details.last_update_login%type,
59: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
52: x_anchor_period_flag IN pa_period_mask_details.anchor_period_flag%type,
53: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
54: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
55: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
56: x_creation_date IN pa_period_mask_details.creation_date%type,
57: x_created_by IN pa_period_mask_details.created_by%type,
58: x_last_update_login IN pa_period_mask_details.last_update_login%type,
59: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
60: x_last_update_date IN pa_period_mask_details.last_update_date%type,
53: x_from_anchor_start IN pa_period_mask_details.from_anchor_start%type,
54: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
55: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
56: x_creation_date IN pa_period_mask_details.creation_date%type,
57: x_created_by IN pa_period_mask_details.created_by%type,
58: x_last_update_login IN pa_period_mask_details.last_update_login%type,
59: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
60: x_last_update_date IN pa_period_mask_details.last_update_date%type,
61: x_owner IN VARCHAR2);
54: x_from_anchor_end IN pa_period_mask_details.from_anchor_end%type,
55: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
56: x_creation_date IN pa_period_mask_details.creation_date%type,
57: x_created_by IN pa_period_mask_details.created_by%type,
58: x_last_update_login IN pa_period_mask_details.last_update_login%type,
59: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
60: x_last_update_date IN pa_period_mask_details.last_update_date%type,
61: x_owner IN VARCHAR2);
62:
55: x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
56: x_creation_date IN pa_period_mask_details.creation_date%type,
57: x_created_by IN pa_period_mask_details.created_by%type,
58: x_last_update_login IN pa_period_mask_details.last_update_login%type,
59: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
60: x_last_update_date IN pa_period_mask_details.last_update_date%type,
61: x_owner IN VARCHAR2);
62:
63:
56: x_creation_date IN pa_period_mask_details.creation_date%type,
57: x_created_by IN pa_period_mask_details.created_by%type,
58: x_last_update_login IN pa_period_mask_details.last_update_login%type,
59: x_last_updated_by IN pa_period_mask_details.last_updated_by%type,
60: x_last_update_date IN pa_period_mask_details.last_update_date%type,
61: x_owner IN VARCHAR2);
62:
63:
64: END PA_PERIOD_MASK_DETAILS_PKG;
60: x_last_update_date IN pa_period_mask_details.last_update_date%type,
61: x_owner IN VARCHAR2);
62:
63:
64: END PA_PERIOD_MASK_DETAILS_PKG;