1 package pqh_gsp_stage_to_hr as
2 /* $Header: pqgspshr.pkh 120.0 2005/05/29 02:00 appldev noship $ */
3 procedure setup_check(p_copy_entity_txn_id in number,
4 p_effective_date in date,
5 p_business_group_id in number,
6 p_status out nocopy varchar2,
7 p_prog_le_created_flag out nocopy varchar2,
8 p_sync_le_created_flag out nocopy varchar2,
9 p_plan_tp_created_flag out nocopy varchar2);
10 function get_bg_for_cet(p_copy_entity_txn_id in number) return number;
11 procedure pre_push_data(p_copy_entity_txn_id in number,
12 p_effective_date in date,
13 p_business_group_id in number,
14 p_business_area in varchar2 default 'PQH_GSP_TASK_LIST',
15 P_Date_Track_Mode IN Varchar2 default 'UPDATE_OVERRIDE');
16 procedure post_push_data(p_copy_entity_txn_id in number,
17 p_effective_date in date,
18 p_business_group_id in number,
19 p_business_area in varchar2 default 'PQH_GSP_TASK_LIST');
20 procedure gsp_data_push(p_copy_entity_txn_id in number,
21 p_effective_date in date,
22 p_business_group_id in number,
23 p_datetrack_mode in varchar2,
24 p_business_area in varchar2 default 'PQH_GSP_TASK_LIST');
25 procedure stage_to_hr(p_copy_entity_txn_id in number,
26 p_effective_date in date,
27 p_business_group_id in number,
28 p_gl_currency in varchar2,
29 p_gl_name in varchar2,
30 p_gl_frequency in varchar2,
31 p_datetrack_mode in varchar2,
32 p_business_area in varchar2 default 'PQH_GSP_TASK_LIST');
33 procedure stage_to_point(p_copy_entity_txn_id in number,
34 p_business_group_id in number,
35 p_effective_date in date,
36 p_business_area in varchar2 default 'PQH_GSP_TASK_LIST');
37 Procedure stage_to_grade(p_copy_entity_txn_id in number,
38 p_business_group_id in number,
39 p_effective_date in date);
40 procedure stage_to_grd_sp(p_copy_entity_txn_id in number,
41 p_effective_date in date,
42 p_business_group_id in number,
43 p_datetrack_mode in varchar2);
44 procedure stage_to_step(p_copy_entity_txn_id in number,
45 p_business_group_id in number,
46 p_effective_date in date,
47 p_datetrack_mode in varchar2);
48 Procedure stage_to_scale(p_copy_entity_txn_id in number,
49 p_business_group_id in number,
50 p_effective_date in date,
51 p_business_area in varchar2 default 'PQH_GSP_TASK_LIST');
52 procedure stage_to_hrate(p_copy_entity_txn_id in number,
53 p_business_group_id in number,
54 p_gl_currency in varchar2,
55 p_effective_date in date,
56 p_datetrack_mode in varchar2);
57 end pqh_gsp_stage_to_hr;