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.ASO_APR_WF_PVT dependencies on ASO_APR_RULES

Line 2699: FROM aso_apr_rules

2695: CURSOR get_existing_rules (
2696: c_object_approval_id NUMBER
2697: ) IS
2698: SELECT oam_rule_id
2699: FROM aso_apr_rules
2700: WHERE object_approval_id = c_object_approval_id
2701: ORDER BY rule_id;
2702:
2703: CURSOR get_rule_count (

Line 2709: FROM aso_apr_rules

2705: ) IS
2706: SELECT COUNT (
2707: *
2708: )
2709: FROM aso_apr_rules
2710: WHERE object_approval_id = c_object_approval_id;
2711:
2712: cursor get_employee_id(l_user_id NUMBER) IS
2713: select employee_id

Line 3267: DELETE FROM aso_apr_rules

3263:
3264: IF l_rules_changed_flag = 'Y'
3265: THEN
3266: -- delete the existing rules
3267: DELETE FROM aso_apr_rules
3268: WHERE object_approval_id = p_object_approval_id;
3269:
3270: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3271: aso_debug_pub.ADD (

Line 4770: FROM aso_apr_rules

4766: CURSOR get_rule_details (
4767: c_approval_id NUMBER
4768: ) IS
4769: SELECT oam_rule_id
4770: FROM aso_apr_rules
4771: WHERE object_approval_id = c_approval_id;
4772: BEGIN
4773: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4774: aso_debug_pub.ADD (