PACKAGE: APPS.PN_REC_ARCL_DTL_PKG

Source

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,
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,
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 
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,
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,
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 
55 END pn_rec_arcl_dtl_pkg;