[Home] [Help]
PACKAGE: APPS.BEN_ORG_OBJECT
Source
1 package ben_org_object AUTHID CURRENT_USER as
2 /* $Header: benorgch.pkh 120.1 2005/05/31 04:10:32 rgajula noship $ */
3 --
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 --
11 History
12 Version Date Who What?
13 --------- --------- ---------- --------------------------------------------
14 115.0 09-Aug-99 GPERRY Created.
15 115.1 16-Aug-99 GPERRY Added nocopy compiler directive.
16 115.2 06 May 00 RChase Added additional NOCOPY compiler directives
17 115.3 12 Dec 01 Tmathers dos2unix for 2128462.
18 -----------------------------------------------------------------------------
19 */
20 --
21 type g_cache_bus_table is table of per_business_groups%rowtype index
22 by binary_integer;
23 --
24 type g_cache_org_table is table of hr_all_organization_units%rowtype index
25 by binary_integer;
26 --
27 type g_cache_pay_table is table of pay_all_payrolls_f%rowtype index
28 by binary_integer;
29 --
30 type g_cache_ben_table is table of ben_benfts_grp%rowtype index
31 by binary_integer;
32 --
33 g_cache_bus_rec g_cache_bus_table;
34 g_cache_last_bus_rec per_business_groups%rowtype;
35 g_cache_org_rec g_cache_org_table;
36 g_cache_last_org_rec hr_all_organization_units%rowtype;
37 g_cache_pay_rec g_cache_pay_table;
38 g_cache_last_pay_rec pay_all_payrolls_f%rowtype;
39 g_cache_ben_rec g_cache_ben_table;
40 g_cache_last_ben_rec ben_benfts_grp%rowtype;
41 --
42 -- Set object routines
43 --
44 procedure set_object
45 (p_rec in out NOCOPY per_business_groups%rowtype);
46 --
47 procedure set_object
48 (p_rec in out NOCOPY hr_all_organization_units%rowtype);
49 --
50 procedure set_object
51 (p_rec in out NOCOPY pay_all_payrolls_f%rowtype);
52 --
53 procedure set_object
54 (p_rec in out NOCOPY ben_benfts_grp%rowtype);
55 --
56 procedure set_bus_object
57 (p_business_group_id in number,
58 p_effective_date in date,
59 p_rec in out nocopy per_business_groups%rowtype);
60 --
61 procedure set_org_object
62 (p_organization_id in number,
63 p_effective_date in date,
64 p_rec in out nocopy hr_all_organization_units%rowtype);
65 --
66 procedure set_pay_object
67 (p_payroll_id in number,
68 p_business_group_id in number,
69 p_effective_date in date,
70 p_rec in out nocopy pay_all_payrolls_f%rowtype);
71 --
72 procedure set_ben_object
73 (p_benfts_grp_id in number,
74 p_business_group_id in number,
75 p_rec in out nocopy ben_benfts_grp%rowtype);
76 --
77 -- Get object routines
78 --
79 procedure get_object
80 (p_business_group_id in number,
81 p_rec in out nocopy per_business_groups%rowtype);
82 --
83 procedure get_object
84 (p_organization_id in number,
85 p_rec in out nocopy hr_all_organization_units%rowtype);
86 --
87 procedure get_object
88 (p_payroll_id in number,
89 p_rec in out nocopy pay_all_payrolls_f%rowtype);
90 --
91 procedure get_object
92 (p_benfts_grp_id in number,
93 p_rec in out nocopy ben_benfts_grp%rowtype);
94 --
95 procedure clear_down_cache;
96 --
97 end ben_org_object;