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 3326: FROM pn_var_bkpts_det_ALL

3322: l_counter NUMBER := 0;
3323:
3324: CURSOR c1 IS
3325: SELECT bkpt_detail_id
3326: FROM pn_var_bkpts_det_ALL
3327: WHERE bkpt_header_id = p_bkpt_header_id;
3328:
3329: BEGIN
3330:

Line 4726: FROM pn_var_bkpts_det_ALL det

4722: SELECT 1
4723: INTO l_bkptsdet_exist
4724: FROM dual
4725: WHERE EXISTS ( SELECT det.bkpt_detail_id
4726: FROM pn_var_bkpts_det_ALL det
4727: WHERE det.bkpt_header_id = p_bkpt_header_id);
4728:
4729: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_BKPTSDET_EXIST (-)');
4730:

Line 5459: FROM pn_var_bkpts_det_all

5455: CURSOR bkpt_details_c(p_bkhd_id IN NUMBER) IS
5456: SELECT bkpt_start_date
5457: ,bkpt_end_date
5458: ,COUNT(bkpt_detail_id) AS bkpt_count
5459: FROM pn_var_bkpts_det_all
5460: WHERE bkpt_header_id = p_bkhd_id
5461: GROUP BY bkpt_start_date, bkpt_end_date
5462: ORDER BY bkpt_start_date;
5463:

Line 5469: FROM pn_var_bkpts_det_all

5465: ,p_st_dt IN DATE
5466: ,p_end_dt IN DATE) IS
5467: SELECT period_bkpt_vol_start
5468: ,period_bkpt_vol_end
5469: FROM pn_var_bkpts_det_all
5470: WHERE bkpt_header_id = p_bkhd_id
5471: AND bkpt_start_date = p_st_dt
5472: AND bkpt_end_date = p_end_dt
5473: ORDER BY period_bkpt_vol_start;

Line 5477: FROM pn_var_bkpts_det_all

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

Line 7572: FROM pn_var_bkpts_det_all

7568: CURSOR detail_cur (p_header_id NUMBER) IS
7569: SELECT
7570: bkpt_start_date,
7571: bkpt_end_date
7572: FROM pn_var_bkpts_det_all
7573: WHERE var_rent_id = p_var_rent_id
7574: AND bkpt_header_id = p_header_id
7575: ORDER BY bkpt_start_date;
7576:

Line 7581: FROM pn_var_bkpts_det_all

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

Line 7811: UPDATE pn_var_bkpts_det_all

7807: p_bkpt_rate IN NUMBER)
7808: IS
7809: BEGIN
7810:
7811: UPDATE pn_var_bkpts_det_all
7812: SET bkpt_rate = p_bkpt_rate
7813: WHERE var_rent_id = p_var_rent_id
7814: AND bkdt_default_id = p_bkdt_dflt_id;
7815:

Line 7865: DELETE pn_var_bkpts_det_all

7861: AND period_id IN (SELECT period_id
7862: FROM pn_var_periods_all
7863: WHERE var_rent_id = p_var_rent_id);
7864:
7865: DELETE pn_var_bkpts_det_all
7866: WHERE bkpt_start_date > p_new_termn_date
7867: AND var_rent_id = p_var_rent_id;
7868:
7869: DELETE pn_var_bkpts_head_all

Line 8458: DELETE FROM pn_var_bkpts_det_all

8454:
8455: /* This generates line items, breakpoint header and details in main tables */
8456:
8457: FOR rec IN bkpt_data_exists LOOP
8458: DELETE FROM pn_var_bkpts_det_all
8459: WHERE var_rent_id = p_var_rent_id;
8460:
8461: DELETE FROM pn_var_bkpts_head_all
8462: WHERE var_rent_id = p_var_rent_id;

Line 8762: DELETE pn_var_bkpts_det_all

8758: WHERE period_id IN (SELECT period_id
8759: FROM pn_var_periods_all
8760: WHERE var_rent_id = p_var_rent_id);
8761:
8762: DELETE pn_var_bkpts_det_all
8763: WHERE var_rent_id = p_var_rent_id;
8764:
8765: DELETE pn_var_bkpts_head_all
8766: WHERE var_rent_id = p_var_rent_id;

Line 9180: DELETE FROM pn_var_bkpts_det_all

9176:
9177:
9178: IF l_bkpt_exists IS NOT NULL THEN
9179:
9180: DELETE FROM pn_var_bkpts_det_all
9181: WHERE var_rent_id = p_var_rent_id;
9182:
9183: DELETE FROM pn_var_bkpts_head_all
9184: WHERE var_rent_id = p_var_rent_id;

Line 9330: FROM pn_var_bkpts_det_all

9326: attribute15,
9327: org_id,
9328: annual_basis_amount,
9329: bkdt_default_id
9330: FROM pn_var_bkpts_det_all
9331: WHERE bkpt_header_id = p_bkpt_header_id
9332: AND bkpt_end_date = p_end_date;
9333:
9334:

Line 9622: UPDATE pn_var_bkpts_det_all

9618: SET bkhd_end_date = period_rec.end_date
9619: WHERE var_rent_id = p_var_rent_id
9620: AND bkhd_end_date = p_old_termn_date;
9621:
9622: UPDATE pn_var_bkpts_det_all
9623: SET bkpt_end_date = period_rec.end_date
9624: WHERE var_rent_id = p_var_rent_id
9625: AND bkpt_end_date = p_old_termn_date;
9626:

Line 10446: FROM pn_var_bkpts_det_all bkdt,

10442: bkdt.attribute15 attribute15,
10443: bkdt.org_id org_id,
10444: bkdt.annual_basis_amount annual_basis_amount,
10445: bkhd.bkhd_default_id bkhd_default_id
10446: FROM pn_var_bkpts_det_all bkdt,
10447: pn_var_bkpts_head_all bkhd
10448: WHERE bkdt.var_rent_id = p_var_rent_id
10449: AND bkdt.bkpt_header_id = bkhd.bkpt_header_id;
10450:

Line 10849: UPDATE pn_var_bkpts_det_all

10845: X_ATTRIBUTE14 => bkdt_rec.ATTRIBUTE14,
10846: X_ATTRIBUTE15 => bkdt_rec.ATTRIBUTE15
10847: );
10848:
10849: UPDATE pn_var_bkpts_det_all
10850: SET BKDT_DEFAULT_ID = l_bkdtdefaultId
10851: WHERE BKPT_DETAIL_ID = bkdt_rec.bkpt_detail_id;
10852:
10853: END IF;