DBA Data[Home] [Help]

APPS.PN_LEASE_PUB dependencies on PN_MO_CACHE_UTILS

Line 11: g_org_id CONSTANT NUMBER := fnd_profile.VALUE ('ORG_ID');--NVL(PN_MO_CACHE_UTILS.get_current_org_id,fnd_profile.VALUE ('org_id'));

7: g_resp_appl_id CONSTANT NUMBER := fnd_global.resp_appl_id;
8: g_resp_id CONSTANT NUMBER := fnd_global.resp_appl_id;
9: g_user_id CONSTANT NUMBER := fnd_global.user_id;
10: g_login_id CONSTANT NUMBER := fnd_global.login_id;
11: g_org_id CONSTANT NUMBER := fnd_profile.VALUE ('ORG_ID');--NVL(PN_MO_CACHE_UTILS.get_current_org_id,fnd_profile.VALUE ('org_id'));
12:
13: -- Procedure to create a new lease
14: PROCEDURE create_lease (
15: p_api_version IN NUMBER

Line 89: IF (NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_LEASE_NUMBER', p_lease_rec.org_id), 'N')) <> 'Y'

85: -- Required Parameters Validation
86: /*********************************************/
87: -- -------------------------------------------
88: -- Make sure the Lease Number is not null if Auto Lease Number is setup to No
89: IF (NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_LEASE_NUMBER', p_lease_rec.org_id), 'N')) <> 'Y'
90: THEN
91:
92: IF ( p_lease_rec.lease_num IS NULL
93: OR p_lease_rec.lease_num = pn_lease_utils.g_pn_miss_char