DBA Data[Home] [Help]

APPS.PN_MTM_ROLLFORWARD_PKG dependencies on PN_MO_CACHE_UTILS

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

526: FOR rec2 IN get_lease_class_code( p_lease_id) LOOP
527: l_lease_class_code := rec2.lease_class_code;
528: END LOOP;
529:
530: IF NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION', rec.org_id),'N') = 'N'
531: AND l_lease_class_code <> 'DIRECT'
532: THEN
533: FOR conflict_rec IN chk_conflicts(p_lease_id,
534: rec.st_date,

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

553: FOR rec3 IN get_loc_type_code(rec.location_id) LOOP
554: l_loc_type_code := rec3.location_type_lookup_code;
555: END LOOP;
556:
557: IF NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION', rec.org_id),'N') = 'Y'
558: AND l_loc_type_code IN ('OFFICE', 'SECTION')
559: THEN
560: PN_SPACE_ASSIGN_CUST_PKG.assignment_split(
561: p_location_id => rec.location_id,