3: --
4: -- Package Name
5: -- CN_INT_ASSIGN_PKG
6: -- Purpose
7: -- Table handler for CN_CAL_PER_INT_TYPES
8: -- Form
9: -- CNINTTP
10: -- Block
11: -- INTERVAL_ASSIGNS
13: -- History
14: -- 16-Aug-99 Yonghong Mao Created
15:
16: PROCEDURE insert_row
17: ( x_cal_per_int_type_id IN OUT NOCOPY cn_cal_per_int_types.cal_per_int_type_id%TYPE,
18: x_org_id cn_cal_per_int_types.org_id%TYPE,
19: x_interval_type_id cn_cal_per_int_types.interval_type_id%TYPE,
20: x_cal_period_id cn_cal_per_int_types.cal_period_id%TYPE,
21: x_interval_number cn_cal_per_int_types.interval_number%TYPE,
14: -- 16-Aug-99 Yonghong Mao Created
15:
16: PROCEDURE insert_row
17: ( x_cal_per_int_type_id IN OUT NOCOPY cn_cal_per_int_types.cal_per_int_type_id%TYPE,
18: x_org_id cn_cal_per_int_types.org_id%TYPE,
19: x_interval_type_id cn_cal_per_int_types.interval_type_id%TYPE,
20: x_cal_period_id cn_cal_per_int_types.cal_period_id%TYPE,
21: x_interval_number cn_cal_per_int_types.interval_number%TYPE,
22: x_last_update_date cn_cal_per_int_types.last_update_date%TYPE,
15:
16: PROCEDURE insert_row
17: ( x_cal_per_int_type_id IN OUT NOCOPY cn_cal_per_int_types.cal_per_int_type_id%TYPE,
18: x_org_id cn_cal_per_int_types.org_id%TYPE,
19: x_interval_type_id cn_cal_per_int_types.interval_type_id%TYPE,
20: x_cal_period_id cn_cal_per_int_types.cal_period_id%TYPE,
21: x_interval_number cn_cal_per_int_types.interval_number%TYPE,
22: x_last_update_date cn_cal_per_int_types.last_update_date%TYPE,
23: x_last_updated_by cn_cal_per_int_types.last_updated_by%TYPE,
16: PROCEDURE insert_row
17: ( x_cal_per_int_type_id IN OUT NOCOPY cn_cal_per_int_types.cal_per_int_type_id%TYPE,
18: x_org_id cn_cal_per_int_types.org_id%TYPE,
19: x_interval_type_id cn_cal_per_int_types.interval_type_id%TYPE,
20: x_cal_period_id cn_cal_per_int_types.cal_period_id%TYPE,
21: x_interval_number cn_cal_per_int_types.interval_number%TYPE,
22: x_last_update_date cn_cal_per_int_types.last_update_date%TYPE,
23: x_last_updated_by cn_cal_per_int_types.last_updated_by%TYPE,
24: x_creation_date cn_cal_per_int_types.creation_date%TYPE,
17: ( x_cal_per_int_type_id IN OUT NOCOPY cn_cal_per_int_types.cal_per_int_type_id%TYPE,
18: x_org_id cn_cal_per_int_types.org_id%TYPE,
19: x_interval_type_id cn_cal_per_int_types.interval_type_id%TYPE,
20: x_cal_period_id cn_cal_per_int_types.cal_period_id%TYPE,
21: x_interval_number cn_cal_per_int_types.interval_number%TYPE,
22: x_last_update_date cn_cal_per_int_types.last_update_date%TYPE,
23: x_last_updated_by cn_cal_per_int_types.last_updated_by%TYPE,
24: x_creation_date cn_cal_per_int_types.creation_date%TYPE,
25: x_created_by cn_cal_per_int_types.created_by%TYPE,
18: x_org_id cn_cal_per_int_types.org_id%TYPE,
19: x_interval_type_id cn_cal_per_int_types.interval_type_id%TYPE,
20: x_cal_period_id cn_cal_per_int_types.cal_period_id%TYPE,
21: x_interval_number cn_cal_per_int_types.interval_number%TYPE,
22: x_last_update_date cn_cal_per_int_types.last_update_date%TYPE,
23: x_last_updated_by cn_cal_per_int_types.last_updated_by%TYPE,
24: x_creation_date cn_cal_per_int_types.creation_date%TYPE,
25: x_created_by cn_cal_per_int_types.created_by%TYPE,
26: x_last_update_login cn_cal_per_int_types.last_update_login%TYPE
19: x_interval_type_id cn_cal_per_int_types.interval_type_id%TYPE,
20: x_cal_period_id cn_cal_per_int_types.cal_period_id%TYPE,
21: x_interval_number cn_cal_per_int_types.interval_number%TYPE,
22: x_last_update_date cn_cal_per_int_types.last_update_date%TYPE,
23: x_last_updated_by cn_cal_per_int_types.last_updated_by%TYPE,
24: x_creation_date cn_cal_per_int_types.creation_date%TYPE,
25: x_created_by cn_cal_per_int_types.created_by%TYPE,
26: x_last_update_login cn_cal_per_int_types.last_update_login%TYPE
27: ) IS
20: x_cal_period_id cn_cal_per_int_types.cal_period_id%TYPE,
21: x_interval_number cn_cal_per_int_types.interval_number%TYPE,
22: x_last_update_date cn_cal_per_int_types.last_update_date%TYPE,
23: x_last_updated_by cn_cal_per_int_types.last_updated_by%TYPE,
24: x_creation_date cn_cal_per_int_types.creation_date%TYPE,
25: x_created_by cn_cal_per_int_types.created_by%TYPE,
26: x_last_update_login cn_cal_per_int_types.last_update_login%TYPE
27: ) IS
28: CURSOR c IS
21: x_interval_number cn_cal_per_int_types.interval_number%TYPE,
22: x_last_update_date cn_cal_per_int_types.last_update_date%TYPE,
23: x_last_updated_by cn_cal_per_int_types.last_updated_by%TYPE,
24: x_creation_date cn_cal_per_int_types.creation_date%TYPE,
25: x_created_by cn_cal_per_int_types.created_by%TYPE,
26: x_last_update_login cn_cal_per_int_types.last_update_login%TYPE
27: ) IS
28: CURSOR c IS
29: SELECT ROWID
22: x_last_update_date cn_cal_per_int_types.last_update_date%TYPE,
23: x_last_updated_by cn_cal_per_int_types.last_updated_by%TYPE,
24: x_creation_date cn_cal_per_int_types.creation_date%TYPE,
25: x_created_by cn_cal_per_int_types.created_by%TYPE,
26: x_last_update_login cn_cal_per_int_types.last_update_login%TYPE
27: ) IS
28: CURSOR c IS
29: SELECT ROWID
30: FROM cn_cal_per_int_types_all
26: x_last_update_login cn_cal_per_int_types.last_update_login%TYPE
27: ) IS
28: CURSOR c IS
29: SELECT ROWID
30: FROM cn_cal_per_int_types_all
31: WHERE cal_per_int_type_id = x_cal_per_int_type_id;
32: l_dummy ROWID;
33: BEGIN
34: IF (x_cal_per_int_type_id IS NULL) THEN
31: WHERE cal_per_int_type_id = x_cal_per_int_type_id;
32: l_dummy ROWID;
33: BEGIN
34: IF (x_cal_per_int_type_id IS NULL) THEN
35: SELECT cn_cal_per_int_types_s.NEXTVAL
36: INTO x_cal_per_int_type_id
37: FROM dual;
38: END IF;
39:
36: INTO x_cal_per_int_type_id
37: FROM dual;
38: END IF;
39:
40: INSERT INTO cn_cal_per_int_types
41: (cal_per_int_type_id,
42: interval_type_id,
43: cal_period_id,
44: interval_number,
82:
83: END insert_row;
84:
85: PROCEDURE update_row
86: ( x_cal_per_int_type_id cn_cal_per_int_types.cal_per_int_type_id%TYPE,
87: x_interval_number cn_cal_per_int_types.interval_number%TYPE,
88: x_last_update_date cn_cal_per_int_types.last_update_date%TYPE,
89: x_last_updated_by cn_cal_per_int_types.last_updated_by%TYPE,
90: x_last_update_login cn_cal_per_int_types.last_update_login%TYPE
83: END insert_row;
84:
85: PROCEDURE update_row
86: ( x_cal_per_int_type_id cn_cal_per_int_types.cal_per_int_type_id%TYPE,
87: x_interval_number cn_cal_per_int_types.interval_number%TYPE,
88: x_last_update_date cn_cal_per_int_types.last_update_date%TYPE,
89: x_last_updated_by cn_cal_per_int_types.last_updated_by%TYPE,
90: x_last_update_login cn_cal_per_int_types.last_update_login%TYPE
91: )
84:
85: PROCEDURE update_row
86: ( x_cal_per_int_type_id cn_cal_per_int_types.cal_per_int_type_id%TYPE,
87: x_interval_number cn_cal_per_int_types.interval_number%TYPE,
88: x_last_update_date cn_cal_per_int_types.last_update_date%TYPE,
89: x_last_updated_by cn_cal_per_int_types.last_updated_by%TYPE,
90: x_last_update_login cn_cal_per_int_types.last_update_login%TYPE
91: )
92: IS
85: PROCEDURE update_row
86: ( x_cal_per_int_type_id cn_cal_per_int_types.cal_per_int_type_id%TYPE,
87: x_interval_number cn_cal_per_int_types.interval_number%TYPE,
88: x_last_update_date cn_cal_per_int_types.last_update_date%TYPE,
89: x_last_updated_by cn_cal_per_int_types.last_updated_by%TYPE,
90: x_last_update_login cn_cal_per_int_types.last_update_login%TYPE
91: )
92: IS
93: CURSOR c IS
86: ( x_cal_per_int_type_id cn_cal_per_int_types.cal_per_int_type_id%TYPE,
87: x_interval_number cn_cal_per_int_types.interval_number%TYPE,
88: x_last_update_date cn_cal_per_int_types.last_update_date%TYPE,
89: x_last_updated_by cn_cal_per_int_types.last_updated_by%TYPE,
90: x_last_update_login cn_cal_per_int_types.last_update_login%TYPE
91: )
92: IS
93: CURSOR c IS
94: SELECT cal_period_id, interval_number, interval_type_id, org_id
91: )
92: IS
93: CURSOR c IS
94: SELECT cal_period_id, interval_number, interval_type_id, org_id
95: FROM cn_cal_per_int_types_all
96: WHERE cal_per_int_type_id = x_cal_per_int_type_id
97: FOR UPDATE OF cal_per_int_type_id nowait;
98:
99: rec c%ROWTYPE;
124: app_exception.raise_exception;
125: END IF;
126: CLOSE c;
127:
128: UPDATE cn_cal_per_int_types_all SET
129: interval_number = x_interval_number,
130: last_update_date = x_last_update_date,
131: last_updated_by = x_last_updated_by,
132: last_update_login = x_last_update_login
164:
165: END update_row;
166:
167: PROCEDURE lock_row
168: ( x_cal_per_int_type_id cn_cal_per_int_types.cal_per_int_type_id%TYPE,
169: x_cal_period_id cn_cal_per_int_types.cal_period_id%TYPE,
170: x_interval_type_id cn_cal_per_int_types.interval_type_id%TYPE,
171: x_interval_number cn_cal_per_int_types.interval_number%TYPE
172: ) IS
165: END update_row;
166:
167: PROCEDURE lock_row
168: ( x_cal_per_int_type_id cn_cal_per_int_types.cal_per_int_type_id%TYPE,
169: x_cal_period_id cn_cal_per_int_types.cal_period_id%TYPE,
170: x_interval_type_id cn_cal_per_int_types.interval_type_id%TYPE,
171: x_interval_number cn_cal_per_int_types.interval_number%TYPE
172: ) IS
173: CURSOR c IS
166:
167: PROCEDURE lock_row
168: ( x_cal_per_int_type_id cn_cal_per_int_types.cal_per_int_type_id%TYPE,
169: x_cal_period_id cn_cal_per_int_types.cal_period_id%TYPE,
170: x_interval_type_id cn_cal_per_int_types.interval_type_id%TYPE,
171: x_interval_number cn_cal_per_int_types.interval_number%TYPE
172: ) IS
173: CURSOR c IS
174: SELECT *
167: PROCEDURE lock_row
168: ( x_cal_per_int_type_id cn_cal_per_int_types.cal_per_int_type_id%TYPE,
169: x_cal_period_id cn_cal_per_int_types.cal_period_id%TYPE,
170: x_interval_type_id cn_cal_per_int_types.interval_type_id%TYPE,
171: x_interval_number cn_cal_per_int_types.interval_number%TYPE
172: ) IS
173: CURSOR c IS
174: SELECT *
175: FROM cn_cal_per_int_types
171: x_interval_number cn_cal_per_int_types.interval_number%TYPE
172: ) IS
173: CURSOR c IS
174: SELECT *
175: FROM cn_cal_per_int_types
176: WHERE cal_per_int_type_id = x_cal_per_int_type_id
177: FOR UPDATE OF cal_per_int_type_id nowait;
178:
179: recinfo c%ROWTYPE;