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_PERIODS_ALL

Line 69: FROM PN_VAR_PERIODS_ALL

65: ) IS
66:
67: CURSOR C IS
68: SELECT ROWID
69: FROM PN_VAR_PERIODS_ALL
70: WHERE PERIOD_ID = X_PERIOD_ID;
71:
72: CURSOR org_id_cur IS
73: SELECT org_id

Line 88: FROM PN_VAR_PERIODS_ALL pnp

84: -- We need to generate the period number
85: -------------------------------------------------------
86: SELECT NVL(MAX(pnp.PERIOD_NUM),0)
87: INTO X_PERIOD_NUM
88: FROM PN_VAR_PERIODS_ALL pnp
89: WHERE pnp.VAR_RENT_ID = X_VAR_RENT_ID;
90:
91: X_PERIOD_NUM := X_PERIOD_NUM + 1;
92:

Line 110: INSERT INTO PN_VAR_PERIODS_ALL

106: ELSE
107: l_org_id := X_ORG_ID;
108: END IF;
109:
110: INSERT INTO PN_VAR_PERIODS_ALL
111: (
112: PERIOD_ID,
113: PERIOD_NUM,
114: LAST_UPDATE_DATE,

Line 226: DELETE FROM PN_VAR_PERIODS_ALL

222: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.DELETE_PERIODS_ROW (+)');
223:
224: l_date := NVL(x_term_date,(TO_DATE('01/01/1776','mm/dd/yyyy')));
225:
226: DELETE FROM PN_VAR_PERIODS_ALL
227: WHERE VAR_RENT_ID = X_VAR_RENT_ID
228: AND START_DATE > l_date
229: AND END_DATE > l_date;
230:

Line 1036: FROM pn_var_periods_all

1032:
1033: /* Fetches the period id which starts on a specified date for a VR agreement */
1034: CURSOR period_cur (p_start_date DATE) IS
1035: SELECT period_id, end_date, status
1036: FROM pn_var_periods_all
1037: WHERE var_rent_id = p_var_rent_id
1038: AND start_date = p_start_date;
1039:
1040: /* Fetches the group id in which a specified invoice date lies for a VR agreement */

Line 1054: l_status pn_var_periods_all.status%TYPE;

1050: l_group_exists VARCHAR2(1) := 'N';
1051: l_invoice_exists VARCHAR2(1) := 'N';
1052: l_period_id NUMBER := NULL;
1053: l_end_date DATE := NULL;
1054: l_status pn_var_periods_all.status%TYPE;
1055: l_grp_date_id NUMBER;
1056: l_grp_end_date DATE := NULL;
1057:
1058:

Line 1277: UPDATE pn_var_periods_all

1273: /* Make the period as active if it is inactive */
1274: IF l_status = pn_var_rent_pkg.status THEN
1275:
1276: pnp_debug_pkg.debug('period is inactive ..'||l_period_id);
1277: UPDATE pn_var_periods_all
1278: SET status = NULL
1279: WHERE period_id = l_period_id;
1280:
1281: END IF;

Line 1286: UPDATE pn_var_periods_all

1282:
1283: ELSIF p_per_end_date > l_end_date THEN /* period is partial */
1284:
1285: /* Updte the end date and partial flag for the period */
1286: UPDATE pn_var_periods_all
1287: SET end_date = p_per_end_date,
1288: partial_period = l_partial_period,
1289: status = NULL
1290: WHERE period_id = l_period_id;

Line 2192: l_status pn_var_periods_all.status%TYPE;

2188:
2189: l_org_id NUMBER;
2190: l_add_flag VARCHAR2(1) := 'N';
2191: l_end_date DATE := NULL;
2192: l_status pn_var_periods_all.status%TYPE;
2193: l_dummy VARCHAR2(1) := NULL;
2194: l_group_exists VARCHAR2(1) := 'N';
2195: l_grp_date_id NUMBER;
2196: l_grp_end_date DATE := NULL;

Line 2213: FROM pn_var_periods_all

2209:
2210: /* Fetches the period id which starts on a specified date for a VR agreement */
2211: CURSOR period_cur (p_start_date DATE) IS
2212: SELECT period_id, end_date, status
2213: FROM pn_var_periods_all
2214: WHERE var_rent_id = p_var_rent_id
2215: AND start_date = p_start_date;
2216:
2217: BEGIN

Line 2369: UPDATE pn_var_periods_all

2365: IF l_status = pn_var_rent_pkg.status THEN
2366:
2367: pnp_debug_pkg.debug('period is inactive ..'||l_periodId);
2368:
2369: UPDATE pn_var_periods_all
2370: SET status = NULL
2371: WHERE period_id = l_periodId;
2372:
2373: END IF;

Line 2389: UPDATE pn_var_periods_all

2385: l_partial_period := 'Y';
2386: END IF;
2387:
2388: /* Updte the end date and partial flag for the period */
2389: UPDATE pn_var_periods_all
2390: SET
2391: end_date = vr_periods(i).l_period_end_date,
2392: partial_period = l_partial_period,
2393: status = NULL

Line 2874: FROM PN_VAR_PERIODS_ALL per

2870: -- updated with the new proration factor after lease contraction
2871:
2872: SELECT per.start_date
2873: INTO p_per_start_date
2874: FROM PN_VAR_PERIODS_ALL per
2875: WHERE per.var_rent_id = p_var_rent_id
2876: AND per.start_date <= p_term_date
2877: AND per.end_date >= p_term_date
2878: AND rownum < 2;

Line 2905: UPDATE pn_var_periods_all

2901: p_proration_factor := 1;
2902: END IF;
2903:
2904: --call to update PN_VAR_PERIODS;
2905: UPDATE pn_var_periods_all
2906: SET end_date = p_term_date,
2907: proration_factor = p_proration_factor,
2908: last_update_date = p_last_update_date,
2909: last_updated_by = p_last_updated_by,

Line 2992: FROM PN_VAR_PERIODS_ALL

2988: CURSOR c1 IS
2989: SELECT constraint_id
2990: FROM PN_VAR_CONSTRAINTS_ALL
2991: WHERE period_id IN (SELECT period_id
2992: FROM PN_VAR_PERIODS_ALL
2993: WHERE var_rent_id = p_var_rent_id
2994: AND start_date > l_date
2995: AND end_date > l_date);
2996:

Line 3064: FROM pn_var_periods_ALL

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
3067: AND end_date > l_date);
3068:

Line 3384: FROM pn_var_periods_ALL periods

3380: SELECT 1
3381: INTO l_period_exists
3382: FROM dual
3383: WHERE EXISTS ( SELECT periods.period_id
3384: FROM pn_var_periods_ALL periods
3385: WHERE periods.var_rent_id = p_var_rent_id);
3386:
3387: RETURN l_period_exists;
3388:

Line 3540: FROM pn_var_periods_ALL

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
3543: AND end_date > l_date);
3544:

Line 3747: FROM pn_var_periods_ALL

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)
3750: AND start_date > l_date
3751: AND end_date > l_date)

Line 3927: FROM pn_var_periods_ALL

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:
3930: l_volhist_bkpts_exist NUMBER := NULL;
3931:

Line 4021: FROM PN_VAR_PERIODS_ALL

4017: FROM dual
4018: WHERE EXISTS ( SELECT constraint_id
4019: FROM pn_var_constraints_ALL
4020: WHERE period_id IN (SELECT period_id
4021: FROM PN_VAR_PERIODS_ALL
4022: WHERE var_rent_id = p_var_rent_id
4023: AND start_date > l_date
4024: AND end_date > l_date)
4025: );

Line 4431: pn_var_periods_ALL per,

4427: SELECT SUM(item.ACTUAL_AMOUNT)
4428: INTO l_base_rent
4429: FROM pn_payment_items_ALL item,
4430: pn_payment_terms_ALL term,
4431: pn_var_periods_ALL per,
4432: pn_var_rents_ALL var,
4433: pn_payment_schedules_all sched
4434: WHERE item.PAYMENT_TERM_ID = term.PAYMENT_TERM_ID
4435: AND sched.PAYMENT_SCHEDULE_ID = item.PAYMENT_SCHEDULE_ID

Line 4455: pn_var_periods_ALL per,

4451: SELECT SUM(item.ACTUAL_AMOUNT)
4452: INTO l_base_rent
4453: FROM pn_payment_items_ALL item,
4454: pn_payment_terms_ALL term,
4455: pn_var_periods_ALL per,
4456: pn_var_rents_ALL var,
4457: pn_payment_schedules_all sched
4458: WHERE item.PAYMENT_TERM_ID = term.PAYMENT_TERM_ID
4459: AND sched.PAYMENT_SCHEDULE_ID = item.PAYMENT_SCHEDULE_ID

Line 4610: FROM pn_var_periods_ALL p1, pn_var_periods_ALL p2,

4606: g1.proration_factor first_group_gl_days,
4607: (g2.grp_end_date-g2.grp_start_date)+1 last_group_pro_days,
4608: g2.proration_factor last_group_gl_days
4609: INTO l_proration_factor
4610: FROM pn_var_periods_ALL p1, pn_var_periods_ALL p2,
4611: pn_var_grp_dates_ALL g1, pn_var_grp_dates_ALL g2
4612: WHERE p1.var_rent_id = p2.var_rent_id
4613: AND p1.var_rent_id = p_var_rent_id
4614: AND g1.var_rent_id = g2.var_rent_id

Line 4617: FROM pn_var_periods_ALL

4613: AND p1.var_rent_id = p_var_rent_id
4614: AND g1.var_rent_id = g2.var_rent_id
4615: AND g1.var_rent_id = p_var_rent_id
4616: AND p1.period_id = (SELECT min(period_id)
4617: FROM pn_var_periods_ALL
4618: WHERE var_rent_id = p_var_rent_id)
4619: AND p2.period_id = (SELECT max(period_id)
4620: FROM pn_var_periods_ALL
4621: WHERE var_rent_id = p_var_rent_id)

Line 4620: FROM pn_var_periods_ALL

4616: AND p1.period_id = (SELECT min(period_id)
4617: FROM pn_var_periods_ALL
4618: WHERE var_rent_id = p_var_rent_id)
4619: AND p2.period_id = (SELECT max(period_id)
4620: FROM pn_var_periods_ALL
4621: WHERE var_rent_id = p_var_rent_id)
4622: AND g1.grp_date_id = (SELECT min(grp_date_id)
4623: FROM pn_var_grp_dates
4624: WHERE var_rent_id = p_var_rent_id)

Line 4852: pn_var_periods_all b,

4848: INTO l_exported
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

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 5433: FROM pn_var_periods_all

5429: CURSOR periods_vr_c(p_vr_id IN NUMBER) IS
5430: SELECT period_id
5431: ,start_date
5432: ,end_date
5433: FROM pn_var_periods_all
5434: WHERE var_rent_id = p_vr_id
5435: ORDER BY start_date;
5436:
5437: CURSOR periods_c(p_prd_id IN NUMBER) IS

Line 5441: FROM pn_var_periods_all

5437: CURSOR periods_c(p_prd_id IN NUMBER) IS
5438: SELECT period_id
5439: ,start_date
5440: ,end_date
5441: FROM pn_var_periods_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

Line 5832: FROM pn_var_periods_all

5828: l_line_t(1) := p_line_item_id;
5829:
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;

Line 6107: FROM pn_var_periods_all

6103: CURSOR periods_vr_c(p_vr_id IN NUMBER) IS
6104: SELECT period_id
6105: ,start_date
6106: ,end_date
6107: FROM pn_var_periods_all
6108: WHERE var_rent_id = p_vr_id
6109: ORDER BY start_date;
6110:
6111: CURSOR periods_c(p_prd_id IN NUMBER) IS

Line 6115: FROM pn_var_periods_all

6111: CURSOR periods_c(p_prd_id IN NUMBER) IS
6112: SELECT period_id
6113: ,start_date
6114: ,end_date
6115: FROM pn_var_periods_all
6116: WHERE period_id = p_prd_id;
6117:
6118: CURSOR constr_c(p_period_id IN NUMBER) IS
6119: SELECT constraint_id

Line 6312: FROM pn_var_periods_all

6308: IS
6309:
6310: Cursor var_periods_cur IS
6311: SELECT *
6312: FROM pn_var_periods_all
6313: WHERE var_rent_id = p_var_rent_id
6314: -- AND (start_date = NVL(p_start_date,start_date) OR
6315: -- end_date = NVL(p_end_date ,end_date) )
6316: Order by start_date ;

Line 6414: UPDATE pn_var_periods_all

6410: pnp_debug_pkg.debug(' v_new_periods_tbl(i).end_date:'||v_new_periods_tbl(i).end_date);
6411: pnp_debug_pkg.debug(' l_partial_period:'||l_partial_period);*/
6412: --Srini End 30-JUL-2004
6413:
6414: UPDATE pn_var_periods_all
6415: SET end_date = v_new_periods_tbl(i).end_date,
6416: partial_period = l_partial_period, --Srini
6417: last_update_date = sysdate,
6418: last_updated_by = FND_GLOBAL.USER_ID,

Line 6559: FROM pn_var_periods_all

6555:
6556: CURSOR periods_cur
6557: IS
6558: SELECT start_date, end_date ,proration_factor
6559: FROM pn_var_periods_all
6560: WHERE period_id = p_period_id;
6561:
6562: CURSOR pn_var_grp_dates_cur
6563: IS

Line 7072: pn_var_periods_all b

7068: IS
7069: CURSOR var_rent_cur IS
7070: SELECT a.proration_rule
7071: FROM pn_var_rents_all a,
7072: pn_var_periods_all b
7073: WHERE a.var_rent_id = NVL(p_var_rent_id,a.var_rent_id)
7074: AND a.var_rent_id = b.var_rent_id
7075: AND b.period_id = NVL(p_period_id,b.period_id);
7076:

Line 7096: pn_var_periods_all b

7092: BEGIN
7093: SELECT proration_rule
7094: INTO l_proration_rule
7095: FROM pn_var_rents_all a,
7096: pn_var_periods_all b
7097: WHERE a.var_rent_id = b.var_rent_id
7098: AND b.period_id = NVL(p_period_id,b.period_id);
7099: EXCEPTION
7100: WHEN OTHERS THEN

Line 7727: FROM pn_var_periods_all

7723: FUNCTION is_partial_period (p_period_id IN NUMBER)
7724: RETURN VARCHAR2 IS
7725: CURSOR is_partial_period_cur IS
7726: SELECT partial_period
7727: FROM pn_var_periods_all
7728: WHERE period_id = p_period_id;
7729: l_return VARCHAR2(1) := 'X';
7730: BEGIN
7731: OPEN is_partial_period_cur;

Line 7868: FROM pn_var_periods_all

7864: /* Delete the data from main tables */
7865: DELETE pn_var_vol_hist_all
7866: WHERE start_date > p_new_termn_date
7867: AND period_id IN (SELECT period_id
7868: FROM pn_var_periods_all
7869: WHERE var_rent_id = p_var_rent_id);
7870:
7871: DELETE pn_var_bkpts_det_all
7872: WHERE bkpt_start_date > p_new_termn_date

Line 7882: FROM pn_var_periods_all

7878:
7879: DELETE pn_var_deductions_all
7880: WHERE start_date > p_new_termn_date
7881: AND period_id IN (SELECT period_id
7882: FROM pn_var_periods_all
7883: WHERE var_rent_id = p_var_rent_id);
7884:
7885: DELETE pn_var_rent_summ_all
7886: WHERE grp_date_id IN (SELECT grp_date_id

Line 7894: FROM pn_var_periods_all

7890:
7891: DELETE pn_var_constraints_all
7892: WHERE constr_start_date > p_new_termn_date
7893: AND period_id IN (SELECT period_id
7894: FROM pn_var_periods_all
7895: WHERE var_rent_id = p_var_rent_id);
7896:
7897:
7898: DELETE pn_var_lines_all

Line 7900: FROM pn_var_periods_all

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);
7903:
7904: /* Delete data from defaults table */

Line 7955: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp

7951:
7952: /* This cursor fetches the distinct invoices for periods starting after new termination date */
7953: CURSOR invoice_date_cur IS
7954: SELECT DISTINCT pvi.invoice_date, pvi.period_id
7955: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp
7956: WHERE pvp.period_id = pvi.period_id
7957: AND pvp.start_date > p_new_termn_date
7958: AND pvp.var_rent_id = p_var_rent_id;
7959:

Line 8006: FROM pn_var_periods_all

8002:
8003: /* This cursor fetches periods starting after new termination date in descending order of start date */
8004: CURSOR period_cur IS
8005: SELECT period_id
8006: FROM pn_var_periods_all
8007: WHERE var_rent_id = p_var_rent_id
8008: AND start_date > p_new_termn_date
8009: ORDER BY start_date DESC;
8010:

Line 8020: FROM pn_var_periods_all per

8016:
8017: /* This cursor fetches periods staring after new termination date for which there exists invoices */
8018: CURSOR period_inv_cur IS
8019: SELECT period_id
8020: FROM pn_var_periods_all per
8021: WHERE per.var_rent_id = p_var_rent_id
8022: AND per.start_date > p_new_termn_date
8023: AND EXISTS (SELECT var_rent_inv_id
8024: FROM pn_var_rent_inv_all

Line 8090: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp

8086: /* Delete draft terms for invoices for all periods which lie after the new termination date */
8087: DELETE pn_payment_terms_all
8088: WHERE status = 'DRAFT'
8089: AND var_rent_inv_id IN (SELECT var_rent_inv_id
8090: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp
8091: WHERE pvi.period_id = pvp.period_id
8092: AND pvp.var_rent_id = p_var_rent_id
8093: AND pvp.start_date > p_new_termn_date);
8094:

Line 8098: FROM pn_payment_terms_all ppt, pn_var_rent_inv_all pvi, pn_var_periods_all pvp

8094:
8095: /* Delete invoices for which there are no terms */
8096: DELETE pn_var_rent_inv_all
8097: WHERE var_rent_inv_id NOT IN (SELECT ppt.var_rent_inv_id
8098: FROM pn_payment_terms_all ppt, pn_var_rent_inv_all pvi, pn_var_periods_all pvp
8099: WHERE ppt.var_rent_inv_id = pvi.var_rent_inv_id
8100: AND pvi.period_id = pvp.period_id
8101: AND pvp.var_rent_id = p_var_rent_id
8102: AND pvp.start_date > p_new_termn_date)

Line 8105: FROM pn_var_periods_all

8101: AND pvp.var_rent_id = p_var_rent_id
8102: AND pvp.start_date > p_new_termn_date)
8103: AND var_rent_id = p_var_rent_id
8104: AND period_id IN (SELECT period_id
8105: FROM pn_var_periods_all
8106: WHERE var_rent_id = p_var_rent_id
8107: AND start_date > p_new_termn_date);
8108:
8109: pnp_debug_pkg.debug ('Loop through the period which start after new termination date');

Line 8133: DELETE pn_var_periods_all

8129: /* Delete group dates and periods for which there exists no invoice */
8130: DELETE pn_var_grp_dates_all
8131: WHERE period_id = period_rec.period_id;
8132:
8133: DELETE pn_var_periods_all
8134: WHERE period_id = period_rec.period_id;
8135: END IF;
8136:
8137: END LOOP;

Line 8249: UPDATE pn_var_periods_all

8245: END LOOP;
8246:
8247: /* OPEN ISSUE */
8248: /* Update the periods after new termination date - set status = 'Reversed' */
8249: UPDATE pn_var_periods_all
8250: SET status = pn_var_rent_pkg.status
8251: WHERE var_rent_id = p_var_rent_id
8252: AND start_date > p_new_termn_date;
8253:

Line 8514: UPDATE pn_var_periods_all

8510: SET end_date = l_inv_end_dt
8511: WHERE var_rent_id = p_var_rent_id
8512: AND p_new_termn_date BETWEEN start_date AND end_date;
8513:
8514: UPDATE pn_var_periods_all
8515: SET end_date = p_new_termn_date,
8516: Partial_period = 'Y'
8517: WHERE var_rent_id = p_var_rent_id
8518: AND period_id = p_period_id;

Line 8644: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp

8640: /* Delete draft terms for invoices for this period */
8641: DELETE pn_payment_terms_all
8642: WHERE status = 'DRAFT'
8643: AND var_rent_inv_id IN (SELECT var_rent_inv_id
8644: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp
8645: WHERE pvi.period_id = p_period_id );
8646:
8647: /* Delete invoices for which there are no terms */
8648: DELETE pn_var_rent_inv_all

Line 8776: FROM pn_var_periods_all

8772:
8773: /* Delete the data from main tables */
8774: DELETE pn_var_vol_hist_all
8775: WHERE period_id IN (SELECT period_id
8776: FROM pn_var_periods_all
8777: WHERE var_rent_id = p_var_rent_id);
8778:
8779: DELETE pn_var_bkpts_det_all
8780: WHERE var_rent_id = p_var_rent_id;

Line 8787: FROM pn_var_periods_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
8787: FROM pn_var_periods_all
8788: WHERE var_rent_id = p_var_rent_id);
8789:
8790: DELETE pn_var_rent_summ_all
8791: WHERE grp_date_id IN (SELECT grp_date_id

Line 8797: FROM pn_var_periods_all

8793: WHERE var_rent_id = p_var_rent_id);
8794:
8795: DELETE pn_var_constraints_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

Line 8802: 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:
8805: /* Delete data from defaults table */
8806:

Line 8830: DELETE pn_var_periods_all

8826:
8827: DELETE pn_var_grp_dates_all
8828: WHERE var_rent_id = p_var_rent_id;
8829:
8830: DELETE pn_var_periods_all
8831: WHERE var_rent_id = p_var_rent_id;
8832:
8833: DELETE pn_var_rents_all
8834: WHERE var_rent_id = p_var_rent_id;

Line 8884: FROM pn_var_periods_all

8880:
8881: /* Fetch the period in which the new termination date lies */
8882: CURSOR period_id_cur(l_var_rent_id NUMBER) IS
8883: SELECT period_id, end_date
8884: FROM pn_var_periods_all
8885: WHERE var_rent_id = l_var_rent_id
8886: AND p_new_termn_date BETWEEN start_date AND end_date;
8887:
8888: /* Fetch the agreements which start after the new termination date */

Line 8902: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp,

8898: SELECT 'Y' approve_term_exits
8899: FROM pn_payment_terms_all
8900: WHERE status = 'APPROVED'
8901: AND var_rent_inv_id IN (SELECT var_rent_inv_id
8902: FROM pn_var_rent_inv_all pvi, pn_var_periods_all pvp,
8903: pn_var_rents_all pvr
8904: WHERE pvi.period_id = pvp.period_id
8905: AND pvr.var_rent_id = pvp.var_rent_id
8906: AND pvr.var_rent_id = p_var_rent_id);

Line 9125: FROM pn_var_periods_all

9121: FROM DUAL
9122: WHERE EXISTS (SELECT constraint_id
9123: FROM pn_var_constraints_all
9124: WHERE period_id IN (SELECT PERIOD_ID
9125: FROM pn_var_periods_all
9126: WHERE var_rent_id = p_var_rent_id)
9127: AND constr_default_id IS NOT NULL);
9128:
9129: /* Get the details of breakpoint header default */

Line 9211: FROM pn_var_periods_all

9207: pnp_debug_pkg.debug ('calling procedure pn_var_defaults_pkg.create_default_constraints ..');
9208: FOR rec IN constr_data_exists LOOP
9209: DELETE FROM pn_var_constraints_all
9210: WHERE period_id IN (SELECT period_id
9211: FROM pn_var_periods_all
9212: WHERE var_rent_id = p_var_rent_id);
9213:
9214: pn_var_defaults_pkg.create_default_constraints (x_var_rent_id => p_var_rent_id);
9215: END LOOP;

Line 9239: FROM pn_var_periods_all

9235:
9236: /* This cursor fetches period, which start after the last period */
9237: CURSOR period_cur IS
9238: SELECT period_id, start_date, end_date
9239: FROM pn_var_periods_all
9240: WHERE var_rent_id = p_var_rent_id
9241: AND start_date > ( SELECT end_date
9242: FROM pn_var_periods_all
9243: WHERE period_id = p_period_id);

Line 9242: FROM pn_var_periods_all

9238: SELECT period_id, start_date, end_date
9239: FROM pn_var_periods_all
9240: WHERE var_rent_id = p_var_rent_id
9241: AND start_date > ( SELECT end_date
9242: FROM pn_var_periods_all
9243: WHERE period_id = p_period_id);
9244:
9245: /* This cursor fetches information abouth the period which was the last one
9246: before contraction */

Line 9249: FROM pn_var_periods_all

9245: /* This cursor fetches information abouth the period which was the last one
9246: before contraction */
9247: CURSOR last_period_cur IS
9248: SELECT end_date
9249: FROM pn_var_periods_all
9250: WHERE period_id = p_period_id;
9251:
9252: /* This cursor fetches the line record data for last period before expansion */
9253: CURSOR line_cur IS

Line 9620: FROM pn_var_periods_all

9616: ,p_period_id IN NUMBER)
9617: IS
9618: CURSOR period_cur IS
9619: SELECT end_date
9620: FROM pn_var_periods_all
9621: WHERE var_rent_id = p_var_rent_id
9622: AND period_id = p_period_id;
9623:
9624: BEGIN

Line 9867: FROM pn_var_periods_all

9863:
9864: /* Fetches the period in which the old termination date falls */
9865: CURSOR last_period_cur (p_var_rent_id NUMBER) IS
9866: SELECT period_id, partial_period
9867: FROM pn_var_periods_all
9868: WHERE var_rent_id = p_var_rent_id
9869: AND p_old_termn_date BETWEEN start_date AND end_date;
9870:
9871: /* This retrieves the variable rent agreements which need to be extended */

Line 10357: FROM pn_var_periods_all per,

10353: /* Cursor used to fetch distinct periods */
10354: CURSOR periods_cur(p_var_rent_id NUMBER) IS
10355: SELECT DISTINCT per.period_id period_id,
10356: var.rent_num rent_num
10357: FROM pn_var_periods_all per,
10358: pn_var_rents_all var
10359: WHERE per.var_rent_id = p_var_rent_id
10360: AND var.var_rent_id = p_var_rent_id;
10361:

Line 10389: FROM pn_var_periods_all per

10385: CURSOR no_per_lines_exists(p_var_rent_id NUMBER,
10386: p_sales_type_code VARCHAR2,
10387: p_item_category_code VARCHAR2) IS
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

Line 10506: pn_var_periods_all per

10502: ,cons.constr_default_id
10503: ,cons.constr_start_date
10504: ,cons.constr_end_date
10505: FROM pn_var_constraints_all cons,
10506: pn_var_periods_all per
10507: WHERE per.var_rent_id = p_var_rent_id
10508: AND cons.period_id = per.period_id;
10509:
10510:

Line 11078: FROM pn_var_periods_all

11074: /* Cursor to get var periods */
11075: CURSOR periods_vr_c(p_vr_id IN NUMBER) IS
11076: SELECT start_date
11077: ,end_date
11078: FROM pn_var_periods_all
11079: WHERE var_rent_id = p_vr_id
11080: ORDER BY start_date;
11081:
11082: /* Cursor to select Breakpoints whose start date