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 3269: FROM pn_var_bkpts_head_all

3265: l_bkptsdet_exISt NUMBER := NULL;
3266:
3267: CURSOR c2 IS
3268: SELECT bkpt_header_id
3269: FROM pn_var_bkpts_head_all
3270: WHERE line_item_id = p_line_item_id;
3271:
3272: BEGIN
3273:

Line 3915: FROM pn_var_bkpts_head_ALL

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

Line 3920: FROM pn_var_bkpts_head_ALL

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

Line 3925: FROM pn_var_bkpts_head_ALL

3921: WHERE period_id = p_id;
3922:
3923: CURSOR c_bkptshd_var_rent ( p_id IN NUMBER ) IS
3924: SELECT bkpt_header_id, line_item_id
3925: FROM pn_var_bkpts_head_ALL
3926: WHERE period_id IN ( SELECT period_id
3927: FROM pn_var_periods_ALL
3928: WHERE var_rent_id = p_id );
3929:

Line 4679: FROM pn_var_bkpts_head_ALL head

4675: SELECT 1
4676: INTO l_bkptshd_exists
4677: FROM dual
4678: WHERE EXISTS ( SELECT head.bkpt_header_id
4679: FROM pn_var_bkpts_head_ALL head
4680: WHERE head.line_item_id = p_line_item_id);
4681:
4682: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_BKPTSHD_EXIST (-)');
4683:

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

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

Line 5455: FROM pn_var_bkpts_head_all

5451: SELECT bkhd_start_date
5452: ,bkhd_end_date
5453: ,bkpt_header_id
5454: ,breakpoint_type
5455: FROM pn_var_bkpts_head_all
5456: WHERE line_item_id = p_line_id
5457: ORDER BY bkhd_start_date;
5458:
5459: CURSOR bkpt_details_c(p_bkhd_id IN NUMBER) IS

Line 7557: FROM pn_var_bkpts_head_all

7553: CURSOR header_cur IS
7554: SELECT bkpt_header_id,
7555: bkhd_start_date,
7556: bkhd_end_date
7557: FROM pn_var_bkpts_head_all
7558: WHERE var_rent_id = p_var_rent_id
7559: AND line_item_id = p_line_item_id
7560: ORDER BY bkhd_start_date;
7561:

Line 7567: FROM pn_var_bkpts_head_all

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

Line 7875: DELETE pn_var_bkpts_head_all

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
7876: WHERE bkhd_start_date > p_new_termn_date
7877: AND var_rent_id = p_var_rent_id;
7878:
7879: DELETE pn_var_deductions_all

Line 8344: FROM pn_var_bkpts_head_all

8340: CURSOR bkpt_data_exists IS
8341: SELECT 'x' bkpt_exists
8342: FROM DUAL
8343: WHERE EXISTS (SELECT bkhd_default_id
8344: FROM pn_var_bkpts_head_all
8345: WHERE var_rent_id = p_var_rent_id
8346: AND bkhd_default_id IS NOT NULL);
8347:
8348: /* Get the max invoice end date corresponding to the new termination date*/

Line 8478: DELETE FROM pn_var_bkpts_head_all

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;
8480:
8481: pn_var_defaults_pkg.create_setup_data (x_var_rent_id => p_var_rent_id);
8482: END LOOP;

Line 8782: DELETE pn_var_bkpts_head_all

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;
8784:
8785: DELETE pn_var_deductions_all
8786: WHERE period_id IN (SELECT period_id

Line 9115: FROM pn_var_bkpts_head_all

9111: CURSOR bkpt_data_exists IS
9112: SELECT 'x' bkpt_exists
9113: FROM DUAL
9114: WHERE EXISTS (SELECT bkhd_default_id
9115: FROM pn_var_bkpts_head_all
9116: WHERE var_rent_id = p_var_rent_id
9117: AND bkhd_default_id IS NOT NULL);
9118:
9119: CURSOR constr_data_exists IS

Line 9200: DELETE FROM pn_var_bkpts_head_all

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;
9202:
9203: pn_var_defaults_pkg.create_setup_data (x_var_rent_id => p_var_rent_id);
9204: END IF;

Line 9313: FROM pn_var_bkpts_head_all

9309: attribute13,
9310: attribute14,
9311: attribute15,
9312: org_id
9313: FROM pn_var_bkpts_head_all
9314: WHERE line_item_id = p_line_item_id
9315: AND bkhd_end_date = p_end_date;
9316:
9317: /* This cursor fetches the breakpoint detail record data,

Line 9634: UPDATE pn_var_bkpts_head_all

9630:
9631: pnp_debug_pkg.debug ('last_period_rec.period_id ...'||p_period_id);
9632: pnp_debug_pkg.debug ('last_period_rec.end_date ....'||period_rec.end_date);
9633:
9634: UPDATE pn_var_bkpts_head_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:

Line 10427: FROM pn_var_bkpts_head_all bkpt,

10423: bkpt.attribute13 attribute13,
10424: bkpt.attribute14 attribute14,
10425: bkpt.attribute15 attribute15,
10426: lines.line_default_id line_default_id
10427: FROM pn_var_bkpts_head_all bkpt,
10428: pn_var_lines_all lines
10429: WHERE bkpt.var_rent_id = p_var_rent_id
10430: AND bkpt.line_item_id = lines.line_item_id;
10431:

Line 10464: pn_var_bkpts_head_all bkhd

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

Line 10788: UPDATE pn_var_bkpts_head_all

10784: X_ATTRIBUTE14 => bkpt_rec.ATTRIBUTE14,
10785: X_ATTRIBUTE15 => bkpt_rec.ATTRIBUTE15
10786: );
10787:
10788: UPDATE pn_var_bkpts_head_all
10789: SET bkhd_default_id = l_bkhddefault_id
10790: WHERE bkpt_header_id = bkpt_rec.bkpt_header_id;
10791:
10792: END IF;