DBA Data[Home] [Help]

PACKAGE: APPS.BEN_PD_COPY_TO_BEN_TWO

Source


1 Package BEN_PD_COPY_TO_BEN_TWO 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(
38    p_validate                       in  number     default 0 -- false
39   ,p_copy_entity_txn_id             in  number
40   ,p_effective_date                 in  date
41   ,p_prefix_suffix_text             in  varchar2  default null
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;