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_COUNTERS_ACC_PKG dependencies on DBMS_SQL

Line 461: l_tab_resource_id dbms_sql.Number_Table;

457: , p_source_object_id IN NUMBER
458: , x_ctr_grp_id IN NUMBER
459: , x_object_version_number OUT NOCOPY NUMBER)
460: IS
461: l_tab_resource_id dbms_sql.Number_Table;
462: l_tab_access_id dbms_sql.Number_Table;
463: l_item_instance_id NUMBER;
464: BEGIN
465: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 462: l_tab_access_id dbms_sql.Number_Table;

458: , x_ctr_grp_id IN NUMBER
459: , x_object_version_number OUT NOCOPY NUMBER)
460: IS
461: l_tab_resource_id dbms_sql.Number_Table;
462: l_tab_access_id dbms_sql.Number_Table;
463: l_item_instance_id NUMBER;
464: BEGIN
465: x_return_status := FND_API.G_RET_STS_SUCCESS;
466: l_item_instance_id := Get_Parent_Item_Instance_Id(x_ctr_grp_id);

Line 510: l_tab_resource_id dbms_sql.Number_Table;

506: , p_object_version_number IN NUMBER
507: , p_cascade_upd_to_instances IN VARCHAR2
508: , x_object_version_number OUT NOCOPY NUMBER )
509: IS
510: l_tab_resource_id dbms_sql.Number_Table;
511: l_tab_access_id dbms_sql.Number_Table;
512: BEGIN
513: x_return_status := FND_API.G_RET_STS_SUCCESS;
514:

Line 511: l_tab_access_id dbms_sql.Number_Table;

507: , p_cascade_upd_to_instances IN VARCHAR2
508: , x_object_version_number OUT NOCOPY NUMBER )
509: IS
510: l_tab_resource_id dbms_sql.Number_Table;
511: l_tab_access_id dbms_sql.Number_Table;
512: BEGIN
513: x_return_status := FND_API.G_RET_STS_SUCCESS;
514:
515: IF p_ctr_grp_id IS NULL

Line 550: l_tab_resource_id dbms_sql.Number_Table;

546: PROCEDURE POST_DELETE_COUNTER_GROUP (
547: p_counter_group_id IN NUMBER
548: ,x_return_status out NOCOPY varchar2)
549: IS
550: l_tab_resource_id dbms_sql.Number_Table;
551: l_tab_access_id dbms_sql.Number_Table;
552: BEGIN
553: x_return_status := FND_API.G_RET_STS_SUCCESS;
554:

Line 551: l_tab_access_id dbms_sql.Number_Table;

547: p_counter_group_id IN NUMBER
548: ,x_return_status out NOCOPY varchar2)
549: IS
550: l_tab_resource_id dbms_sql.Number_Table;
551: l_tab_access_id dbms_sql.Number_Table;
552: BEGIN
553: x_return_status := FND_API.G_RET_STS_SUCCESS;
554:
555: IF p_counter_group_id IS NULL

Line 595: l_tab_resource_id dbms_sql.Number_Table;

591: , X_Msg_Data OUT NOCOPY VARCHAR2
592: , x_ctr_id IN NUMBER
593: , x_object_version_number OUT NOCOPY NUMBER)
594: IS
595: l_tab_resource_id dbms_sql.Number_Table;
596: l_tab_access_id dbms_sql.Number_Table;
597: l_counter_group_id NUMBER;
598: BEGIN
599: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 596: l_tab_access_id dbms_sql.Number_Table;

592: , x_ctr_id IN NUMBER
593: , x_object_version_number OUT NOCOPY NUMBER)
594: IS
595: l_tab_resource_id dbms_sql.Number_Table;
596: l_tab_access_id dbms_sql.Number_Table;
597: l_counter_group_id NUMBER;
598: BEGIN
599: x_return_status := FND_API.G_RET_STS_SUCCESS;
600: l_counter_group_id := Get_Parent_Ctr_Grp_Id(x_ctr_id);

Line 642: l_tab_resource_id dbms_sql.Number_Table;

638: , p_object_version_number IN NUMBER
639: , p_cascade_upd_to_instances IN VARCHAR2
640: , x_object_version_number OUT NOCOPY NUMBER )
641: IS
642: l_tab_resource_id dbms_sql.Number_Table;
643: l_tab_access_id dbms_sql.Number_Table;
644: BEGIN
645: x_return_status := FND_API.G_RET_STS_SUCCESS;
646:

Line 643: l_tab_access_id dbms_sql.Number_Table;

639: , p_cascade_upd_to_instances IN VARCHAR2
640: , x_object_version_number OUT NOCOPY NUMBER )
641: IS
642: l_tab_resource_id dbms_sql.Number_Table;
643: l_tab_access_id dbms_sql.Number_Table;
644: BEGIN
645: x_return_status := FND_API.G_RET_STS_SUCCESS;
646:
647: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

Line 682: l_tab_resource_id dbms_sql.Number_Table;

678: PROCEDURE POST_DELETE_COUNTER (
679: p_counter_id IN NUMBER
680: ,x_return_status out NOCOPY varchar2)
681: IS
682: l_tab_resource_id dbms_sql.Number_Table;
683: l_tab_access_id dbms_sql.Number_Table;
684: BEGIN
685: x_return_status := FND_API.G_RET_STS_SUCCESS;
686:

Line 683: l_tab_access_id dbms_sql.Number_Table;

679: p_counter_id IN NUMBER
680: ,x_return_status out NOCOPY varchar2)
681: IS
682: l_tab_resource_id dbms_sql.Number_Table;
683: l_tab_access_id dbms_sql.Number_Table;
684: BEGIN
685: x_return_status := FND_API.G_RET_STS_SUCCESS;
686:
687: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

Line 722: l_tab_resource_id dbms_sql.Number_Table;

718: , X_Msg_Data OUT NOCOPY VARCHAR2
719: , x_ctr_prop_id IN NUMBER
720: , x_object_version_number OUT NOCOPY NUMBER )
721: IS
722: l_tab_resource_id dbms_sql.Number_Table;
723: l_tab_access_id dbms_sql.Number_Table;
724: l_counter_id NUMBER;
725: BEGIN
726: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 723: l_tab_access_id dbms_sql.Number_Table;

719: , x_ctr_prop_id IN NUMBER
720: , x_object_version_number OUT NOCOPY NUMBER )
721: IS
722: l_tab_resource_id dbms_sql.Number_Table;
723: l_tab_access_id dbms_sql.Number_Table;
724: l_counter_id NUMBER;
725: BEGIN
726: x_return_status := FND_API.G_RET_STS_SUCCESS;
727:

Line 771: l_tab_resource_id dbms_sql.Number_Table;

767: , p_object_version_number IN NUMBER
768: , p_cascade_upd_to_instances IN VARCHAR2
769: , x_object_version_number OUT NOCOPY NUMBER )
770: IS
771: l_tab_resource_id dbms_sql.Number_Table;
772: l_tab_access_id dbms_sql.Number_Table;
773: BEGIN
774: x_return_status := FND_API.G_RET_STS_SUCCESS;
775:

Line 772: l_tab_access_id dbms_sql.Number_Table;

768: , p_cascade_upd_to_instances IN VARCHAR2
769: , x_object_version_number OUT NOCOPY NUMBER )
770: IS
771: l_tab_resource_id dbms_sql.Number_Table;
772: l_tab_access_id dbms_sql.Number_Table;
773: BEGIN
774: x_return_status := FND_API.G_RET_STS_SUCCESS;
775:
776: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

Line 811: l_tab_resource_id dbms_sql.Number_Table;

807: PROCEDURE POST_DELETE_COUNTER_PROPERTY (
808: p_counter_prop_id IN NUMBER
809: ,x_return_status out NOCOPY varchar2)
810: IS
811: l_tab_resource_id dbms_sql.Number_Table;
812: l_tab_access_id dbms_sql.Number_Table;
813: BEGIN
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815:

Line 812: l_tab_access_id dbms_sql.Number_Table;

808: p_counter_prop_id IN NUMBER
809: ,x_return_status out NOCOPY varchar2)
810: IS
811: l_tab_resource_id dbms_sql.Number_Table;
812: l_tab_access_id dbms_sql.Number_Table;
813: BEGIN
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815:
816: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List