APPS.OKL_SUBSIDY_POOL_RPT_PVT dependencies on OKL_G_REPORTS_GT

Line 3245: OKL_G_REPORTS_GT (VALUE1_TEXT,

3241: x_chld_pool_dtl_rec.total_budget := okl_accounting_util.format_amount(0,l_pool_rec.currency_code);
3242: x_chld_pool_dtl_rec.remaining_balance := okl_accounting_util.format_amount(0,l_pool_rec.currency_code);
3243: END IF;
3244: INSERT INTO
3245: OKL_G_REPORTS_GT (VALUE1_TEXT,
3246: VALUE2_TEXT,
3247: VALUE3_TEXT,
3248: VALUE4_TEXT,
3249: VALUE5_TEXT,

Line 3474: OKL_G_REPORTS_GT(VALUE1_TEXT,

3470: IF ( P_REMAINING is not null AND P_CURRENCY is null) THEN
3471: fnd_message.set_name( G_APP_NAME,
3472: 'OKL_SUBPOOL_CURR_REQ');
3473: INSERT INTO
3474: OKL_G_REPORTS_GT(VALUE1_TEXT,
3475: VALUE2_TEXT)
3476: VALUES
3477: ('ERROR',
3478: fnd_message.get

Line 3485: OKL_G_REPORTS_GT(VALUE1_TEXT,

3481: ELSIF ( P_REMAINING is null AND P_CURRENCY is not null) THEN
3482: fnd_message.set_name( G_APP_NAME,
3483: 'OKL_SUBPOOL_REM_BDGT');
3484: INSERT INTO
3485: OKL_G_REPORTS_GT(VALUE1_TEXT,
3486: VALUE2_TEXT)
3487: VALUES
3488: ('ERROR',
3489: fnd_message.get

Line 3496: OKL_G_REPORTS_GT(VALUE1_TEXT,

3492: ELSIF (P_PERCENT is not null AND P_PERCENT > 100)THEN
3493: fnd_message.set_name( G_APP_NAME,
3494: 'OKL_LLA_PERCENT');
3495: INSERT INTO
3496: OKL_G_REPORTS_GT(VALUE1_TEXT,
3497: VALUE2_TEXT)
3498: VALUES
3499: ('ERROR',
3500: fnd_message.get

Line 3516: OKL_G_REPORTS_GT(VALUE1_TEXT,

3512: (P_PERCENT is null AND P_REMAINING is null AND l_date is null AND P_DAYS is null AND P_CURRENCY is null)) THEN
3513: fnd_message.set_name( G_APP_NAME,
3514: 'OKL_SUBPOOL_ATLIMIT_PARAMS');
3515: INSERT INTO
3516: OKL_G_REPORTS_GT(VALUE1_TEXT,
3517: VALUE2_TEXT)
3518: VALUES
3519: ('ERROR',
3520: fnd_message.get

Line 3530: OKL_G_REPORTS_GT(VALUE1_TEXT,

3526: FOR each_row IN c_get_percent(P_PERCENT) LOOP
3527: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, each_row.id, l_parameter_list);
3528: l_event_name := G_WF_EVT_POOL_NEAR_BUDGLMT;
3529: INSERT INTO
3530: OKL_G_REPORTS_GT(VALUE1_TEXT,
3531: VALUE2_TEXT,
3532: VALUE3_TEXT,
3533: VALUE4_TEXT,
3534: VALUE5_TEXT,

Line 3584: OKL_G_REPORTS_GT(VALUE1_TEXT,

3580: FOR each_row IN c_get_budget(P_REMAINING,P_CURRENCY) LOOP
3581: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, each_row.id, l_parameter_list);
3582: l_event_name := G_WF_EVT_POOL_NEAR_BUDGLMT;
3583: INSERT INTO
3584: OKL_G_REPORTS_GT(VALUE1_TEXT,
3585: VALUE2_TEXT,
3586: VALUE3_TEXT,
3587: VALUE4_TEXT,
3588: VALUE5_TEXT,

Line 3639: OKL_G_REPORTS_GT(VALUE1_TEXT,

3635: FOR each_row IN c_get_dates(l_date) LOOP
3636: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, each_row.id, l_parameter_list);
3637: l_event_name := G_WF_EVT_POOL_NEAR_EXPIR;
3638: INSERT INTO
3639: OKL_G_REPORTS_GT(VALUE1_TEXT,
3640: VALUE2_TEXT,
3641: VALUE3_TEXT,
3642: VALUE4_TEXT,
3643: VALUE5_TEXT,

Line 3676: OKL_G_REPORTS_GT(VALUE1_TEXT,

3672: FOR each_row IN c_get_days(P_DAYS) LOOP
3673: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, each_row.id, l_parameter_list);
3674: l_event_name := G_WF_EVT_POOL_NEAR_EXPIR;
3675: INSERT INTO
3676: OKL_G_REPORTS_GT(VALUE1_TEXT,
3677: VALUE2_TEXT,
3678: VALUE3_TEXT,
3679: VALUE4_TEXT,
3680: VALUE5_TEXT,

Line 3867: OKL_G_REPORTS_GT(VALUE1_TEXT,

3863: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
3864:
3865: -- Insert the parent pool record into the Global Temporary Table
3866: INSERT INTO
3867: OKL_G_REPORTS_GT(VALUE1_TEXT,
3868: VALUE2_TEXT,
3869: VALUE3_TEXT,
3870: VALUE4_TEXT,
3871: VALUE5_TEXT,

Line 3912: OKL_G_REPORTS_GT(VALUE1_TEXT,

3908: l_trx_amt := l_trx_amt + l_amount;
3909: END LOOP;
3910: -- Insert the parent pool record into the Global Temporary Table
3911: INSERT INTO
3912: OKL_G_REPORTS_GT(VALUE1_TEXT,
3913: VALUE2_TEXT,
3914: VALUE3_TEXT,
3915: VALUE4_TEXT,
3916: VALUE5_TEXT,

Line 4098: OKL_G_REPORTS_GT(VALUE1_TEXT,

4094: END IF;
4095: -- Insert the transactions record for the subsidy pool type "Budget" in
4096: -- Global Temporary Table.
4097: INSERT INTO
4098: OKL_G_REPORTS_GT(VALUE1_TEXT,
4099: VALUE2_TEXT,
4100: VALUE3_TEXT,
4101: VALUE4_TEXT,
4102: VALUE5_TEXT,

Line 4173: OKL_G_REPORTS_GT(VALUE1_TEXT,

4169: END IF;
4170: -- Insert the transactions record for the subsidy pool in
4171: -- Global Temporary Table.
4172: INSERT INTO
4173: OKL_G_REPORTS_GT(VALUE1_TEXT,
4174: VALUE2_TEXT,
4175: VALUE3_TEXT,
4176: VALUE4_TEXT,
4177: VALUE5_TEXT,