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.AHL_APPROVALS_PVT dependencies on AHL_APPROVAL_RULES_V

Line 594: FROM Ahl_Approval_Rules_vl

590: CURSOR c_id_exists (x_id IN NUMBER) IS
591: SELECT 1
592: FROM dual
593: WHERE EXISTS (SELECT 1
594: FROM Ahl_Approval_Rules_vl
595: WHERE Approval_Rule_id = x_id);
596: CURSOR c_operating IS
597: SELECT ORGANIZATION_ID
598: FROM HR_OPERATING_UNITS

Line 1516: FROM Ahl_Approval_Rules_VL

1512:
1513: IS
1514: CURSOR c_Approval_Rules IS
1515: SELECT *
1516: FROM Ahl_Approval_Rules_VL
1517: WHERE Approval_Rule_id = p_Approval_Rule_id;
1518: --
1519: -- This is the only exception for using %ROWTYPE.
1520: -- We are selecting from the VL view, which may

Line 1916: FROM Ahl_Approval_Rules_v

1912: )
1913: IS
1914: CURSOR c_Approval_Rules IS
1915: SELECT *
1916: FROM Ahl_Approval_Rules_v
1917: WHERE Approval_Rule_id = p_Approval_Rules_rec.Approval_Rule_id;
1918: --
1919: -- This is the only exception for using %ROWTYPE.
1920: -- We are selecting from the VL view, which may

Line 1995: FROM Ahl_Approval_Rules_vl

1991: IF l_Approval_Rules_rec.active_end_Date IS NOT NULL THEN
1992:
1993: BEGIN
1994: SELECT 1 INTO l_count
1995: FROM Ahl_Approval_Rules_vl
1996: WHERE Approval_Rule_id = l_Approval_Rules_rec.Approval_Rule_id
1997: AND approval_rule_name = l_Approval_Rules_rec.approval_rule_name
1998: AND active_start_date = l_Approval_Rules_rec.active_start_date
1999: AND active_end_date = l_Approval_Rules_rec.active_end_Date

Line 2008: FROM Ahl_Approval_Rules_vl

2004: END;
2005: ELSE -- for end date
2006: BEGIN
2007: SELECT 1 INTO l_count
2008: FROM Ahl_Approval_Rules_vl
2009: WHERE Approval_Rule_id = l_Approval_Rules_rec.Approval_Rule_id
2010: AND approval_rule_name = l_Approval_Rules_rec.approval_rule_name
2011: AND active_start_date = l_Approval_Rules_rec.active_start_date
2012: AND status_code = l_Approval_Rules_rec.status_code;

Line 2021: FROM Ahl_Approval_Rules_vl

2017: END IF; -- for end date
2018: ELSE
2019: BEGIN
2020: SELECT 1 INTO l_count
2021: FROM Ahl_Approval_Rules_vl
2022: WHERE Approval_Rule_id = l_Approval_Rules_rec.Approval_Rule_id
2023: AND approval_rule_name = l_Approval_Rules_rec.approval_rule_name
2024: AND status_code = l_Approval_Rules_rec.status_code;
2025: EXCEPTION

Line 2164: 'Ahl_Approval_Rules_v',

2160: IF p_validation_mode = Jtf_Plsql_Api.g_create
2161: AND p_Approval_Rules_rec.Approval_Rule_id IS NOT NULL
2162: THEN
2163: IF Ahl_Utility_Pvt.check_uniqueness(
2164: 'Ahl_Approval_Rules_v',
2165: 'Approval_Rule_Id = ' || p_Approval_Rules_rec.Approval_Rule_id
2166: ) = Fnd_Api.g_false
2167: THEN
2168: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

Line 2180: 'Ahl_Approval_Rules_v',

2176:
2177: -- check if NAME is UNIQUE
2178: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
2179: l_valid_flag := Ahl_Utility_Pvt.Check_Uniqueness (
2180: 'Ahl_Approval_Rules_v',
2181: 'approval_rule_name = ''' || p_Approval_Rules_rec.approval_rule_name || ''''
2182: -- ''' AND language = ''' || p_Approval_Rules_rec.language || ''''
2183: );
2184: ELSE

Line 2186: 'Ahl_Approval_Rules_v',

2182: -- ''' AND language = ''' || p_Approval_Rules_rec.language || ''''
2183: );
2184: ELSE
2185: l_valid_flag := Ahl_Utility_Pvt.Check_Uniqueness (
2186: 'Ahl_Approval_Rules_v',
2187: 'approval_rule_name = ''' || p_Approval_Rules_rec.approval_rule_name ||
2188: -- ''' AND language = ''' || p_Approval_Rules_rec.language ||
2189: ''' AND approval_rule_id <> ' || p_Approval_Rules_rec.approval_rule_id
2190: );

Line 2231: 'Ahl_Approval_Rules_v',

2227: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
2228: -- For add approval uniqueness validations
2229: IF l_approval_priority_code IS NOT NULL AND l_OPERATING_UNIT_ID IS NOT NULL THEN
2230: l_valid_flag := Check_Rules_Uniqueness (
2231: 'Ahl_Approval_Rules_v',
2232: 'approval_object_code = ''' || p_Approval_Rules_rec.approval_object_code ||
2233: ''' AND approval_type_code = '''|| p_Approval_Rules_rec.approval_type_code ||
2234: ''' AND approval_priority_code = '''|| p_Approval_Rules_rec.approval_priority_code ||
2235: ''' AND operating_unit_id = ' || l_operating_unit_id ||

Line 2240: 'Ahl_Approval_Rules_vl',

2236: ' AND application_usg_code = ''' || p_Approval_Rules_rec.application_usg_code ||
2237: ''' AND active_start_date LIKE ''%' || p_Approval_Rules_rec.active_start_date || '%''', 'N' );
2238: ELSIF l_approval_priority_code IS NOT NULL AND l_OPERATING_UNIT_ID IS NULL THEN
2239: l_valid_flag := Check_Rules_Uniqueness (
2240: 'Ahl_Approval_Rules_vl',
2241: 'approval_object_code = ''' || p_Approval_Rules_rec.approval_object_code ||
2242: ''' AND approval_type_code = '''|| p_Approval_Rules_rec.approval_type_code ||
2243: ''' AND approval_priority_code = ''' || p_Approval_Rules_rec.approval_priority_code ||
2244: ''' AND application_usg_code = ''' || p_Approval_Rules_rec.application_usg_code ||

Line 2248: 'Ahl_Approval_Rules_v',

2244: ''' AND application_usg_code = ''' || p_Approval_Rules_rec.application_usg_code ||
2245: ''' AND active_start_date LIKE ''%' || p_Approval_Rules_rec.active_start_date || '%''', 'I' );
2246: ELSIF l_approval_priority_code IS NULL AND l_OPERATING_UNIT_ID IS NOT NULL THEN
2247: l_valid_flag := Check_Rules_Uniqueness (
2248: 'Ahl_Approval_Rules_v',
2249: 'approval_object_code = ''' || p_Approval_Rules_rec.approval_object_code ||
2250: ''' AND approval_type_code = '''|| p_Approval_Rules_rec.approval_type_code ||
2251: ''' AND operating_unit_id = ' || l_operating_unit_id ||
2252: ' AND application_usg_code = ''' || p_Approval_Rules_rec.application_usg_code ||

Line 2256: 'Ahl_Approval_Rules_v',

2252: ' AND application_usg_code = ''' || p_Approval_Rules_rec.application_usg_code ||
2253: ''' AND active_start_date LIKE ''%' || p_Approval_Rules_rec.active_start_date || '%''', 'C' );
2254: ELSE
2255: l_valid_flag := Check_Rules_Uniqueness (
2256: 'Ahl_Approval_Rules_v',
2257: 'approval_object_code = ''' || p_Approval_Rules_rec.approval_object_code ||
2258: ''' AND approval_type_code = '''|| p_Approval_Rules_rec.approval_type_code ||
2259: ''' AND application_usg_code = ''' || p_Approval_Rules_rec.application_usg_code ||
2260: ''' AND active_start_date LIKE ''%' || p_Approval_Rules_rec.active_start_date || '%''', 'B' );

Line 2279: 'Ahl_Approval_Rules_v',

2275: CLOSE c_appl_usg;
2276:
2277: IF l_approval_priority_code IS NOT NULL AND l_OPERATING_UNIT_ID IS NOT NULL THEN
2278: l_valid_flag := Check_Rules_Uniqueness (
2279: 'Ahl_Approval_Rules_v',
2280: 'approval_object_code = ''' || l_object ||
2281: ''' AND approval_type_code = '''|| l_type ||
2282: ''' AND approval_priority_code = '''|| p_Approval_Rules_rec.approval_priority_code ||
2283: ''' AND operating_unit_id = ' || l_operating_unit_id ||

Line 2290: 'Ahl_Approval_Rules_v',

2286: '%'' AND approval_rule_id <> ' || p_Approval_Rules_rec.approval_rule_id, 'N'
2287: );
2288: ELSIF l_approval_priority_code IS NOT NULL AND l_OPERATING_UNIT_ID IS NULL THEN
2289: l_valid_flag := Check_Rules_Uniqueness (
2290: 'Ahl_Approval_Rules_v',
2291: 'approval_object_code = ''' || l_object ||
2292: ''' AND approval_type_code = '''|| l_type ||
2293: ''' AND approval_priority_code = '''|| p_Approval_Rules_rec.approval_priority_code ||
2294: ''' AND application_usg_code = ''' || l_application_usg_code ||

Line 2300: 'Ahl_Approval_Rules_v',

2296: '%'' AND approval_rule_id <> ' || p_Approval_Rules_rec.approval_rule_id, 'I'
2297: );
2298: ELSIF l_approval_priority_code IS NULL AND l_OPERATING_UNIT_ID IS NOT NULL THEN
2299: l_valid_flag := Check_Rules_Uniqueness (
2300: 'Ahl_Approval_Rules_v',
2301: 'approval_object_code = ''' || l_object ||
2302: ''' AND approval_type_code = '''|| l_type ||
2303: ''' AND OPERATING_UNIT_ID = ' || l_operating_unit_id ||
2304: ' AND application_usg_code = ''' || l_application_usg_code ||

Line 2310: 'Ahl_Approval_Rules_v',

2306: '%'' AND approval_rule_id <> ' || p_Approval_Rules_rec.approval_rule_id, 'N'
2307: );
2308: ELSE
2309: l_valid_flag := Check_Rules_Uniqueness (
2310: 'Ahl_Approval_Rules_v',
2311: 'approval_object_code = ''' || l_object ||
2312: ''' AND approval_type_code = '''|| l_type ||
2313: ''' AND application_usg_code = ''' || l_application_usg_code ||
2314: ''' AND active_start_date LIKE ''%' || p_Approval_Rules_rec.active_start_date ||