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.
PACKAGE: APPS.PN_REC_ARCL_DTLLN_PKG

Source


1 PACKAGE pn_rec_arcl_dtlln_pkg AUTHID CURRENT_USER AS
2 /* $Header: PNRACLDS.pls 115.4 2003/06/13 02:01:44 ftanudja noship $ */
3 
4 PROCEDURE insert_row(
5              x_org_id                  pn_rec_arcl_dtlln.org_id%TYPE,
6              x_area_class_dtl_id       pn_rec_arcl_dtlln.area_class_dtl_id%TYPE,
7              x_area_class_dtl_line_id  IN OUT NOCOPY pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE,
8              x_from_date               pn_rec_arcl_dtlln.from_date%TYPE,
9              x_to_date                 pn_rec_arcl_dtlln.to_date%TYPE,
10              x_location_id             pn_rec_arcl_dtlln.location_id%TYPE,
11              x_property_id             pn_rec_arcl_dtlln.property_id%TYPE,
12              x_cust_space_assign_id    pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
13              x_cust_account_id         pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
14              x_lease_id                pn_rec_arcl_dtlln.lease_id%TYPE,
15              x_assignable_area         pn_rec_arcl_dtlln.assignable_area%TYPE,
16              x_assigned_area           pn_rec_arcl_dtlln.assigned_area%TYPE,
17              x_assigned_area_ovr       pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
18              x_occupancy_pct           pn_rec_arcl_dtlln.occupancy_pct%TYPE,
19              x_occupied_area           pn_rec_arcl_dtlln.occupied_area%TYPE,
20              x_occupied_area_ovr       pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
21              x_vacant_area             pn_rec_arcl_dtlln.vacant_area%TYPE,
22              x_vacant_area_ovr         pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
23              x_weighted_avg            pn_rec_arcl_dtlln.weighted_avg%TYPE,
24              x_weighted_avg_ovr        pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
25              x_exclude_area_flag       pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
26              x_exclude_area_ovr_flag   pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
27              x_exclude_prorata_flag    pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
28              x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
29              x_include_flag            pn_rec_arcl_dtlln.include_flag%TYPE,
30              x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
31              x_recovery_type_code      pn_rec_arcl_dtlln.recovery_type_code%TYPE,
32              x_last_update_date        pn_rec_arcl_dtlln.last_update_date%TYPE,
33              x_last_updated_by         pn_rec_arcl_dtlln.last_updated_by%TYPE,
34              x_creation_date           pn_rec_arcl_dtlln.creation_date%TYPE,
35              x_created_by              pn_rec_arcl_dtlln.created_by%TYPE,
36              x_last_update_login       pn_rec_arcl_dtlln.last_update_login%TYPE);
37 
38 PROCEDURE update_row(
39              x_area_class_dtl_line_id  pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE,
40              x_from_date               pn_rec_arcl_dtlln.from_date%TYPE,
41              x_to_date                 pn_rec_arcl_dtlln.to_date%TYPE,
42              x_location_id             pn_rec_arcl_dtlln.location_id%TYPE,
43              x_property_id             pn_rec_arcl_dtlln.property_id%TYPE,
44              x_cust_space_assign_id    pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
45              x_cust_account_id         pn_rec_arcl_dtlln.cust_space_assign_id%TYPE,
46              x_lease_id                pn_rec_arcl_dtlln.lease_id%TYPE,
47              x_assignable_area         pn_rec_arcl_dtlln.assignable_area%TYPE,
48              x_assigned_area           pn_rec_arcl_dtlln.assigned_area%TYPE,
49              x_assigned_area_ovr     pn_rec_arcl_dtlln.assigned_area_ovr%TYPE,
50              x_occupancy_pct           pn_rec_arcl_dtlln.occupancy_pct%TYPE,
51              x_occupied_area           pn_rec_arcl_dtlln.occupied_area%TYPE,
52              x_occupied_area_ovr       pn_rec_arcl_dtlln.occupied_area_ovr%TYPE,
53              x_vacant_area             pn_rec_arcl_dtlln.vacant_area%TYPE,
54              x_vacant_area_ovr         pn_rec_arcl_dtlln.vacant_area_ovr%TYPE,
55              x_weighted_avg            pn_rec_arcl_dtlln.weighted_avg%TYPE,
56              x_weighted_avg_ovr        pn_rec_arcl_dtlln.weighted_avg_ovr%TYPE,
57              x_exclude_area_flag       pn_rec_arcl_dtlln.exclude_area_flag%TYPE,
58              x_exclude_area_ovr_flag   pn_rec_arcl_dtlln.exclude_area_ovr_flag%TYPE,
59              x_exclude_prorata_flag    pn_rec_arcl_dtlln.exclude_prorata_flag%TYPE,
60              x_exclude_prorata_ovr_flag pn_rec_arcl_dtlln.exclude_prorata_ovr_flag%TYPE,
61              x_include_flag            pn_rec_arcl_dtlln.include_flag%TYPE,
62              x_recovery_space_std_code pn_rec_arcl_dtlln.recovery_space_std_code%TYPE,
63              x_recovery_type_code      pn_rec_arcl_dtlln.recovery_type_code%TYPE,
64              x_last_update_date        pn_rec_arcl_dtlln.last_update_date%TYPE,
65              x_last_updated_by         pn_rec_arcl_dtlln.last_updated_by%TYPE,
66              x_creation_date           pn_rec_arcl_dtlln.creation_date%TYPE,
67              x_created_by              pn_rec_arcl_dtlln.created_by%TYPE,
68              x_last_update_login       pn_rec_arcl_dtlln.last_update_login%TYPE);
69 
70 PROCEDURE delete_row(x_area_class_dtl_line_id    pn_rec_arcl_dtlln.area_class_dtl_line_id%TYPE);
71 
72 END pn_rec_arcl_dtlln_pkg;