DBA Data[Home] [Help]

APPS.PN_LEASE_PVT dependencies on PN_MO_CACHE_UTILS

Line 8: , org_id NUMBER := nvl(pn_mo_cache_utils.get_current_org_id,fnd_profile.value ('org_id'))

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'))
9: , last_update_date DATE := pn_lease_utils.g_pn_miss_date
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

Line 117: , org_id NUMBER := nvl(pn_mo_cache_utils.get_current_org_id,fnd_profile.value ('org_id'))

113: , lease_change_id NUMBER := pn_lease_utils.g_pn_miss_num
114: , location_code VARCHAR2 (30) := pn_lease_utils.g_pn_miss_char
115: , location_id NUMBER := pn_lease_utils.g_pn_miss_num
116: , status VARCHAR2 (1) := pn_lease_utils.g_pn_miss_char
117: , org_id NUMBER := nvl(pn_mo_cache_utils.get_current_org_id,fnd_profile.value ('org_id'))
118: , attribute_category VARCHAR2 (30) := pn_lease_utils.g_pn_miss_char
119: , attribute1 VARCHAR2 (150) := pn_lease_utils.g_pn_miss_char
120: , attribute2 VARCHAR2 (150) := pn_lease_utils.g_pn_miss_char
121: , attribute3 VARCHAR2 (150) := pn_lease_utils.g_pn_miss_char

Line 178: , org_id NUMBER := nvl(pn_mo_cache_utils.get_current_org_id,fnd_profile.value ('org_id'))

174: , attribute12 VARCHAR2 (150) := pn_lease_utils.g_pn_miss_char
175: , attribute13 VARCHAR2 (150) := pn_lease_utils.g_pn_miss_char
176: , attribute14 VARCHAR2 (150) := pn_lease_utils.g_pn_miss_char
177: , attribute15 VARCHAR2 (150) := pn_lease_utils.g_pn_miss_char
178: , org_id NUMBER := nvl(pn_mo_cache_utils.get_current_org_id,fnd_profile.value ('org_id'))
179: , recovery_type_code pn_tenancies_all.recovery_type_code%TYPE:= pn_lease_utils.g_pn_miss_char
180: , recovery_type_meaning VARCHAR2(80) := pn_lease_utils.g_pn_miss_char
181: , recovery_space_std_code pn_tenancies_all.recovery_space_std_code%TYPE:= pn_lease_utils.g_pn_miss_char
182: , recovery_space_std_meaning VARCHAR2(30) := pn_lease_utils.g_pn_miss_char

Line 523: , org_id NUMBER := nvl(pn_mo_cache_utils.get_current_org_id,fnd_profile.value ('org_id'))

519: , attribute12 pn_payment_terms_all.attribute12%TYPE := NULL
520: , attribute13 pn_payment_terms_all.attribute13 %TYPE := NULL
521: , attribute14 pn_payment_terms_all.attribute14 %TYPE := NULL
522: , attribute15 pn_payment_terms_all.attribute15%TYPE := NULL
523: , org_id NUMBER := nvl(pn_mo_cache_utils.get_current_org_id,fnd_profile.value ('org_id'))
524: , customer_id NUMBER := NULL
525: , customer_name VARCHAR2 (50) := NULL
526: , customer_site_use_id pn_payment_terms_all.customer_site_use_id%TYPE := NULL
527: , customer_site_code VARCHAR2 (30) := NULL