APPS.PN_REC_ARCL_DTL_PKG dependencies on PN_REC_ARCL_DTL

Line 1: PACKAGE BODY pn_rec_arcl_dtl_pkg AS

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: -------------------------------------------------------------------------------

Line 14: x_org_id pn_rec_arcl_dtl.org_id%TYPE,

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,

Line 15: x_area_class_id pn_rec_arcl_dtl.area_class_id%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,

Line 16: x_area_class_dtl_id IN OUT NOCOPY pn_rec_arcl_dtl.area_class_dtl_id%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,

Line 17: x_as_of_date pn_rec_arcl_dtl.as_of_date%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,

Line 18: x_from_date pn_rec_arcl_dtl.from_date%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,

Line 19: x_to_date pn_rec_arcl_dtl.to_date%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,

Line 20: x_status pn_rec_arcl_dtl.status%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,

Line 21: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%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,

Line 22: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_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,

Line 23: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_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,

Line 24: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_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,

Line 25: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%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,

Line 26: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_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,

Line 27: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_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,

Line 28: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%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,

Line 29: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%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,

Line 30: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%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,

Line 31: x_last_update_date pn_rec_arcl_dtl.last_update_date%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)

Line 32: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%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

Line 33: x_creation_date pn_rec_arcl_dtl.creation_date%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
37: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.insert_row';

Line 34: x_created_by pn_rec_arcl_dtl.created_by%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';
38:

Line 35: x_last_update_login pn_rec_arcl_dtl.last_update_login%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:
39: CURSOR org_cur IS

Line 37: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.insert_row';

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

Line 58: INSERT INTO pn_rec_arcl_dtl_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,

Line 85: pn_rec_arcl_dtl_s.nextval,

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,

Line 124: x_area_class_id pn_rec_arcl_dtl.area_class_id%TYPE,

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,

Line 125: x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%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,

Line 126: x_as_of_date pn_rec_arcl_dtl.as_of_date%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,

Line 127: x_from_date pn_rec_arcl_dtl.from_date%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,

Line 128: x_to_date pn_rec_arcl_dtl.to_date%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,

Line 129: x_status pn_rec_arcl_dtl.status%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,

Line 130: x_ttl_assignable_area pn_rec_arcl_dtl.total_assignable_area%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,

Line 131: x_ttl_occupied_area pn_rec_arcl_dtl.total_occupied_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,

Line 132: x_ttl_occupied_area_ovr pn_rec_arcl_dtl.total_occupied_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,

Line 133: x_ttl_occupied_area_exc pn_rec_arcl_dtl.total_occupied_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,

Line 134: x_ttl_vacant_area pn_rec_arcl_dtl.total_vacant_area%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,

Line 135: x_ttl_vacant_area_ovr pn_rec_arcl_dtl.total_vacant_area_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,

Line 136: x_ttl_vacant_area_exc pn_rec_arcl_dtl.total_vacant_area_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,

Line 137: x_ttl_weighted_avg pn_rec_arcl_dtl.total_weighted_avg%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,

Line 138: x_ttl_weighted_avg_ovr pn_rec_arcl_dtl.total_weighted_avg_ovr%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,

Line 139: x_ttl_weighted_avg_exc pn_rec_arcl_dtl.total_weighted_avg_exc%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,

Line 140: x_last_update_date pn_rec_arcl_dtl.last_update_date%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)

Line 141: x_last_updated_by pn_rec_arcl_dtl.last_updated_by%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

Line 142: x_creation_date pn_rec_arcl_dtl.creation_date%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
146: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.update_row';

Line 143: x_created_by pn_rec_arcl_dtl.created_by%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';
147: BEGIN

Line 144: x_last_update_login pn_rec_arcl_dtl.last_update_login%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
148:

Line 146: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.update_row';

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:

Line 151: UPDATE pn_rec_arcl_dtl_all

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,

Line 191: PROCEDURE delete_row(x_area_class_dtl_id pn_rec_arcl_dtl.area_class_dtl_id%TYPE)

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:

Line 193: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtl_pkg.delete_row';

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:

Line 198: DELETE pn_rec_arcl_dtl_all

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:

Line 209: END pn_rec_arcl_dtl_pkg;

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;