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_VAR_RENT_PKG dependencies on PN_VAR_BKPTS_HEAD_ALL

Line 3265: FROM pn_var_bkpts_head_all

3261: l_bkptsdet_exISt NUMBER := NULL;
3262:
3263: CURSOR c2 IS
3264: SELECT bkpt_header_id
3265: FROM pn_var_bkpts_head_all
3266: WHERE line_item_id = p_line_item_id;
3267:
3268: BEGIN
3269:

Line 3911: FROM pn_var_bkpts_head_ALL

3907: RETURN NUMBER IS
3908:
3909: CURSOR c_bkptshd_line_item ( p_id IN NUMBER ) IS
3910: SELECT bkpt_header_id, line_item_id
3911: FROM pn_var_bkpts_head_ALL
3912: WHERE line_item_id = p_id;
3913:
3914: CURSOR c_bkptshd_period ( p_id IN NUMBER ) IS
3915: SELECT bkpt_header_id, line_item_id

Line 3916: FROM pn_var_bkpts_head_ALL

3912: WHERE line_item_id = p_id;
3913:
3914: CURSOR c_bkptshd_period ( p_id IN NUMBER ) IS
3915: SELECT bkpt_header_id, line_item_id
3916: FROM pn_var_bkpts_head_ALL
3917: WHERE period_id = p_id;
3918:
3919: CURSOR c_bkptshd_var_rent ( p_id IN NUMBER ) IS
3920: SELECT bkpt_header_id, line_item_id

Line 3921: FROM pn_var_bkpts_head_ALL

3917: WHERE period_id = p_id;
3918:
3919: CURSOR c_bkptshd_var_rent ( p_id IN NUMBER ) IS
3920: SELECT bkpt_header_id, line_item_id
3921: FROM pn_var_bkpts_head_ALL
3922: WHERE period_id IN ( SELECT period_id
3923: FROM pn_var_periods_ALL
3924: WHERE var_rent_id = p_id );
3925:

Line 4675: FROM pn_var_bkpts_head_ALL head

4671: SELECT 1
4672: INTO l_bkptshd_exists
4673: FROM dual
4674: WHERE EXISTS ( SELECT head.bkpt_header_id
4675: FROM pn_var_bkpts_head_ALL head
4676: WHERE head.line_item_id = p_line_item_id);
4677:
4678: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_BKPTSHD_EXIST (-)');
4679:

Line 5167: FROM pn_var_periods_all pd, pn_var_lines_all ln, pn_var_bkpts_head_all bp

5163: PROCEDURE delete_inv_summ (p_var_rent_id IN NUMBER) IS
5164:
5165: CURSOR C_EXIST IS
5166: SELECT bp.bkpt_header_id
5167: FROM pn_var_periods_all pd, pn_var_lines_all ln, pn_var_bkpts_head_all bp
5168: WHERE pd.var_rent_id = p_var_rent_id
5169: AND pd.period_id = ln.period_id
5170: AND ln.lINe_item_id = bp.lINe_item_id
5171: AND bp.break_type = 'NATURAL';

Line 5451: FROM pn_var_bkpts_head_all

5447: SELECT bkhd_start_date
5448: ,bkhd_end_date
5449: ,bkpt_header_id
5450: ,breakpoint_type
5451: FROM pn_var_bkpts_head_all
5452: WHERE line_item_id = p_line_id
5453: ORDER BY bkhd_start_date;
5454:
5455: CURSOR bkpt_details_c(p_bkhd_id IN NUMBER) IS

Line 7553: FROM pn_var_bkpts_head_all

7549: CURSOR header_cur IS
7550: SELECT bkpt_header_id,
7551: bkhd_start_date,
7552: bkhd_end_date
7553: FROM pn_var_bkpts_head_all
7554: WHERE var_rent_id = p_var_rent_id
7555: AND line_item_id = p_line_item_id
7556: ORDER BY bkhd_start_date;
7557:

Line 7563: FROM pn_var_bkpts_head_all

7559: CURSOR exist_next_header_date (p_end_date DATE) IS
7560: SELECT 'x'
7561: FROM dual
7562: WHERE EXISTS ( SELECT var_Rent_id
7563: FROM pn_var_bkpts_head_all
7564: WHERE var_rent_id = p_var_rent_id
7565: AND line_item_id = p_line_item_id
7566: AND bkhd_start_date = p_end_date + 1);
7567:

Line 7869: DELETE pn_var_bkpts_head_all

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
7870: WHERE bkhd_start_date > p_new_termn_date
7871: AND var_rent_id = p_var_rent_id;
7872:
7873: DELETE pn_var_deductions_all

Line 8334: FROM pn_var_bkpts_head_all

8330: CURSOR bkpt_data_exists IS
8331: SELECT 'x' bkpt_exists
8332: FROM DUAL
8333: WHERE EXISTS (SELECT bkhd_default_id
8334: FROM pn_var_bkpts_head_all
8335: WHERE var_rent_id = p_var_rent_id
8336: AND bkhd_default_id IS NOT NULL);
8337:
8338: /* Get the max invoice end date corresponding to the new termination date*/

Line 8461: DELETE FROM pn_var_bkpts_head_all

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;
8463:
8464: pn_var_defaults_pkg.create_setup_data (x_var_rent_id => p_var_rent_id);
8465: END LOOP;

Line 8765: DELETE pn_var_bkpts_head_all

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;
8767:
8768: DELETE pn_var_deductions_all
8769: WHERE period_id IN (SELECT period_id

Line 9098: FROM pn_var_bkpts_head_all

9094: CURSOR bkpt_data_exists IS
9095: SELECT 'x' bkpt_exists
9096: FROM DUAL
9097: WHERE EXISTS (SELECT bkhd_default_id
9098: FROM pn_var_bkpts_head_all
9099: WHERE var_rent_id = p_var_rent_id
9100: AND bkhd_default_id IS NOT NULL);
9101:
9102: CURSOR constr_data_exists IS

Line 9183: DELETE FROM pn_var_bkpts_head_all

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;
9185:
9186: pn_var_defaults_pkg.create_setup_data (x_var_rent_id => p_var_rent_id);
9187: END IF;

Line 9296: FROM pn_var_bkpts_head_all

9292: attribute13,
9293: attribute14,
9294: attribute15,
9295: org_id
9296: FROM pn_var_bkpts_head_all
9297: WHERE line_item_id = p_line_item_id
9298: AND bkhd_end_date = p_end_date;
9299:
9300: /* This cursor fetches the breakpoint detail record data,

Line 9617: UPDATE pn_var_bkpts_head_all

9613:
9614: pnp_debug_pkg.debug ('last_period_rec.period_id ...'||p_period_id);
9615: pnp_debug_pkg.debug ('last_period_rec.end_date ....'||period_rec.end_date);
9616:
9617: UPDATE pn_var_bkpts_head_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:

Line 10410: FROM pn_var_bkpts_head_all bkpt,

10406: bkpt.attribute13 attribute13,
10407: bkpt.attribute14 attribute14,
10408: bkpt.attribute15 attribute15,
10409: lines.line_default_id line_default_id
10410: FROM pn_var_bkpts_head_all bkpt,
10411: pn_var_lines_all lines
10412: WHERE bkpt.var_rent_id = p_var_rent_id
10413: AND bkpt.line_item_id = lines.line_item_id;
10414:

Line 10447: pn_var_bkpts_head_all bkhd

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:
10451:

Line 10771: UPDATE pn_var_bkpts_head_all

10767: X_ATTRIBUTE14 => bkpt_rec.ATTRIBUTE14,
10768: X_ATTRIBUTE15 => bkpt_rec.ATTRIBUTE15
10769: );
10770:
10771: UPDATE pn_var_bkpts_head_all
10772: SET bkhd_default_id = l_bkhddefault_id
10773: WHERE bkpt_header_id = bkpt_rec.bkpt_header_id;
10774:
10775: END IF;