[Home] [Help]
PACKAGE: APPS.BEN_CLS_UNRESOLVED_ACTN_ITEM
Source
1 package ben_cls_unresolved_Actn_item AUTHID CURRENT_USER as
2 /* $Header: benuneai.pkh 120.0.12010000.1 2008/07/29 12:32:02 appldev ship $ */
3 /* ========================================================================
4 Name:
5 Cls_unresolved_act_item
6 Purpose
7 This package is used to all unsolved action items.
8 History
9 Ver Date Who What?
10 ------ ----------- ----------- ---------------------------------------------
11 115.0 01-Sep-1998 Hugh Dang Initial Created.
12 115.1 12-Dec-1998 Hugh Dang Remove local procedure and call batch_utils.
13 115.2 30-Dec-1998 Hugh Dang Add audit log flag and new procedure restart.
14 115.3 22-Feb-1999 Hugh Dang Changed p_effective_date data type.
15 115.4 11-dec-2002 hmani NoCopy changes
16
17 ===========================================================================
18 */
19 --
20 -- Global type declaration
21 --
22 type g_cache_person_process_object is record
23 (person_id ben_person_actions.person_id%type
24 ,person_action_id ben_person_actions.person_action_id%type
25 ,object_version_number ben_person_actions.object_version_number%type
26 ,ler_id ben_person_actions.ler_id%type
27 );
28 type g_cache_person_process_rec is table of g_cache_person_process_object
29 index by binary_integer;
30 --
31 -- Global varaibles.
32 --
33 g_debug boolean := FALSE;
34 --
35 -- ===========================================================================
36 -- << Procedure: *cls_per_unresolved_actn_item* >>
37 -- ===========================================================================
38 --
39 procedure cls_per_unresolved_actn_item
40 (p_person_id in number
41 ,p_effective_date in date
42 ,p_business_group_id in number
43 ,p_overwrite_flag in boolean default FALSE
44 ,p_batch_flag in boolean default FALSE
45 ,p_validate in boolean default FALSE
46 ,p_person_action_id in number default NULL
47 ,p_object_version_number in number default NULL
48 ,p_audit_log in varchar2 default 'N'
49 );
50 --
51 -- ===========================================================================
52 -- << Procedure: *do_multithread* >>
53 -- ===========================================================================
54 --
55 Procedure do_multithread
56 (errbuf out nocopy varchar2
57 ,retcode out nocopy number
58 ,p_validate in varchar2 default 'N'
59 ,p_benefit_action_id in number
60 ,p_thread_id in number
61 ,p_effective_date in varchar2
62 ,p_business_group_id in number
63 ,p_audit_log in varchar2 default 'N'
64 );
65 --
66 -- ===========================================================================
67 -- << Procedure: *Process* >>
68 -- ===========================================================================
69 --
70 Procedure Process
71 (errbuf out nocopy varchar2
72 ,retcode out nocopy number
73 ,p_benefit_action_id in number
74 ,p_effective_date in varchar2
75 ,p_business_group_id in number
76 ,p_pgm_id in number default NULL
77 ,p_pl_nip_id in number default NULL
78 ,p_location_id in number default NULL
79 ,p_Person_id in number default NULL
80 ,p_Person_selection_rl in number default NULL
81 ,p_validate in varchar2 default 'N'
82 ,p_debug_messages in varchar2 default 'N'
83 ,p_audit_log in varchar2 default 'N'
84 );
85 --
86 -- ===========================================================================
87 -- << Procedure: *Restart* >>
88 -- ===========================================================================
89 --
90 Procedure restart
91 (errbuf out nocopy varchar2
92 ,retcode out nocopy number
93 ,p_benefit_action_id in number
94 );
95 End ben_cls_unresolved_Actn_item;