1 PACKAGE HR_CCMGR_SS AUTHID CURRENT_USER AS
2 /* $Header: hrccmwrs.pkh 115.6 2002/12/04 16:22:20 hjonnala noship $ */
3
4 -- ---------------------------------------------------------------------------
5 -- ---------------------------- < delete_trans_steps > -----------------------
6 -- ---------------------------------------------------------------------------
7 -- Purpose: This procedure is used for deleting the transaction steps
8 -- pertaining to HR_CCMGR_SS module
9 -- ---------------------------------------------------------------------------
10
11 procedure delete_trans_steps(itemtype IN Varchar2
12 ,itemkey IN Varchar2
13 ,actid IN Number);
14
15 -- ---------------------------------------------------------------------------
16 -- ---------------------------- < validate_ccmgr_record > --------------------
17 -- ---------------------------------------------------------------------------
18 -- Purpose: This procedure invokes the Organization Information api's
19 -- p_validate_mode (TRUE, FALSE): (Validation only, INS/UPD mode)
20 -- ---------------------------------------------------------------------------
21 procedure validate_ccmgr_record(p_ccmgr_rec IN HR_CCMGR_TYPE
22 ,p_validate_mode IN Boolean Default True
23 ,p_eff_date IN Date
24 ,p_warning OUT NOCOPY Boolean);
25
26 -- ---------------------------------------------------------------------------
27 -- ---------------------------- < process_api > ------------------------------
28 -- ---------------------------------------------------------------------------
29 -- Purpose: This procedure is used by the WF procedures to commit or validate
30 -- the transaction step with HRMS system
31 -- ---------------------------------------------------------------------------
32 procedure process_api(p_validate in boolean default false
33 ,p_transaction_step_id in number default null
34 ,p_effective_date in varchar2 default null);
35
36 -- ---------------------------------------------------------------------------
37 -- ---------------------------- < update_ccmgr_recs > ------------------------
38 -- ---------------------------------------------------------------------------
39 -- Purpose: This procedure process the transaction data entered and writes
40 -- into the transaction tables
41 -- ---------------------------------------------------------------------------
42 procedure update_ccmgr_recs(p_item_key IN Varchar2
43 ,p_item_type IN Varchar2
44 ,p_activity_id IN Number
45 ,p_login_person_id IN OUT NOCOPY Number
46 ,p_ccmgr_tbl IN OUT NOCOPY HR_CCMGR_TABLE
47 ,p_mode IN Varchar2 Default '#'
48 ,p_error_message OUT NOCOPY Long
49 ,p_status OUT NOCOPY Varchar2);
50
51 -- ---------------------------------------------------------------------------
52 -- ---------------------------- < get_supervisor_details > -------------------
53 -- ---------------------------------------------------------------------------
54 -- Purpose: This procedure is used for defaulting supervisor if dealing
55 -- with terminated CCM
56 -- ---------------------------------------------------------------------------
57 procedure get_supervisor_details(p_emp_id IN Number,
58 p_sup_id OUT NOCOPY Number,
59 p_sup_name OUT NOCOPY Varchar2);
60
61 -- ---------------------------------------------------------------------------
62 -- ---------------------------- < issue_notify > -----------------------------
63 -- ---------------------------------------------------------------------------
64 -- Purpose: This procedure is used for decision crieteria wether to isuue a
65 -- a notification or not
66 -- ---------------------------------------------------------------------------
67 procedure issue_notify(itemtype IN Varchar2,
68 itemkey IN Varchar2,
69 actid IN Number,
70 funmode IN Varchar2,
71 result OUT NOCOPY Varchar2);
72
73 -- ---------------------------------------------------------------------------
74 -- ---------------------------- < get_noaccess_list > ------------------------
75 -- ---------------------------------------------------------------------------
76 -- Purpose: This procedure is used for constructing the plsql/clob document
77 -- used in the CCM notification
78 -- ---------------------------------------------------------------------------
79 procedure get_noaccess_list(document_id IN Varchar2,
80 display_type IN Varchar2,
81 document IN OUT NOCOPY Clob,
82 document_type IN OUT NOCOPY Varchar2);
83
84 end HR_CCMGR_SS;