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.CSL_CS_COUNTER_VALS_ACC_PKG dependencies on DBMS_SQL

Line 317: l_tab_resource_id dbms_sql.Number_Table;

313: , X_Return_Status OUT NOCOPY VARCHAR2
314: , X_Msg_Count OUT NOCOPY NUMBER
315: , X_Msg_Data OUT NOCOPY VARCHAR2 )
316: IS
317: l_tab_resource_id dbms_sql.Number_Table;
318: l_tab_access_id dbms_sql.Number_Table;
319: l_counter_id NUMBER;
320:
321: CURSOR c_ctr_vals( b_grp_log_id NUMBER ) IS

Line 318: l_tab_access_id dbms_sql.Number_Table;

314: , X_Msg_Count OUT NOCOPY NUMBER
315: , X_Msg_Data OUT NOCOPY VARCHAR2 )
316: IS
317: l_tab_resource_id dbms_sql.Number_Table;
318: l_tab_access_id dbms_sql.Number_Table;
319: l_counter_id NUMBER;
320:
321: CURSOR c_ctr_vals( b_grp_log_id NUMBER ) IS
322: SELECT *

Line 378: l_tab_resource_id dbms_sql.Number_Table;

374: , X_Return_Status OUT NOCOPY VARCHAR2
375: , X_Msg_Count OUT NOCOPY NUMBER
376: , X_Msg_Data OUT NOCOPY VARCHAR2 )
377: IS
378: l_tab_resource_id dbms_sql.Number_Table;
379: l_tab_access_id dbms_sql.Number_Table;
380: CURSOR c_ctr_vals( b_grp_log_id NUMBER ) IS
381: SELECT *
382: FROM CS_COUNTER_VALUES

Line 379: l_tab_access_id dbms_sql.Number_Table;

375: , X_Msg_Count OUT NOCOPY NUMBER
376: , X_Msg_Data OUT NOCOPY VARCHAR2 )
377: IS
378: l_tab_resource_id dbms_sql.Number_Table;
379: l_tab_access_id dbms_sql.Number_Table;
380: CURSOR c_ctr_vals( b_grp_log_id NUMBER ) IS
381: SELECT *
382: FROM CS_COUNTER_VALUES
383: WHERE COUNTER_GRP_LOG_ID = b_grp_log_id;

Line 425: l_tab_resource_id dbms_sql.Number_Table;

421: PROCEDURE POST_DELETE_COUNTER_VALUE (
422: p_counter_value_id in NUMBER
423: ,x_return_status OUT NOCOPY varchar2)
424: IS
425: l_tab_resource_id dbms_sql.Number_Table;
426: l_tab_access_id dbms_sql.Number_Table;
427: BEGIN
428: x_return_status := FND_API.G_RET_STS_SUCCESS;
429:

Line 426: l_tab_access_id dbms_sql.Number_Table;

422: p_counter_value_id in NUMBER
423: ,x_return_status OUT NOCOPY varchar2)
424: IS
425: l_tab_resource_id dbms_sql.Number_Table;
426: l_tab_access_id dbms_sql.Number_Table;
427: BEGIN
428: x_return_status := FND_API.G_RET_STS_SUCCESS;
429:
430: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

Line 477: l_tab_resource_id dbms_sql.Number_Table;

473: , X_Return_Status OUT NOCOPY VARCHAR2
474: , X_Msg_Count OUT NOCOPY NUMBER
475: , X_Msg_Data OUT NOCOPY VARCHAR2 )
476: IS
477: l_tab_resource_id dbms_sql.Number_Table;
478: l_tab_access_id dbms_sql.Number_Table;
479:
480: CURSOR c_ctr_prop_val ( b_ctr_grp_log_id NUMBER ) IS
481: SELECT CPV.COUNTER_PROP_VALUE_ID

Line 478: l_tab_access_id dbms_sql.Number_Table;

474: , X_Msg_Count OUT NOCOPY NUMBER
475: , X_Msg_Data OUT NOCOPY VARCHAR2 )
476: IS
477: l_tab_resource_id dbms_sql.Number_Table;
478: l_tab_access_id dbms_sql.Number_Table;
479:
480: CURSOR c_ctr_prop_val ( b_ctr_grp_log_id NUMBER ) IS
481: SELECT CPV.COUNTER_PROP_VALUE_ID
482: , CPV.COUNTER_VALUE_ID

Line 532: l_tab_resource_id dbms_sql.Number_Table;

528: , X_Return_Status OUT NOCOPY VARCHAR2
529: , X_Msg_Count OUT NOCOPY NUMBER
530: , X_Msg_Data OUT NOCOPY VARCHAR2 )
531: IS
532: l_tab_resource_id dbms_sql.Number_Table;
533: l_tab_access_id dbms_sql.Number_Table;
534:
535: CURSOR c_ctr_prop_val ( b_ctr_grp_log_id NUMBER ) IS
536: SELECT CPV.COUNTER_PROP_VALUE_ID

Line 533: l_tab_access_id dbms_sql.Number_Table;

529: , X_Msg_Count OUT NOCOPY NUMBER
530: , X_Msg_Data OUT NOCOPY VARCHAR2 )
531: IS
532: l_tab_resource_id dbms_sql.Number_Table;
533: l_tab_access_id dbms_sql.Number_Table;
534:
535: CURSOR c_ctr_prop_val ( b_ctr_grp_log_id NUMBER ) IS
536: SELECT CPV.COUNTER_PROP_VALUE_ID
537: , CPV.COUNTER_VALUE_ID

Line 583: l_tab_resource_id dbms_sql.Number_Table;

579: PROCEDURE POST_DELETE_COUNTER_PROP_VAL (
580: p_counter_prop_val_id in NUMBER
581: ,x_return_status OUT NOCOPY varchar2)
582: IS
583: l_tab_resource_id dbms_sql.Number_Table;
584: l_tab_access_id dbms_sql.Number_Table;
585: BEGIN
586: x_return_status := FND_API.G_RET_STS_SUCCESS;
587:

Line 584: l_tab_access_id dbms_sql.Number_Table;

580: p_counter_prop_val_id in NUMBER
581: ,x_return_status OUT NOCOPY varchar2)
582: IS
583: l_tab_resource_id dbms_sql.Number_Table;
584: l_tab_access_id dbms_sql.Number_Table;
585: BEGIN
586: x_return_status := FND_API.G_RET_STS_SUCCESS;
587:
588: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List