DBA Data[Home] [Help]

APPS.PN_MTM_ROLLFORWARD_PKG dependencies on PN_MO_CACHE_UTILS

Line 479: IF NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION', rec.org_id),'N') = 'N'

475: FOR rec2 IN get_lease_class_code( p_lease_id) LOOP
476: l_lease_class_code := rec2.lease_class_code;
477: END LOOP;
478:
479: IF NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION', rec.org_id),'N') = 'N'
480: AND l_lease_class_code <> 'DIRECT'
481: THEN
482: FOR conflict_rec IN chk_conflicts(p_lease_id,
483: rec.st_date,

Line 506: IF NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION', rec.org_id),'N') = 'Y'

502: FOR rec3 IN get_loc_type_code(rec.location_id) LOOP
503: l_loc_type_code := rec3.location_type_lookup_code;
504: END LOOP;
505:
506: IF NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION', rec.org_id),'N') = 'Y'
507: AND l_loc_type_code IN ('OFFICE', 'SECTION')
508: THEN
509: PN_SPACE_ASSIGN_CUST_PKG.assignment_split(
510: p_location_id => rec.location_id,