1: PACKAGE PN_LEASE_PVT AUTHID CURRENT_USER AS
2: /* $Header: PNLSPVTS.pls 120.2 2011/09/30 17:45:05 asahoo ship $ */
3:
4: -- Record Type for PN_LEASES_ALL and PN_LEASE_DETAILS_ALL record.
5: TYPE lease_rec IS RECORD (
6: lease_id NUMBER := pn_lease_utils.g_pn_miss_num
7: , lease_change_id NUMBER := pn_lease_utils.g_pn_miss_num
8: , org_id NUMBER := nvl(pn_mo_cache_utils.get_current_org_id,fnd_profile.value ('org_id'))
10: , last_updated_by NUMBER := pn_lease_utils.g_pn_miss_num
11: , creation_date DATE := pn_lease_utils.g_pn_miss_date
12: , created_by NUMBER := pn_lease_utils.g_pn_miss_num
13: , last_update_login NUMBER := pn_lease_utils.g_pn_miss_num
14: , lease_name pn_leases_all.NAME%TYPE := pn_lease_utils.g_pn_miss_char
15: , lease_num pn_leases_all.lease_num%TYPE := pn_lease_utils.g_pn_miss_char
16: , parent_lease_name pn_leases_all.NAME%TYPE := pn_lease_utils.g_pn_miss_char
17: , parent_lease_num pn_leases_all.lease_num%TYPE := pn_lease_utils.g_pn_miss_char
18: , parent_lease_id NUMBER := pn_lease_utils.g_pn_miss_num
11: , creation_date DATE := pn_lease_utils.g_pn_miss_date
12: , created_by NUMBER := pn_lease_utils.g_pn_miss_num
13: , last_update_login NUMBER := pn_lease_utils.g_pn_miss_num
14: , lease_name pn_leases_all.NAME%TYPE := pn_lease_utils.g_pn_miss_char
15: , lease_num pn_leases_all.lease_num%TYPE := pn_lease_utils.g_pn_miss_char
16: , parent_lease_name pn_leases_all.NAME%TYPE := pn_lease_utils.g_pn_miss_char
17: , parent_lease_num pn_leases_all.lease_num%TYPE := pn_lease_utils.g_pn_miss_char
18: , parent_lease_id NUMBER := pn_lease_utils.g_pn_miss_num
19: , lease_type VARCHAR2 (80) := pn_lease_utils.g_pn_miss_char
12: , created_by NUMBER := pn_lease_utils.g_pn_miss_num
13: , last_update_login NUMBER := pn_lease_utils.g_pn_miss_num
14: , lease_name pn_leases_all.NAME%TYPE := pn_lease_utils.g_pn_miss_char
15: , lease_num pn_leases_all.lease_num%TYPE := pn_lease_utils.g_pn_miss_char
16: , parent_lease_name pn_leases_all.NAME%TYPE := pn_lease_utils.g_pn_miss_char
17: , parent_lease_num pn_leases_all.lease_num%TYPE := pn_lease_utils.g_pn_miss_char
18: , parent_lease_id NUMBER := pn_lease_utils.g_pn_miss_num
19: , lease_type VARCHAR2 (80) := pn_lease_utils.g_pn_miss_char
20: , lease_type_code pn_leases_all.lease_type_code%TYPE := pn_lease_utils.g_pn_miss_char
13: , last_update_login NUMBER := pn_lease_utils.g_pn_miss_num
14: , lease_name pn_leases_all.NAME%TYPE := pn_lease_utils.g_pn_miss_char
15: , lease_num pn_leases_all.lease_num%TYPE := pn_lease_utils.g_pn_miss_char
16: , parent_lease_name pn_leases_all.NAME%TYPE := pn_lease_utils.g_pn_miss_char
17: , parent_lease_num pn_leases_all.lease_num%TYPE := pn_lease_utils.g_pn_miss_char
18: , parent_lease_id NUMBER := pn_lease_utils.g_pn_miss_num
19: , lease_type VARCHAR2 (80) := pn_lease_utils.g_pn_miss_char
20: , lease_type_code pn_leases_all.lease_type_code%TYPE := pn_lease_utils.g_pn_miss_char
21: , lease_class VARCHAR2 (80) := pn_lease_utils.g_pn_miss_char
16: , parent_lease_name pn_leases_all.NAME%TYPE := pn_lease_utils.g_pn_miss_char
17: , parent_lease_num pn_leases_all.lease_num%TYPE := pn_lease_utils.g_pn_miss_char
18: , parent_lease_id NUMBER := pn_lease_utils.g_pn_miss_num
19: , lease_type VARCHAR2 (80) := pn_lease_utils.g_pn_miss_char
20: , lease_type_code pn_leases_all.lease_type_code%TYPE := pn_lease_utils.g_pn_miss_char
21: , lease_class VARCHAR2 (80) := pn_lease_utils.g_pn_miss_char
22: , lease_class_code pn_leases_all.lease_class_code%TYPE:= pn_lease_utils.g_pn_miss_char
23: , abstracted_by_user fnd_user.user_name%TYPE := pn_lease_utils.g_pn_miss_char
24: , abstracted_by_user_id NUMBER := pn_lease_utils.g_pn_miss_num
18: , parent_lease_id NUMBER := pn_lease_utils.g_pn_miss_num
19: , lease_type VARCHAR2 (80) := pn_lease_utils.g_pn_miss_char
20: , lease_type_code pn_leases_all.lease_type_code%TYPE := pn_lease_utils.g_pn_miss_char
21: , lease_class VARCHAR2 (80) := pn_lease_utils.g_pn_miss_char
22: , lease_class_code pn_leases_all.lease_class_code%TYPE:= pn_lease_utils.g_pn_miss_char
23: , abstracted_by_user fnd_user.user_name%TYPE := pn_lease_utils.g_pn_miss_char
24: , abstracted_by_user_id NUMBER := pn_lease_utils.g_pn_miss_num
25: , location_code VARCHAR2 (30) := pn_lease_utils.g_pn_miss_char
26: , location_id NUMBER := pn_lease_utils.g_pn_miss_num
23: , abstracted_by_user fnd_user.user_name%TYPE := pn_lease_utils.g_pn_miss_char
24: , abstracted_by_user_id NUMBER := pn_lease_utils.g_pn_miss_num
25: , location_code VARCHAR2 (30) := pn_lease_utils.g_pn_miss_char
26: , location_id NUMBER := pn_lease_utils.g_pn_miss_num
27: , status_code pn_leases_all.status%TYPE := pn_lease_utils.g_pn_miss_char
28: , status VARCHAR2 (80) := pn_lease_utils.g_pn_miss_char
29: , lease_status_code pn_leases_all.lease_status%TYPE := pn_lease_utils.g_pn_miss_char
30: , lease_status VARCHAR2 (80) := pn_lease_utils.g_pn_miss_char
31: , lease_detail_id NUMBER := pn_lease_utils.g_pn_miss_num
25: , location_code VARCHAR2 (30) := pn_lease_utils.g_pn_miss_char
26: , location_id NUMBER := pn_lease_utils.g_pn_miss_num
27: , status_code pn_leases_all.status%TYPE := pn_lease_utils.g_pn_miss_char
28: , status VARCHAR2 (80) := pn_lease_utils.g_pn_miss_char
29: , lease_status_code pn_leases_all.lease_status%TYPE := pn_lease_utils.g_pn_miss_char
30: , lease_status VARCHAR2 (80) := pn_lease_utils.g_pn_miss_char
31: , lease_detail_id NUMBER := pn_lease_utils.g_pn_miss_num
32: , lease_commencement_date DATE := pn_lease_utils.g_pn_miss_date
33: , lease_termination_date DATE := pn_lease_utils.g_pn_miss_date
46: , send_entries VARCHAR2 (1) := pn_lease_utils.g_pn_miss_char
47: , amend_comm_date DATE := pn_lease_utils.g_pn_miss_date
48: , amend_exec_date DATE := pn_lease_utils.g_pn_miss_date
49: , amend_lease_name pn_lease_changes_all.lease_change_name%TYPE := pn_lease_utils.g_pn_miss_char
50: , cal_start pn_leases_all.cal_start%TYPE := pn_lease_utils.g_pn_miss_char
51: , attribute_category VARCHAR2 (30) := pn_lease_utils.g_pn_miss_char
52: , attribute1 VARCHAR2 (150) := pn_lease_utils.g_pn_miss_char
53: , attribute2 VARCHAR2 (150) := pn_lease_utils.g_pn_miss_char
54: , attribute3 VARCHAR2 (150) := pn_lease_utils.g_pn_miss_char