PACKAGE: APPS.POS_SUPP_APPR

Source

1 package POS_SUPP_APPR AUTHID CURRENT_USER as
2 /* $Header: POSSPAPS.pls 120.3.12020000.3 2013/02/09 13:31:08 hvutukur ship $ */
3 
4 ameApplicationId     number :=177; /* ame is using POS id  */
5 ameTransactionType   varchar2(50) := 'POS_SUPP_APPR';  /* Transaction type used by ame */
6 wfItemType  varchar2(50) := 'POSSPAPP'; /* Workflow Item Type */
7 wfProcess varchar2(50) := 'POSSPAPP_PROCESS';  /* Workflow process name */
8 
9 fieldDelimiter    constant varchar2(1) := ',';
10 quoteChar         constant varchar2(1) := '\';
11 
12 
13 procedure INITIALIZE_WF(
14     itemtype  in varchar2,
15     itemkey   in varchar2,
16     actid     in number,
17     funcmode  in varchar2,
18     resultout in out nocopy varchar2);
19 
20 procedure IS_AME_ENABLED(
21     itemtype  in varchar2,
22     itemkey   in varchar2,
23     actid     in number,
24     funcmode  in varchar2,
25     resultout in out nocopy varchar2);
26 
27 procedure GET_NEXT_APPROVER(
28     itemtype  in varchar2,
29     itemkey   in varchar2,
30     actid     in number,
31     funcmode  in varchar2,
32     resultout in out nocopy varchar2);
33 
34 procedure SET_STATUS_REJECTED(
35     itemtype  in varchar2,
36     itemkey   in varchar2,
37     actid     in number,
38     funcmode  in varchar2,
39     resultout in out nocopy varchar2);
40 
41 PROCEDURE STARTWF_POSSPAPP(
42     suppid     IN  VARCHAR2,
43     suppname IN VARCHAR2,
44     requestor IN  VARCHAR2,
45     result in out nocopy varchar2,
46     processresult in out nocopy varchar2);
47 
48 procedure CHECK_IF_AME_ENABLED(
49     result in out nocopy varchar2);
50 
51 procedure GET_APPROVER_IN_WF(
52     suppid   in varchar2,
53     user_id  out nocopy varchar2,
54     user_name out nocopy varchar2,
55     user_firstname out nocopy varchar2,
56     user_lastname out nocopy varchar2,
57     status in out nocopy varchar2);
58 
59 procedure CHECK_IF_APPROVER(
60     suppid   in varchar2,
61     approver  in varchar2,
62     result in out nocopy varchar2);
63 
64 procedure PROCESS_APPROVE(
65     suppid   in varchar2,
66     approver  in varchar2,
67     result in out nocopy varchar2,
68     processresult in out nocopy varchar2);
69 
70 procedure PROCESS_REJECT(
71     suppid   in varchar2,
72     approver  in varchar2,
73     result in out nocopy varchar2,
74     processresult in out nocopy varchar2);
75 
76 procedure GET_AME_PROCESS_STATUS(
77     suppid   in varchar2,
78     result in out nocopy varchar2);
79 
80 procedure get_ame_approval_list_history(
81     pProspSupplierId        IN  VARCHAR2,
82     pApprovalListStr    OUT NOCOPY VARCHAR2,
83     pApprovalListCount  OUT NOCOPY NUMBER,
84     pQuoteChar          OUT NOCOPY VARCHAR2,
85     pFieldDelimiter     OUT NOCOPY VARCHAR2);
86 
87 procedure Process_Response_Internal(
88     suppid      in varchar2,
89     p_response  in varchar2 );
90 
91 function CHECK_CURRENT_APPROVER(
92     suppid   in varchar2)
93 return VARCHAR2;
94 
95 function GET_APPROVER_NAME_IN_WF(
96     suppid   in varchar2) return varchar2;
97 
98 end POS_SUPP_APPR;