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 FND_PROFILE

Line 2694: ( (NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') IN ('OT','RECUR')) OR

2690: -- frequency defined in the agreement.
2691: --
2692:
2693: IF p_calculate_date > p_assessment_date AND
2694: ( (NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') IN ('OT','RECUR')) OR
2695: (NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') IN ('SINGLETERM') AND
2696: l_index_finder_method IN ('FINDER_DATE')))
2697: THEN
2698: v_num_pymt_since_assmt_dt := 0;

Line 2695: (NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') IN ('SINGLETERM') AND

2691: --
2692:
2693: IF p_calculate_date > p_assessment_date AND
2694: ( (NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') IN ('OT','RECUR')) OR
2695: (NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') IN ('SINGLETERM') AND
2696: l_index_finder_method IN ('FINDER_DATE')))
2697: THEN
2698: v_num_pymt_since_assmt_dt := 0;
2699:

Line 2791: IF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'PERIOD_END' AND

2787: END LOOP;
2788:
2789: v_end_date := ip_main_lease_termination_date; -- default value
2790:
2791: IF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'PERIOD_END' AND
2792: v_basis_type = c_basis_type_fixed AND
2793: v_reference_period_type = c_ref_period_base_year
2794: THEN
2795: IF v_current_assessment_date < v_max_assessment_date THEN

Line 2808: IF NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') = 'END_AGRMNT' THEN

2804: END IF;
2805:
2806: ELSE
2807:
2808: IF NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') = 'END_AGRMNT' THEN
2809: v_end_date := v_index_termination_date;
2810: ELSE
2811: v_end_date := ip_main_lease_termination_date;
2812: END IF;

Line 2903: ,X_LAST_UPDATED_BY => NVL (fnd_profile.VALUE ('USER_ID'), 0)

2899: ,X_AMOUNT => (NVL(l_term_contribution,0)- NVL(l_total_inter_term,0))
2900: ,X_APPROVED_FLAG => 'DRAFT'
2901: ,X_INDEX_TERM_INDICATOR => ip_index_term_indicator
2902: ,X_LAST_UPDATE_DATE => SYSDATE
2903: ,X_LAST_UPDATED_BY => NVL (fnd_profile.VALUE ('USER_ID'), 0)
2904: ,X_CREATION_DATE => SYSDATE
2905: ,X_CREATED_BY => NVL (fnd_profile.VALUE ('USER_ID'), 0)
2906: ,X_LAST_UPDATE_LOGIN => NVL (fnd_profile.VALUE ('USER_ID'), 0)
2907: );

Line 2905: ,X_CREATED_BY => NVL (fnd_profile.VALUE ('USER_ID'), 0)

2901: ,X_INDEX_TERM_INDICATOR => ip_index_term_indicator
2902: ,X_LAST_UPDATE_DATE => SYSDATE
2903: ,X_LAST_UPDATED_BY => NVL (fnd_profile.VALUE ('USER_ID'), 0)
2904: ,X_CREATION_DATE => SYSDATE
2905: ,X_CREATED_BY => NVL (fnd_profile.VALUE ('USER_ID'), 0)
2906: ,X_LAST_UPDATE_LOGIN => NVL (fnd_profile.VALUE ('USER_ID'), 0)
2907: );
2908:
2909: END IF;

Line 2906: ,X_LAST_UPDATE_LOGIN => NVL (fnd_profile.VALUE ('USER_ID'), 0)

2902: ,X_LAST_UPDATE_DATE => SYSDATE
2903: ,X_LAST_UPDATED_BY => NVL (fnd_profile.VALUE ('USER_ID'), 0)
2904: ,X_CREATION_DATE => SYSDATE
2905: ,X_CREATED_BY => NVL (fnd_profile.VALUE ('USER_ID'), 0)
2906: ,X_LAST_UPDATE_LOGIN => NVL (fnd_profile.VALUE ('USER_ID'), 0)
2907: );
2908:
2909: END IF;
2910:

Line 3667: NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') IN ('OT','RECUR') ) OR

3663: p_normalized := NVL(rec_unq_comb.normalize,'N');
3664:
3665: IF v_start_date <= v_end_date AND
3666: (( TRUNC(p_main_lease_termination_date) > p_calculate_date AND
3667: NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') IN ('OT','RECUR') ) OR
3668: NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'SINGLETERM')
3669: THEN
3670:
3671: create_payment_term_record (

Line 3668: NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'SINGLETERM')

3664:
3665: IF v_start_date <= v_end_date AND
3666: (( TRUNC(p_main_lease_termination_date) > p_calculate_date AND
3667: NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') IN ('OT','RECUR') ) OR
3668: NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'SINGLETERM')
3669: THEN
3670:
3671: create_payment_term_record (
3672: p_lease_id => p_lease_id

Line 3695: IF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'RECUR' AND

3691: ,op_msg => v_msg
3692: );
3693: END IF;
3694:
3695: IF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'RECUR' AND
3696: p_index_finder_type in (c_index_finder_backbill,
3697: c_index_finder_most_recent)
3698: THEN
3699: derive_term_end_date(

Line 3839: IF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'OT' THEN

3835:
3836: /* Creating the backbill/atleast backbill payment term for the earlier
3837: combination */
3838:
3839: IF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'OT' THEN
3840: l_backbill_st_date := TRUNC(SYSDATE) ;
3841: l_backbill_end_date := NULL;
3842: l_backbill_freq := c_spread_frequency_one_time;
3843: l_backbill_amt := (v_previous_backbill_amt -

Line 3968: IF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'OT' THEN

3964: put_log('back bill overlap amount: '||v_overlap_backbill_amt);
3965:
3966: IF (v_total_backbill_amt - v_total_exist_backbill - v_overlap_backbill_amt) <> 0 THEN
3967:
3968: IF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'OT' THEN
3969: l_backbill_st_date := TRUNC(SYSDATE) ;
3970: l_backbill_end_date := NULL;
3971: l_backbill_freq := c_spread_frequency_one_time;
3972: l_backbill_amt := (v_total_backbill_amt - v_total_exist_backbill - v_overlap_backbill_amt);

Line 4611: IF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'OT' THEN

4607: v_backbill_amt := v_backbill_amt - v_approved_amt_annual_atlst_bb - v_backbill_overlap_amt;
4608:
4609: IF v_backbill_amt <> 0 THEN
4610:
4611: IF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'OT' THEN
4612: l_backbill_st_date := TRUNC(SYSDATE) ;
4613: l_backbill_end_date := NULL;
4614: l_backbill_freq := c_spread_frequency_one_time;
4615: l_backbill_amt := v_backbill_amt;

Line 4616: ELSIF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'RECUR' THEN

4612: l_backbill_st_date := TRUNC(SYSDATE) ;
4613: l_backbill_end_date := NULL;
4614: l_backbill_freq := c_spread_frequency_one_time;
4615: l_backbill_amt := v_backbill_amt;
4616: ELSIF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'RECUR' THEN
4617:
4618: derive_term_end_date(
4619: ip_index_lease_id => p_index_lease_id
4620: ,ip_index_period_id => p_index_period_id

Line 4897: IF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'OT' THEN

4893:
4894: v_backbill_amt := v_backbill_amt - v_approved_amt_annual_bb - v_backbill_overlap_amt;
4895:
4896: IF v_backbill_amt <> 0 THEN
4897: IF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'OT' THEN
4898: l_backbill_st_date := TRUNC(SYSDATE) ;
4899: l_backbill_end_date := NULL;
4900: l_backbill_freq := c_spread_frequency_one_time;
4901: l_backbill_amt := v_backbill_amt;

Line 4903: ELSIF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'RECUR' THEN

4899: l_backbill_end_date := NULL;
4900: l_backbill_freq := c_spread_frequency_one_time;
4901: l_backbill_amt := v_backbill_amt;
4902: l_backbill_normalize := 'N';
4903: ELSIF NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'RECUR' THEN
4904:
4905: derive_term_end_date(
4906: ip_index_lease_id => p_index_lease_id
4907: ,ip_index_period_id => p_index_period_id

Line 5017: -- 18-SEP-02 ftanudja o changed call from fnd_profile.value('PN_SET..')

5013: -- and specifies a location
5014: -- ( in the agreements header ), this
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.

Line 5433: NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'OT' then

5429:
5430: IF p_term_template_id is null THEN
5431:
5432: IF p_index_term_indicator not in (c_index_pay_term_type_atlst) AND
5433: NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'OT' then
5434: v_normalize := 'N';
5435: ELSE
5436: v_normalize := p_normalized;
5437: END IF;

Line 5441: NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'OT'

5437: END IF;
5438:
5439: IF p_index_term_indicator in (c_index_pay_term_type_atlst_bb,
5440: c_index_pay_term_type_backbill) AND
5441: NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') = 'OT'
5442: THEN
5443: v_frequency_code := c_spread_frequency_one_time;
5444: END IF;
5445: ELSE

Line 5642: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

5638: ,x_payment_term_id => v_payment_term_id
5639: ,x_index_period_id => p_index_period_id
5640: ,x_index_term_indicator => p_index_term_indicator
5641: ,x_last_update_date => SYSDATE
5642: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
5643: ,x_creation_date => SYSDATE
5644: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
5645: ,x_payment_purpose_code => NVL (v_payment_purpose_code, p_purpose_code)
5646: ,x_payment_term_type_code => NVL (v_payment_term_type_code,c_payment_term_type_index)

Line 5644: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

5640: ,x_index_term_indicator => p_index_term_indicator
5641: ,x_last_update_date => SYSDATE
5642: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
5643: ,x_creation_date => SYSDATE
5644: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
5645: ,x_payment_purpose_code => NVL (v_payment_purpose_code, p_purpose_code)
5646: ,x_payment_term_type_code => NVL (v_payment_term_type_code,c_payment_term_type_index)
5647: ,x_frequency_code => p_spread_frequency
5648: ,x_lease_id => p_lease_id

Line 5655: ,x_last_update_login => NVL (fnd_profile.VALUE ('USER_ID'), 0)

5651: ,x_end_date => v_payment_end_date
5652: ,x_set_of_books_id => NVL(v_set_of_books_id,v_gl_set_of_books_id)
5653: ,x_currency_code => v_currency_code
5654: ,x_rate => 1 -- not used in application
5655: ,x_last_update_login => NVL (fnd_profile.VALUE ('USER_ID'), 0)
5656: ,x_vendor_id => v_vendor_id
5657: ,x_vendor_site_id => v_vendor_site_id
5658: ,x_target_date => NULL
5659: ,x_actual_amount => v_actual_amount

Line 5776: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

5772: ,x_account_class => c_rec.account_class
5773: ,x_percentage => c_rec.percentage
5774: ,x_line_number => c_rec.line_number
5775: ,x_last_update_date => SYSDATE
5776: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
5777: ,x_creation_date => SYSDATE
5778: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
5779: ,x_last_update_login => NVL (fnd_profile.VALUE ('USER_ID'), 0)
5780: ,x_attribute_category => c_rec.attribute_category

Line 5778: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)

5774: ,x_line_number => c_rec.line_number
5775: ,x_last_update_date => SYSDATE
5776: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
5777: ,x_creation_date => SYSDATE
5778: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
5779: ,x_last_update_login => NVL (fnd_profile.VALUE ('USER_ID'), 0)
5780: ,x_attribute_category => c_rec.attribute_category
5781: ,x_attribute1 => c_rec.attribute1
5782: ,x_attribute2 => c_rec.attribute2

Line 5779: ,x_last_update_login => NVL (fnd_profile.VALUE ('USER_ID'), 0)

5775: ,x_last_update_date => SYSDATE
5776: ,x_last_updated_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
5777: ,x_creation_date => SYSDATE
5778: ,x_created_by => NVL (fnd_profile.VALUE ('USER_ID'), 0)
5779: ,x_last_update_login => NVL (fnd_profile.VALUE ('USER_ID'), 0)
5780: ,x_attribute_category => c_rec.attribute_category
5781: ,x_attribute1 => c_rec.attribute1
5782: ,x_attribute2 => c_rec.attribute2
5783: ,x_attribute3 => c_rec.attribute3

Line 6350: IF (NVL(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') <> 'PERIOD_END' OR

6346: FOR terms_rec IN get_extendable_terms(c_rec.index_period_id,l_term_date) LOOP
6347: l_terms_exist := TRUE;
6348: END LOOP;
6349:
6350: IF (NVL(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') <> 'PERIOD_END' OR
6351: (c_rec.basis_type <> c_basis_type_fixed AND
6352: c_rec.reference_period <> c_ref_period_base_year))
6353: AND NVL(l_ext_end_dt, l_term_date) > l_term_date
6354: AND NOT(l_terms_exist)

Line 6449: IF (NVL(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') <> 'PERIOD_END' OR

6445: l_term_date := l_rec.lease_termination_date;
6446: l_ext_end_dt := l_rec.lease_extension_end_date;
6447: END LOOP;
6448:
6449: IF (NVL(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') <> 'PERIOD_END' OR
6450: (c_rec.basis_type <> c_basis_type_fixed AND
6451: c_rec.reference_period <> c_ref_period_base_year))
6452: AND NVL(l_ext_end_dt, l_term_date) > l_term_date
6453: AND NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE'

Line 6453: AND NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE'

6449: IF (NVL(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') <> 'PERIOD_END' OR
6450: (c_rec.basis_type <> c_basis_type_fixed AND
6451: c_rec.reference_period <> c_ref_period_base_year))
6452: AND NVL(l_ext_end_dt, l_term_date) > l_term_date
6453: AND NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE'
6454: THEN
6455: FOR terms_rec IN get_extendable_terms(c_rec.index_period_id,l_term_date) LOOP
6456: l_term_rec := terms_rec;
6457:

Line 6632: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)

6628: IF v_msg IS NULL THEN
6629: UPDATE pn_index_leases_all
6630: SET initial_basis = v_initial_basis
6631: ,last_update_date = SYSDATE
6632: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
6633: WHERE index_lease_id = v_index_lease_id;
6634: END IF;
6635: END IF;
6636:

Line 6677: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)

6673: ,carry_forward_amount = v_carry_forward_amount
6674: ,constraint_applied_percent = v_constraint_applied_percent
6675: ,carry_forward_percent = v_carry_forward_percent
6676: ,last_update_date = SYSDATE
6677: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
6678: WHERE index_period_id = v_index_period_id;
6679:
6680:
6681: v_prev_index_amount := v_p_constrained_rent_amount;

Line 6718: -- 15-SEP-05 pikhar o replaced fnd_profile.value(PN_RECALC_INDEX_RENT)

6714: -- HISTORY
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'

Line 7135: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)

7131: UPDATE pn_payment_terms_all
7132: SET status = c_payment_term_status_approved
7133: ,include_in_var_rent = l_include_in_var_rent
7134: ,last_update_date = SYSDATE
7135: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
7136: ,approved_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
7137: WHERE payment_term_id = ip_index_pay_term_id;
7138:
7139: --

Line 7136: ,approved_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)

7132: SET status = c_payment_term_status_approved
7133: ,include_in_var_rent = l_include_in_var_rent
7134: ,last_update_date = SYSDATE
7135: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
7136: ,approved_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
7137: WHERE payment_term_id = ip_index_pay_term_id;
7138:
7139: --
7140: -- update status of records in pn_index_lease_terms

Line 7145: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)

7141: --
7142: UPDATE pn_index_lease_terms_all
7143: SET APPROVED_FLAG = c_payment_term_status_approved
7144: ,last_update_date = SYSDATE
7145: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
7146: WHERE rent_increase_term_id = ip_index_pay_term_id;
7147: END IF;
7148:
7149: op_msg := v_msg;