DBA Data[Home] [Help]

APPS.PAY_AU_PROCESSES_API dependencies on PAY_AU_PROCESSES

Line 1: Package Body pay_au_processes_api as

1: Package Body pay_au_processes_api as
2: /* $Header: pyaprapi.pkb 120.0 2005/05/29 02:58 appldev noship $ */
3: --
4: -- Package Variables
5: --

Line 29: l_process_id pay_au_processes.process_id%TYPE;

25: --
26: --
27: -- Out variables
28: --
29: l_process_id pay_au_processes.process_id%TYPE;
30: l_object_version_number pay_au_processes.object_version_number%TYPE;
31: --
32: l_proc varchar2(72);
33: --

Line 30: l_object_version_number pay_au_processes.object_version_number%TYPE;

26: --
27: -- Out variables
28: --
29: l_process_id pay_au_processes.process_id%TYPE;
30: l_object_version_number pay_au_processes.object_version_number%TYPE;
31: --
32: l_proc varchar2(72);
33: --
34: -- Declare a cursor that will check whether the passed

Line 40: select process_id from pay_au_processes pap

36: -- name, business_group_id and legislation_code for a unique
37: -- combination
38: --
39: cursor csr_valid_combo is
40: select process_id from pay_au_processes pap
41: where pap.legislation_code = p_legislation_code
42: and (pap.business_group_id is null
43: or pap.business_group_id = p_business_group_id)
44: and (pap.short_name = p_short_name

Line 245: g_package := ' pay_au_processes_api.';

241: end update_au_process;
242: --
243: --
244: begin
245: g_package := ' pay_au_processes_api.';
246: end pay_au_processes_api;

Line 246: end pay_au_processes_api;

242: --
243: --
244: begin
245: g_package := ' pay_au_processes_api.';
246: end pay_au_processes_api;