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_VAREN_PVT dependencies on PN_VAR_RENTS_ALL

Line 3: --l_var_rent_id pn_var_rents_all.var_rent_id%TYPE := NULL;

1: PACKAGE BODY pn_varen_pvt AS
2: /* $Header: PNVARPVB.pls 120.1 2010/12/15 10:22:16 seevivek noship $ */
3: --l_var_rent_id pn_var_rents_all.var_rent_id%TYPE := NULL;
4: l_var_rent_date_id pn_var_rent_dates_all.var_rent_date_id%TYPE := NULL;
5:
6: --------------------------------------------------------------------------------
7: -- NAME : INSERT_CONSTRAINTS

Line 1482: l_var_rent_id pn_var_rents_all.var_rent_id%TYPE;

1478: l_line_end_date pn_var_line_defaults_all.line_end_date%TYPE;
1479: l_agreement_template_id pn_var_line_defaults_all.agreement_template_id%TYPE;
1480: l_processed_flag pn_var_line_defaults_all.processed_flag%TYPE := NULL;
1481: l_var_rent_exist NUMBER;
1482: l_var_rent_id pn_var_rents_all.var_rent_id%TYPE;
1483: BEGIN
1484: -- NULL;
1485: pn_varen_util.pvt_debug
1486: ('PN_VAREN_PVT: Insert_Variable_Rent_Lines: Calling PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW Package'

Line 1518: FROM pn_var_rents_all

1514: INTO l_line_start_date
1515: , l_line_end_date
1516: , l_agreement_template_id
1517: , l_var_rent_id
1518: FROM pn_var_rents_all
1519: WHERE ( var_rent_id = p_variable_rent_lines_rec_type.var_rent_id
1520: OR rent_num = p_variable_rent_lines_rec_type.var_rent_num
1521: )
1522: AND org_id = g_org_id

Line 2007: FROM pn_var_rents_all

2003: INTO l_variable_rent_exists
2004: , l_var_rent_id
2005: , l_var_commencement_date
2006: , l_var_termination_date
2007: FROM pn_var_rents_all
2008: WHERE ( rent_num = p_allow_abat_tbl_type (b).var_rent_num
2009: OR var_rent_id = p_allow_abat_tbl_type (b).var_rent_id
2010: )
2011: AND org_id = g_org_id --l_org_id

Line 2701: FROM pn_var_rents_all

2697: SELECT COUNT (1)
2698: , var_rent_id
2699: INTO l_variable_rent_exists
2700: , l_var_rent_id
2701: FROM pn_var_rents_all
2702: WHERE ( rent_num = p_constraints_tbl_type (c).var_rent_num
2703: OR var_rent_id = p_constraints_tbl_type (c).var_rent_id
2704: )
2705: AND org_id = g_org_id --l_org_id

Line 3976: FROM pn_var_rents_all

3972: SELECT commencement_date
3973: , termination_date
3974: INTO l_bkhd_comm_date
3975: , l_bkhd_term_date
3976: FROM pn_var_rents_all
3977: WHERE var_rent_id = p_breakpoint_header_rec_type.var_rent_id
3978: AND org_id = g_org_id;
3979:
3980:

Line 4722: FROM pn_var_rents_all

4718: SELECT COUNT (1)
4719: ,var_rent_id
4720: INTO l_variable_rent_exists
4721: ,l_var_rent_id
4722: FROM pn_var_rents_all
4723: WHERE (rent_num = p_variable_rent_lines_tbl (i).var_rent_num
4724: OR var_rent_id = p_variable_rent_lines_tbl (i).var_rent_id
4725: )
4726: AND org_id = g_org_id

Line 5982: l_auto_var_rent_id pn_var_rents_all.var_rent_id%TYPE;

5978: l_invg_spread_code pn_var_templates_all.invg_spread_code%TYPE;
5979: l_invg_day_of_month pn_var_templates_all.invg_day_of_month%TYPE;
5980: l_invg_days_after pn_var_templates_all.invg_days_after%TYPE;
5981: l_comments pn_var_templates_all.comments%TYPE;
5982: l_auto_var_rent_id pn_var_rents_all.var_rent_id%TYPE;
5983: l_auto_var_rent_num pn_system_setup_options.auto_var_rent_num_gen%TYPE;
5984:
5985: l_proration_days NUMBER;
5986: l_location_id NUMBER;

Line 9245: -- VALUE IN PN_VAR_RENTS_ALL.PRORATION_DAYS WOULD BE THE SAME AS THE VALUE IN PN_LEASES_ALL.PAYMENT_TERM_PRORATION_RULE

9241: IS
9242: l_var_rent_rec pn_varen_pvt.var_rent_rec_type;
9243: --
9244: l_leaseid pn_leases_all.lease_id%TYPE := NULL;
9245: -- VALUE IN PN_VAR_RENTS_ALL.PRORATION_DAYS WOULD BE THE SAME AS THE VALUE IN PN_LEASES_ALL.PAYMENT_TERM_PRORATION_RULE
9246: -- l_var_rent_id pn_var_rents_all.var_rent_id%TYPE;
9247: l_rent_num pn_var_rents_all.rent_num%TYPE;
9248: l_prorationdays pn_var_rents_all.proration_days%TYPE := NULL;
9249: l_payment_purpose_meaning fnd_lookups.meaning%TYPE;

Line 9246: -- l_var_rent_id pn_var_rents_all.var_rent_id%TYPE;

9242: l_var_rent_rec pn_varen_pvt.var_rent_rec_type;
9243: --
9244: l_leaseid pn_leases_all.lease_id%TYPE := NULL;
9245: -- VALUE IN PN_VAR_RENTS_ALL.PRORATION_DAYS WOULD BE THE SAME AS THE VALUE IN PN_LEASES_ALL.PAYMENT_TERM_PRORATION_RULE
9246: -- l_var_rent_id pn_var_rents_all.var_rent_id%TYPE;
9247: l_rent_num pn_var_rents_all.rent_num%TYPE;
9248: l_prorationdays pn_var_rents_all.proration_days%TYPE := NULL;
9249: l_payment_purpose_meaning fnd_lookups.meaning%TYPE;
9250: l_payment_purpose_lkp_code fnd_lookups.lookup_code%TYPE;

Line 9247: l_rent_num pn_var_rents_all.rent_num%TYPE;

9243: --
9244: l_leaseid pn_leases_all.lease_id%TYPE := NULL;
9245: -- VALUE IN PN_VAR_RENTS_ALL.PRORATION_DAYS WOULD BE THE SAME AS THE VALUE IN PN_LEASES_ALL.PAYMENT_TERM_PRORATION_RULE
9246: -- l_var_rent_id pn_var_rents_all.var_rent_id%TYPE;
9247: l_rent_num pn_var_rents_all.rent_num%TYPE;
9248: l_prorationdays pn_var_rents_all.proration_days%TYPE := NULL;
9249: l_payment_purpose_meaning fnd_lookups.meaning%TYPE;
9250: l_payment_purpose_lkp_code fnd_lookups.lookup_code%TYPE;
9251: l_location_code pn_locations_all.location_code%TYPE;

Line 9248: l_prorationdays pn_var_rents_all.proration_days%TYPE := NULL;

9244: l_leaseid pn_leases_all.lease_id%TYPE := NULL;
9245: -- VALUE IN PN_VAR_RENTS_ALL.PRORATION_DAYS WOULD BE THE SAME AS THE VALUE IN PN_LEASES_ALL.PAYMENT_TERM_PRORATION_RULE
9246: -- l_var_rent_id pn_var_rents_all.var_rent_id%TYPE;
9247: l_rent_num pn_var_rents_all.rent_num%TYPE;
9248: l_prorationdays pn_var_rents_all.proration_days%TYPE := NULL;
9249: l_payment_purpose_meaning fnd_lookups.meaning%TYPE;
9250: l_payment_purpose_lkp_code fnd_lookups.lookup_code%TYPE;
9251: l_location_code pn_locations_all.location_code%TYPE;
9252: l_rent_type_meaning fnd_lookups.meaning%TYPE;

Line 9881: l_cumulativevol pn_var_rents_all.cumulative_vol%TYPE;

9877: l_grp_exist NUMBER;
9878: l_dates_created NUMBER;
9879: l_var_rent_exist NUMBER;
9880: l_use_gl_calendar pn_var_rent_dates_all.use_gl_calendar%TYPE;
9881: l_cumulativevol pn_var_rents_all.cumulative_vol%TYPE;
9882: l_yearstartdate pn_var_rent_dates_all.year_start_date%TYPE;
9883: l_chg_cal_var_rent_id pn_var_rents_all.chg_cal_var_rent_id%TYPE;
9884:
9885: CURSOR c_var_rent_exist

Line 9883: l_chg_cal_var_rent_id pn_var_rents_all.chg_cal_var_rent_id%TYPE;

9879: l_var_rent_exist NUMBER;
9880: l_use_gl_calendar pn_var_rent_dates_all.use_gl_calendar%TYPE;
9881: l_cumulativevol pn_var_rents_all.cumulative_vol%TYPE;
9882: l_yearstartdate pn_var_rent_dates_all.year_start_date%TYPE;
9883: l_chg_cal_var_rent_id pn_var_rents_all.chg_cal_var_rent_id%TYPE;
9884:
9885: CURSOR c_var_rent_exist
9886: IS
9887: SELECT COUNT (*)

Line 9888: FROM pn_var_rents_all

9884:
9885: CURSOR c_var_rent_exist
9886: IS
9887: SELECT COUNT (*)
9888: FROM pn_var_rents_all
9889: WHERE ( var_rent_id = p_var_rent_id
9890: OR UPPER (rent_num) = UPPER (p_var_rent_num))
9891: AND org_id = p_org_id;
9892:

Line 9941: FROM pn_var_rents_all pvra

9937: , pvrd.year_start_date
9938: , pvra.var_rent_id
9939: , pvra.cumulative_vol
9940: , pvra.chg_cal_var_rent_id
9941: FROM pn_var_rents_all pvra
9942: , pn_var_rent_dates_all pvrd
9943: WHERE pvra.var_rent_id = pvrd.var_rent_id
9944: AND pvra.var_rent_id = p_var_rent_id;
9945: BEGIN

Line 10144: l_chg_cal_var_rent_id pn_var_rents_all.chg_cal_var_rent_id%TYPE;

10140: l_var_rent_ext NUMBER;
10141: l_varentid NUMBER;
10142: l_dates_ctd NUMBER;
10143: l_period_ext NUMBER;
10144: l_chg_cal_var_rent_id pn_var_rents_all.chg_cal_var_rent_id%TYPE;
10145:
10146: CURSOR c_var_rent_et
10147: IS
10148: SELECT COUNT (*)

Line 10149: FROM pn_var_rents_all

10145:
10146: CURSOR c_var_rent_et
10147: IS
10148: SELECT COUNT (*)
10149: FROM pn_var_rents_all
10150: WHERE ( var_rent_id = p_var_rent_id
10151: OR UPPER (rent_num) = UPPER (p_var_rent_num))
10152: AND org_id = p_org_id;
10153:

Line 10158: FROM pn_var_rents_all

10154: /*
10155: CURSOR c_var_rent_num_exist
10156: IS
10157: SELECT COUNT (*)
10158: FROM pn_var_rents_all
10159: WHERE ( UPPER (rent_num) = UPPER (p_var_rent_num)
10160: )
10161: AND org_id = p_org_id;
10162: */

Line 10173: FROM pn_var_rents_all pvra

10169: CURSOR c_var_dtls
10170: IS
10171: SELECT pvra.var_rent_id
10172: , pvra.chg_cal_var_rent_id
10173: FROM pn_var_rents_all pvra
10174: , pn_var_rent_dates_all pvrd
10175: WHERE pvra.var_rent_id = pvrd.var_rent_id
10176: AND pvra.var_rent_id = p_var_rent_id;
10177: BEGIN

Line 10569: FROM pn_var_rents_all

10565: , agreement_template_id
10566: , chg_cal_var_rent_id
10567: --, order_of_appl_code
10568: --, excess_abat_code
10569: FROM pn_var_rents_all
10570: WHERE var_rent_id = p_upd_var_rent_rec.var_rent_id;
10571:
10572: CURSOR c_pn_var_rent_dates
10573: IS

Line 10855: l_var_commencement_date pn_var_rents_all.commencement_date%TYPE;

10851: l_undo_periods VARCHAR2 (1) := 'N';
10852: l_bkpt_exist NUMBER := 0;
10853: ln_const_count NUMBER := 0;
10854: l_return_msg VARCHAR2 (2000);
10855: l_var_commencement_date pn_var_rents_all.commencement_date%TYPE;
10856: l_var_termination_date pn_var_rents_all.termination_date%TYPE;
10857: --l_var_comm_date pn_var_rents_all.commencement_date%TYPE;
10858: --l_var_term_date pn_var_rents_all.termination_date%TYPE;
10859: l_upd_allow_abat_val VARCHAR2 (1) := 'S';

Line 10856: l_var_termination_date pn_var_rents_all.termination_date%TYPE;

10852: l_bkpt_exist NUMBER := 0;
10853: ln_const_count NUMBER := 0;
10854: l_return_msg VARCHAR2 (2000);
10855: l_var_commencement_date pn_var_rents_all.commencement_date%TYPE;
10856: l_var_termination_date pn_var_rents_all.termination_date%TYPE;
10857: --l_var_comm_date pn_var_rents_all.commencement_date%TYPE;
10858: --l_var_term_date pn_var_rents_all.termination_date%TYPE;
10859: l_upd_allow_abat_val VARCHAR2 (1) := 'S';
10860: l_commencement_date DATE;

Line 10857: --l_var_comm_date pn_var_rents_all.commencement_date%TYPE;

10853: ln_const_count NUMBER := 0;
10854: l_return_msg VARCHAR2 (2000);
10855: l_var_commencement_date pn_var_rents_all.commencement_date%TYPE;
10856: l_var_termination_date pn_var_rents_all.termination_date%TYPE;
10857: --l_var_comm_date pn_var_rents_all.commencement_date%TYPE;
10858: --l_var_term_date pn_var_rents_all.termination_date%TYPE;
10859: l_upd_allow_abat_val VARCHAR2 (1) := 'S';
10860: l_commencement_date DATE;
10861: l_termination_date DATE;

Line 10858: --l_var_term_date pn_var_rents_all.termination_date%TYPE;

10854: l_return_msg VARCHAR2 (2000);
10855: l_var_commencement_date pn_var_rents_all.commencement_date%TYPE;
10856: l_var_termination_date pn_var_rents_all.termination_date%TYPE;
10857: --l_var_comm_date pn_var_rents_all.commencement_date%TYPE;
10858: --l_var_term_date pn_var_rents_all.termination_date%TYPE;
10859: l_upd_allow_abat_val VARCHAR2 (1) := 'S';
10860: l_commencement_date DATE;
10861: l_termination_date DATE;
10862: l_location_id NUMBER;

Line 16060: FROM pn_var_rents_all

16056: SELECT commencement_date
16057: , termination_date
16058: INTO l_var_commencement_date
16059: , l_var_termination_date
16060: FROM pn_var_rents_all
16061: WHERE ( var_rent_id = p_allow_abat_tbl (ua).var_rent_id
16062: OR rent_num = p_allow_abat_tbl (ua).var_rent_num)
16063: AND org_id = g_org_id --l_org_id
16064: GROUP BY var_rent_id