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_LINES

Line 2644: | corresponding line items in the PN_VAR_LINES table

Line 2662: | PN_VAR_LINES table for a variable rent record

Line 3023: | Delete variable rent lines record in PN_VAR_LINES and associated

Line 3030: | PN_VAR_LINES_PKG.DELETE_ROW

Line 3040: | NOTES : Delete variable rent lines record in PN_VAR_LINES and associated

3036: | OUT:
3037: |
3038: | RETURNS : None
3039: |
3040: | NOTES : Delete variable rent lines record in PN_VAR_LINES and associated
3041: | volume history records in the PN_VAR_VOL_HIST table for a
3042: | variable rent record
3043: |
3044: | MODIFICATION HISTORY

Line 3048: | 14-JUL-05 hareesha o Bug 4284035 - Replaced pn_var_lines with _ALL table.

3044: | MODIFICATION HISTORY
3045: |
3046: | 15-OCT-2001 Daniel Thota o Created
3047: | 27-DEC-2001 Daniel Thota o Included parameter p_term_date for contraction.
3048: | 14-JUL-05 hareesha o Bug 4284035 - Replaced pn_var_lines with _ALL table.
3049: +===========================================================================*/
3050:
3051: PROCEDURE DELETE_VAR_RENT_LINES(p_var_rent_id IN NUMBER,
3052: p_term_date IN DATE ) IS

Line 3062: FROM pn_var_lines

3058: l_date DATE := NVL(p_term_date,(TO_DATE('01/01/1776','mm/dd/yyyy')));
3059:
3060: CURSOR c1 is
3061: SELECT line_item_id
3062: FROM pn_var_lines
3063: WHERE period_id IN (SELECT period_id
3064: FROM pn_var_periods_ALL
3065: WHERE var_rent_id = p_var_rent_id
3066: AND start_date > l_date

Line 3104: PN_VAR_LINES_PKG.DELETE_ROW(lines_rec.line_item_id);

3100: END IF;
3101: -------------------------------------------------------------------------
3102: -- Delete lines associated with each period for this variable rent record
3103: -------------------------------------------------------------------------
3104: PN_VAR_LINES_PKG.DELETE_ROW(lines_rec.line_item_id);
3105:
3106: l_counter := l_counter + 1;
3107:
3108: IF l_counter = 1000 THEN

Line 3186: | PN_VAR_LINES_PKG.DELETE_ROW

3182: |
3183: | SCOPE - PUBLIC
3184: |
3185: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
3186: | PN_VAR_LINES_PKG.DELETE_ROW
3187: |
3188: | ARGUMENTS : IN:
3189: | p_line_item_id
3190: |

Line 3244: | PN_VAR_LINES_PKG.DELETE_ROW

3240: |
3241: | SCOPE - PUBLIC
3242: |
3243: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
3244: | PN_VAR_LINES_PKG.DELETE_ROW
3245: |
3246: | ARGUMENTS : IN:
3247: | p_line_item_id
3248: |

Line 3307: | PN_VAR_LINES_PKG.DELETE_ROW

3303: |
3304: | SCOPE - PUBLIC
3305: |
3306: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
3307: | PN_VAR_LINES_PKG.DELETE_ROW
3308: |
3309: | ARGUMENTS : IN:
3310: | p_bkpt_header_id
3311: |

Line 3538: FROM pn_var_lines

3534: l_counter NUMBER;
3535:
3536: CURSOR c1 is
3537: SELECT line_item_id
3538: FROM pn_var_lines
3539: WHERE period_id IN (SELECT period_id
3540: FROM pn_var_periods_ALL
3541: WHERE var_rent_id = p_var_rent_id
3542: AND start_date > l_date

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 9419: pn_var_lines_pkg.insert_row(x_rowid => l_rowid,

9415: l_line_item_id := NULL;
9416: l_line_item_num := NULL;
9417:
9418: /* generate line item for this period using the data from last period */
9419: pn_var_lines_pkg.insert_row(x_rowid => l_rowid,
9420: x_line_item_id => l_line_item_id,
9421: x_line_item_num => l_line_item_num,
9422: x_period_id => period_rec.period_id,
9423: x_sales_type_code => line_rec.sales_type_code,

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 10682: PN_VAR_LINES_PKG.INSERT_ROW (

10678: l_rowId_lines := NULL;
10679: l_lineitemId := NULL;
10680: l_lineitemNum := NULL;
10681:
10682: PN_VAR_LINES_PKG.INSERT_ROW (
10683: X_ROWID => l_rowId_lines,
10684: X_LINE_ITEM_ID => l_lineitemId,
10685: X_LINE_ITEM_NUM => l_lineitemNum,
10686: X_PERIOD_ID => per_rec.period_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');