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_LINES_ALL

Line 3745: FROM pn_var_lines_ALL

3741: SELECT 1
3742: INTO l_lines_exist
3743: FROM dual
3744: WHERE EXISTS ( SELECT line_item_id
3745: FROM pn_var_lines_ALL
3746: WHERE period_id IN (SELECT period_id
3747: FROM pn_var_periods_ALL
3748: WHERE var_rent_id = p_var_rent_id
3749: AND period_id = NVL(p_period_id,period_id)

Line 4826: FROM pn_var_lines_ALL

4822: FROM dual
4823: WHERE EXISTS ( SELECT grp_date_id
4824: FROM pn_var_grp_dates_all
4825: WHERE period_id IN (SELECT period_id
4826: FROM pn_var_lines_ALL
4827: WHERE line_item_id = p_id)
4828: AND (actual_exp_code = 'Y' OR
4829: forecasted_exp_code = 'Y')
4830: );

Line 4840: FROM pn_var_lines_ALL

4836: FROM dual
4837: WHERE EXISTS ( SELECT grp_date_id
4838: FROM pn_var_grp_dates_all
4839: WHERE period_id IN (SELECT period_id
4840: FROM pn_var_lines_ALL
4841: WHERE line_default_id = p_id)
4842: AND (actual_exp_code = 'Y' OR
4843: forecasted_exp_code = 'Y')
4844: );

Line 4853: pn_var_lines_all c

4849: FROM dual
4850: WHERE EXISTS ( SELECT grp_date_id
4851: FROM pn_var_grp_dates_all a,
4852: pn_var_periods_all b,
4853: pn_var_lines_all c
4854: WHERE a.period_id = b.period_id
4855: AND b.period_id = c.period_id
4856: AND c.line_default_id = p_id
4857: AND (a.actual_exp_code = 'Y' OR

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 5446: FROM pn_var_lines_all

5442: WHERE period_id = p_prd_id;
5443:
5444: CURSOR line_items_c(p_prd_id IN NUMBER) IS
5445: SELECT line_item_id
5446: FROM pn_var_lines_all
5447: WHERE period_id = p_prd_id
5448: ORDER BY line_item_id;
5449:
5450: CURSOR bkpt_headers_c(p_line_id IN NUMBER) IS

Line 5834: FROM pn_var_lines_all

5830: SELECT start_date , end_date
5831: INTO l_period_st_dt, l_period_end_dt
5832: FROM pn_var_periods_all
5833: WHERE period_id =(SELECT period_id
5834: FROM pn_var_lines_all
5835: WHERE line_item_id = p_line_item_id);
5836: END IF;
5837:
5838: IF l_line_t.FIRST IS NOT NULL THEN

Line 7898: DELETE pn_var_lines_all

7894: FROM pn_var_periods_all
7895: WHERE var_rent_id = p_var_rent_id);
7896:
7897:
7898: DELETE pn_var_lines_all
7899: WHERE period_id IN (SELECT period_id
7900: FROM pn_var_periods_all
7901: WHERE var_rent_id = p_var_rent_id
7902: AND start_date > p_new_termn_date);

Line 8800: DELETE pn_var_lines_all

8796: WHERE period_id IN (SELECT period_id
8797: FROM pn_var_periods_all
8798: WHERE var_rent_id = p_var_rent_id);
8799:
8800: DELETE pn_var_lines_all
8801: WHERE period_id IN (SELECT period_id
8802: FROM pn_var_periods_all
8803: WHERE var_rent_id = p_var_rent_id);
8804:

Line 9043: UPDATE pn_var_lines_all

9039: SET termination_date = p_new_termn_date
9040: WHERE var_rent_id = var_rent_rec.var_rent_id;
9041:
9042: /* update the bkpt_update_flag to 'Y for VR agreement */
9043: UPDATE pn_var_lines_all
9044: SET bkpt_update_flag = 'Y',
9045: sales_vol_update_flag = 'Y'
9046: WHERE var_rent_id = var_rent_rec.var_rent_id;
9047:

Line 9279: FROM pn_var_lines_all

9275: ,agreement_template_id
9276: ,line_default_id
9277: ,var_rent_id
9278: ,line_item_id
9279: FROM pn_var_lines_all
9280: WHERE period_id = p_period_id;
9281:
9282: /* This cursor fetches the breakpoint header record data,
9283: which ends on end date of last period before expansion */

Line 9998: UPDATE pn_var_lines_all

9994: END IF;
9995: END IF;
9996:
9997: /* update the bkpt_update_flag to 'Y for VR agreement */
9998: UPDATE pn_var_lines_all
9999: SET bkpt_update_flag = 'Y',
10000: sales_vol_update_flag = 'Y'
10001: WHERE var_rent_id = main_vr_rec.var_rent_id;
10002:

Line 10281: l_sales_type_code pn_var_lines_all.sales_type_code%TYPE;

10277: p_var_rent_id IN NUMBER)
10278: IS
10279:
10280: TYPE NUM_TBL IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
10281: l_sales_type_code pn_var_lines_all.sales_type_code%TYPE;
10282: l_item_category_code pn_var_lines_all.item_category_code%TYPE;
10283: l_lease_id NUMBER := NULL;
10284: l_prop_id NUMBER := NULL;
10285: l_loc_id NUMBER := NULL;

Line 10282: l_item_category_code pn_var_lines_all.item_category_code%TYPE;

10278: IS
10279:
10280: TYPE NUM_TBL IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
10281: l_sales_type_code pn_var_lines_all.sales_type_code%TYPE;
10282: l_item_category_code pn_var_lines_all.item_category_code%TYPE;
10283: l_lease_id NUMBER := NULL;
10284: l_prop_id NUMBER := NULL;
10285: l_loc_id NUMBER := NULL;
10286: l_var_rent_id NUMBER := NULL;

Line 10369: FROM pn_var_lines_all

10365: SELECT DISTINCT
10366: sales_type_code,
10367: item_category_code,
10368: org_id
10369: FROM pn_var_lines_all
10370: WHERE var_rent_id = p_var_rent_id;
10371:
10372:
10373: /* Cursor used to count if a give periods has more than one occurance of a line */

Line 10378: FROM pn_var_lines_all

10374: CURSOR lines_count_cur(p_per_id NUMBER,
10375: p_sales_type_code VARCHAR2,
10376: p_item_category_code VARCHAR2) IS
10377: SELECT count(*) lines_count
10378: FROM pn_var_lines_all
10379: WHERE sales_type_code = p_sales_type_code
10380: AND item_category_code = p_item_category_code
10381: AND period_id = p_per_id;
10382:

Line 10392: FROM pn_var_lines_all lines

10388: SELECT per.period_id, per.org_id
10389: FROM pn_var_periods_all per
10390: WHERE per.period_id not in (
10391: SELECT lines.period_id
10392: FROM pn_var_lines_all lines
10393: WHERE lines.var_rent_id = p_var_rent_id
10394: AND nvl(lines.sales_type_code,'-1') = nvl(p_sales_type_code,'-1')
10395: AND nvl(lines.item_category_code,'-1') = nvl(p_item_category_code,'-1'))
10396: AND var_rent_id = p_var_rent_id ;

Line 10428: pn_var_lines_all lines

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

Line 10670: /* Insert the line item into pn_var_lines_all for thoses

10666: X_ATTRIBUTE15 => NULL
10667: );
10668:
10669: /* check nvl condition*/
10670: /* Insert the line item into pn_var_lines_all for thoses
10671: periods where this line does not exists*/
10672:
10673:
10674: FOR per_rec IN no_per_lines_exists(l_var_rent_id,

Line 10723: UPDATE pn_var_lines_all

10719: END LOOP; /* per_rec*/
10720:
10721:
10722:
10723: UPDATE pn_var_lines_all
10724: SET line_default_id = l_linedefaultid
10725: WHERE var_rent_id = l_var_rent_id
10726: AND nvl(sales_type_code,'-1') = nvl(l_sales_type_code,'-1')
10727: AND nvl(item_category_code,'-1') = nvl(l_item_category_code,'-1');