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 DUAL

Line 99: FROM dual;

95: -------------------------------------------------------
96: IF ( X_PERIOD_ID IS NULL) THEN
97: SELECT pn_var_periods_s.nextval
98: INTO X_PERIOD_ID
99: FROM dual;
100: END IF;
101:
102: IF X_ORG_ID IS NULL THEN
103: FOR org_id_rec IN org_id_cur LOOP

Line 466: FROM dual;

462: -------------------------------------------------------
463: IF ( X_REPORT_DATE_ID IS NULL) THEN
464: SELECT pn_var_report_dates_s.nextval
465: INTO X_REPORT_DATE_ID
466: FROM dual;
467: END IF;
468:
469: IF X_ORG_ID IS NULL THEN
470: FOR org_id_rec IN org_id_cur LOOP

Line 686: FROM dual;

682: -------------------------------------------------------
683: IF ( X_GRP_DATE_ID IS NULL) THEN
684: SELECT pn_var_grp_dates_s.nextval
685: INTO X_GRP_DATE_ID
686: FROM dual;
687: END IF;
688:
689: IF X_ORG_ID IS NULL THEN
690: FOR org_id_rec IN org_id_cur LOOP

Line 3382: FROM dual

3378: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_PERIOD_EXISTS (+)');
3379:
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:

Line 3434: FROM dual

3430: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_CALCULATION_EXISTS (+)');
3431:
3432: SELECT 1
3433: INTO l_calculation_exists
3434: FROM dual
3435: WHERE EXISTS ( SELECT inv.var_rent_inv_id
3436: FROM pn_var_rent_inv_all inv
3437: WHERE inv.var_rent_id = p_var_rent_id);
3438:

Line 3485: FROM dual

3481: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_INVOICE_EXISTS (+)');
3482:
3483: SELECT 1
3484: INTO l_invoice_exists
3485: FROM dual
3486: WHERE EXISTS ( SELECT inv.var_rent_inv_id
3487: FROM pn_var_rent_inv_all inv
3488: WHERE inv.var_rent_id = p_var_rent_id);
3489:

Line 3684: FROM dual

3680: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_VRDATES_EXISTS (+)');
3681:
3682: SELECT 1
3683: INTO l_vrdates_exists
3684: FROM dual
3685: WHERE EXISTS ( SELECT dates.var_rent_date_id
3686: FROM pn_var_rent_dates_ALL dates
3687: WHERE dates.var_rent_id = p_var_rent_id);
3688:

Line 3743: FROM dual

3739: l_date := nvl(p_term_date,(to_date('01/01/1776','mm/dd/yyyy')));
3740:
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

Line 3800: FROM dual

3796: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_VOLHIST_EXIST (+)');
3797:
3798: SELECT 1
3799: INTO l_volhist_exist
3800: FROM dual
3801: WHERE EXISTS ( SELECT vol_hist_id
3802: FROM pn_var_vol_hist_ALL
3803: WHERE line_item_id = p_line_item_id
3804: );

Line 3856: FROM dual

3852: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_VOLHIST_APPROVED_EXIST (+)');
3853:
3854: SELECT 'Y'
3855: INTO l_volhist_approved_exist
3856: FROM dual
3857: WHERE EXISTS ( SELECT vol_hist_id
3858: FROM pn_var_vol_hist_all
3859: WHERE line_item_id = p_line_item_id
3860: AND grp_date_id = p_grp_date_id

Line 4017: FROM dual

4013: l_date := NVL(p_term_date,(TO_DATE('01/01/1776','mm/dd/yyyy')));
4014:
4015: SELECT 1
4016: INTO l_constr_exist
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

Line 4076: FROM dual

4072: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_ABAT_DEF_EXIST (+)');
4073:
4074: SELECT 1
4075: INTO l_abat_exist
4076: FROM dual
4077: WHERE EXISTS ( SELECT NULL
4078: FROM pn_var_abat_defaults_all
4079: WHERE var_rent_id = p_var_rent_id
4080: );

Line 4132: FROM dual

4128: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_CONSTR_DEF_EXIST (+)');
4129:
4130: SELECT 1
4131: INTO l_constr_exist
4132: FROM dual
4133: WHERE EXISTS ( SELECT NULL
4134: FROM pn_var_constr_defaults_all
4135: WHERE var_rent_id = p_var_rent_id
4136: );

Line 4184: FROM dual

4180: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_DEDUCT_EXIST (+)');
4181:
4182: SELECT 1
4183: INTO l_deduct_exist
4184: FROM dual
4185: WHERE EXISTS ( SELECT deduction_id
4186: FROM pn_var_deductions_ALL
4187: WHERE line_item_id = p_line_item_id
4188: );

Line 4677: FROM dual

4673: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_BKPTSHD_EXIST (+)');
4674:
4675: SELECT 1
4676: INTO l_bkptshd_exists
4677: FROM dual
4678: WHERE EXISTS ( SELECT head.bkpt_header_id
4679: FROM pn_var_bkpts_head_ALL head
4680: WHERE head.line_item_id = p_line_item_id);
4681:

Line 4728: FROM dual

4724: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_BKPTSDET_EXIST (+)');
4725:
4726: SELECT 1
4727: INTO l_bkptsdet_exist
4728: FROM dual
4729: WHERE EXISTS ( SELECT det.bkpt_detail_id
4730: FROM pn_var_bkpts_det_ALL det
4731: WHERE det.bkpt_header_id = p_bkpt_header_id);
4732:

Line 4798: FROM dual

4794: IF p_block IN('SUMMARY_FDR_BLK','VARENT_DATES_BLK') THEN
4795:
4796: SELECT 1
4797: INTO l_exported
4798: FROM dual
4799: WHERE EXISTS ( SELECT grp_date_id
4800: FROM pn_var_grp_dates_all
4801: WHERE var_rent_id = p_id
4802: AND (actual_exp_code = 'Y' OR

Line 4810: FROM dual

4806: ELSIF p_block IN('CONSTRAINTS_BLK') THEN
4807:
4808: SELECT 1
4809: INTO l_exported
4810: FROM dual
4811: WHERE EXISTS ( SELECT grp_date_id
4812: FROM pn_var_grp_dates_all
4813: WHERE period_id = p_id
4814: AND (actual_exp_code = 'Y' OR

Line 4822: FROM dual

4818: ELSIF p_block IN('LINE_ITEMS_BLK','BKPTS_HEADER_BLK','BKPTS_DETAIL_BLK','DEDUCTIONS_BLK') THEN
4819:
4820: SELECT 1
4821: INTO l_exported
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

Line 4836: FROM dual

4832: ELSIF p_block IN('LINE_DEFAULTS_BLK','BKHD_DEFAULTS_BLK','BKDT_DEFAULTS_BLK') THEN
4833: IF p_start_dt IS NULL OR p_end_dt IS NULL THEN
4834: SELECT 1
4835: INTO l_exported
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

Line 4849: FROM dual

4845:
4846: ELSE
4847: SELECT 1
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

Line 4870: FROM dual

4866: ELSIF p_block IN('VOL_HIST_BLK') THEN
4867:
4868: SELECT 1
4869: INTO l_exported
4870: FROM dual
4871: WHERE EXISTS ( SELECT vol_hist_id
4872: FROM pn_var_vol_hist_ALL
4873: WHERE vol_hist_id = p_id
4874: AND (actual_exp_code = 'Y' OR

Line 4882: FROM dual

4878: ELSIF p_block IN('PERIODS_INV_BLK') THEN -- Fix for bug # 2722191
4879:
4880: SELECT 1
4881: INTO l_exported
4882: FROM dual
4883: WHERE EXISTS ( SELECT VAR_RENT_INV_ID
4884: FROM pn_var_rent_inv_all
4885: WHERE var_rent_inv_id = p_id
4886: AND (actual_exp_code = 'Y' OR

Line 4939: FROM dual

4935: NULL;
4936: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_EXPORTED (+)');
4937: SELECT 1
4938: INTO l_exported
4939: FROM dual
4940: WHERE EXISTS ( SELECT vol_hist_id
4941: FROM pn_var_vol_hist_ALL
4942: WHERE vol_hist_id = p_id
4943: AND forecasted_exp_code = 'Y'

Line 4998: FROM dual

4994: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_STATUS (+)');
4995:
4996: SELECT 'COMPLETE'
4997: INTO l_status
4998: FROM dual
4999: WHERE NOT EXISTS
5000: (SELECT grp_date_id
5001: FROM pn_var_grp_dates_all
5002: WHERE period_id = p_period_id

Line 5027: FROM dual

5023: BEGIN
5024:
5025: SELECT 'RECONCILED'
5026: INTO l_status
5027: FROM dual
5028: WHERE NOT EXISTS(SELECT grp_date_id
5029: FROM pn_var_grp_dates_all
5030: WHERE period_id = p_period_id
5031: AND variance_exp_code = 'N')

Line 5083: FROM dual

5079: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_ADJUST_HIST_EXISTS (+)');
5080:
5081: SELECT 1
5082: INTO l_adjust_hist_exists
5083: FROM dual
5084: WHERE EXISTS(SELECT 1
5085: FROM pn_var_rent_inv_ALL inv1
5086: WHERE inv1.period_id = p_period_id
5087: AND (NVL(inv1.adjust_num,0) <> 0 OR

Line 5126: FROM DUAL

5122: p_period_id IN NUMBER ) RETURN VARCHAR2 IS
5123:
5124: CURSOR chk_term_cur IS
5125: SELECT 'Y' term_exists
5126: FROM DUAL
5127: WHERE EXISTS (SELECT NULL
5128: FROM pn_var_rent_inv_all INv,
5129: pn_payment_terms_all pt
5130: WHERE inv.var_rent_id = p_var_rent_id

Line 5284: FROM dual

5280: IF p_invoice_on = 'ACTUAL' THEN
5281:
5282: SELECT 1
5283: INTO l_vol_ready_for_adjust
5284: FROM dual
5285: WHERE EXISTS(SELECT vh.grp_date_id
5286: FROM pn_var_vol_hist_all vh
5287: WHERE actual_exp_code = 'N'
5288: AND period_id = p_period_id

Line 5298: FROM dual

5294: ELSIF p_invoice_on = 'FORECASTED' THEN
5295:
5296: SELECT 1
5297: INTO l_vol_ready_for_adjust
5298: FROM dual
5299: WHERE EXISTS(SELECT vh.grp_date_id
5300: FROM pn_var_vol_hist_all vh
5301: WHERE forecasted_exp_code = 'N'
5302: AND period_id = p_period_id

Line 7034: FROM DUAL

7030: l_default := 'N';
7031: BEGIN
7032: SELECT 'Y'
7033: INTO l_default
7034: FROM DUAL
7035: WHERE EXISTS (SELECT var_rent_id
7036: FROM pn_var_bkhd_defaults_all
7037: WHERE var_rent_id = main_vr_rec.var_rent_id);
7038: EXCEPTION

Line 7413: FROM DUAL

7409: IS
7410:
7411: CURSOR c_1 IS
7412: SELECT 'z'
7413: FROM DUAL
7414: WHERE EXISTS ( SELECT a.var_rent_id
7415: FROM pn_var_bkdt_defaults_all a,
7416: pn_var_bkhd_defaults_all b
7417: WHERE a.var_rent_id = p_var_rent_id

Line 7458: FROM dual

7454:
7455:
7456: CURSOR exist_next_header_date (p_end_date DATE) IS
7457: SELECT 'x'
7458: FROM dual
7459: WHERE EXISTS ( SELECT var_Rent_id
7460: FROM pn_var_bkhd_defaults_all
7461: WHERE var_rent_id = p_var_rent_id
7462: AND line_default_id = p_line_default_id

Line 7476: FROM dual

7472: ORDER BY bkdt_start_date;
7473:
7474: CURSOR exist_next_detail_date (p_header_id NUMBER,p_end_date DATE) IS
7475: SELECT 'x'
7476: FROM dual
7477: WHERE EXISTS ( SELECT var_Rent_id
7478: FROM pn_var_bkdt_defaults_all
7479: WHERE var_rent_id = p_var_rent_id
7480: AND bkhd_default_id = p_header_id

Line 7565: FROM dual

7561:
7562:
7563: CURSOR exist_next_header_date (p_end_date DATE) IS
7564: SELECT 'x'
7565: FROM dual
7566: WHERE EXISTS ( SELECT var_Rent_id
7567: FROM pn_var_bkpts_head_all
7568: WHERE var_rent_id = p_var_rent_id
7569: AND line_item_id = p_line_item_id

Line 7583: FROM dual

7579: ORDER BY bkpt_start_date;
7580:
7581: CURSOR exist_next_detail_date (p_header_id NUMBER,p_end_date DATE) IS
7582: SELECT 'x'
7583: FROM dual
7584: WHERE EXISTS ( SELECT var_Rent_id
7585: FROM pn_var_bkpts_det_all
7586: WHERE var_rent_id = p_var_rent_id
7587: AND bkpt_header_id = p_header_id

Line 7655: FROM dual

7651: IS
7652:
7653: CURSOR var_rent_cur IS
7654: SELECT 'x'
7655: FROM dual
7656: WHERE EXISTS ( SELECT var_rent_id
7657: FROM pn_var_rents_all
7658: WHERE agreement_template_id = p_template_id);
7659:

Line 7690: FROM dual

7686: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_BKPTS_SETUP_EXISTS (+)');
7687:
7688: /*SELECT 1
7689: INTO l_bkpts_exists
7690: FROM dual
7691: WHERE EXISTS ( SELECT 1
7692: FROM pn_var_transactions_all
7693: WHERE var_rent_id = p_var_rent_id);
7694:

Line 7784: FROM dual;

7780: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.DETERMINE_FREQUENCY (+)');
7781:
7782: SELECT X_VAR_RENT_END_DATE - X_VAR_RENT_START_DATE + 1
7783: INTO l_days
7784: FROM dual;
7785:
7786: IF l_days > 0 AND l_days <= 31 THEN
7787: l_freq_code := 'MON';
7788: ELSIF l_days > 31 AND l_days <= 92 THEN

Line 8342: FROM DUAL

8338:
8339:
8340: CURSOR bkpt_data_exists IS
8341: SELECT 'x' bkpt_exists
8342: FROM DUAL
8343: WHERE EXISTS (SELECT bkhd_default_id
8344: FROM pn_var_bkpts_head_all
8345: WHERE var_rent_id = p_var_rent_id
8346: AND bkhd_default_id IS NOT NULL);

Line 9113: FROM DUAL

9109: WHERE line_default_id = p_linedefid;
9110:
9111: CURSOR bkpt_data_exists IS
9112: SELECT 'x' bkpt_exists
9113: FROM DUAL
9114: WHERE EXISTS (SELECT bkhd_default_id
9115: FROM pn_var_bkpts_head_all
9116: WHERE var_rent_id = p_var_rent_id
9117: AND bkhd_default_id IS NOT NULL);

Line 9121: FROM DUAL

9117: AND bkhd_default_id IS NOT NULL);
9118:
9119: CURSOR constr_data_exists IS
9120: SELECT 'x'
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

Line 9889: FROM DUAL

9885:
9886: /* This returns Y if record exits in line or constraint defaults */
9887: CURSOR default_exists (p_var_rent_id NUMBER) IS
9888: SELECT 'Y'
9889: FROM DUAL
9890: WHERE EXISTS (SELECT var_rent_id
9891: FROM pn_var_line_defaults_all
9892: WHERE var_rent_id = p_var_rent_id)
9893: OR EXISTS (SELECT var_rent_id

Line 10603: FROM dual;

10599: IF (nvl(l_invalid_agr,'N') <> 'Y') THEN
10600:
10601: SELECT sysdate
10602: INTO l_date
10603: FROM dual;
10604:
10605: DELETE FROM PN_VAR_LINE_DEFAULTS_ALL
10606: WHERE var_rent_id = l_var_rent_id;
10607:

Line 10994: FROM dual

10990: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_INV_EXP (+)');
10991:
10992: SELECT 1
10993: INTO l_inv_exp
10994: FROM dual
10995: WHERE EXISTS ( SELECT inv.var_rent_inv_id
10996: FROM pn_var_rent_inv_all inv
10997: WHERE inv.var_rent_id = p_var_rent_id
10998: AND inv.invoice_date = p_invoice_date