[Home] [Help]
PACKAGE: APPS.IRC_GET_VACANCY_DEFAULTS
Source
1 Package IRC_GET_VACANCY_DEFAULTS as
2 /* $Header: irvacdft.pkh 120.0 2005/07/26 15:19:01 mbocutt noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Global Record Type Specification |
6 -- ----------------------------------------------------------------------------
7 --
8 Type g_rec_type Is Record
9 (ORG_INFORMATION_ID NUMBER
10 ,ORG_INFORMATION_CONTEXT VARCHAR2(40)
11 ,ORGANIZATION_ID NUMBER(15)
12 ,ORG_INFORMATION1 VARCHAR2(150)
13 ,ORG_INFORMATION2 VARCHAR2(150)
14 ,ORG_INFORMATION3 VARCHAR2(150)
15 ,ORG_INFORMATION4 VARCHAR2(150)
16 ,ORG_INFORMATION5 VARCHAR2(150)
17 ,ORG_INFORMATION6 VARCHAR2(150)
18 ,ORG_INFORMATION7 VARCHAR2(150)
19 ,ORG_INFORMATION8 VARCHAR2(150)
20 ,ORG_INFORMATION9 VARCHAR2(150)
21 ,ORG_INFORMATION10 VARCHAR2(150)
22 ,ORG_INFORMATION11 VARCHAR2(150)
23 ,ORG_INFORMATION12 VARCHAR2(150)
24 ,ORG_INFORMATION13 VARCHAR2(150)
25 ,ORG_INFORMATION14 VARCHAR2(150)
26 ,ORG_INFORMATION15 VARCHAR2(150)
27 ,ORG_INFORMATION16 VARCHAR2(150)
28 ,ORG_INFORMATION17 VARCHAR2(150)
29 ,ORG_INFORMATION18 VARCHAR2(150)
30 ,ORG_INFORMATION19 VARCHAR2(150)
31 ,ORG_INFORMATION20 VARCHAR2(150)
32 );
33 --
34 Procedure populate_defaults_rec
35 ( p_organization_id in varchar2
36 ,p_level in varchar2
37 );
38 --
39 Procedure get_BG_defaults
40 ( p_business_group_id in number
41 ,p_currency out nocopy varchar2
42 ,p_vacancy_name_is_auto out nocopy varchar2
43 ,p_budget_measurement_type out nocopy varchar2
44 ,p_number_of_openings out nocopy number
45 ,p_location_default out nocopy varchar2
46 ,p_organization_default out nocopy varchar2
47 );
48 --
49 Function get_currency (p_organization_id in varchar) return varchar2;
50 --
51 Function get_vacancy_name_is_auto return varchar2;
52 --
53 Function get_number_of_openings return number;
54 --
55 Function get_budget_measurement_type return varchar2;
56 --
57 Function get_organization_default return varchar2;
58 --
59 Function get_location_default return varchar2;
60 --
61 end IRC_GET_VACANCY_DEFAULTS;