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 2693: ( (NVL(fnd_profile.value('PN_RI_BACKBILL_TYPE'),'OT') IN ('OT','RECUR')) OR

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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