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.

[Home] [Help]

APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_BKPTS_DET_ALL

Line 3330: FROM pn_var_bkpts_det_ALL

3326: l_counter NUMBER := 0;
3327:
3328: CURSOR c1 IS
3329: SELECT bkpt_detail_id
3330: FROM pn_var_bkpts_det_ALL
3331: WHERE bkpt_header_id = p_bkpt_header_id;
3332:
3333: BEGIN
3334:

Line 4730: FROM pn_var_bkpts_det_ALL det

4726: SELECT 1
4727: INTO l_bkptsdet_exist
4728: FROM dual
4729: WHERE EXISTS ( SELECT det.bkpt_detail_id
4730: FROM pn_var_bkpts_det_ALL det
4731: WHERE det.bkpt_header_id = p_bkpt_header_id);
4732:
4733: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_BKPTSDET_EXIST (-)');
4734:

Line 5463: FROM pn_var_bkpts_det_all

5459: CURSOR bkpt_details_c(p_bkhd_id IN NUMBER) IS
5460: SELECT bkpt_start_date
5461: ,bkpt_end_date
5462: ,COUNT(bkpt_detail_id) AS bkpt_count
5463: FROM pn_var_bkpts_det_all
5464: WHERE bkpt_header_id = p_bkhd_id
5465: GROUP BY bkpt_start_date, bkpt_end_date
5466: ORDER BY bkpt_start_date;
5467:

Line 5473: FROM pn_var_bkpts_det_all

5469: ,p_st_dt IN DATE
5470: ,p_end_dt IN DATE) IS
5471: SELECT period_bkpt_vol_start
5472: ,period_bkpt_vol_end
5473: FROM pn_var_bkpts_det_all
5474: WHERE bkpt_header_id = p_bkhd_id
5475: AND bkpt_start_date = p_st_dt
5476: AND bkpt_end_date = p_end_dt
5477: ORDER BY period_bkpt_vol_start;

Line 5481: FROM pn_var_bkpts_det_all

5477: ORDER BY period_bkpt_vol_start;
5478:
5479: CURSOR null_vols(p_bkhd_id IN NUMBER, p_start_date IN DATE) IS
5480: SELECT count(*)
5481: FROM pn_var_bkpts_det_all
5482: WHERE bkpt_header_id = p_bkhd_id
5483: AND bkpt_start_date = p_start_date
5484: AND period_bkpt_vol_end IS NULL;
5485:

Line 7576: FROM pn_var_bkpts_det_all

7572: CURSOR detail_cur (p_header_id NUMBER) IS
7573: SELECT
7574: bkpt_start_date,
7575: bkpt_end_date
7576: FROM pn_var_bkpts_det_all
7577: WHERE var_rent_id = p_var_rent_id
7578: AND bkpt_header_id = p_header_id
7579: ORDER BY bkpt_start_date;
7580:

Line 7585: FROM pn_var_bkpts_det_all

7581: CURSOR exist_next_detail_date (p_header_id NUMBER,p_end_date DATE) IS
7582: SELECT 'x'
7583: FROM dual
7584: WHERE EXISTS ( SELECT var_Rent_id
7585: FROM pn_var_bkpts_det_all
7586: WHERE var_rent_id = p_var_rent_id
7587: AND bkpt_header_id = p_header_id
7588: AND bkpt_start_date = p_end_date + 1);
7589:

Line 7815: UPDATE pn_var_bkpts_det_all

7811: p_bkpt_rate IN NUMBER)
7812: IS
7813: BEGIN
7814:
7815: UPDATE pn_var_bkpts_det_all
7816: SET bkpt_rate = p_bkpt_rate
7817: WHERE var_rent_id = p_var_rent_id
7818: AND bkdt_default_id = p_bkdt_dflt_id;
7819:

Line 7871: DELETE pn_var_bkpts_det_all

7867: AND period_id IN (SELECT period_id
7868: FROM pn_var_periods_all
7869: WHERE var_rent_id = p_var_rent_id);
7870:
7871: DELETE pn_var_bkpts_det_all
7872: WHERE bkpt_start_date > p_new_termn_date
7873: AND var_rent_id = p_var_rent_id;
7874:
7875: DELETE pn_var_bkpts_head_all

Line 8475: DELETE FROM pn_var_bkpts_det_all

8471:
8472: /* This generates line items, breakpoint header and details in main tables */
8473:
8474: FOR rec IN bkpt_data_exists LOOP
8475: DELETE FROM pn_var_bkpts_det_all
8476: WHERE var_rent_id = p_var_rent_id;
8477:
8478: DELETE FROM pn_var_bkpts_head_all
8479: WHERE var_rent_id = p_var_rent_id;

Line 8779: DELETE pn_var_bkpts_det_all

8775: WHERE period_id IN (SELECT period_id
8776: FROM pn_var_periods_all
8777: WHERE var_rent_id = p_var_rent_id);
8778:
8779: DELETE pn_var_bkpts_det_all
8780: WHERE var_rent_id = p_var_rent_id;
8781:
8782: DELETE pn_var_bkpts_head_all
8783: WHERE var_rent_id = p_var_rent_id;

Line 9197: DELETE FROM pn_var_bkpts_det_all

9193:
9194:
9195: IF l_bkpt_exists IS NOT NULL THEN
9196:
9197: DELETE FROM pn_var_bkpts_det_all
9198: WHERE var_rent_id = p_var_rent_id;
9199:
9200: DELETE FROM pn_var_bkpts_head_all
9201: WHERE var_rent_id = p_var_rent_id;

Line 9347: FROM pn_var_bkpts_det_all

9343: attribute15,
9344: org_id,
9345: annual_basis_amount,
9346: bkdt_default_id
9347: FROM pn_var_bkpts_det_all
9348: WHERE bkpt_header_id = p_bkpt_header_id
9349: AND bkpt_end_date = p_end_date;
9350:
9351:

Line 9639: UPDATE pn_var_bkpts_det_all

9635: SET bkhd_end_date = period_rec.end_date
9636: WHERE var_rent_id = p_var_rent_id
9637: AND bkhd_end_date = p_old_termn_date;
9638:
9639: UPDATE pn_var_bkpts_det_all
9640: SET bkpt_end_date = period_rec.end_date
9641: WHERE var_rent_id = p_var_rent_id
9642: AND bkpt_end_date = p_old_termn_date;
9643:

Line 10463: FROM pn_var_bkpts_det_all bkdt,

10459: bkdt.attribute15 attribute15,
10460: bkdt.org_id org_id,
10461: bkdt.annual_basis_amount annual_basis_amount,
10462: bkhd.bkhd_default_id bkhd_default_id
10463: FROM pn_var_bkpts_det_all bkdt,
10464: pn_var_bkpts_head_all bkhd
10465: WHERE bkdt.var_rent_id = p_var_rent_id
10466: AND bkdt.bkpt_header_id = bkhd.bkpt_header_id;
10467:

Line 10866: UPDATE pn_var_bkpts_det_all

10862: X_ATTRIBUTE14 => bkdt_rec.ATTRIBUTE14,
10863: X_ATTRIBUTE15 => bkdt_rec.ATTRIBUTE15
10864: );
10865:
10866: UPDATE pn_var_bkpts_det_all
10867: SET BKDT_DEFAULT_ID = l_bkdtdefaultId
10868: WHERE BKPT_DETAIL_ID = bkdt_rec.bkpt_detail_id;
10869:
10870: END IF;