DBA Data[Home] [Help]

APPS.PAY_IVL_BUS dependencies on PAY_IVL_BUS

Line 1: Package Body pay_ivl_bus as

1: Package Body pay_ivl_bus as
2: /* $Header: pyivlrhi.pkb 120.0.12010000.6 2009/07/30 12:03:21 npannamp ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' pay_ivl_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pay_ivl_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --

Line 123: if ( nvl(pay_ivl_bus.g_input_value_id, hr_api.g_number)

119: ,p_argument => 'input_value_id'
120: ,p_argument_value => p_input_value_id
121: );
122: --
123: if ( nvl(pay_ivl_bus.g_input_value_id, hr_api.g_number)
124:
125: = p_input_value_id) then
126: --
127: -- The legislation code has already been found with a previous

Line 131: l_legislation_code := pay_ivl_bus.g_legislation_code;

127: -- The legislation code has already been found with a previous
128: -- call to this function. Just return the value in the global
129: -- variable.
130: --
131: l_legislation_code := pay_ivl_bus.g_legislation_code;
132: hr_utility.set_location(l_proc, 20);
133: else
134: --
135: -- The ID is different to the last call to this function

Line 156: pay_ivl_bus.g_input_value_id := p_input_value_id;

152: -- Set the global variables so the values are
153: -- available for the next call to this function.
154: --
155: close csr_leg_code;
156: pay_ivl_bus.g_input_value_id := p_input_value_id;
157: pay_ivl_bus.g_legislation_code := l_legislation_code;
158: end if;
159: hr_utility.set_location(' Leaving:'|| l_proc, 40);
160: return l_legislation_code;

Line 157: pay_ivl_bus.g_legislation_code := l_legislation_code;

153: -- available for the next call to this function.
154: --
155: close csr_leg_code;
156: pay_ivl_bus.g_input_value_id := p_input_value_id;
157: pay_ivl_bus.g_legislation_code := l_legislation_code;
158: end if;
159: hr_utility.set_location(' Leaving:'|| l_proc, 40);
160: return l_legislation_code;
161: end return_legislation_code;

Line 1457: pay_ivl_bus.chk_default_value_format

1453: open csr_currency(p_element_type_id);
1454: fetch csr_currency into l_input_currency_code ;
1455: close csr_currency;
1456: --
1457: pay_ivl_bus.chk_default_value_format
1458: ( p_default_value
1459: ,p_lookup_type
1460: ,p_min_value
1461: ,p_max_value

Line 2133: pay_ivl_bus.chk_other_insert_val

2129: --
2130: hr_multi_message.end_validation_set;
2131: END IF;
2132: IF hr_startup_data_api_support.g_startup_mode NOT IN ('STARTUP') THEN
2133: pay_ivl_bus.chk_other_insert_val
2134: (p_element_type_id => p_rec.element_type_id
2135: ,p_formula_id => p_rec.formula_id
2136: ,p_lookup_type => p_rec.lookup_type
2137: ,p_value_set_id => p_rec.value_set_id

Line 2145: pay_ivl_bus.chk_lookup_type

2141: ,p_end_date => p_validation_end_date
2142: ,p_pay_basis_warning => p_pay_basis_warning
2143: );
2144:
2145: pay_ivl_bus.chk_lookup_type
2146: (p_lookup_type => p_rec.lookup_type
2147: ,p_uom => p_rec.uom
2148: ,p_effective_date => p_effective_date);
2149:

Line 2150: pay_ivl_bus.chk_formula_id

2146: (p_lookup_type => p_rec.lookup_type
2147: ,p_uom => p_rec.uom
2148: ,p_effective_date => p_effective_date);
2149:
2150: pay_ivl_bus.chk_formula_id
2151: ( p_business_group_id => p_rec.business_group_id
2152: ,p_legislation_code => p_rec.legislation_code
2153: ,p_effective_date => p_effective_date
2154: ,p_formula_id => p_rec.formula_id

Line 2157: pay_ivl_bus.chk_formula_validation

2153: ,p_effective_date => p_effective_date
2154: ,p_formula_id => p_rec.formula_id
2155: );
2156:
2157: pay_ivl_bus.chk_formula_validation
2158: ( p_default_value => p_rec.default_value
2159: ,p_warning_or_error => p_rec.warning_or_error
2160: ,p_effective_date => p_effective_date
2161: ,p_formula_id => p_rec.formula_id

Line 2168: pay_ivl_bus.chk_value_set_id (

2164: ,p_assignment_id_warning => p_assignment_id_warning
2165: ,p_formula_message => p_formula_message
2166: );
2167:
2168: pay_ivl_bus.chk_value_set_id (
2169: p_value_set_id => p_rec.value_set_id,
2170: p_uom => p_rec.uom
2171: );
2172:

Line 2173: pay_ivl_bus.chk_hot_default_flag

2169: p_value_set_id => p_rec.value_set_id,
2170: p_uom => p_rec.uom
2171: );
2172:
2173: pay_ivl_bus.chk_hot_default_flag
2174: (p_mandatory_flag => p_rec.mandatory_flag
2175: ,p_hot_default_flag => p_rec.hot_default_flag
2176: );
2177:

Line 2178: pay_ivl_bus.chk_name

2174: (p_mandatory_flag => p_rec.mandatory_flag
2175: ,p_hot_default_flag => p_rec.hot_default_flag
2176: );
2177:
2178: pay_ivl_bus.chk_name
2179: (p_name => p_rec.name
2180: ,p_element_type_id => p_rec.element_type_id
2181: ,p_uom => p_rec.uom
2182: );

Line 2184: pay_ivl_bus.chk_uom

2180: ,p_element_type_id => p_rec.element_type_id
2181: ,p_uom => p_rec.uom
2182: );
2183:
2184: pay_ivl_bus.chk_uom
2185: (p_element_type_id => p_rec.element_type_id
2186: ,p_uom => p_rec.uom
2187: ,p_effective_date => p_effective_date );
2188:

Line 2192: pay_ivl_bus.chk_max_min_value

2188:
2189: -- Bug 6164772. Changed the order of call to raise proper error message
2190: -- when check_format() errors from within
2191:
2192: pay_ivl_bus.chk_max_min_value
2193: (p_element_type_id => p_rec.element_type_id
2194: ,p_max_value => p_rec.max_value
2195: ,p_min_value => p_rec.min_value
2196: ,p_uom => p_rec.uom

Line 2202: pay_ivl_bus.chk_default_value

2198: ,p_lookup_type => p_rec.lookup_type
2199: ,p_min_max_warning => p_min_max_warning
2200: );
2201:
2202: pay_ivl_bus.chk_default_value
2203: ( p_element_type_id => p_rec.element_type_id
2204: ,p_default_value => p_rec.default_value
2205: ,p_lookup_type => p_rec.lookup_type
2206: ,p_value_set_id => p_rec.value_set_id

Line 2215: pay_ivl_bus.chk_warning_or_error

2211: ,p_effective_date => p_effective_date
2212: ,p_default_val_warning => p_default_val_warning
2213: );
2214:
2215: pay_ivl_bus.chk_warning_or_error
2216: (p_warning_or_error => p_rec.warning_or_error
2217: ,p_lookup_type => p_rec.lookup_type
2218: ,p_min_value => p_rec.min_value
2219: ,p_max_value => p_rec.max_value

Line 2283: pay_ivl_bus.chk_other_upd_val

2279: hr_multi_message.end_validation_set;
2280:
2281: END IF;
2282: IF hr_startup_data_api_support.g_startup_mode NOT IN ('STARTUP') THEN
2283: pay_ivl_bus.chk_other_upd_val
2284: (p_formula_id => p_rec.formula_id
2285: ,p_lookup_type => p_rec.lookup_type
2286: ,p_value_set_id => p_rec.value_set_id
2287: ,p_min_value => p_rec.min_value

Line 2290: pay_ivl_bus.chk_upd_generate_db_items_flag

2286: ,p_value_set_id => p_rec.value_set_id
2287: ,p_min_value => p_rec.min_value
2288: ,p_max_value => p_rec.max_value);
2289:
2290: pay_ivl_bus.chk_upd_generate_db_items_flag
2291: (p_datetrack_mode => p_datetrack_mode
2292: ,p_generate_db_items_flag => p_rec.generate_db_items_flag);
2293:
2294: pay_ivl_bus.chk_upd_name

Line 2294: pay_ivl_bus.chk_upd_name

2290: pay_ivl_bus.chk_upd_generate_db_items_flag
2291: (p_datetrack_mode => p_datetrack_mode
2292: ,p_generate_db_items_flag => p_rec.generate_db_items_flag);
2293:
2294: pay_ivl_bus.chk_upd_name
2295: (p_datetrack_mode => p_datetrack_mode
2296: ,p_name => p_rec.name
2297: ,p_effective_date => p_effective_date
2298: ,p_element_type_id => p_rec.element_type_id);

Line 2300: pay_ivl_bus.chk_upd_uom

2296: ,p_name => p_rec.name
2297: ,p_effective_date => p_effective_date
2298: ,p_element_type_id => p_rec.element_type_id);
2299:
2300: pay_ivl_bus.chk_upd_uom
2301: (p_datetrack_mode => p_datetrack_mode
2302: ,p_uom => p_rec.uom
2303: ,p_input_value_id => p_rec.input_value_id
2304: ,p_effective_date => p_effective_date);

Line 2306: pay_ivl_bus.chk_upd_def_value_null

2302: ,p_uom => p_rec.uom
2303: ,p_input_value_id => p_rec.input_value_id
2304: ,p_effective_date => p_effective_date);
2305:
2306: pay_ivl_bus.chk_upd_def_value_null
2307: (p_input_value_id => p_rec.input_value_id
2308: ,p_effective_date => p_effective_date
2309: ,p_default_value => p_rec.default_value
2310: ,p_pay_basis_warning => p_pay_basis_warning);

Line 2312: pay_ivl_bus.chk_upd_mand_flag

2308: ,p_effective_date => p_effective_date
2309: ,p_default_value => p_rec.default_value
2310: ,p_pay_basis_warning => p_pay_basis_warning);
2311:
2312: pay_ivl_bus.chk_upd_mand_flag
2313: (p_mandatory_flag => p_rec.mandatory_flag
2314: );
2315:
2316: pay_ivl_bus.chk_hot_default_flag

Line 2316: pay_ivl_bus.chk_hot_default_flag

2312: pay_ivl_bus.chk_upd_mand_flag
2313: (p_mandatory_flag => p_rec.mandatory_flag
2314: );
2315:
2316: pay_ivl_bus.chk_hot_default_flag
2317: (p_mandatory_flag => p_rec.mandatory_flag
2318: ,p_hot_default_flag => p_rec.hot_default_flag);
2319:
2320: pay_ivl_bus.chk_lookup_type

Line 2320: pay_ivl_bus.chk_lookup_type

2316: pay_ivl_bus.chk_hot_default_flag
2317: (p_mandatory_flag => p_rec.mandatory_flag
2318: ,p_hot_default_flag => p_rec.hot_default_flag);
2319:
2320: pay_ivl_bus.chk_lookup_type
2321: (p_lookup_type => p_rec.lookup_type
2322: ,p_uom => p_rec.uom
2323: ,p_effective_date => p_effective_date);
2324:

Line 2325: pay_ivl_bus.chk_formula_id

2321: (p_lookup_type => p_rec.lookup_type
2322: ,p_uom => p_rec.uom
2323: ,p_effective_date => p_effective_date);
2324:
2325: pay_ivl_bus.chk_formula_id
2326: ( p_business_group_id => p_rec.business_group_id
2327: ,p_legislation_code => p_rec.legislation_code
2328: ,p_effective_date => p_effective_date
2329: ,p_formula_id => p_rec.formula_id

Line 2332: pay_ivl_bus.chk_formula_validation

2328: ,p_effective_date => p_effective_date
2329: ,p_formula_id => p_rec.formula_id
2330: );
2331:
2332: pay_ivl_bus.chk_formula_validation
2333: ( p_default_value => p_rec.default_value
2334: ,p_warning_or_error => p_rec.warning_or_error
2335: ,p_effective_date => p_effective_date
2336: ,p_formula_id => p_rec.formula_id

Line 2343: pay_ivl_bus.chk_value_set_id (

2339: ,p_assignment_id_warning => p_assignment_id_warning
2340: ,p_formula_message => p_formula_message
2341: );
2342:
2343: pay_ivl_bus.chk_value_set_id (
2344: p_value_set_id => p_rec.value_set_id,
2345: p_uom => p_rec.uom
2346: );
2347:

Line 2348: pay_ivl_bus.chk_upd_display_sequence

2344: p_value_set_id => p_rec.value_set_id,
2345: p_uom => p_rec.uom
2346: );
2347:
2348: pay_ivl_bus.chk_upd_display_sequence
2349: (p_element_type_id => p_rec.element_type_id
2350: ,p_name => p_rec.name
2351: ,p_display_sequence => p_rec.display_sequence );
2352:

Line 2355: pay_ivl_bus.chk_max_min_value

2351: ,p_display_sequence => p_rec.display_sequence );
2352:
2353: -- Bug 6164772
2354:
2355: pay_ivl_bus.chk_max_min_value
2356: (p_element_type_id => p_rec.element_type_id
2357: ,p_max_value => p_rec.max_value
2358: ,p_min_value => p_rec.min_value
2359: ,p_uom => p_rec.uom

Line 2365: pay_ivl_bus.chk_default_value

2361: ,p_lookup_type => p_rec.lookup_type
2362: ,p_min_max_warning => p_min_max_warning
2363: );
2364:
2365: pay_ivl_bus.chk_default_value
2366: ( p_element_type_id => p_rec.element_type_id
2367: ,p_default_value => p_rec.default_value
2368: ,p_lookup_type => p_rec.lookup_type
2369: ,p_value_set_id => p_rec.value_set_id

Line 2378: pay_ivl_bus.chk_warning_or_error

2374: ,p_effective_date => p_effective_date
2375: ,p_default_val_warning => p_default_val_warning
2376: );
2377:
2378: pay_ivl_bus.chk_warning_or_error
2379: (p_warning_or_error => p_rec.warning_or_error
2380: ,p_lookup_type => p_rec.lookup_type
2381: ,p_min_value => p_rec.min_value
2382: ,p_max_value => p_rec.max_value

Line 2387: pay_ivl_bus.chk_raise_warning

2383: ,p_formula_id => p_rec.formula_id
2384: ,p_effective_date => p_effective_date
2385: );
2386:
2387: pay_ivl_bus.chk_raise_warning
2388: (p_lookup_type => p_rec.lookup_type
2389: ,p_name => p_rec.name
2390: ,p_default_value => p_rec.default_value
2391: ,p_min => p_rec.min_value

Line 2398: pay_ivl_bus.chk_upd_default_value

2394: ,p_link_inp_val_warning => p_link_inp_val_warning);
2395:
2396: /* Bug 6164772
2397: if p_rec.default_value <> hr_api.g_varchar2 then
2398: pay_ivl_bus.chk_upd_default_value
2399: ( p_default_value => p_rec.default_value
2400: ,p_lookup_type => p_rec.lookup_type
2401: ,p_value_set_id => p_rec.value_set_id
2402: ,p_min_value => p_rec.min_value

Line 2469: pay_ivl_bus.chk_delete_allowed

2465: hr_multi_message.end_validation_set;
2466:
2467: END IF;
2468:
2469: pay_ivl_bus.chk_delete_allowed
2470: (p_datetrack_mode => p_datetrack_mode
2471: ,p_input_value_id => p_rec.input_value_id
2472: ,p_element_type_id => p_rec.element_type_id
2473: ,p_effective_date => p_effective_date

Line 2491: end pay_ivl_bus;

2487: --
2488: hr_utility.set_location(' Leaving:'||l_proc, 10);
2489: End delete_validate;
2490: --
2491: end pay_ivl_bus;