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 893: -- 19-SEP-05 piagrawa o Modified to pass org id to pn_mo_cache_utils.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5859: -- org id in pn_mo_cache_utils.get_profile_value

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

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

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

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

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

Line 6719: -- with pn_mo_cache_utils.get_profile_value

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

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

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