DBA Data[Home] [Help]

APPS.PN_LEASE_PVT dependencies on PN_LEASES_ALL

Line 4: -- Record Type for PN_LEASES_ALL and PN_LEASE_DETAILS_ALL record.

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'))

Line 14: , lease_name pn_leases_all.NAME%TYPE := pn_lease_utils.g_pn_miss_char

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

Line 15: , lease_num pn_leases_all.lease_num%TYPE := pn_lease_utils.g_pn_miss_char

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

Line 16: , parent_lease_name pn_leases_all.NAME%TYPE := 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

Line 17: , parent_lease_num pn_leases_all.lease_num%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

Line 20: , lease_type_code pn_leases_all.lease_type_code%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
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

Line 22: , lease_class_code pn_leases_all.lease_class_code%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
25: , location_code VARCHAR2 (30) := pn_lease_utils.g_pn_miss_char
26: , location_id NUMBER := pn_lease_utils.g_pn_miss_num

Line 27: , status_code pn_leases_all.status%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
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

Line 29: , lease_status_code pn_leases_all.lease_status%TYPE := pn_lease_utils.g_pn_miss_char

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

Line 50: , cal_start pn_leases_all.cal_start%TYPE := pn_lease_utils.g_pn_miss_char

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