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_VARIABLE_AMOUNT_PKG dependencies on PN_VAR_RENTS

Line 197: g_var_rent_id pn_var_rents.var_rent_id%TYPE;

193:
194:
195: /* global variables */
196: g_breakpoint_TYPE pn_var_bkpts_head.breakpoint_TYPE%TYPE;
197: g_var_rent_id pn_var_rents.var_rent_id%TYPE;
198: g_period_id pn_var_periods.period_id%TYPE;
199: g_invoice_date pn_var_grp_dates.invoice_date%TYPE;
200: g_group_date pn_var_grp_dates.group_date%TYPE;
201: g_invoice_on pn_var_rents.invoice_on%TYPE;

Line 201: g_invoice_on pn_var_rents.invoice_on%TYPE;

197: g_var_rent_id pn_var_rents.var_rent_id%TYPE;
198: g_period_id pn_var_periods.period_id%TYPE;
199: g_invoice_date pn_var_grp_dates.invoice_date%TYPE;
200: g_group_date pn_var_grp_dates.group_date%TYPE;
201: g_invoice_on pn_var_rents.invoice_on%TYPE;
202: g_cumulative pn_var_rents.cumulative_vol%TYPE;
203: g_rent_TYPE varchar2(20);
204: g_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
205: g_currency_code gl_sets_of_books.currency_code%TYPE;

Line 202: g_cumulative pn_var_rents.cumulative_vol%TYPE;

198: g_period_id pn_var_periods.period_id%TYPE;
199: g_invoice_date pn_var_grp_dates.invoice_date%TYPE;
200: g_group_date pn_var_grp_dates.group_date%TYPE;
201: g_invoice_on pn_var_rents.invoice_on%TYPE;
202: g_cumulative pn_var_rents.cumulative_vol%TYPE;
203: g_rent_TYPE varchar2(20);
204: g_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
205: g_currency_code gl_sets_of_books.currency_code%TYPE;
206: g_precision number;

Line 1279: FROM pn_var_rents_all

1275: CURSOR csr_get_abt(ip_var_rent_id NUMBER)
1276: IS
1277: SELECT NVL(abatement_amount,0),
1278: negative_rent
1279: FROM pn_var_rents_all
1280: WHERE var_rent_id = ip_var_rent_id;
1281:
1282: /* Get the abatement amount that has been applied to transferred invoices.
1283: Here we only consider those invoices where the adjust num is the MAXimum

Line 1339: l_total_abatement pn_var_rents.abatement_amount%TYPE := 0;

1335: AND inv.invoice_date = ip_invoice_date
1336: AND inv.adjust_num < ip_adjust_num;
1337:
1338:
1339: l_total_abatement pn_var_rents.abatement_amount%TYPE := 0;
1340: l_total_abt_appl NUMBER := 0;
1341: l_negative_rent pn_var_rent_inv.negative_rent%TYPE := 0;
1342: l_actual_invoice_amt pn_var_rent_inv.actual_invoiced_amount%TYPE := 0;
1343: l_negative_available NUMBER := 0;

Line 1346: l_negative_rent_flag pn_var_rents.negative_rent%TYPE;

1342: l_actual_invoice_amt pn_var_rent_inv.actual_invoiced_amount%TYPE := 0;
1343: l_negative_available NUMBER := 0;
1344: l_negative_applied NUMBER := 0;
1345: l_abatement_applied NUMBER := 0;
1346: l_negative_rent_flag pn_var_rents.negative_rent%TYPE;
1347: l_last_invoice_dt pn_var_grp_dates.invoice_date%TYPE;
1348: l_prev_invoiced_amt NUMBER;
1349: l_rec_abatement NUMBER := 0;
1350:

Line 1918: FROM pn_var_rents_all

1914: negative_rent
1915: INTO p_cumulative,
1916: p_invoice_on,
1917: p_negative_rent
1918: FROM pn_var_rents_all
1919: WHERE var_rent_id = p_var_rent_id;
1920:
1921: pnp_debug_pkg.log( 'pn_variable_amount_pkg.get_varrent_details : (-) ');
1922:

Line 2074: FROM pn_var_rents_all pvr , pn_var_periods_all pvp

2070:
2071:
2072: CURSOR first_period_cur IS
2073: SELECT pvp.period_id
2074: FROM pn_var_rents_all pvr , pn_var_periods_all pvp
2075: WHERE pvr.var_rent_id = p_var_rent_id
2076: AND pvr.var_rent_id = pvp.var_rent_id
2077: AND proration_rule IN ('FY', 'FLY')
2078: AND pvp.start_date = pvr.commencement_date;

Line 2176: pn_var_rents_all vrent

2172: summ.tot_for_vol,
2173: summ.tot_ded,
2174: decode(vrent.cumulative_vol ,'N','N','T','N','Y')
2175: FROM pn_var_rent_summ_all summ,
2176: pn_var_rents_all vrent
2177: WHERE summ.line_item_id = p_line_item_id
2178: AND summ.group_date = p_group_date
2179: AND summ.var_rent_id = vrent.var_rent_id;
2180:

Line 2196: l_cumulative_vol pn_var_rents.cumulative_vol%type;

2192:
2193: l_tot_act_vol NUMBER :=0;
2194: l_tot_for_vol NUMBER :=0;
2195: l_tot_ded NUMBER :=0;
2196: l_cumulative_vol pn_var_rents.cumulative_vol%type;
2197: l_prev_act_vol NUMBER := 0;
2198: l_prev_for_vol NUMBER := 0;
2199: l_prev_ded NUMBER := 0;
2200: l_ret_val NUMBER ;

Line 2303: pn_var_rents_all pvr,

2299: pvr.rent_num,
2300: pl.org_id
2301: FROM pn_leases pl,
2302: pn_lease_details_all pld,
2303: pn_var_rents_all pvr,
2304: pn_locations_all ploc
2305: WHERE pl.lease_id = pvr.lease_id
2306: AND pld.lease_id = pvr.lease_id
2307: AND ploc.location_id = pvr.location_id

Line 2325: FROM pn_var_rents_all pvr,

2321: pvr.invoice_on,
2322: pvr.cumulative_vol,
2323: pvr.rent_num,
2324: pl.org_id
2325: FROM pn_var_rents_all pvr,
2326: pn_leases pl,
2327: pn_lease_details_all pld
2328: WHERE pl.lease_id = pvr.lease_id
2329: AND pld.lease_id = pvr.lease_id

Line 2377: l_var_rent_id pn_var_rents.var_rent_id%TYPE;

2373: WHERE set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',p_org_ID);
2374:
2375: ---- end ---
2376:
2377: l_var_rent_id pn_var_rents.var_rent_id%TYPE;
2378: l_invoice_on pn_var_rents.invoice_on%TYPE;
2379: l_cumulative pn_var_rents.cumulative_vol%TYPE;
2380: l_rent_num pn_var_rents.rent_num%TYPE;
2381: l_errbuf VARCHAR2(2000);

Line 2378: l_invoice_on pn_var_rents.invoice_on%TYPE;

2374:
2375: ---- end ---
2376:
2377: l_var_rent_id pn_var_rents.var_rent_id%TYPE;
2378: l_invoice_on pn_var_rents.invoice_on%TYPE;
2379: l_cumulative pn_var_rents.cumulative_vol%TYPE;
2380: l_rent_num pn_var_rents.rent_num%TYPE;
2381: l_errbuf VARCHAR2(2000);
2382: l_retcode VARCHAR2(2000);

Line 2379: l_cumulative pn_var_rents.cumulative_vol%TYPE;

2375: ---- end ---
2376:
2377: l_var_rent_id pn_var_rents.var_rent_id%TYPE;
2378: l_invoice_on pn_var_rents.invoice_on%TYPE;
2379: l_cumulative pn_var_rents.cumulative_vol%TYPE;
2380: l_rent_num pn_var_rents.rent_num%TYPE;
2381: l_errbuf VARCHAR2(2000);
2382: l_retcode VARCHAR2(2000);
2383: l_ext_precision NUMBER;

Line 2380: l_rent_num pn_var_rents.rent_num%TYPE;

2376:
2377: l_var_rent_id pn_var_rents.var_rent_id%TYPE;
2378: l_invoice_on pn_var_rents.invoice_on%TYPE;
2379: l_cumulative pn_var_rents.cumulative_vol%TYPE;
2380: l_rent_num pn_var_rents.rent_num%TYPE;
2381: l_errbuf VARCHAR2(2000);
2382: l_retcode VARCHAR2(2000);
2383: l_ext_precision NUMBER;
2384: l_min_acct_unit NUMBER;