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 3378: FROM dual

3374: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_PERIOD_EXISTS (+)');
3375:
3376: SELECT 1
3377: INTO l_period_exists
3378: FROM dual
3379: WHERE EXISTS ( SELECT periods.period_id
3380: FROM pn_var_periods_ALL periods
3381: WHERE periods.var_rent_id = p_var_rent_id);
3382:

Line 3430: FROM dual

3426: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_CALCULATION_EXISTS (+)');
3427:
3428: SELECT 1
3429: INTO l_calculation_exists
3430: FROM dual
3431: WHERE EXISTS ( SELECT inv.var_rent_inv_id
3432: FROM pn_var_rent_inv_all inv
3433: WHERE inv.var_rent_id = p_var_rent_id);
3434:

Line 3481: FROM dual

3477: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_INVOICE_EXISTS (+)');
3478:
3479: SELECT 1
3480: INTO l_invoice_exists
3481: FROM dual
3482: WHERE EXISTS ( SELECT inv.var_rent_inv_id
3483: FROM pn_var_rent_inv_all inv
3484: WHERE inv.var_rent_id = p_var_rent_id);
3485:

Line 3680: FROM dual

3676: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_VRDATES_EXISTS (+)');
3677:
3678: SELECT 1
3679: INTO l_vrdates_exists
3680: FROM dual
3681: WHERE EXISTS ( SELECT dates.var_rent_date_id
3682: FROM pn_var_rent_dates_ALL dates
3683: WHERE dates.var_rent_id = p_var_rent_id);
3684:

Line 3739: FROM dual

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

Line 3796: FROM dual

3792: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_VOLHIST_EXIST (+)');
3793:
3794: SELECT 1
3795: INTO l_volhist_exist
3796: FROM dual
3797: WHERE EXISTS ( SELECT vol_hist_id
3798: FROM pn_var_vol_hist_ALL
3799: WHERE line_item_id = p_line_item_id
3800: );

Line 3852: FROM dual

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

Line 4013: FROM dual

4009: l_date := NVL(p_term_date,(TO_DATE('01/01/1776','mm/dd/yyyy')));
4010:
4011: SELECT 1
4012: INTO l_constr_exist
4013: FROM dual
4014: WHERE EXISTS ( SELECT constraint_id
4015: FROM pn_var_constraints_ALL
4016: WHERE period_id IN (SELECT period_id
4017: FROM PN_VAR_PERIODS_ALL

Line 4072: FROM dual

4068: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_ABAT_DEF_EXIST (+)');
4069:
4070: SELECT 1
4071: INTO l_abat_exist
4072: FROM dual
4073: WHERE EXISTS ( SELECT NULL
4074: FROM pn_var_abat_defaults_all
4075: WHERE var_rent_id = p_var_rent_id
4076: );

Line 4128: FROM dual

4124: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_CONSTR_DEF_EXIST (+)');
4125:
4126: SELECT 1
4127: INTO l_constr_exist
4128: FROM dual
4129: WHERE EXISTS ( SELECT NULL
4130: FROM pn_var_constr_defaults_all
4131: WHERE var_rent_id = p_var_rent_id
4132: );

Line 4180: FROM dual

4176: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_DEDUCT_EXIST (+)');
4177:
4178: SELECT 1
4179: INTO l_deduct_exist
4180: FROM dual
4181: WHERE EXISTS ( SELECT deduction_id
4182: FROM pn_var_deductions_ALL
4183: WHERE line_item_id = p_line_item_id
4184: );

Line 4673: FROM dual

4669: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_BKPTSHD_EXIST (+)');
4670:
4671: SELECT 1
4672: INTO l_bkptshd_exists
4673: FROM dual
4674: WHERE EXISTS ( SELECT head.bkpt_header_id
4675: FROM pn_var_bkpts_head_ALL head
4676: WHERE head.line_item_id = p_line_item_id);
4677:

Line 4724: FROM dual

4720: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_BKPTSDET_EXIST (+)');
4721:
4722: SELECT 1
4723: INTO l_bkptsdet_exist
4724: FROM dual
4725: WHERE EXISTS ( SELECT det.bkpt_detail_id
4726: FROM pn_var_bkpts_det_ALL det
4727: WHERE det.bkpt_header_id = p_bkpt_header_id);
4728:

Line 4794: FROM dual

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

Line 4806: FROM dual

4802: ELSIF p_block IN('CONSTRAINTS_BLK') THEN
4803:
4804: SELECT 1
4805: INTO l_exported
4806: FROM dual
4807: WHERE EXISTS ( SELECT grp_date_id
4808: FROM pn_var_grp_dates_all
4809: WHERE period_id = p_id
4810: AND (actual_exp_code = 'Y' OR

Line 4818: FROM dual

4814: ELSIF p_block IN('LINE_ITEMS_BLK','BKPTS_HEADER_BLK','BKPTS_DETAIL_BLK','DEDUCTIONS_BLK') THEN
4815:
4816: SELECT 1
4817: INTO l_exported
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

Line 4832: FROM dual

4828: ELSIF p_block IN('LINE_DEFAULTS_BLK','BKHD_DEFAULTS_BLK','BKDT_DEFAULTS_BLK') THEN
4829: IF p_start_dt IS NULL OR p_end_dt IS NULL THEN
4830: SELECT 1
4831: INTO l_exported
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

Line 4845: FROM dual

4841:
4842: ELSE
4843: SELECT 1
4844: INTO l_exported
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

Line 4866: FROM dual

4862: ELSIF p_block IN('VOL_HIST_BLK') THEN
4863:
4864: SELECT 1
4865: INTO l_exported
4866: FROM dual
4867: WHERE EXISTS ( SELECT vol_hist_id
4868: FROM pn_var_vol_hist_ALL
4869: WHERE vol_hist_id = p_id
4870: AND (actual_exp_code = 'Y' OR

Line 4878: FROM dual

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

Line 4935: FROM dual

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

Line 4994: FROM dual

4990: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_STATUS (+)');
4991:
4992: SELECT 'COMPLETE'
4993: INTO l_status
4994: FROM dual
4995: WHERE NOT EXISTS
4996: (SELECT grp_date_id
4997: FROM pn_var_grp_dates_all
4998: WHERE period_id = p_period_id

Line 5023: FROM dual

5019: BEGIN
5020:
5021: SELECT 'RECONCILED'
5022: INTO l_status
5023: FROM dual
5024: WHERE NOT EXISTS(SELECT grp_date_id
5025: FROM pn_var_grp_dates_all
5026: WHERE period_id = p_period_id
5027: AND variance_exp_code = 'N')

Line 5079: FROM dual

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

Line 5122: FROM DUAL

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

Line 5280: FROM dual

5276: IF p_invoice_on = 'ACTUAL' THEN
5277:
5278: SELECT 1
5279: INTO l_vol_ready_for_adjust
5280: FROM dual
5281: WHERE EXISTS(SELECT vh.grp_date_id
5282: FROM pn_var_vol_hist_all vh
5283: WHERE actual_exp_code = 'N'
5284: AND period_id = p_period_id

Line 5294: FROM dual

5290: ELSIF p_invoice_on = 'FORECASTED' THEN
5291:
5292: SELECT 1
5293: INTO l_vol_ready_for_adjust
5294: FROM dual
5295: WHERE EXISTS(SELECT vh.grp_date_id
5296: FROM pn_var_vol_hist_all vh
5297: WHERE forecasted_exp_code = 'N'
5298: AND period_id = p_period_id

Line 7030: FROM DUAL

7026: l_default := 'N';
7027: BEGIN
7028: SELECT 'Y'
7029: INTO l_default
7030: FROM DUAL
7031: WHERE EXISTS (SELECT var_rent_id
7032: FROM pn_var_bkhd_defaults_all
7033: WHERE var_rent_id = main_vr_rec.var_rent_id);
7034: EXCEPTION

Line 7409: FROM DUAL

7405: IS
7406:
7407: CURSOR c_1 IS
7408: SELECT 'z'
7409: FROM DUAL
7410: WHERE EXISTS ( SELECT a.var_rent_id
7411: FROM pn_var_bkdt_defaults_all a,
7412: pn_var_bkhd_defaults_all b
7413: WHERE a.var_rent_id = p_var_rent_id

Line 7454: FROM dual

7450:
7451:
7452: CURSOR exist_next_header_date (p_end_date DATE) IS
7453: SELECT 'x'
7454: FROM dual
7455: WHERE EXISTS ( SELECT var_Rent_id
7456: FROM pn_var_bkhd_defaults_all
7457: WHERE var_rent_id = p_var_rent_id
7458: AND line_default_id = p_line_default_id

Line 7472: FROM dual

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

Line 7561: FROM dual

7557:
7558:
7559: CURSOR exist_next_header_date (p_end_date DATE) IS
7560: SELECT 'x'
7561: FROM dual
7562: WHERE EXISTS ( SELECT var_Rent_id
7563: FROM pn_var_bkpts_head_all
7564: WHERE var_rent_id = p_var_rent_id
7565: AND line_item_id = p_line_item_id

Line 7579: FROM dual

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

Line 7651: FROM dual

7647: IS
7648:
7649: CURSOR var_rent_cur IS
7650: SELECT 'x'
7651: FROM dual
7652: WHERE EXISTS ( SELECT var_rent_id
7653: FROM pn_var_rents_all
7654: WHERE agreement_template_id = p_template_id);
7655:

Line 7686: FROM dual

7682: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_BKPTS_SETUP_EXISTS (+)');
7683:
7684: /*SELECT 1
7685: INTO l_bkpts_exists
7686: FROM dual
7687: WHERE EXISTS ( SELECT 1
7688: FROM pn_var_transactions_all
7689: WHERE var_rent_id = p_var_rent_id);
7690:

Line 7780: FROM dual;

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

Line 8332: FROM DUAL

8328:
8329:
8330: CURSOR bkpt_data_exists IS
8331: SELECT 'x' bkpt_exists
8332: FROM DUAL
8333: WHERE EXISTS (SELECT bkhd_default_id
8334: FROM pn_var_bkpts_head_all
8335: WHERE var_rent_id = p_var_rent_id
8336: AND bkhd_default_id IS NOT NULL);

Line 9096: FROM DUAL

9092: WHERE line_default_id = p_linedefid;
9093:
9094: CURSOR bkpt_data_exists IS
9095: SELECT 'x' bkpt_exists
9096: FROM DUAL
9097: WHERE EXISTS (SELECT bkhd_default_id
9098: FROM pn_var_bkpts_head_all
9099: WHERE var_rent_id = p_var_rent_id
9100: AND bkhd_default_id IS NOT NULL);

Line 9104: FROM DUAL

9100: AND bkhd_default_id IS NOT NULL);
9101:
9102: CURSOR constr_data_exists IS
9103: SELECT 'x'
9104: FROM DUAL
9105: WHERE EXISTS (SELECT constraint_id
9106: FROM pn_var_constraints_all
9107: WHERE period_id IN (SELECT PERIOD_ID
9108: FROM pn_var_periods_all

Line 9872: FROM DUAL

9868:
9869: /* This returns Y if record exits in line or constraint defaults */
9870: CURSOR default_exists (p_var_rent_id NUMBER) IS
9871: SELECT 'Y'
9872: FROM DUAL
9873: WHERE EXISTS (SELECT var_rent_id
9874: FROM pn_var_line_defaults_all
9875: WHERE var_rent_id = p_var_rent_id)
9876: OR EXISTS (SELECT var_rent_id

Line 10586: FROM dual;

10582: IF (nvl(l_invalid_agr,'N') <> 'Y') THEN
10583:
10584: SELECT sysdate
10585: INTO l_date
10586: FROM dual;
10587:
10588: DELETE FROM PN_VAR_LINE_DEFAULTS_ALL
10589: WHERE var_rent_id = l_var_rent_id;
10590:

Line 10977: FROM dual

10973: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.FIND_IF_INV_EXP (+)');
10974:
10975: SELECT 1
10976: INTO l_inv_exp
10977: FROM dual
10978: WHERE EXISTS ( SELECT inv.var_rent_inv_id
10979: FROM pn_var_rent_inv_all inv
10980: WHERE inv.var_rent_id = p_var_rent_id
10981: AND inv.invoice_date = p_invoice_date