1 Package ben_plan_design_elpro_module AUTHID CURRENT_USER as
2 /* $Header: bepdcprf.pkh 120.1 2006/02/28 03:28:34 rgajula noship $ */
3 --
4
5 --Bug 5059695 Cursor to retreive the transaction category
6 cursor g_trasaction_categories(c_copy_entity_txn_id number) is
7 select ptc.short_name
8 from PQH_COPY_ENTITY_TXNS pcet,
9 PQH_TRANSACTION_CATEGORIES ptc
10 where pcet.COPY_ENTITY_TXN_ID= c_copy_entity_txn_id
11 and ptc.TRANSACTION_CATEGORY_ID = pcet.TRANSACTION_CATEGORY_ID;
12
13 g_copy_entity_txn_id PQH_COPY_ENTITY_TXNS.COPY_ENTITY_TXN_ID%type := -999999;
14 g_trasaction_category PQH_TRANSACTION_CATEGORIES.SHORT_NAME%type := null;
15
16 -- End Bug 5059695
17
18 procedure create_elpro_results
19 (
20 p_validate in number default 0 -- false
21 ,p_copy_entity_result_id in number -- Source Elpro
22 ,p_copy_entity_txn_id in number default null
23 ,p_pgm_id in number default null
24 ,p_ptip_id in number default null
25 ,p_plip_id in number default null
26 ,p_pl_id in number default null
27 ,p_oipl_id in number default null
28 ,p_business_group_id in number default null
29 ,p_number_of_copies in number default 0
30 ,p_object_version_number out nocopy number
31 ,p_effective_date in date
32 ,p_parent_entity_result_id in number
33 ) ;
34 --
35 procedure create_dep_elpro_result
36 (
37 p_validate in number default 0 -- false
38 ,p_copy_entity_result_id in number
39 ,p_copy_entity_txn_id in number default null
40 ,p_pgm_id in number default null
41 ,p_ptip_id in number default null
42 ,p_pl_id in number default null
43 ,p_business_group_id in number default null
44 ,p_number_of_copies in number default 0
45 ,p_object_version_number out nocopy number
46 ,p_effective_date in date
47 ,p_parent_entity_result_id in number
48 ) ;
49 --
50 procedure create_elig_prfl_results
51 (
52 p_validate in number default 0 -- false
53 ,p_mirror_src_entity_result_id in number
54 ,p_parent_entity_result_id in number
55 ,p_copy_entity_txn_id in number
56 ,p_eligy_prfl_id in number
57 ,p_mndtry_flag in varchar2 default null
58 ,p_business_group_id in number default null
59 ,p_number_of_copies in number default 0
60 ,p_object_version_number out nocopy number
61 ,p_effective_date in date
62 ,p_no_dup_rslt in varchar2 default null
63 );
64 --
65 procedure create_dep_elig_prfl_results
66 (
67 p_validate in number default 0 -- false
68 ,p_mirror_src_entity_result_id in number
69 ,p_parent_entity_result_id in number
70 ,p_copy_entity_txn_id in number
71 ,p_dpnt_cvg_eligy_prfl_id in number
72 ,p_business_group_id in number default null
73 ,p_number_of_copies in number default 0
74 ,p_object_version_number out nocopy number
75 ,p_effective_date in date
76 ,p_no_dup_rslt in varchar2 default null
77 );
78 --
79 procedure create_eligy_criteria_result
80 (
81 p_validate in number default 0 -- false
82 ,p_copy_entity_result_id in number
83 ,p_copy_entity_txn_id in number
84 ,p_eligy_criteria_id in number
85 ,p_business_group_id in number default null
86 ,p_number_of_copies in number default 0
87 ,p_object_version_number out nocopy number
88 ,p_effective_date in date
89 ,p_parent_entity_result_id in number
90 ,p_no_dup_rslt in varchar2 default null
91 );
92 --
93 end ben_plan_design_elpro_module;