1 package pqh_gsp_stage_to_ben AUTHID CURRENT_USER as
2 /* $Header: pqgspsbe.pkh 120.1 2005/12/14 03:35 hmehta noship $ */
3 function get_ovn(p_table_name in varchar2,
4 p_key_column_name in varchar2,
5 p_key_column_value in number,
6 p_effective_date in date default null) return number;
7 function get_update_mode(p_table_name varchar2,
8 p_key_column_name varchar2,
9 p_key_column_value number,
10 p_effective_date in date) return varchar2;
11 procedure stage_to_ben(p_copy_entity_txn_id in number,
12 p_effective_date in date,
13 p_business_group_id in number,
14 p_datetrack_mode in varchar2,
15 p_business_area in varchar2 default 'PQH_GSP_TASK_LIST');
16 procedure stage_to_opt(p_copy_entity_txn_id in number,
17 p_business_group_id in number,
18 p_effective_date in date,
19 p_pl_typ_id in number,
20 p_datetrack_mode in varchar2);
21 Procedure stage_to_plan(p_copy_entity_txn_id in number,
22 p_business_group_id in number,
23 p_effective_date in date,
24 p_pl_typ_id in number,
25 p_datetrack_mode in varchar2);
26 procedure stage_to_oipl(p_copy_entity_txn_id in number,
27 p_business_group_id in number,
28 p_effective_date in date,
29 p_datetrack_mode in varchar2);
30 procedure stage_to_pgm(p_copy_entity_txn_id in number,
31 p_business_group_id in number,
32 p_effective_date in date,
33 p_pl_typ_id in number,
34 p_datetrack_mode in varchar2);
35 Procedure stage_to_elp(p_copy_entity_txn_id in number,
36 p_business_group_id in number,
37 p_effective_date in date,
38 p_datetrack_mode in varchar2);
39 procedure stage_to_abr(p_copy_entity_txn_id in number,
40 p_business_group_id in number,
41 p_effective_date in date,
42 p_datetrack_mode in varchar2);
43 procedure stage_to_vpf(p_copy_entity_txn_id in number,
44 p_business_group_id in number,
45 p_effective_date in date,
46 p_datetrack_mode in varchar2);
47 procedure stage_to_plip(p_copy_entity_txn_id in number,
48 p_business_group_id in number,
49 p_effective_date in date,
50 p_datetrack_mode in varchar2,
51 p_business_area in varchar2 default 'PQH_GSP_TASK_LIST');
52 procedure stage_to_cep(p_copy_entity_txn_id in number,
53 p_business_group_id in number,
54 p_effective_date in date,
55 p_datetrack_mode in varchar2);
56 procedure stage_to_epa(p_copy_entity_txn_id in number,
57 p_business_group_id in number,
58 p_effective_date in date,
59 p_datetrack_mode in varchar2);
60 PROCEDURE create_pgm_le (
61 errbuf OUT NOCOPY VARCHAR2,
62 retcode OUT NOCOPY NUMBER,
63 p_effective_date IN VARCHAR2,
64 p_business_group_id IN VARCHAR2,
65 p_pgm_id IN NUMBER DEFAULT NULL
66 );
67 procedure cre_update_elig_prfl(
68 p_copy_entity_txn_id in number
69 ,p_effective_date in date
70 ,p_business_group_id in number
71 ,p_business_area in varchar2 default 'PQH_GSP_TASK_LIST');
72
73 end pqh_gsp_stage_to_ben;