1 Package BEN_PD_COPY_TO_BEN_TWO AUTHID CURRENT_USER as
2 /* $Header: bepdccp2.pkh 120.1.12000000.1 2007/01/19 20:44:56 appldev noship $ */
3 --
4 --TCS PDW Integration ENH
5
6 --cursor g_copy_entity_txn is used by the body of BEN_PD_COPY_TO_BEN_TWO in
7 --create_pgm_intersect_rows, this cursor along with the globals defined
8 --are used to avoid unnecessary queries to DB if the copy_entity_txn_id
9 --remains unchanged.
10
11 -- It would be a good idea NOT to use the cursor in any other file other
12 -- than BEN_PD_COPY_TO_BEN_TWO body , this would improve modularity and.
13
14 cursor g_copy_entity_txn(c_copy_entity_txn_id number) is
15 select cet.row_type_cd row_type_cd
16 from ben_copy_entity_txns_vw cet,
17 PQH_TRANSACTION_CATEGORIES ptc
18 where cet.COPY_ENTITY_TXN_ID= c_copy_entity_txn_id
19 and ptc.TRANSACTION_CATEGORY_ID = cet.TRANSACTION_CATEGORY_ID;
20
21 g_copy_entity_txn_id PQH_COPY_ENTITY_TXNS.COPY_ENTITY_TXN_ID%type := -999999;
22 g_row_type_cd ben_copy_entity_txns_vw.row_type_cd%type := null;
23 --TCS PDW Integration ENH
24
25 procedure set_mapping(p_copy_entity_txn_id number) ;
26 --
27 procedure create_final_intersect_rows
28 (
29 p_validate in number default 0
30 ,p_copy_entity_txn_id in number
31 ,p_effective_date in date
32 ,p_prefix_suffix_text in varchar2 default null
33 ,p_reuse_object_flag in varchar2 default null
34 ,p_target_business_group_id in varchar2 default null
35 ,p_prefix_suffix_cd in varchar2 default null
36 );
37 procedure create_pgm_intersect_rows(
41 ,p_prefix_suffix_text in varchar2 default null
38 p_validate in number default 0 -- false
39 ,p_copy_entity_txn_id in number
40 ,p_effective_date in date
42 ,p_reuse_object_flag in varchar2 default null
43 ,p_target_business_group_id in varchar2 default null
44 ,p_prefix_suffix_cd in varchar2 default null
45 );
46 procedure create_stg_to_ben_rows
47 (
48 p_validate in number default 0 -- false
49 ,p_copy_entity_txn_id in number
50 ,p_effective_date in date
51 ,p_prefix_suffix_text in varchar2 default null
52 ,p_reuse_object_flag in varchar2 default null
53 ,p_target_business_group_id in varchar2 default null
54 ,p_prefix_suffix_cd in varchar2 default null
55 ,p_effective_date_to_copy in date default null
56 ) ;
57 -- ----------------------------------------------------------------------------
58 end BEN_PD_COPY_TO_BEN_TWO;