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 3741: FROM pn_var_lines_ALL

3737: SELECT 1
3738: INTO l_lines_exist
3739: FROM dual
3740: WHERE EXISTS ( SELECT line_item_id
3741: FROM pn_var_lines_ALL
3742: WHERE period_id IN (SELECT period_id
3743: FROM pn_var_periods_ALL
3744: WHERE var_rent_id = p_var_rent_id
3745: AND period_id = NVL(p_period_id,period_id)

Line 4822: FROM pn_var_lines_ALL

4818: FROM dual
4819: WHERE EXISTS ( SELECT grp_date_id
4820: FROM pn_var_grp_dates_all
4821: WHERE period_id IN (SELECT period_id
4822: FROM pn_var_lines_ALL
4823: WHERE line_item_id = p_id)
4824: AND (actual_exp_code = 'Y' OR
4825: forecasted_exp_code = 'Y')
4826: );

Line 4836: FROM pn_var_lines_ALL

4832: FROM dual
4833: WHERE EXISTS ( SELECT grp_date_id
4834: FROM pn_var_grp_dates_all
4835: WHERE period_id IN (SELECT period_id
4836: FROM pn_var_lines_ALL
4837: WHERE line_default_id = p_id)
4838: AND (actual_exp_code = 'Y' OR
4839: forecasted_exp_code = 'Y')
4840: );

Line 4849: pn_var_lines_all c

4845: FROM dual
4846: WHERE EXISTS ( SELECT grp_date_id
4847: FROM pn_var_grp_dates_all a,
4848: pn_var_periods_all b,
4849: pn_var_lines_all c
4850: WHERE a.period_id = b.period_id
4851: AND b.period_id = c.period_id
4852: AND c.line_default_id = p_id
4853: AND (a.actual_exp_code = 'Y' OR

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

5438: WHERE period_id = p_prd_id;
5439:
5440: CURSOR line_items_c(p_prd_id IN NUMBER) IS
5441: SELECT line_item_id
5442: FROM pn_var_lines_all
5443: WHERE period_id = p_prd_id
5444: ORDER BY line_item_id;
5445:
5446: CURSOR bkpt_headers_c(p_line_id IN NUMBER) IS

Line 5830: FROM pn_var_lines_all

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

Line 7892: DELETE pn_var_lines_all

7888: FROM pn_var_periods_all
7889: WHERE var_rent_id = p_var_rent_id);
7890:
7891:
7892: DELETE pn_var_lines_all
7893: WHERE period_id IN (SELECT period_id
7894: FROM pn_var_periods_all
7895: WHERE var_rent_id = p_var_rent_id
7896: AND start_date > p_new_termn_date);

Line 8783: DELETE pn_var_lines_all

8779: WHERE period_id IN (SELECT period_id
8780: FROM pn_var_periods_all
8781: WHERE var_rent_id = p_var_rent_id);
8782:
8783: DELETE pn_var_lines_all
8784: WHERE period_id IN (SELECT period_id
8785: FROM pn_var_periods_all
8786: WHERE var_rent_id = p_var_rent_id);
8787:

Line 9026: UPDATE pn_var_lines_all

9022: SET termination_date = p_new_termn_date
9023: WHERE var_rent_id = var_rent_rec.var_rent_id;
9024:
9025: /* update the bkpt_update_flag to 'Y for VR agreement */
9026: UPDATE pn_var_lines_all
9027: SET bkpt_update_flag = 'Y',
9028: sales_vol_update_flag = 'Y'
9029: WHERE var_rent_id = var_rent_rec.var_rent_id;
9030:

Line 9262: FROM pn_var_lines_all

9258: ,agreement_template_id
9259: ,line_default_id
9260: ,var_rent_id
9261: ,line_item_id
9262: FROM pn_var_lines_all
9263: WHERE period_id = p_period_id;
9264:
9265: /* This cursor fetches the breakpoint header record data,
9266: which ends on end date of last period before expansion */

Line 9981: UPDATE pn_var_lines_all

9977: END IF;
9978: END IF;
9979:
9980: /* update the bkpt_update_flag to 'Y for VR agreement */
9981: UPDATE pn_var_lines_all
9982: SET bkpt_update_flag = 'Y',
9983: sales_vol_update_flag = 'Y'
9984: WHERE var_rent_id = main_vr_rec.var_rent_id;
9985:

Line 10264: l_sales_type_code pn_var_lines_all.sales_type_code%TYPE;

10260: p_var_rent_id IN NUMBER)
10261: IS
10262:
10263: TYPE NUM_TBL IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
10264: l_sales_type_code pn_var_lines_all.sales_type_code%TYPE;
10265: l_item_category_code pn_var_lines_all.item_category_code%TYPE;
10266: l_lease_id NUMBER := NULL;
10267: l_prop_id NUMBER := NULL;
10268: l_loc_id NUMBER := NULL;

Line 10265: l_item_category_code pn_var_lines_all.item_category_code%TYPE;

10261: IS
10262:
10263: TYPE NUM_TBL IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
10264: l_sales_type_code pn_var_lines_all.sales_type_code%TYPE;
10265: l_item_category_code pn_var_lines_all.item_category_code%TYPE;
10266: l_lease_id NUMBER := NULL;
10267: l_prop_id NUMBER := NULL;
10268: l_loc_id NUMBER := NULL;
10269: l_var_rent_id NUMBER := NULL;

Line 10352: FROM pn_var_lines_all

10348: SELECT DISTINCT
10349: sales_type_code,
10350: item_category_code,
10351: org_id
10352: FROM pn_var_lines_all
10353: WHERE var_rent_id = p_var_rent_id;
10354:
10355:
10356: /* Cursor used to count if a give periods has more than one occurance of a line */

Line 10361: FROM pn_var_lines_all

10357: CURSOR lines_count_cur(p_per_id NUMBER,
10358: p_sales_type_code VARCHAR2,
10359: p_item_category_code VARCHAR2) IS
10360: SELECT count(*) lines_count
10361: FROM pn_var_lines_all
10362: WHERE sales_type_code = p_sales_type_code
10363: AND item_category_code = p_item_category_code
10364: AND period_id = p_per_id;
10365:

Line 10375: FROM pn_var_lines_all lines

10371: SELECT per.period_id, per.org_id
10372: FROM pn_var_periods_all per
10373: WHERE per.period_id not in (
10374: SELECT lines.period_id
10375: FROM pn_var_lines_all lines
10376: WHERE lines.var_rent_id = p_var_rent_id
10377: AND nvl(lines.sales_type_code,'-1') = nvl(p_sales_type_code,'-1')
10378: AND nvl(lines.item_category_code,'-1') = nvl(p_item_category_code,'-1'))
10379: AND var_rent_id = p_var_rent_id ;

Line 10411: pn_var_lines_all lines

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

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

10649: X_ATTRIBUTE15 => NULL
10650: );
10651:
10652: /* check nvl condition*/
10653: /* Insert the line item into pn_var_lines_all for thoses
10654: periods where this line does not exists*/
10655:
10656:
10657: FOR per_rec IN no_per_lines_exists(l_var_rent_id,

Line 10706: UPDATE pn_var_lines_all

10702: END LOOP; /* per_rec*/
10703:
10704:
10705:
10706: UPDATE pn_var_lines_all
10707: SET line_default_id = l_linedefaultid
10708: WHERE var_rent_id = l_var_rent_id
10709: AND nvl(sales_type_code,'-1') = nvl(l_sales_type_code,'-1')
10710: AND nvl(item_category_code,'-1') = nvl(l_item_category_code,'-1');