1: PACKAGE pn_rec_arcl_dtl_pkg AUTHID CURRENT_USER AS
2: /* $Header: PNRACLHS.pls 115.3 2003/05/23 16:44:13 ftanudja noship $ */
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_arcl_dtl.org_id%TYPE,
1: PACKAGE pn_rec_arcl_dtl_pkg AUTHID CURRENT_USER AS
2: /* $Header: PNRACLHS.pls 115.3 2003/05/23 16:44:13 ftanudja noship $ */
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_arcl_dtl.org_id%TYPE,
6: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
7: x_area_class_dtl_id IN OUT NOCOPY pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
8: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
9: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
2: /* $Header: PNRACLHS.pls 115.3 2003/05/23 16:44:13 ftanudja noship $ */
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_arcl_dtl.org_id%TYPE,
6: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
7: x_area_class_dtl_id IN OUT NOCOPY pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
8: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
9: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
10: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
3:
4: PROCEDURE insert_row(
5: x_org_id pn_rec_arcl_dtl.org_id%TYPE,
6: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
7: x_area_class_dtl_id IN OUT NOCOPY pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
8: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
9: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
10: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
11: x_status pn_rec_arcl_dtl.status%TYPE,
4: PROCEDURE insert_row(
5: x_org_id pn_rec_arcl_dtl.org_id%TYPE,
6: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
7: x_area_class_dtl_id IN OUT NOCOPY pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
8: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
9: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
10: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
11: x_status pn_rec_arcl_dtl.status%TYPE,
12: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
5: x_org_id pn_rec_arcl_dtl.org_id%TYPE,
6: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
7: x_area_class_dtl_id IN OUT NOCOPY pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
8: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
9: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
10: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
11: x_status pn_rec_arcl_dtl.status%TYPE,
12: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
13: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
6: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
7: x_area_class_dtl_id IN OUT NOCOPY pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
8: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
9: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
10: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
11: x_status pn_rec_arcl_dtl.status%TYPE,
12: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
13: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
14: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
7: x_area_class_dtl_id IN OUT NOCOPY pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
8: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
9: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
10: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
11: x_status pn_rec_arcl_dtl.status%TYPE,
12: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
13: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
14: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
15: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
8: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
9: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
10: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
11: x_status pn_rec_arcl_dtl.status%TYPE,
12: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
13: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
14: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
15: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
16: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
9: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
10: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
11: x_status pn_rec_arcl_dtl.status%TYPE,
12: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
13: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
14: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
15: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
16: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
17: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
10: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
11: x_status pn_rec_arcl_dtl.status%TYPE,
12: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
13: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
14: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
15: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
16: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
17: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
18: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
11: x_status pn_rec_arcl_dtl.status%TYPE,
12: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
13: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
14: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
15: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
16: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
17: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
18: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
19: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
12: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
13: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
14: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
15: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
16: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
17: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
18: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
19: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
20: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
13: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
14: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
15: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
16: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
17: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
18: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
19: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
20: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
21: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
14: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
15: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
16: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
17: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
18: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
19: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
20: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
21: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
22: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
15: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
16: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
17: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
18: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
19: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
20: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
21: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
22: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
23: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
16: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
17: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
18: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
19: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
20: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
21: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
22: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
23: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
24: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
17: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
18: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
19: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
20: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
21: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
22: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
23: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
24: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
25: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
18: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
19: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
20: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
21: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
22: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
23: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
24: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
25: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
26: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE);
19: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
20: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
21: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
22: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
23: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
24: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
25: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
26: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE);
27:
20: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
21: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
22: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
23: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
24: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
25: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
26: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE);
27:
28:
21: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
22: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
23: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
24: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
25: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
26: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE);
27:
28:
29: PROCEDURE update_row(
22: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
23: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
24: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
25: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
26: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE);
27:
28:
29: PROCEDURE update_row(
30: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
26: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE);
27:
28:
29: PROCEDURE update_row(
30: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
31: x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
32: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
33: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
34: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
27:
28:
29: PROCEDURE update_row(
30: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
31: x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
32: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
33: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
34: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
35: x_status pn_rec_arcl_dtl.status%TYPE,
28:
29: PROCEDURE update_row(
30: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
31: x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
32: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
33: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
34: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
35: x_status pn_rec_arcl_dtl.status%TYPE,
36: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
29: PROCEDURE update_row(
30: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
31: x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
32: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
33: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
34: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
35: x_status pn_rec_arcl_dtl.status%TYPE,
36: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
37: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
30: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,
31: x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
32: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
33: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
34: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
35: x_status pn_rec_arcl_dtl.status%TYPE,
36: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
37: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
38: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
31: x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE,
32: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
33: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
34: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
35: x_status pn_rec_arcl_dtl.status%TYPE,
36: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
37: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
38: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
39: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
32: x_as_of_date pn_rec_arcl_dtl.as_of_date%TYPE,
33: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
34: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
35: x_status pn_rec_arcl_dtl.status%TYPE,
36: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
37: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
38: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
39: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
40: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
33: x_from_date pn_rec_arcl_dtl.from_date%TYPE,
34: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
35: x_status pn_rec_arcl_dtl.status%TYPE,
36: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
37: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
38: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
39: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
40: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
41: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
34: x_to_date pn_rec_arcl_dtl.to_date%TYPE,
35: x_status pn_rec_arcl_dtl.status%TYPE,
36: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
37: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
38: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
39: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
40: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
41: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
42: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
35: x_status pn_rec_arcl_dtl.status%TYPE,
36: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
37: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
38: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
39: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
40: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
41: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
42: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
43: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
36: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%TYPE,
37: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
38: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
39: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
40: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
41: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
42: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
43: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
44: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
37: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_area%TYPE,
38: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
39: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
40: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
41: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
42: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
43: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
44: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
45: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
38: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_area_ovr%TYPE,
39: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
40: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
41: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
42: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
43: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
44: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
45: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
46: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
39: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_area_exc%TYPE,
40: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
41: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
42: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
43: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
44: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
45: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
46: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
47: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
40: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%TYPE,
41: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
42: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
43: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
44: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
45: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
46: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
47: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
48: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
41: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_ovr%TYPE,
42: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
43: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
44: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
45: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
46: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
47: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
48: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
49: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
42: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_exc%TYPE,
43: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
44: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
45: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
46: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
47: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
48: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
49: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
50: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE
43: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%TYPE,
44: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
45: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
46: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
47: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
48: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
49: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
50: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE
51: );
44: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%TYPE,
45: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
46: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
47: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
48: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
49: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
50: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE
51: );
52:
45: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%TYPE,
46: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
47: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
48: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
49: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
50: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE
51: );
52:
53: PROCEDURE delete_row(x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE);
46: x_last_update_date pn_rec_arcl_dtl.last_update_date%TYPE,
47: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%TYPE,
48: x_creation_date pn_rec_arcl_dtl.creation_date%TYPE,
49: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
50: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE
51: );
52:
53: PROCEDURE delete_row(x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE);
54:
49: x_created_by pn_rec_arcl_dtl.created_by%TYPE,
50: x_last_update_login pn_rec_arcl_dtl.last_update_login%TYPE
51: );
52:
53: PROCEDURE delete_row(x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE);
54:
55: END pn_rec_arcl_dtl_pkg;
51: );
52:
53: PROCEDURE delete_row(x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE);
54:
55: END pn_rec_arcl_dtl_pkg;