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.AMS_WFCMPAPR_PVT dependencies on AMS_APPROVAL_RULES

Line 1559: FROM ams_approval_rules

1555: CURSOR c_appr_rule(l_appr_type VARCHAR2)
1556: IS
1557: SELECT mgr_approval_needed_flag ,
1558: parent_owner_approval_flag
1559: FROM ams_approval_rules
1560: WHERE arc_approval_for_object = p_obj_type
1561: AND approval_type = l_appr_type ;
1562:
1563: l_attr_rec c_attr_det%ROWTYPE;

Line 1652: -- If the Flags in AMS_APPROVAL_RULES are N we

1648: ELSIF l_ba_flag = 'Y' AND l_ta_flag = 'N' THEN
1649: x_appr_type := 'BUDGET' ;
1650:
1651: --Following Code is Added by PTENDULK on 28th Jan
1652: -- If the Flags in AMS_APPROVAL_RULES are N we
1653: -- Don't need Approvals
1654: OPEN c_appr_rule(x_appr_type) ;
1655: FETCH c_appr_rule INTO l_mgr_appr_flag,l_own_appr_flag ;
1656: CLOSE c_appr_rule ;

Line 1666: -- If the Flags in AMS_APPROVAL_RULES are N we

1662: END IF ;
1663: ELSIF l_ba_flag = 'N' AND l_ta_flag = 'Y' THEN
1664: x_appr_type := 'THEME' ;
1665: --Following Code is Added by PTENDULK on 28th Jan
1666: -- If the Flags in AMS_APPROVAL_RULES are N we
1667: -- Don't need Approvals
1668: OPEN c_appr_rule(x_appr_type) ;
1669: FETCH c_appr_rule INTO l_mgr_appr_flag,l_own_appr_flag ;
1670: CLOSE c_appr_rule ;

Line 1680: -- If the Flags in AMS_APPROVAL_RULES are N we

1676: END IF ;
1677: ELSIF l_ba_flag = 'Y' AND l_ta_flag = 'Y' THEN
1678: x_appr_type := 'BOTH' ;
1679: --Following Code is Added by PTENDULK on 28th Jan
1680: -- If the Flags in AMS_APPROVAL_RULES are N we
1681: -- Don't need Approvals
1682: OPEN c_appr_rule(x_appr_type) ;
1683: FETCH c_appr_rule INTO l_mgr_appr_flag,l_own_appr_flag ;
1684: CLOSE c_appr_rule ;

Line 1781: FROM ams_approval_rules

1777:
1778: CURSOR c_appr_check(l_appr_type VARCHAR) IS
1779: SELECT mgr_approval_needed_flag ,
1780: parent_owner_approval_flag
1781: FROM ams_approval_rules
1782: WHERE arc_approval_for_object = l_approval_for_object
1783: AND approval_type = l_appr_type ;
1784:
1785: l_own_appr_flag VARCHAR2(1);

Line 1966: -- Check the Flags in AMS_APPROVAL_RULES

1962: result := 'COMPLETE:ERROR' ;
1963: ELSE
1964:
1965: -- Now Check Which Aprovals are required .
1966: -- Check the Flags in AMS_APPROVAL_RULES
1967: -- Whether all Approvals are required.
1968: OPEN c_appr_check('BOTH') ;
1969: FETCH c_appr_check INTO l_man_appr_flag,l_own_appr_flag ;
1970: CLOSE c_appr_check ;

Line 2289: -- Check the Flags in AMS_APPROVAL_RULES

2285:
2286: result := 'COMPLETE:SUCCESS' ;
2287: ELSE
2288: -- Now Check Which Aprovals are required .
2289: -- Check the Flags in AMS_APPROVAL_RULES
2290: -- Whether all Approvals are required.
2291: OPEN c_appr_check('BUDGET') ;
2292: FETCH c_appr_check INTO l_man_appr_flag,l_own_appr_flag ;
2293: CLOSE c_appr_check ;

Line 2439: -- Check the Flags in AMS_APPROVAL_RULES

2435:
2436: result := 'COMPLETE:ERROR' ;
2437: ELSE
2438: -- Now Check Which Aprovals are required .
2439: -- Check the Flags in AMS_APPROVAL_RULES
2440: -- Whether all Approvals are required.
2441: OPEN c_appr_check('THEME') ;
2442: FETCH c_appr_check INTO l_man_appr_flag,l_own_appr_flag ;
2443: CLOSE c_appr_check ;

Line 2900: FROM ams_approval_rules

2896: SELECT timeout_days_low_prio,
2897: timeout_days_std_prio,
2898: timeout_days_high_prio,
2899: timeout_days_medium_prio
2900: FROM ams_approval_rules
2901: WHERE arc_approval_for_object = p_obj_type
2902: AND DECODE(approval_type,'BOTH','BUDGET',approval_type) = p_approval_type ;
2903: -- If the Approval type is Both then Use Priority and Timeout of Budget
2904: