PACKAGE: APPS.BEN_TYPE

Source

1 package ben_type as
2 /* $Header: bentype.pkh 120.0 2005/05/28 00:13:32 appldev noship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 |			Copyright (c) 1997 Oracle Corporation		       |
7 |			   Redwood Shores, California, USA		       |
8 |			        All rights reserved.			       |
9 +==============================================================================+
10 
11 Name
12 	Environment Object Caching Routine
13 Purpose
14 	This package is used to return environment object information.
15 History
16   Date       Who        Version    What?
17   ---------  ---------  -------    --------------------------------------------
18   27 Jul 99  mhoyes     115.0      Created
19   ------------------------------------------------------------------------------
20 */
21 --
22   --
23   -- Types
24   --
25   --   Create reporting structure
26   --
27   type g_report_rec is record
28     (reporting_id          number,
29      benefit_action_id     number,
30      thread_id             number,
31      sequence              number,
32      rep_typ_cd            hr_lookups.lookup_code%type,
33      error_message_code    hr_lookups.lookup_code%type,
34      national_identifier   per_people_f.national_identifier%type,
35      related_person_ler_id ben_ler_f.ler_id%type,
36      temporal_ler_id       ben_ler_f.ler_id%type,
37      ler_id                ben_ler_f.ler_id%type,
38      person_id             per_people_f.person_id%type,
39      pgm_id                ben_pgm_f.pgm_id%type,
40      pl_id                 ben_pl_f.pl_id%type,
41      related_person_id     per_people_f.person_id%type,
42      oipl_id               ben_oipl_f.oipl_id%type,
43      pl_typ_id             ben_pl_typ_f.pl_typ_id%type,
44      actl_prem_id          ben_actl_prem_f.actl_prem_id%type,
45      val                   ben_prtt_prem_by_mo_f.val%type,
46      mo_num                ben_prtt_prem_by_mo_f.mo_num%type,
47      yr_num                ben_prtt_prem_by_mo_f.yr_num%type,
48      text                  varchar2(2000),
49      object_version_number number);
50   --
51   type g_report_table is varray(10000000) of g_report_rec;
52   --
53   -- Batch actions
54   --
55   type g_batch_action_rec is record
56     (person_action_id      number,
57      action_status_cd      varchar2(30),
58      ler_id                number,
59      object_version_number number,
60      effective_date        date);
61   --
62   type g_batch_action_table is varray(10000000) of g_batch_action_rec;
63   --
64   type g_batch_proc_rec is record
65     (batch_ler_id          number,
66      benefit_action_id     number,
67      strt_dt               date,
68      end_dt                date,
69      strt_tm               varchar2(30),
70      end_tm                varchar2(30),
71      elpsd_tm              varchar2(30),
72      per_slctd             number,
73      per_proc              number,
74      per_unproc            number,
75      per_proc_succ         number,
76      per_err               number,
77      business_group_id     number,
78      object_version_number number);
79   --
80   type g_batch_proc_table is varray(10000000) of g_batch_proc_rec;
81   --
82   type g_batch_commu_rec is record
83     (batch_commu_id         number,
84      benefit_action_id     number,
85      person_id             number,
86      per_cm_id             number,
87      cm_typ_id             number,
88      per_cm_prvdd_id       number,
89      to_be_sent_dt         date,
90      business_group_id     number,
91      object_version_number number);
92   --
93   type g_batch_commu_table is varray(10000000) of g_batch_commu_rec;
94   --
95 --
96 end ben_type;