1 PACKAGE AP_WEB_INACTIVE_EMP_WF_PKG AUTHID CURRENT_USER as
2 /* $Header: apwinacs.pls 120.5 2005/10/02 20:15:44 albowicz noship $ */
3
4 --------------------------------------------------------
5 c_business CONSTANT VARCHAR2(8) := 'BUSINESS';
6 c_api_version_num CONSTANT NUMBER := 1.0;
7 c_commit CONSTANT VARCHAR2(1) := 'T';
8 c_attribute_appl_id CONSTANT NUMBER := 178;
9 c_last_update_login CONSTANT NUMBER := 0;
10 c_sec_attribute CONSTANT VARCHAR2(30) := 'ICX_HR_PERSON_ID';
11
12 ---------------------------------------------------------------------------------
13 SUBTYPE ccTrxn_cardProgID IS AP_CREDIT_CARD_TRXNS.card_program_id%TYPE;
14 SUBTYPE ccTrxn_billedDate IS AP_CREDIT_CARD_TRXNS.billed_date%TYPE;
15 ---------------------------------------------------------------------------------
16
17 /*PER Employees */
18 ----------------------------------------------------------------------------------
19 SUBTYPE perEmp_employeeID IS PER_EMPLOYEES_CURRENT_X.employee_id%TYPE;
20 SUBTYPE perEmp_supervisorID IS PER_EMPLOYEES_CURRENT_X.supervisor_id%TYPE;
21 ----------------------------------------------------------------------------------
22
23
24 SUBTYPE wfItems_item_type IS WF_ITEMS.item_type%type;
25 SUBTYPE wfItems_item_key IS WF_ITEMS.item_key%type;
26
27 -----------------------------------------------
28 TYPE InactEmpCCTrxnCursor IS REF CURSOR;
29 -----------------------------------------------
30
31
32 PROCEDURE Start_inactive_emp_process(p_card_program_id IN NUMBER,
33 p_inact_employee_id IN NUMBER,
34 p_billed_currency_code IN VARCHAR2,
35 p_total_amt_posted IN NUMBER,
36 p_cc_billed_start_date IN ccTrxn_billedDate,
37 p_cc_billed_end_date IN ccTrxn_billedDate,
38 p_wf_item_type IN wfItems_item_type,
39 p_wf_item_key IN wfItems_item_key);
40
41 FUNCTION GetInactEmpCcardTrxnCursor(
42 p_cardProgramId IN ccTrxn_cardProgID,
43 p_employeeId IN perEmp_employeeID,
44 p_billedStartDate IN ccTrxn_billedDate,
45 p_billedEndDate IN ccTrxn_billedDate,
46 p_itemkey IN wfItems_item_key,
47 p_Inact_Emp_trx_cursor OUT NOCOPY InactEmpCCTrxnCursor
48 ) RETURN BOOLEAN;
49
50 PROCEDURE GenerateCCTrxList(document_id IN VARCHAR2,
51 display_type IN VARCHAR2,
52 document IN OUT NOCOPY VARCHAR2,
53 document_type IN OUT NOCOPY VARCHAR2);
54
55 PROCEDURE FindActiveMAnager(p_item_type IN VARCHAR2,
56 p_item_key IN VARCHAR2,
57 p_actid IN NUMBER,
58 p_funmode IN VARCHAR2,
59 p_result OUT NOCOPY VARCHAR2);
60
61 PROCEDURE CheckMangSecAttr(itemtype in varchar2,
62 itemkey in varchar2,
63 actid in number,
64 funcmode in varchar2,
65 resultout in out NOCOPY varchar2);
66
67
68 PROCEDURE SetAPRolePreparer(p_item_type IN VARCHAR2,
69 p_item_key IN VARCHAR2,
70 p_actid IN NUMBER,
71 p_funmode IN VARCHAR2,
72 p_result OUT NOCOPY VARCHAR2);
73
74 PROCEDURE SetFromRoleForwardFrom(p_item_type IN VARCHAR2,
75 p_item_key IN VARCHAR2,
76 p_actid IN NUMBER,
77 p_funmode IN VARCHAR2,
78 p_result OUT NOCOPY VARCHAR2);
79
80 PROCEDURE RecordForwardFromInfo(p_item_type IN VARCHAR2,
81 p_item_key IN VARCHAR2,
82 p_actid IN NUMBER,
83 p_funmode IN VARCHAR2,
84 p_result OUT NOCOPY VARCHAR2);
85
86 PROCEDURE SetMangInfoPrepNoResp(itemtype in varchar2,
87 itemkey in varchar2,
88 actid in number,
89 funcmode in varchar2,
90 resultout in out NOCOPY varchar2);
91
92 PROCEDURE AddSecAttrPreparer(itemtype in varchar2,
93 itemkey in varchar2,
94 actid in number,
95 funcmode in varchar2,
96 resultout in out NOCOPY varchar2);
97
98
99 PROCEDURE RemoveSecAttrPreparer(itemtype in varchar2,
100 itemkey in varchar2,
101 actid in number,
102 funcmode in varchar2,
103 resultout in out NOCOPY varchar2);
104
105 PROCEDURE Format_message(p_status IN VARCHAR2,
106 p_msg_count IN NUMBER,
107 p_msg_data IN VARCHAR2,
108 p_error OUT NOCOPY VARCHAR2);
109
110 PROCEDURE CheckCCTransactionExists(itemtype in varchar2,
111 itemkey in varchar2,
112 actid in number,
113 funcmode in varchar2,
114 resultout in out NOCOPY varchar2);
115
116 PROCEDURE CheckWfExistsEmpl(itemtype in varchar2,
117 itemkey in varchar2,
118 actid in number,
119 funcmode in varchar2,
120 resultout in out NOCOPY varchar2);
121
122 PROCEDURE CallbackFunction(p_s_item_type IN VARCHAR2,
123 p_s_item_key IN VARCHAR2,
124 p_n_actid IN NUMBER,
125 p_s_command IN VARCHAR2,
126 p_s_result OUT NOCOPY VARCHAR2);
127
128 PROCEDURE IsNotifTransferred( p_item_type IN VARCHAR2,
129 p_item_key IN VARCHAR2,
130 p_actid IN NUMBER,
131 p_funmode IN VARCHAR2,
132 p_result OUT NOCOPY VARCHAR2);
133
134 PROCEDURE SetPersonAs(p_preparer_id IN NUMBER,
135 p_item_type IN VARCHAR2,
136 p_item_key IN VARCHAR2,
137 p_preparer_target IN VARCHAR2);
138
139 PROCEDURE CheckAPApproved(itemtype in varchar2,
140 itemkey in varchar2,
141 actid in number,
142 funcmode in varchar2,
143 resultout in out NOCOPY varchar2);
144
145 FUNCTION GetUserIdForEmp(p_emp_user_name IN VARCHAR2,
146 p_user_id OUT NOCOPY NUMBER
147 ) RETURN BOOLEAN;
148
149 PROCEDURE ClearItemkeyCCTrx(itemtype in varchar2,
150 itemkey in varchar2,
151 actid in number,
152 funcmode in varchar2,
153 resultout in out NOCOPY varchar2);
154
155 END AP_WEB_INACTIVE_EMP_WF_PKG;