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 2640: | corresponding line items in the PN_VAR_LINES table

Line 2658: | PN_VAR_LINES table for a variable rent record

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

Line 3026: | PN_VAR_LINES_PKG.DELETE_ROW

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

3032: | OUT:
3033: |
3034: | RETURNS : None
3035: |
3036: | NOTES : Delete variable rent lines record in PN_VAR_LINES and associated
3037: | volume history records in the PN_VAR_VOL_HIST table for a
3038: | variable rent record
3039: |
3040: | MODIFICATION HISTORY

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

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

Line 3058: FROM pn_var_lines

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

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

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

Line 3182: | PN_VAR_LINES_PKG.DELETE_ROW

3178: |
3179: | SCOPE - PUBLIC
3180: |
3181: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
3182: | PN_VAR_LINES_PKG.DELETE_ROW
3183: |
3184: | ARGUMENTS : IN:
3185: | p_line_item_id
3186: |

Line 3240: | PN_VAR_LINES_PKG.DELETE_ROW

3236: |
3237: | SCOPE - PUBLIC
3238: |
3239: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
3240: | PN_VAR_LINES_PKG.DELETE_ROW
3241: |
3242: | ARGUMENTS : IN:
3243: | p_line_item_id
3244: |

Line 3303: | PN_VAR_LINES_PKG.DELETE_ROW

3299: |
3300: | SCOPE - PUBLIC
3301: |
3302: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
3303: | PN_VAR_LINES_PKG.DELETE_ROW
3304: |
3305: | ARGUMENTS : IN:
3306: | p_bkpt_header_id
3307: |

Line 3534: FROM pn_var_lines

3530: l_counter NUMBER;
3531:
3532: CURSOR c1 is
3533: SELECT line_item_id
3534: FROM pn_var_lines
3535: WHERE period_id IN (SELECT period_id
3536: FROM pn_var_periods_ALL
3537: WHERE var_rent_id = p_var_rent_id
3538: AND start_date > l_date

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

9398: l_line_item_id := NULL;
9399: l_line_item_num := NULL;
9400:
9401: /* generate line item for this period using the data from last period */
9402: pn_var_lines_pkg.insert_row(x_rowid => l_rowid,
9403: x_line_item_id => l_line_item_id,
9404: x_line_item_num => l_line_item_num,
9405: x_period_id => period_rec.period_id,
9406: x_sales_type_code => line_rec.sales_type_code,

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

10661: l_rowId_lines := NULL;
10662: l_lineitemId := NULL;
10663: l_lineitemNum := NULL;
10664:
10665: PN_VAR_LINES_PKG.INSERT_ROW (
10666: X_ROWID => l_rowId_lines,
10667: X_LINE_ITEM_ID => l_lineitemId,
10668: X_LINE_ITEM_NUM => l_lineitemNum,
10669: X_PERIOD_ID => per_rec.period_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');