1 Package pqh_gsp_del_grade_ladder_obj AUTHID CURRENT_USER as
2 /* $Header: pqgspdel.pkh 115.0 2003/09/16 19:53 srajakum noship $ */
3 --
4 --
5 --
6 -- This is the main function called before copying BEN objects from staging
7 -- tables to actual BEN tables
8 -- Returns either 'SUCCESS' or 'FAILURE'
9 --
10 --
11 Function delete_from_ben (p_copy_entity_txn_id in number,
12 p_effective_date in date,
13 p_datetrack_mode in varchar2 default null)
14 RETURN varchar2;
15 --
16 -- The following functions allow deleting individual components under a txn
17 -- Values returned are 'SUCCESS' / 'FAILURE'
18 --
19 --
20 Function unlink_plan_from_pgm (p_copy_entity_txn_id in number,
21 p_effective_date in date,
22 p_datetrack_mode in varchar2 default null)
23 RETURN varchar2;
24 --
25 Function unlink_oipl_from_plan (p_copy_entity_txn_id in number,
26 p_effective_date in date,
27 p_datetrack_mode in varchar2 default null)
28 RETURN varchar2;
29 --
30 Function delete_option (p_copy_entity_txn_id in number,
31 p_effective_date in date,
32 p_datetrack_mode in varchar2 default null)
33 RETURN varchar2;
34 --
35 Function unlink_elig_prfl (p_copy_entity_txn_id in number,
36 p_effective_date in date,
37 p_datetrack_mode in varchar2 default null)
38 RETURN varchar2;
39 --
40 End;
[Home] [Help]