1 Package PER_SP_STAGE AUTHID CURRENT_USER as
2 /* $Header: perspstage.pkh 120.2 2011/04/05 05:21:18 vkodedal noship $ */
3
4 procedure createHRApiTransaction(p_person_id in number,
5 p_copy_entity_txn_id in number,
6 p_hr_api_txn_id out nocopy number);
7
8 procedure create_sp(p_business_group_id in number,
9 p_copy_entity_txn_id out nocopy number);
10
11 procedure stage_to_sp(p_effective_date in date
12 ,p_copy_entity_txn_id in number
13 ,p_validate in varchar2);
14
15 procedure sp_to_stage(p_effective_date in date default trunc(sysdate)
16 ,p_plan_id in number
17 ,p_business_group_id in number default null
18 ,p_mode in varchar2 default null
19 ,p_copy_entity_txn_id OUT nocopy number);
20
21 procedure launch_wf(p_process in wf_process_activities.process_name%type,
22 p_item_type in wf_items.item_type%type,
23 p_person_id in number,
24 p_copy_entity_txn_id in number,
25 p_approval_reqd in varchar2);
26
27 procedure reject_transaction( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
28 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
29 actid IN NUMBER,
30 funcmode IN VARCHAR2,
31 resultout OUT nocopy VARCHAR2 );
32
33 procedure get_approval_req( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
34 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
35 actid IN NUMBER,
36 funcmode IN VARCHAR2,
37 resultout OUT nocopy VARCHAR2 );
38
39 procedure commit_transaction( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
40 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
41 actid IN NUMBER,
42 funcmode IN VARCHAR2,
43 resultout OUT nocopy VARCHAR2 );
44
45 procedure commit_txn( p_copy_entity_txn_id in Number);
46
47 procedure refresh_txn( p_copy_entity_txn_id in Number);
48
49 end PER_SP_STAGE;