eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_INDEX_AMOUNT_PKG dependencies on PN_MO_CACHE_UTILS

Line 892: -- 19-SEP-05 piagrawa o Modified to pass org id to pn_mo_cache_utils.

888: -- PN_CALC_ANNUALIZED_BASIS decide whether to calculate
889: -- annualized basis for the terms active as of the period
890: -- End date or the for the entire period.
891: -- Replaced the old 2 cursors with 4 new ones.
892: -- 19-SEP-05 piagrawa o Modified to pass org id to pn_mo_cache_utils.
893: -- get_profile_value
894: -- 14-AUG-06 pikhar o Added check to find out if contributing terms have
895: -- include_in_var_rent = 'INCLUDE_RI'
896: -- 23-SEP-06 prabhakar o Modified the curosrs to fetch terms from pn_index_exclude_term_all

Line 958: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR

954: (
955: ppt.payment_term_id NOT IN (select piet.payment_term_id
956: FROM pn_index_exclude_term_all piet
957: WHERE piet.index_lease_id = p_index_lease_id)
958: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR
959: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
960: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')
961: )
962: )

Line 959: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR

955: ppt.payment_term_id NOT IN (select piet.payment_term_id
956: FROM pn_index_exclude_term_all piet
957: WHERE piet.index_lease_id = p_index_lease_id)
958: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR
959: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
960: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')
961: )
962: )
963: )

Line 960: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')

956: FROM pn_index_exclude_term_all piet
957: WHERE piet.index_lease_id = p_index_lease_id)
958: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR
959: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
960: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')
961: )
962: )
963: )
964: AND ppt.currency_code = pil.currency_code;

Line 998: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR

994: (
995: ppt.payment_term_id NOT IN (select piet.payment_term_id
996: FROM pn_index_exclude_term_all piet
997: WHERE piet.index_lease_id = p_index_lease_id)
998: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR
999: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
1000: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')
1001: )
1002: )

Line 999: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR

995: ppt.payment_term_id NOT IN (select piet.payment_term_id
996: FROM pn_index_exclude_term_all piet
997: WHERE piet.index_lease_id = p_index_lease_id)
998: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR
999: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
1000: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')
1001: )
1002: )
1003: )

Line 1000: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')

996: FROM pn_index_exclude_term_all piet
997: WHERE piet.index_lease_id = p_index_lease_id)
998: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR
999: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
1000: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')
1001: )
1002: )
1003: )
1004: AND ppt.currency_code = pil.currency_code;

Line 1036: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR

1032: (
1033: ppt.payment_term_id NOT IN (select piet.payment_term_id
1034: FROM pn_index_exclude_term_all piet
1035: WHERE piet.index_lease_id = p_index_lease_id)
1036: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR
1037: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
1038: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')
1039: )
1040: )

Line 1037: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR

1033: ppt.payment_term_id NOT IN (select piet.payment_term_id
1034: FROM pn_index_exclude_term_all piet
1035: WHERE piet.index_lease_id = p_index_lease_id)
1036: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR
1037: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
1038: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')
1039: )
1040: )
1041: )

Line 1038: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')

1034: FROM pn_index_exclude_term_all piet
1035: WHERE piet.index_lease_id = p_index_lease_id)
1036: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR
1037: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
1038: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')
1039: )
1040: )
1041: )
1042: AND ppt.currency_code = pil.currency_code;

Line 1072: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR

1068: (
1069: ppt.payment_term_id NOT IN (select piet.payment_term_id
1070: FROM pn_index_exclude_term_all piet
1071: WHERE piet.index_lease_id = p_index_lease_id)
1072: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR
1073: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
1074: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')
1075: )
1076: )

Line 1073: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR

1069: ppt.payment_term_id NOT IN (select piet.payment_term_id
1070: FROM pn_index_exclude_term_all piet
1071: WHERE piet.index_lease_id = p_index_lease_id)
1072: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR
1073: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
1074: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')
1075: )
1076: )
1077: )

Line 1074: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')

1070: FROM pn_index_exclude_term_all piet
1071: WHERE piet.index_lease_id = p_index_lease_id)
1072: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'Y' OR
1073: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
1074: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',p_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')
1075: )
1076: )
1077: )
1078: AND ppt.currency_code = pil.currency_code;

Line 1101: := pn_mo_cache_utils.get_profile_value('PN_CALC_ANNUALIZED_BASIS', l_org_id);

1097: END LOOP;
1098:
1099: /* get the value for the PN_CALC_ANNUALIZED_BASIS profile */
1100: l_calc_annualized_basis
1101: := pn_mo_cache_utils.get_profile_value('PN_CALC_ANNUALIZED_BASIS', l_org_id);
1102:
1103: /* if increase on GROSS, get all payment items regardless of type */
1104:
1105: IF p_type_code = c_increase_on_gross THEN

Line 2941: -- 19-SEP-05 piagrawa o Modified to pass org id to pn_mo_cache_utils.

2937: -- End date or the for the entire period.
2938: -- 14-APR-05 ftanudja o Added cur_sum_backbill_overlap_items and logic to
2939: -- take into account recurring term amount overlapping
2940: -- with backbill. #4307736
2941: -- 19-SEP-05 piagrawa o Modified to pass org id to pn_mo_cache_utils.
2942: -- get_profile_value
2943: -- 06-APR-06 hkulkarn o Bug4291907 - check if v_created_payment_term_id IS not
2944: -- null before making call to insert_inter_term
2945: -- 05-MAY-06 Hareesha o Bug# 5115291 Get the latest norm_st_date of

Line 3030: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'Y' OR

3026: (
3027: ppt.payment_term_id NOT IN (select piet.payment_term_id
3028: FROM pn_index_exclude_term_all piet
3029: WHERE piet.index_lease_id = p_index_lease_id)
3030: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'Y' OR
3031: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
3032: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')
3033: )
3034: )

Line 3031: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR

3027: ppt.payment_term_id NOT IN (select piet.payment_term_id
3028: FROM pn_index_exclude_term_all piet
3029: WHERE piet.index_lease_id = p_index_lease_id)
3030: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'Y' OR
3031: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
3032: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')
3033: )
3034: )
3035: )

Line 3032: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')

3028: FROM pn_index_exclude_term_all piet
3029: WHERE piet.index_lease_id = p_index_lease_id)
3030: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'Y' OR
3031: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'G' and NVL(pil.gross_flag,'N') = 'Y') OR
3032: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'U' and NVL(pil.gross_flag,'N') = 'N')
3033: )
3034: )
3035: )
3036: AND (( p_basis_type = c_basis_type_compound AND

Line 3098: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'Y' OR

3094: (
3095: ppt.payment_term_id NOT IN (select piet.payment_term_id
3096: FROM pn_index_exclude_term_all piet
3097: WHERE piet.index_lease_id = p_index_lease_id)
3098: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'Y' OR
3099: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'G' and l_gross_flag = 'Y' ) OR
3100: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'U' and l_gross_flag = 'N' )
3101: )
3102: )

Line 3099: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'G' and l_gross_flag = 'Y' ) OR

3095: ppt.payment_term_id NOT IN (select piet.payment_term_id
3096: FROM pn_index_exclude_term_all piet
3097: WHERE piet.index_lease_id = p_index_lease_id)
3098: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'Y' OR
3099: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'G' and l_gross_flag = 'Y' ) OR
3100: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'U' and l_gross_flag = 'N' )
3101: )
3102: )
3103: )

Line 3100: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'U' and l_gross_flag = 'N' )

3096: FROM pn_index_exclude_term_all piet
3097: WHERE piet.index_lease_id = p_index_lease_id)
3098: AND ( pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'Y' OR
3099: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'G' and l_gross_flag = 'Y' ) OR
3100: (pn_mo_cache_utils.get_profile_value('incl_terms_by_default_flag',ip_org_id) = 'U' and l_gross_flag = 'N' )
3101: )
3102: )
3103: )
3104: AND ( ( p_basis_type = c_basis_type_compound AND

Line 3337: := pn_mo_cache_utils.get_profile_value('PN_CALC_ANNUALIZED_BASIS', l_org_id);

3333: v_reference_period_type := ref_period_rec.reference_period;
3334: END LOOP;
3335:
3336: l_calc_annualized_basis
3337: := pn_mo_cache_utils.get_profile_value('PN_CALC_ANNUALIZED_BASIS', l_org_id);
3338:
3339: SELECT NVL (p_increase_on, c_increase_on_gross)
3340: INTO v_type_code
3341: FROM DUAL;

Line 5017: -- pn_mo_cache_utils.get_profile_value('PN_SET..').

5013: -- same location shld be defaulted for all
5014: -- index rent terms created for that rent increase.
5015: -- 18-SEP-02 ftanudja o changed call from fnd_profile.value('PN_SET..')
5016: -- to wrapper function
5017: -- pn_mo_cache_utils.get_profile_value('PN_SET..').
5018: -- 26-JAN-04 ftanudja o added handling logic for p_called_from ='NEGRENT'.
5019: -- #3255737.
5020: -- If 'NEGRENT' then use the term end dt,
5021: -- not lease term dt.

Line 5028: -- 19-SEP-05 piagrawa o Modified to pass org id to pn_mo_cache_utils.

5024: -- 08-OCT-04 stripath o Modified for BUG# 3961117, added new parameter p_calculate_date
5025: -- for not to create backbills if Assessment Date <= CutOff Date.
5026: -- 21-APR-05 ftanudja o Added area_type_code, area defaulting. #4324777
5027: -- 15-JUL-05 ftanudja o R12: tax_classification_code. #4495054.
5028: -- 19-SEP-05 piagrawa o Modified to pass org id to pn_mo_cache_utils.
5029: -- get_profile_value
5030: -- 25-NOV-05 pikhar o Modified org id passed to pn_mo_cache_utils.
5031: -- get_profile_value
5032: -- 06-APR-06 hkulkarn o Bug#4291907 - modified to comapre the term amount

Line 5030: -- 25-NOV-05 pikhar o Modified org id passed to pn_mo_cache_utils.

5026: -- 21-APR-05 ftanudja o Added area_type_code, area defaulting. #4324777
5027: -- 15-JUL-05 ftanudja o R12: tax_classification_code. #4495054.
5028: -- 19-SEP-05 piagrawa o Modified to pass org id to pn_mo_cache_utils.
5029: -- get_profile_value
5030: -- 25-NOV-05 pikhar o Modified org id passed to pn_mo_cache_utils.
5031: -- get_profile_value
5032: -- 06-APR-06 hkulkarn o Bug#4291907 - modified to comapre the term amount
5033: -- with value in system option SMALLEST_TERM_AMOUNT
5034: -- 18-APR-06 Hareesha o Bug#5115291 - Get the latest norm_start_date

Line 5496: v_gl_set_of_books_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID', v_org_id);

5492: END IF;
5493:
5494: /* Derive SET_OF_BOOKS_ID and currency code */
5495:
5496: v_gl_set_of_books_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID', v_org_id);
5497:
5498:
5499: IF p_term_template_id is not null THEN
5500: v_currency_code := g_currency_code;

Line 5623: AND abs(v_actual_amount) > nvl(pn_mo_cache_utils.get_profile_value('SMALLEST_TERM_AMOUNT',v_org_id),0)

5619:
5620: /* Create a record in PN_PAYMENT_TERMS table */
5621:
5622: IF ( v_actual_amount <> 0
5623: AND abs(v_actual_amount) > nvl(pn_mo_cache_utils.get_profile_value('SMALLEST_TERM_AMOUNT',v_org_id),0)
5624: ) THEN --#@#Bug4291907
5625:
5626: /* pikhar Start - Added for bug 5881424 - 15-FEB-07 */
5627: IF v_include_in_var_rent = 'INCLUDE_RI' THEN

Line 5825: l_prof_cut_off VARCHAR2(30) := pn_mo_cache_utils.get_profile_value('PN_CUTOFF_DATE');

5821: FUNCTION Get_Calculate_Date (p_assessment_date IN DATE,
5822: p_period_str_date IN DATE)
5823: RETURN DATE
5824: IS
5825: l_prof_cut_off VARCHAR2(30) := pn_mo_cache_utils.get_profile_value('PN_CUTOFF_DATE');
5826: l_cut_off_date DATE := NULL;
5827: l_calculate_date DATE;
5828: BEGIN
5829:

Line 5857: -- org id in pn_mo_cache_utils.get_profile_value

5853: -- DESCRIPTION : This function returns returns the lease of assessment date
5854: -- and the profile option cut off date(change from Legacy to PN)
5855: -- HISTORY :
5856: -- 19-SEP-05 piagrawa o Modified the signature of procedure. Also passed
5857: -- org id in pn_mo_cache_utils.get_profile_value
5858: -------------------------------------------------------------------------------
5859: FUNCTION Get_Calculate_Date (p_assessment_date IN DATE,
5860: p_period_str_date IN DATE,
5861: p_org_id IN NUMBER)

Line 5864: l_prof_cut_off VARCHAR2(30) := pn_mo_cache_utils.get_profile_value('PN_CUTOFF_DATE', p_org_id);

5860: p_period_str_date IN DATE,
5861: p_org_id IN NUMBER)
5862: RETURN DATE
5863: IS
5864: l_prof_cut_off VARCHAR2(30) := pn_mo_cache_utils.get_profile_value('PN_CUTOFF_DATE', p_org_id);
5865: l_cut_off_date DATE := NULL;
5866: l_calculate_date DATE;
5867: BEGIN
5868:

Line 5900: -- 19-sep-05 piagrawa o passed org id in pn_mo_cache_utils.get_profile_value

5896: -- initial_basis..' Bug # 3436147
5897: -- 08-OCT-04 Satish o BUG# 3961117. Get calculate_date and pass it for not to
5898: -- create backbills if Assessment Date <= CutOff Date.
5899: -- 03-Feb-05 Vivek o Bug 4099136. Select NULL as purpose in cursor c1
5900: -- 19-sep-05 piagrawa o passed org id in pn_mo_cache_utils.get_profile_value
5901: -- 24-NOV-06 Prabhakar o Added handling for index multiplier in calculating RI
5902: -- by passing adjusted index percentage to index_amonut.
5903: -- 12-DEC-06 Prabhakar o Added the derivation of proration_factor
5904: -- o Added proration_rule,proration_period_start_date and

Line 6717: -- with pn_mo_cache_utils.get_profile_value

6713: -- 25-MAR-04 ftanudja o Fixed csr il_recs p_location_code logic.
6714: -- 09-MAR-05 ftanudja o Used profile option 'PN_RECALC_INDEX_RENT'
6715: -- for recalculate logic. #4212326.
6716: -- 15-SEP-05 pikhar o replaced fnd_profile.value(PN_RECALC_INDEX_RENT)
6717: -- with pn_mo_cache_utils.get_profile_value
6718: -- 25-NOV-05 pikhar o Replaced pn_locations_all with pn_locations
6719: -- 15-DEC-05 pikhar o replaced get_profile_value(PN_RECALC_INDEX_RENT) with
6720: -- get_profile_value('RECALC_IR_ON_ACC_CHG_FLAG'
6721: -------------------------------------------------------------------------------

Line 6824: IF nvl(pn_mo_cache_utils.get_profile_value('RECALC_IR_ON_ACC_CHG_FLAG',il_rec.org_id),'Y') = 'N' THEN

6820: put_output(fnd_message.get);
6821: END IF;
6822: END IF;
6823:
6824: IF nvl(pn_mo_cache_utils.get_profile_value('RECALC_IR_ON_ACC_CHG_FLAG',il_rec.org_id),'Y') = 'N' THEN
6825: l_recalculate := 'N';
6826: ELSE
6827: l_recalculate := ip_recalculate;
6828: END IF;