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.OKL_SUBSIDY_POOL_RPT_PVT dependencies on WF_EVENT

Line 4: G_WF_EVT_POOL_NEAR_EXPIR CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.pool_nearing_expiration';

1: PACKAGE BODY okl_subsidy_pool_rpt_pvt AS
2: /* $Header: OKLRSIOB.pls 120.15 2007/01/09 12:37:08 udhenuko noship $ */
3:
4: G_WF_EVT_POOL_NEAR_EXPIR CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.pool_nearing_expiration';
5: G_WF_EVT_POOL_NEAR_BUDGLMT CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.pool_nearing_bdgt_limit';
6: G_WF_ITM_SUB_POOL_ID CONSTANT VARCHAR2(30) := 'SUBSIDY_POOL_ID';
7:
8: -------------------------------------------------------------------------------

Line 5: G_WF_EVT_POOL_NEAR_BUDGLMT CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.pool_nearing_bdgt_limit';

1: PACKAGE BODY okl_subsidy_pool_rpt_pvt AS
2: /* $Header: OKLRSIOB.pls 120.15 2007/01/09 12:37:08 udhenuko noship $ */
3:
4: G_WF_EVT_POOL_NEAR_EXPIR CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.pool_nearing_expiration';
5: G_WF_EVT_POOL_NEAR_BUDGLMT CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.pool_nearing_bdgt_limit';
6: G_WF_ITM_SUB_POOL_ID CONSTANT VARCHAR2(30) := 'SUBSIDY_POOL_ID';
7:
8: -------------------------------------------------------------------------------
9: -- PROCEDURE raise_business_event

Line 2430: l_event_name wf_events.name%TYPE;

2426: l_debug_enabled VARCHAR2(10);
2427: is_debug_procedure_on BOOLEAN;
2428: is_debug_statement_on BOOLEAN;
2429: l_parameter_list WF_PARAMETER_LIST_T;
2430: l_event_name wf_events.name%TYPE;
2431: l_api_version NUMBER;
2432: l_init_msg_list VARCHAR2(1);
2433: l_return_status VARCHAR2(1);
2434: l_msg_count NUMBER;

Line 2486: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, each_row.id, l_parameter_list);

2482:
2483: -- If p_percent parameter value is entered by user and other parameters value is nul.
2484: IF(p_percent is not null) THEN
2485: FOR each_row IN c_get_percent(p_percent) LOOP
2486: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, each_row.id, l_parameter_list);
2487: l_event_name := G_WF_EVT_POOL_NEAR_BUDGLMT;
2488: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
2489: GET_PROPER_LENGTH(each_row.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
2490: GET_PROPER_LENGTH(each_row.currency_code,l_Currency_Code_len,'DATA')||' '||

Line 2530: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, each_row.id, l_parameter_list);

2526: END LOOP;
2527: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
2528: ELSIF(p_remaining is not null) THEN
2529: FOR each_row IN c_get_budget(p_remaining,p_currency) LOOP
2530: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, each_row.id, l_parameter_list);
2531: l_event_name := G_WF_EVT_POOL_NEAR_BUDGLMT;
2532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
2533: GET_PROPER_LENGTH(each_row.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
2534: GET_PROPER_LENGTH(each_row.currency_code,l_Currency_Code_len,'DATA')||' '||

Line 2574: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, each_row.id, l_parameter_list);

2570: END LOOP;
2571: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
2572: ELSIF(p_date is not null) THEN
2573: FOR each_row IN c_get_dates(p_date) LOOP
2574: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, each_row.id, l_parameter_list);
2575: l_event_name := G_WF_EVT_POOL_NEAR_EXPIR;
2576: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
2577: GET_PROPER_LENGTH(each_row.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
2578: GET_PROPER_LENGTH(each_row.currency_code,l_Currency_Code_len,'DATA')||' '||

Line 2601: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, each_row.id, l_parameter_list);

2597: END LOOP;
2598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
2599: ELSIF(p_days is not null) THEN
2600: FOR each_row IN c_get_days(p_days) LOOP
2601: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, each_row.id, l_parameter_list);
2602: l_event_name := G_WF_EVT_POOL_NEAR_EXPIR;
2603: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
2604: GET_PROPER_LENGTH(each_row.subsidy_pool_name,l_Pool_Name_len,'DATA')||' '||
2605: GET_PROPER_LENGTH(each_row.currency_code,l_Currency_Code_len,'DATA')||' '||

Line 3430: l_event_name wf_events.name%TYPE;

3426: l_debug_enabled VARCHAR2(10);
3427: is_debug_procedure_on BOOLEAN;
3428: is_debug_statement_on BOOLEAN;
3429: l_parameter_list WF_PARAMETER_LIST_T;
3430: l_event_name wf_events.name%TYPE;
3431: l_api_version NUMBER;
3432: l_init_msg_list VARCHAR2(1);
3433: l_return_status VARCHAR2(1);
3434: l_msg_count NUMBER;

Line 3527: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, each_row.id, l_parameter_list);

3523:
3524: -- If p_percent parameter value is entered by user and other parameters value is null.
3525: IF(P_PERCENT is not null) THEN
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,

Line 3581: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, each_row.id, l_parameter_list);

3577: END IF;
3578: END LOOP;
3579: ELSIF(P_REMAINING is not null) THEN
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,

Line 3636: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, each_row.id, l_parameter_list);

3632: END LOOP;
3633: ELSIF(l_date is not null) THEN
3634: l_date:= FND_DATE.CANONICAL_TO_DATE(l_date);
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,

Line 3673: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, each_row.id, l_parameter_list);

3669: END IF;
3670: END LOOP;
3671: ELSIF(P_DAYS is not null) THEN
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,