1: PACKAGE BODY pn_rec_arcl_dtl_pkg AS
2: /* $Header: PNRACLHB.pls 120.2 2005/11/30 23:30:33 appldev noship $ */
3:
4:
5: -------------------------------------------------------------------------------
10: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
11: -- 28-NOV-05 pikhar o fetched org_id using cursor
12: -------------------------------------------------------------------------------
13: PROCEDURE insert_row(
14: x_org_id pn_rec_arcl_dtl.org_id%TYPE,
15: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
16: x_area_class_dtl_id IN OUT NOCOPY pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
17: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
18: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
11: -- 28-NOV-05 pikhar o fetched org_id using cursor
12: -------------------------------------------------------------------------------
13: PROCEDURE insert_row(
14: x_org_id pn_rec_arcl_dtl.org_id%TYPE,
15: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
16: x_area_class_dtl_id IN OUT NOCOPY pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
17: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
18: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
19: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
12: -------------------------------------------------------------------------------
13: PROCEDURE insert_row(
14: x_org_id pn_rec_arcl_dtl.org_id%TYPE,
15: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
16: x_area_class_dtl_id IN OUT NOCOPY pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
17: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
18: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
19: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
20: x_status pn_rec_arcl_dtl.status%TYPE,
13: PROCEDURE insert_row(
14: x_org_id pn_rec_arcl_dtl.org_id%TYPE,
15: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
16: x_area_class_dtl_id IN OUT NOCOPY pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
17: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
18: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
19: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
20: x_status pn_rec_arcl_dtl.status%TYPE,
21: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
14: x_org_id pn_rec_arcl_dtl.org_id%TYPE,
15: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
16: x_area_class_dtl_id IN OUT NOCOPY pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
17: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
18: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
19: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
20: x_status pn_rec_arcl_dtl.status%TYPE,
21: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
22: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
15: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
16: x_area_class_dtl_id IN OUT NOCOPY pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
17: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
18: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
19: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
20: x_status pn_rec_arcl_dtl.status%TYPE,
21: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
22: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
23: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
16: x_area_class_dtl_id IN OUT NOCOPY pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
17: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
18: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
19: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
20: x_status pn_rec_arcl_dtl.status%TYPE,
21: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
22: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
23: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
24: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
17: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
18: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
19: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
20: x_status pn_rec_arcl_dtl.status%TYPE,
21: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
22: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
23: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
24: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
25: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
18: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
19: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
20: x_status pn_rec_arcl_dtl.status%TYPE,
21: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
22: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
23: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
24: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
25: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
26: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
19: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
20: x_status pn_rec_arcl_dtl.status%TYPE,
21: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
22: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
23: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
24: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
25: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
26: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
27: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
20: x_status pn_rec_arcl_dtl.status%TYPE,
21: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
22: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
23: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
24: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
25: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
26: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
27: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
28: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
21: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
22: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
23: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
24: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
25: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
26: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
27: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
28: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
29: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
22: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
23: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
24: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
25: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
26: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
27: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
28: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
29: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
30: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
23: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
24: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
25: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
26: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
27: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
28: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
29: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
30: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
31: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
24: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
25: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
26: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
27: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
28: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
29: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
30: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
31: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
32: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
25: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
26: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
27: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
28: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
29: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
30: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
31: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
32: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
33: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
26: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
27: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
28: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
29: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
30: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
31: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
32: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
33: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
34: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
27: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
28: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
29: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
30: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
31: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
32: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
33: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
34: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
35: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE)
28: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
29: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
30: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
31: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
32: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
33: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
34: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
35: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE)
36: IS
29: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
30: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
31: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
32: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
33: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
34: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
35: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE)
36: IS
37: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.insert_row';
30: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
31: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
32: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
33: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
34: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
35: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE)
36: IS
37: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.insert_row';
38:
31: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
32: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
33: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
34: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
35: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE)
36: IS
37: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.insert_row';
38:
39: CURSOR org_cur IS
33: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
34: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
35: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE)
36: IS
37: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.insert_row';
38:
39: CURSOR org_cur IS
40: SELECT org_id
41: FROM pn_rec_arcl_all
54: ELSE
55: l_org_id := x_org_id;
56: END IF;
57:
58: INSERT INTO pn_rec_arcl_dtl_all
59: (
60: org_id,
61: area_class_id,
62: area_class_dtl_id,
81: last_update_login)
82: VALUES(
83: l_org_id,
84: x_area_class_id,
85: pn_rec_arcl_dtl_s.nextval,
86: x_as_of_date,
87: x_from_date,
88: x_to_date,
89: x_status,
120: -- HISTORY :
121: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
122: -------------------------------------------------------------------------------
123: PROCEDURE update_row(
124: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
125: x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
126: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
127: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
128: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
121: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
122: -------------------------------------------------------------------------------
123: PROCEDURE update_row(
124: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
125: x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
126: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
127: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
128: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
129: x_status pn_rec_arcl_dtl.status%TYPE,
122: -------------------------------------------------------------------------------
123: PROCEDURE update_row(
124: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
125: x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
126: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
127: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
128: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
129: x_status pn_rec_arcl_dtl.status%TYPE,
130: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
123: PROCEDURE update_row(
124: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
125: x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
126: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
127: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
128: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
129: x_status pn_rec_arcl_dtl.status%TYPE,
130: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
131: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
124: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
125: x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
126: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
127: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
128: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
129: x_status pn_rec_arcl_dtl.status%TYPE,
130: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
131: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
132: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
125: x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
126: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
127: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
128: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
129: x_status pn_rec_arcl_dtl.status%TYPE,
130: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
131: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
132: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
133: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
126: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
127: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
128: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
129: x_status pn_rec_arcl_dtl.status%TYPE,
130: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
131: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
132: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
133: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
134: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
127: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
128: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
129: x_status pn_rec_arcl_dtl.status%TYPE,
130: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
131: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
132: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
133: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
134: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
135: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
128: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
129: x_status pn_rec_arcl_dtl.status%TYPE,
130: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
131: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
132: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
133: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
134: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
135: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
136: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
129: x_status pn_rec_arcl_dtl.status%TYPE,
130: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
131: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
132: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
133: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
134: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
135: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
136: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
137: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
130: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
131: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
132: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
133: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
134: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
135: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
136: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
137: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
138: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
131: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
132: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
133: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
134: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
135: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
136: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
137: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
138: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
139: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
132: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
133: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
134: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
135: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
136: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
137: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
138: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
139: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
140: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
133: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
134: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
135: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
136: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
137: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
138: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
139: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
140: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
141: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
134: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
135: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
136: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
137: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
138: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
139: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
140: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
141: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
142: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
135: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
136: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
137: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
138: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
139: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
140: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
141: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
142: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
143: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
136: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
137: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
138: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
139: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
140: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
141: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
142: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
143: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
144: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE)
137: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
138: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
139: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
140: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
141: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
142: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
143: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
144: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE)
145: IS
138: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
139: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
140: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
141: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
142: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
143: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
144: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE)
145: IS
146: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.update_row';
139: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
140: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
141: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
142: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
143: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
144: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE)
145: IS
146: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.update_row';
147: BEGIN
140: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
141: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
142: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
143: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
144: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE)
145: IS
146: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.update_row';
147: BEGIN
148:
142: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
143: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
144: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE)
145: IS
146: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.update_row';
147: BEGIN
148:
149: pnp_debug_pkg.debug(l_desc ||' (+)');
150:
147: BEGIN
148:
149: pnp_debug_pkg.debug(l_desc ||' (+)');
150:
151: UPDATE pn_rec_arcl_dtl_all
152: SET
153: area_class_id = x_area_class_id,
154: as_of_date = x_as_of_date,
155: from_date = x_from_date,
187: -- PURPOSE : deletes the row
188: -- HISTORY :
189: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
190: -------------------------------------------------------------------------------
191: PROCEDURE delete_row(x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE)
192: IS
193: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.delete_row';
194: BEGIN
195:
189: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
190: -------------------------------------------------------------------------------
191: PROCEDURE delete_row(x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE)
192: IS
193: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.delete_row';
194: BEGIN
195:
196: pnp_debug_pkg.debug(l_desc ||' (+)');
197:
194: BEGIN
195:
196: pnp_debug_pkg.debug(l_desc ||' (+)');
197:
198: DELETE pn_rec_arcl_dtl_all
199: WHERE area_class_dtl_id = x_area_class_dtl_id;
200:
201: pnp_debug_pkg.debug(l_desc ||' (-)');
202:
205: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));
206: app_exception.raise_exception;
207: END delete_row;
208:
209: END pn_rec_arcl_dtl_pkg;