DBA Data[Home] [Help]

APPS.HR_STARTUP_DATA_API_SUPPORT dependencies on HR_STARTUP_DATA_API_SUPPORT

Line 1: PACKAGE BODY hr_startup_data_api_support AS

1: PACKAGE BODY hr_startup_data_api_support AS
2: /* $Header: hrsdasup.pkb 120.0 2005/05/31 02:37:18 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- |-----------------------< enable_startup_mode >----------------------------|

Line 13: hr_startup_data_api_support.g_startup_mode := p_mode;

9: ,p_startup_session_id IN number default null) IS
10: --
11: BEGIN
12: --
13: hr_startup_data_api_support.g_startup_mode := p_mode;
14: hr_startup_data_api_support.g_startup_session_id := p_startup_session_id;
15: hr_utility.trace('enable_startup_mode');
16: hr_utility.trace('mode is: ' || hr_startup_data_api_support.g_startup_mode);
17: hr_utility.trace('sessionid is: '||to_char(hr_startup_data_api_support.g_startup_session_id));

Line 14: hr_startup_data_api_support.g_startup_session_id := p_startup_session_id;

10: --
11: BEGIN
12: --
13: hr_startup_data_api_support.g_startup_mode := p_mode;
14: hr_startup_data_api_support.g_startup_session_id := p_startup_session_id;
15: hr_utility.trace('enable_startup_mode');
16: hr_utility.trace('mode is: ' || hr_startup_data_api_support.g_startup_mode);
17: hr_utility.trace('sessionid is: '||to_char(hr_startup_data_api_support.g_startup_session_id));
18: --

Line 16: hr_utility.trace('mode is: ' || hr_startup_data_api_support.g_startup_mode);

12: --
13: hr_startup_data_api_support.g_startup_mode := p_mode;
14: hr_startup_data_api_support.g_startup_session_id := p_startup_session_id;
15: hr_utility.trace('enable_startup_mode');
16: hr_utility.trace('mode is: ' || hr_startup_data_api_support.g_startup_mode);
17: hr_utility.trace('sessionid is: '||to_char(hr_startup_data_api_support.g_startup_session_id));
18: --
19: END enable_startup_mode;
20: --

Line 17: hr_utility.trace('sessionid is: '||to_char(hr_startup_data_api_support.g_startup_session_id));

13: hr_startup_data_api_support.g_startup_mode := p_mode;
14: hr_startup_data_api_support.g_startup_session_id := p_startup_session_id;
15: hr_utility.trace('enable_startup_mode');
16: hr_utility.trace('mode is: ' || hr_startup_data_api_support.g_startup_mode);
17: hr_utility.trace('sessionid is: '||to_char(hr_startup_data_api_support.g_startup_session_id));
18: --
19: END enable_startup_mode;
20: --
21: -- ----------------------------------------------------------------------------

Line 28: hr_utility.trace('return val : ' || hr_startup_data_api_support.g_startup_mode);

24: FUNCTION return_startup_mode RETURN varchar2 IS
25: --
26: BEGIN
27: hr_utility.trace('entering return_startup_mode');
28: hr_utility.trace('return val : ' || hr_startup_data_api_support.g_startup_mode);
29: RETURN (hr_startup_data_api_support.g_startup_mode);
30: END return_startup_mode;
31: --
32: -- ----------------------------------------------------------------------------

Line 29: RETURN (hr_startup_data_api_support.g_startup_mode);

25: --
26: BEGIN
27: hr_utility.trace('entering return_startup_mode');
28: hr_utility.trace('return val : ' || hr_startup_data_api_support.g_startup_mode);
29: RETURN (hr_startup_data_api_support.g_startup_mode);
30: END return_startup_mode;
31: --
32: -- ----------------------------------------------------------------------------
33: -- |----------------------< create_owner_definition >-------------------------|

Line 48: IF hr_startup_data_api_support.g_session_id IS NULL THEN

44: -- Issue savepoint
45: SAVEPOINT ins_owner_def;
46: --
47: -- Fetch session_id
48: IF hr_startup_data_api_support.g_session_id IS NULL THEN
49: if hr_startup_data_api_support.g_startup_session_id is null then
50: OPEN csr_get_session_id;
51: FETCH csr_get_session_id INTO hr_startup_data_api_support.g_session_id;
52: CLOSE csr_get_session_id;

Line 49: if hr_startup_data_api_support.g_startup_session_id is null then

45: SAVEPOINT ins_owner_def;
46: --
47: -- Fetch session_id
48: IF hr_startup_data_api_support.g_session_id IS NULL THEN
49: if hr_startup_data_api_support.g_startup_session_id is null then
50: OPEN csr_get_session_id;
51: FETCH csr_get_session_id INTO hr_startup_data_api_support.g_session_id;
52: CLOSE csr_get_session_id;
53: else

Line 51: FETCH csr_get_session_id INTO hr_startup_data_api_support.g_session_id;

47: -- Fetch session_id
48: IF hr_startup_data_api_support.g_session_id IS NULL THEN
49: if hr_startup_data_api_support.g_startup_session_id is null then
50: OPEN csr_get_session_id;
51: FETCH csr_get_session_id INTO hr_startup_data_api_support.g_session_id;
52: CLOSE csr_get_session_id;
53: else
54: hr_startup_data_api_support.g_session_id :=
55: hr_startup_data_api_support.g_startup_session_id;

Line 54: hr_startup_data_api_support.g_session_id :=

50: OPEN csr_get_session_id;
51: FETCH csr_get_session_id INTO hr_startup_data_api_support.g_session_id;
52: CLOSE csr_get_session_id;
53: else
54: hr_startup_data_api_support.g_session_id :=
55: hr_startup_data_api_support.g_startup_session_id;
56: end if;
57: END IF;
58: --

Line 55: hr_startup_data_api_support.g_startup_session_id;

51: FETCH csr_get_session_id INTO hr_startup_data_api_support.g_session_id;
52: CLOSE csr_get_session_id;
53: else
54: hr_startup_data_api_support.g_session_id :=
55: hr_startup_data_api_support.g_startup_session_id;
56: end if;
57: END IF;
58: --
59: hr_utility.trace('create_owner_definition');

Line 60: hr_utility.trace('session id: ' || to_char(hr_startup_data_api_support.g_session_id));

56: end if;
57: END IF;
58: --
59: hr_utility.trace('create_owner_definition');
60: hr_utility.trace('session id: ' || to_char(hr_startup_data_api_support.g_session_id));
61: hr_utility.trace('product_short_name: ' || p_product_shortname);
62: INSERT INTO hr_owner_definitions
63: (session_id
64: ,product_short_name)

Line 66: (hr_startup_data_api_support.g_session_id

62: INSERT INTO hr_owner_definitions
63: (session_id
64: ,product_short_name)
65: VALUES
66: (hr_startup_data_api_support.g_session_id
67: ,p_product_shortname);
68: --
69: -- When in validation mode, raise validation enabled exception
70: IF p_validate THEN

Line 134: hr_startup_data_api_support.g_generic_allowed := p_generic;

130: ,p_startup IN boolean
131: ,p_user IN boolean) IS
132: --
133: BEGIN
134: hr_startup_data_api_support.g_generic_allowed := p_generic;
135: hr_startup_data_api_support.g_startup_allowed := p_startup;
136: hr_startup_data_api_support.g_user_allowed := p_user;
137: hr_utility.trace('mode_allowed');
138: if p_generic then hr_utility.trace('p_generic : TRUE'); else hr_utility.trace('p_generic : FALSE'); end if;

Line 135: hr_startup_data_api_support.g_startup_allowed := p_startup;

131: ,p_user IN boolean) IS
132: --
133: BEGIN
134: hr_startup_data_api_support.g_generic_allowed := p_generic;
135: hr_startup_data_api_support.g_startup_allowed := p_startup;
136: hr_startup_data_api_support.g_user_allowed := p_user;
137: hr_utility.trace('mode_allowed');
138: if p_generic then hr_utility.trace('p_generic : TRUE'); else hr_utility.trace('p_generic : FALSE'); end if;
139: if p_startup then hr_utility.trace('p_startup : TRUE'); else hr_utility.trace('p_startup : FALSE'); end if;

Line 136: hr_startup_data_api_support.g_user_allowed := p_user;

132: --
133: BEGIN
134: hr_startup_data_api_support.g_generic_allowed := p_generic;
135: hr_startup_data_api_support.g_startup_allowed := p_startup;
136: hr_startup_data_api_support.g_user_allowed := p_user;
137: hr_utility.trace('mode_allowed');
138: if p_generic then hr_utility.trace('p_generic : TRUE'); else hr_utility.trace('p_generic : FALSE'); end if;
139: if p_startup then hr_utility.trace('p_startup : TRUE'); else hr_utility.trace('p_startup : FALSE'); end if;
140: if p_user then hr_utility.trace('p_user : TRUE'); else hr_utility.trace('p_user : FALSE'); end if;

Line 173: l_mode := hr_startup_data_api_support.return_startup_mode;

169: l_session_id number;
170: --
171: BEGIN
172: -- fetch startup mode
173: l_mode := hr_startup_data_api_support.return_startup_mode;
174: l_session_id := nvl(hr_startup_data_api_support.g_startup_session_id
175: , userenv('sessionid'));
176: --
177: hr_utility.trace('chk_startup_action');

Line 174: l_session_id := nvl(hr_startup_data_api_support.g_startup_session_id

170: --
171: BEGIN
172: -- fetch startup mode
173: l_mode := hr_startup_data_api_support.return_startup_mode;
174: l_session_id := nvl(hr_startup_data_api_support.g_startup_session_id
175: , userenv('sessionid'));
176: --
177: hr_utility.trace('chk_startup_action');
178: hr_utility.trace('l_session_id : ' || to_char(l_session_id));

Line 179: hr_utility.trace('hr_startup_data_api_support.g_startup_session_id : ' || to_char(hr_startup_data_api_support.g_startup_session_id));

175: , userenv('sessionid'));
176: --
177: hr_utility.trace('chk_startup_action');
178: hr_utility.trace('l_session_id : ' || to_char(l_session_id));
179: hr_utility.trace('hr_startup_data_api_support.g_startup_session_id : ' || to_char(hr_startup_data_api_support.g_startup_session_id));
180: hr_utility.trace('l_mode : ' || l_mode);
181: hr_utility.trace('p_business_group_id : ' || nvl(to_char(p_business_group_id), 'NULL'));
182: hr_utility.trace('p_legislation_code : ' || nvl(p_legislation_code, 'NULL'));
183: hr_utility.trace('p_legislation_subgroup : ' || nvl(p_legislation_subgroup, 'NULL'));

Line 249: l_mode := hr_startup_data_api_support.return_startup_mode;

245: l_proc varchar2(72) := 'chk_startup_action';
246: --
247: BEGIN
248: -- fetch startup mode
249: l_mode := hr_startup_data_api_support.return_startup_mode;
250: -- Only perform checks if API is not being called by SDM
251: IF (l_mode <> 'DELIVERY') THEN
252: IF ((p_business_group_id IS NULL) AND
253: (p_legislation_code IS NULL) AND

Line 276: END hr_startup_data_api_support;

272: END IF;
273: END IF;
274: END chk_upd_del_startup_action;
275: --
276: END hr_startup_data_api_support;