1 PACKAGE HR_SFLUTIL_SS AS
2 /* $Header: hrsflutlss.pkh 120.2 2006/12/04 13:27:26 rachakra noship $ */
3
4 procedure sflBlock
5 (itemtype in varchar2
6 ,itemkey in varchar2
7 ,actid in number
8 ,funmode in varchar2
9 ,result in out nocopy varchar2);
10
11
12 procedure closeSFLNotifications(p_transaction_id IN NUMBER
13 ,p_approvalItemType in varchar2
14 ,p_approvalItemKey in varchar2);
15
16 procedure closeSFLTransaction
17 (itemtype in varchar2
18 ,itemkey in varchar2
19 ,actid in number
20 ,funmode in varchar2
21 ,result in out nocopy varchar2);
22
23 procedure Notify(itemtype in varchar2,
24 itemkey in varchar2,
25 actid in number,
26 funcmode in varchar2,
27 resultout in out nocopy varchar2);
28
29 procedure getSFLMsgSubject(document_id IN Varchar2,
30 display_type IN Varchar2,
31 document IN OUT NOCOPY varchar2,
32 document_type IN OUT NOCOPY Varchar2) ;
33
34 procedure getSFLTransactionDetails (
35 p_transaction_id IN NUMBER
36 ,p_ntfId OUT NOCOPY NUMBER
37 ,p_itemType IN OUT NOCOPY VARCHAR2
38 ,p_itemKey OUT NOCOPY VARCHAR2 );
39
40 procedure sendSFLNotification(p_transaction_id IN NUMBER,
41 p_transaction_ref_table in varchar2,
42 p_userName in varchar2,
43 p_reentryPageFunction in varchar2,
44 p_sflWFProcessName in varchar2,
45 p_notification_id out NOCOPY number);
46
47 procedure setSFLNtfDetails
48 (itemtype in varchar2
49 ,itemkey in varchar2
50 ,actid in number
51 ,funmode in varchar2
52 ,result in out nocopy varchar2);
53
54
55 function getSubject(p_transaction_id in number,
56 p_notification_id in number) return varchar2;
57
58 function isTxnOwner(p_transaction_id in number,
59 p_person_id in number) return boolean;
60
61 function getSFLStatusForUpdate(
62 p_currentTxnStatus in varchar2,
63 p_proposedTxnStatus in varchar2) RETURN VARCHAR2;
64
65 function OpenNotificationsExist( nid in Number ) return Boolean;
66
67 procedure processApprovalSubmit(p_transaction_id in number);
68
69 procedure closeOpenSFLNotification(p_transaction_id IN NUMBER);
70
71 --5672792
72 function isCurrentTxnSFLClose ( p_transaction_id hr_api_transactions.transaction_id%type )
73 return varchar2;
74 --5672792
75
76 END HR_SFLUTIL_SS;