APPS.PN_VAREN_PVT dependencies on PN_VAR_RENT_DATES_ALL

Line 4: l_var_rent_date_id pn_var_rent_dates_all.var_rent_date_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
8: -- DESCRIPTION :

Line 9267: l_var_rent_date_id pn_var_rent_dates_all.var_rent_date_id%TYPE;

9263: l_term_template_name pn_term_templates_all.NAME%TYPE;
9264: l_proration_rule_meaning fnd_lookups.meaning%TYPE;
9265: l_proration_rule_code fnd_lookups.lookup_code%TYPE;
9266: --
9267: l_var_rent_date_id pn_var_rent_dates_all.var_rent_date_id%TYPE;
9268: --
9269: l_location_id pn_locations_all.location_id%TYPE;
9270: -- l_location_code pn_locations_all.location_code%type;
9271: l_lease_commencement_date pn_lease_details_all.lease_commencement_date%TYPE;

Line 9880: l_use_gl_calendar pn_var_rent_dates_all.use_gl_calendar%TYPE;

9876: l_vol_exist NUMBER;
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:

Line 9882: l_yearstartdate pn_var_rent_dates_all.year_start_date%TYPE;

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
9886: IS

Line 9930: FROM pn_var_rent_dates_all

9926:
9927: CURSOR c_dates_created
9928: IS
9929: SELECT COUNT (*)
9930: FROM pn_var_rent_dates_all
9931: WHERE var_rent_id = p_var_rent_id;
9932:
9933: -- AND a.grp_start_date = l_comm_date;
9934: CURSOR c_var_details

Line 9942: , pn_var_rent_dates_all pvrd

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
9946: x_return_status := fnd_api.g_ret_sts_success;

Line 10166: FROM pn_var_rent_dates_all

10162: */
10163: CURSOR c_dates_ctd
10164: IS
10165: SELECT COUNT (*)
10166: FROM pn_var_rent_dates_all
10167: WHERE var_rent_id = p_var_rent_id;
10168:
10169: CURSOR c_var_dtls
10170: IS

Line 10174: , pn_var_rent_dates_all pvrd

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
10178: x_return_status := fnd_api.g_ret_sts_success;

Line 10620: FROM pn_var_rent_dates_all

10616: , year_start_date
10617: , comments
10618: , effective_date
10619: , vrg_reptg_freq_code
10620: FROM pn_var_rent_dates_all
10621: WHERE var_rent_id = p_upd_var_rent_rec.var_rent_id;
10622:
10623: --CURSOR c_pn_var_line_defaults Commented by Vivek on 09-DEC-2010
10624: CURSOR c_pn_var_line_defaults (