1 PACKAGE hr_startup_data_api_support AUTHID CURRENT_USER AS
2 /* $Header: hrsdasup.pkh 115.1 2002/08/16 21:45:22 tjesumic noship $ */
3 --
4 g_startup_mode varchar2(10) := 'USER';
5 g_session_id number := NULL;
6 g_startup_allowed boolean := TRUE;
7 g_generic_allowed boolean := TRUE;
8 g_user_allowed boolean := TRUE;
9 g_startup_session_id number := NULL;
10 --
11 -- ----------------------------------------------------------------------------
12 -- |-----------------------< enable_startup_mode >----------------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- Description:
16 -- This procedure is called prior to calling an API for a startup data entity,
17 -- and is used to set the global variable which will indicate the mode which
18 -- is to be used for thr startup data entity.
19 --
20 -- Post Success:
21 -- The global variable will be set which determines the mode for startup
22 -- data entities.
23 --
24 -- For Oracle Internal Use Only.
25 --
26 -- ----------------------------------------------------------------------------
27 PROCEDURE enable_startup_mode
28 (p_mode IN VARCHAR2
29 ,p_startup_session_id IN NUMBER DEFAULT null);
30 --
31 -- ----------------------------------------------------------------------------
32 -- |-----------------------< return_startup_mode >----------------------------|
33 -- ----------------------------------------------------------------------------
34 --
35 -- Description:
36 -- This function is called to return the value of the global variable which
37 -- holds the startup data mode.
38 --
39 -- ----------------------------------------------------------------------------
40 FUNCTION return_startup_mode RETURN varchar2;
41 --
42 -- ----------------------------------------------------------------------------
43 -- |----------------------< create_owner_definition >-------------------------|
44 -- ----------------------------------------------------------------------------
45 --
46 -- Description:
47 -- This procedure is called prior to calling the API to insert/update/delete
48 -- startup data. It will perform the same function as the PAYWSDOP form, and
49 -- will insert one row into the HR_OWNER_DEFINITIONS table.
50 --
51 -- Post success:
52 -- A row will be inserted into the HR_OWNER_DEFINITIONS table for the current
53 -- session.
54 -- ----------------------------------------------------------------------------
55 PROCEDURE create_owner_definition(p_product_shortname IN varchar2
56 ,p_validate IN boolean default false);
57 --
58 -- ----------------------------------------------------------------------------
59 -- |----------------------< delete_owner_definitions >------------------------|
60 -- ----------------------------------------------------------------------------
61 --
62 -- Description:
63 -- This procedure, when called, will clear the rows from the
64 -- HR_OWNER_DEFINITIONS table, for the current session.
65 --
66 -- Post success:
67 -- For the current session, all rows will be removed from the
68 -- HR_OWNER_DEFINITIONS table.
69 -- ----------------------------------------------------------------------------
70 PROCEDURE delete_owner_definitions(p_validate IN boolean default false);
71 --
72 -- ----------------------------------------------------------------------------
73 -- |-----------------------< chk_startup_action >-----------------------------|
74 -- ----------------------------------------------------------------------------
75 --
76 -- Description:
77 -- This procedure will check that the current action is allowed according to
78 -- the current startup mode, when called from insert_validate procedure. Will
79 -- check that a row exists in the hr_owner_definitions table also.
80 --
81 -- ----------------------------------------------------------------------------
82 PROCEDURE chk_startup_action
83 (p_generic_allowed IN boolean
84 ,p_startup_allowed IN boolean
85 ,p_user_allowed IN boolean
86 ,p_business_group_id IN number
87 ,p_legislation_code IN varchar2
88 ,p_legislation_subgroup IN varchar2
89 );
90 --
91 -- ----------------------------------------------------------------------------
92 -- |-------------------< chk_upd_del_startup_action >-------------------------|
93 -- ----------------------------------------------------------------------------
94 --
95 -- Description:
96 -- This procedure will check that the current action is allowed according to
97 -- the current startup mode, when called from update_validate or
98 -- delete_validate procedures.
99 --
100 -- ----------------------------------------------------------------------------
101 PROCEDURE chk_upd_del_startup_action
102 (p_generic_allowed IN boolean
103 ,p_startup_allowed IN boolean
104 ,p_user_allowed IN boolean
105 ,p_business_group_id IN number
106 ,p_legislation_code IN varchar2
107 ,p_legislation_subgroup IN varchar2
108 );
109 --
110 END hr_startup_data_api_support;