eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_REC_ARCL_DTLLN_PKG dependencies on PN_REC_ARCL_DTLLN

Line 1: PACKAGE BODY pn_rec_arcl_dtlln_pkg AS

1: PACKAGE BODY pn_rec_arcl_dtlln_pkg AS
2: /* $Header: PNRACLDB.pls 120.2 2005/11/30 23:29:12 appldev noship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PROCDURE : INSERT_ROW

Line 13: x_org_id pn_rec_arcl_dtlln.org_id%TYPE,

9: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
10: -- 28-NOV-05 pikhar o fetched org_id using cursor
11: -------------------------------------------------------------------------------
12: PROCEDURE insert_row(
13: x_org_id pn_rec_arcl_dtlln.org_id%TYPE,
14: x_area_class_dtl_id pn_rec_arcl_dtlln.area_class_dtl_id%TYPE,
15: x_area_class_dtl_line_id IN OUT NOCOPY pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE,
16: x_from_date pn_rec_arcl_dtlln.from_date%TYPE,
17: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,

Line 14: x_area_class_dtl_id pn_rec_arcl_dtlln.area_class_dtl_id%TYPE,

10: -- 28-NOV-05 pikhar o fetched org_id using cursor
11: -------------------------------------------------------------------------------
12: PROCEDURE insert_row(
13: x_org_id pn_rec_arcl_dtlln.org_id%TYPE,
14: x_area_class_dtl_id pn_rec_arcl_dtlln.area_class_dtl_id%TYPE,
15: x_area_class_dtl_line_id IN OUT NOCOPY pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE,
16: x_from_date pn_rec_arcl_dtlln.from_date%TYPE,
17: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,
18: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,

Line 15: x_area_class_dtl_line_id IN OUT NOCOPY pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE,

11: -------------------------------------------------------------------------------
12: PROCEDURE insert_row(
13: x_org_id pn_rec_arcl_dtlln.org_id%TYPE,
14: x_area_class_dtl_id pn_rec_arcl_dtlln.area_class_dtl_id%TYPE,
15: x_area_class_dtl_line_id IN OUT NOCOPY pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE,
16: x_from_date pn_rec_arcl_dtlln.from_date%TYPE,
17: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,
18: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,
19: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,

Line 16: x_from_date pn_rec_arcl_dtlln.from_date%TYPE,

12: PROCEDURE insert_row(
13: x_org_id pn_rec_arcl_dtlln.org_id%TYPE,
14: x_area_class_dtl_id pn_rec_arcl_dtlln.area_class_dtl_id%TYPE,
15: x_area_class_dtl_line_id IN OUT NOCOPY pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE,
16: x_from_date pn_rec_arcl_dtlln.from_date%TYPE,
17: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,
18: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,
19: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,
20: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,

Line 17: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,

13: x_org_id pn_rec_arcl_dtlln.org_id%TYPE,
14: x_area_class_dtl_id pn_rec_arcl_dtlln.area_class_dtl_id%TYPE,
15: x_area_class_dtl_line_id IN OUT NOCOPY pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE,
16: x_from_date pn_rec_arcl_dtlln.from_date%TYPE,
17: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,
18: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,
19: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,
20: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
21: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,

Line 18: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,

14: x_area_class_dtl_id pn_rec_arcl_dtlln.area_class_dtl_id%TYPE,
15: x_area_class_dtl_line_id IN OUT NOCOPY pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE,
16: x_from_date pn_rec_arcl_dtlln.from_date%TYPE,
17: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,
18: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,
19: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,
20: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
21: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
22: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,

Line 19: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,

15: x_area_class_dtl_line_id IN OUT NOCOPY pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE,
16: x_from_date pn_rec_arcl_dtlln.from_date%TYPE,
17: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,
18: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,
19: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,
20: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
21: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
22: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,
23: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,

Line 20: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,

16: x_from_date pn_rec_arcl_dtlln.from_date%TYPE,
17: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,
18: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,
19: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,
20: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
21: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
22: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,
23: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,
24: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,

Line 21: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,

17: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,
18: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,
19: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,
20: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
21: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
22: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,
23: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,
24: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,
25: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,

Line 22: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,

18: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,
19: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,
20: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
21: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
22: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,
23: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,
24: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,
25: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
26: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,

Line 23: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,

19: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,
20: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
21: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
22: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,
23: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,
24: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,
25: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
26: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,
27: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,

Line 24: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,

20: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
21: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
22: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,
23: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,
24: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,
25: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
26: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,
27: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,
28: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,

Line 25: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,

21: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
22: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,
23: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,
24: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,
25: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
26: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,
27: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,
28: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
29: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,

Line 26: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,

22: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,
23: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,
24: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,
25: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
26: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,
27: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,
28: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
29: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,
30: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,

Line 27: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,

23: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,
24: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,
25: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
26: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,
27: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,
28: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
29: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,
30: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
31: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,

Line 28: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,

24: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,
25: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
26: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,
27: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,
28: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
29: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,
30: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
31: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,
32: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,

Line 29: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,

25: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
26: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,
27: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,
28: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
29: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,
30: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
31: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,
32: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
33: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,

Line 30: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,

26: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,
27: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,
28: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
29: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,
30: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
31: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,
32: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
33: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
34: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,

Line 31: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,

27: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,
28: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
29: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,
30: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
31: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,
32: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
33: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
34: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
35: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,

Line 32: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,

28: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
29: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,
30: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
31: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,
32: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
33: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
34: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
35: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
36: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,

Line 33: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,

29: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,
30: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
31: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,
32: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
33: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
34: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
35: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
36: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
37: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,

Line 34: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,

30: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
31: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,
32: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
33: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
34: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
35: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
36: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
37: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,
38: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,

Line 35: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,

31: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,
32: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
33: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
34: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
35: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
36: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
37: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,
38: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
39: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,

Line 36: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,

32: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
33: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
34: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
35: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
36: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
37: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,
38: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
39: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,
40: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,

Line 37: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,

33: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
34: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
35: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
36: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
37: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,
38: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
39: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,
40: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,
41: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,

Line 38: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,

34: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
35: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
36: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
37: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,
38: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
39: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,
40: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,
41: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,
42: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,

Line 39: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,

35: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
36: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
37: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,
38: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
39: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,
40: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,
41: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,
42: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,
43: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,

Line 40: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,

36: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
37: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,
38: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
39: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,
40: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,
41: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,
42: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,
43: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,
44: x_last_update_login pn_rec_arcl_dtlln.last_update_login%TYPE)

Line 41: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,

37: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,
38: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
39: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,
40: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,
41: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,
42: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,
43: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,
44: x_last_update_login pn_rec_arcl_dtlln.last_update_login%TYPE)
45: IS

Line 42: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,

38: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
39: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,
40: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,
41: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,
42: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,
43: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,
44: x_last_update_login pn_rec_arcl_dtlln.last_update_login%TYPE)
45: IS
46: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.insert_row';

Line 43: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,

39: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,
40: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,
41: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,
42: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,
43: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,
44: x_last_update_login pn_rec_arcl_dtlln.last_update_login%TYPE)
45: IS
46: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.insert_row';
47:

Line 44: x_last_update_login pn_rec_arcl_dtlln.last_update_login%TYPE)

40: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,
41: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,
42: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,
43: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,
44: x_last_update_login pn_rec_arcl_dtlln.last_update_login%TYPE)
45: IS
46: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.insert_row';
47:
48: CURSOR org_cur IS

Line 46: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.insert_row';

42: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,
43: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,
44: x_last_update_login pn_rec_arcl_dtlln.last_update_login%TYPE)
45: IS
46: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.insert_row';
47:
48: CURSOR org_cur IS
49: SELECT org_id
50: FROM pn_rec_arcl_dtl_all

Line 67: INSERT INTO pn_rec_arcl_dtlln_all

63: ELSE
64: l_org_id := x_org_id;
65: END IF;
66:
67: INSERT INTO pn_rec_arcl_dtlln_all
68: (
69: org_id,
70: area_class_dtl_id,
71: area_class_dtl_line_id,

Line 105: pn_rec_arcl_dtlln_s.nextval,

101: )VALUES
102: (
103: l_org_id,
104: x_area_class_dtl_id,
105: pn_rec_arcl_dtlln_s.nextval,
106: x_from_date,
107: x_to_date,
108: x_location_id,
109: x_property_id,

Line 153: x_area_class_dtl_line_id pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE,

149: -- HISTORY :
150: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
151: -------------------------------------------------------------------------------
152: PROCEDURE update_row(
153: x_area_class_dtl_line_id pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE,
154: x_from_date pn_rec_arcl_dtlln.from_date%TYPE,
155: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,
156: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,
157: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,

Line 154: x_from_date pn_rec_arcl_dtlln.from_date%TYPE,

150: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
151: -------------------------------------------------------------------------------
152: PROCEDURE update_row(
153: x_area_class_dtl_line_id pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE,
154: x_from_date pn_rec_arcl_dtlln.from_date%TYPE,
155: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,
156: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,
157: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,
158: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,

Line 155: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,

151: -------------------------------------------------------------------------------
152: PROCEDURE update_row(
153: x_area_class_dtl_line_id pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE,
154: x_from_date pn_rec_arcl_dtlln.from_date%TYPE,
155: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,
156: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,
157: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,
158: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
159: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,

Line 156: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,

152: PROCEDURE update_row(
153: x_area_class_dtl_line_id pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE,
154: x_from_date pn_rec_arcl_dtlln.from_date%TYPE,
155: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,
156: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,
157: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,
158: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
159: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
160: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,

Line 157: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,

153: x_area_class_dtl_line_id pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE,
154: x_from_date pn_rec_arcl_dtlln.from_date%TYPE,
155: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,
156: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,
157: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,
158: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
159: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
160: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,
161: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,

Line 158: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,

154: x_from_date pn_rec_arcl_dtlln.from_date%TYPE,
155: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,
156: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,
157: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,
158: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
159: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
160: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,
161: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,
162: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,

Line 159: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,

155: x_to_date pn_rec_arcl_dtlln.to_date%TYPE,
156: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,
157: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,
158: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
159: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
160: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,
161: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,
162: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,
163: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,

Line 160: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,

156: x_location_id pn_rec_arcl_dtlln.location_id%TYPE,
157: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,
158: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
159: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
160: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,
161: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,
162: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,
163: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
164: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,

Line 161: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,

157: x_property_id pn_rec_arcl_dtlln.property_id%TYPE,
158: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
159: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
160: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,
161: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,
162: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,
163: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
164: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,
165: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,

Line 162: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,

158: x_cust_space_assign_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
159: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
160: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,
161: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,
162: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,
163: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
164: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,
165: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,
166: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,

Line 163: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,

159: x_cust_account_id pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
160: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,
161: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,
162: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,
163: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
164: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,
165: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,
166: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
167: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,

Line 164: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,

160: x_lease_id pn_rec_arcl_dtlln.lease_id%TYPE,
161: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,
162: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,
163: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
164: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,
165: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,
166: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
167: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,
168: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,

Line 165: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,

161: x_assignable_area pn_rec_arcl_dtlln.assignable_area%TYPE,
162: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,
163: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
164: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,
165: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,
166: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
167: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,
168: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
169: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,

Line 166: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,

162: x_assigned_area pn_rec_arcl_dtlln.assigned_area%TYPE,
163: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
164: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,
165: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,
166: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
167: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,
168: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
169: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,
170: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,

Line 167: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,

163: x_assigned_area_ovr pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
164: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,
165: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,
166: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
167: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,
168: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
169: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,
170: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
171: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,

Line 168: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,

164: x_occupancy_pct pn_rec_arcl_dtlln.occupancy_pct%TYPE,
165: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,
166: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
167: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,
168: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
169: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,
170: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
171: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
172: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,

Line 169: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,

165: x_occupied_area pn_rec_arcl_dtlln.occupied_area%TYPE,
166: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
167: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,
168: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
169: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,
170: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
171: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
172: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
173: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,

Line 170: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,

166: x_occupied_area_ovr pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
167: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,
168: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
169: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,
170: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
171: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
172: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
173: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
174: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,

Line 171: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,

167: x_vacant_area pn_rec_arcl_dtlln.vacant_area%TYPE,
168: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
169: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,
170: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
171: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
172: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
173: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
174: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
175: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,

Line 172: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,

168: x_vacant_area_ovr pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
169: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,
170: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
171: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
172: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
173: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
174: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
175: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,
176: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,

Line 173: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,

169: x_weighted_avg pn_rec_arcl_dtlln.weighted_avg%TYPE,
170: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
171: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
172: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
173: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
174: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
175: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,
176: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
177: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,

Line 174: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,

170: x_weighted_avg_ovr pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
171: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
172: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
173: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
174: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
175: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,
176: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
177: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,
178: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,

Line 175: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,

171: x_exclude_area_flag pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
172: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
173: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
174: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
175: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,
176: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
177: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,
178: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,
179: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,

Line 176: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,

172: x_exclude_area_ovr_flag pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
173: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
174: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
175: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,
176: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
177: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,
178: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,
179: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,
180: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,

Line 177: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,

173: x_exclude_prorata_flag pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
174: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
175: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,
176: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
177: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,
178: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,
179: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,
180: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,
181: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,

Line 178: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,

174: x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
175: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,
176: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
177: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,
178: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,
179: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,
180: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,
181: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,
182: x_last_update_login pn_rec_arcl_dtlln.last_update_login%TYPE)

Line 179: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,

175: x_include_flag pn_rec_arcl_dtlln.include_flag%TYPE,
176: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
177: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,
178: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,
179: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,
180: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,
181: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,
182: x_last_update_login pn_rec_arcl_dtlln.last_update_login%TYPE)
183: IS

Line 180: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,

176: x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
177: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,
178: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,
179: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,
180: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,
181: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,
182: x_last_update_login pn_rec_arcl_dtlln.last_update_login%TYPE)
183: IS
184: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.update_row';

Line 181: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,

177: x_recovery_type_code pn_rec_arcl_dtlln.recovery_type_code%TYPE,
178: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,
179: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,
180: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,
181: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,
182: x_last_update_login pn_rec_arcl_dtlln.last_update_login%TYPE)
183: IS
184: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.update_row';
185: BEGIN

Line 182: x_last_update_login pn_rec_arcl_dtlln.last_update_login%TYPE)

178: x_last_update_date pn_rec_arcl_dtlln.last_update_date%TYPE,
179: x_last_updated_by pn_rec_arcl_dtlln.last_updated_by%TYPE,
180: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,
181: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,
182: x_last_update_login pn_rec_arcl_dtlln.last_update_login%TYPE)
183: IS
184: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.update_row';
185: BEGIN
186:

Line 184: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.update_row';

180: x_creation_date pn_rec_arcl_dtlln.creation_date%TYPE,
181: x_created_by pn_rec_arcl_dtlln.created_by%TYPE,
182: x_last_update_login pn_rec_arcl_dtlln.last_update_login%TYPE)
183: IS
184: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.update_row';
185: BEGIN
186:
187: pnp_debug_pkg.debug(l_desc ||' (+)');
188:

Line 189: UPDATE pn_rec_arcl_dtlln_all

185: BEGIN
186:
187: pnp_debug_pkg.debug(l_desc ||' (+)');
188:
189: UPDATE pn_rec_arcl_dtlln_all
190: SET
191: from_date = x_from_date,
192: to_date = x_to_date,
193: location_id = x_location_id,

Line 237: PROCEDURE delete_row(x_area_class_dtl_line_id pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE)

233: -- PURPOSE : deletes the row
234: -- HISTORY :
235: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
236: -------------------------------------------------------------------------------
237: PROCEDURE delete_row(x_area_class_dtl_line_id pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE)
238: IS
239: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.delete_row';
240: BEGIN
241:

Line 239: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.delete_row';

235: -- 15-JUL-05 sdmahesh o Replaced base views with their _ALL table.
236: -------------------------------------------------------------------------------
237: PROCEDURE delete_row(x_area_class_dtl_line_id pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE)
238: IS
239: l_desc VARCHAR2(100) := 'pn_rec_arcl_dtlln_pkg.delete_row';
240: BEGIN
241:
242: pnp_debug_pkg.debug(l_desc ||' (+)');
243:

Line 244: DELETE pn_rec_arcl_dtlln_all

240: BEGIN
241:
242: pnp_debug_pkg.debug(l_desc ||' (+)');
243:
244: DELETE pn_rec_arcl_dtlln_all
245: WHERE area_class_dtl_line_id = x_area_class_dtl_line_id;
246:
247: pnp_debug_pkg.debug(l_desc ||' (-)');
248:

Line 255: END pn_rec_arcl_dtlln_pkg;

251: RAISE_APPLICATION_ERROR(-20001, to_char(sqlcode));
252: app_exception.raise_exception;
253: END delete_row;
254:
255: END pn_rec_arcl_dtlln_pkg;