APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_REPORT_DATES_ALL

Line 249: | Inserts the records into PN_VAR_REPORT_DATES_ALL

245: | PROCEDURE
246: | CREATE_REPORT_DATES
247: |
248: | DESCRIPTION
249: | Inserts the records into PN_VAR_REPORT_DATES_ALL
250: |
251: | SCOPE - PUBLIC
252: |
253: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 262: | NOTES : Inserts the records into PN_VAR_REPORT_DATES_ALL

258: | OUT:
259: |
260: | RETURNS : None
261: |
262: | NOTES : Inserts the records into PN_VAR_REPORT_DATES_ALL
263: |
264: | MODIFICATION HISTORY
265: |
266: | 10-JAN-2006 Prabhakar o Created.

Line 446: FROM PN_VAR_REPORT_DATES_ALL

442: ) IS
443:
444: CURSOR C IS
445: SELECT ROWID
446: FROM PN_VAR_REPORT_DATES_ALL
447: WHERE REPORT_DATE_ID = X_REPORT_DATE_ID;
448:
449: CURSOR org_id_cur IS
450: SELECT org_id

Line 477: INSERT INTO PN_VAR_REPORT_DATES_ALL

473: ELSE
474: l_org_id := X_ORG_ID;
475: END IF;
476:
477: INSERT INTO PN_VAR_REPORT_DATES_ALL
478: (
479: REPORT_DATE_ID,
480: GRP_DATE_ID,
481: VAR_RENT_ID,

Line 588: DELETE FROM PN_VAR_REPORT_DATES_ALL

584: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.DELETE_REPORT_DATE_ROW (+)');
585:
586: l_date := NVL(X_END_DATE,(TO_DATE('01/01/1776','mm/dd/yyyy')));
587:
588: DELETE FROM PN_VAR_REPORT_DATES_ALL
589: WHERE VAR_RENT_ID = X_VAR_RENT_ID
590: AND REPORT_START_DATE > l_date
591: AND REPORT_END_DATE > l_date;
592:

Line 8437: UPDATE pn_var_report_dates_all

8433: AND p_new_termn_date BETWEEN grp_start_date AND grp_end_date;
8434:
8435: PN_VAR_RENT_PKG.DELETE_REPORT_DATE_ROW(p_var_rent_id, p_new_termn_date);
8436:
8437: UPDATE pn_var_report_dates_all
8438: SET report_end_date = p_new_termn_date
8439: WHERE grp_date_id = l_group_date_id
8440: AND p_new_termn_date BETWEEN report_start_date AND report_end_date;
8441: