DBA Data[Home] [Help]

PACKAGE: APPS.OKL_SO_CREDIT_APP_WF

Source


1 PACKAGE OKL_SO_CREDIT_APP_WF AUTHID CURRENT_USER AS
2 /* $Header: OKLRCRQS.pls 115.7 2003/04/17 18:30:35 rgalipo noship $ */
3   ---------------------------------------------------------------------------
4   -- GLOBAL DATASTRUCTURES
5   ---------------------------------------------------------------------------
6 
7   G_CREDIT_CHKLST_TPL CONSTANT VARCHAR2(30) := 'LACCLH';
8   G_CREDIT_CHKLST_TPL_RULE1 CONSTANT VARCHAR2(30) := 'LACCLT';
9   G_CREDIT_CHKLST_TPL_RULE2 CONSTANT VARCHAR2(30) := 'LACCLD';
10 
11   TYPE l_chr_rec IS RECORD
12       (party_id          NUMBER
13       ,cust_acct_id      NUMBER
14       ,cust_acct_site_id NUMBER
15       ,site_use_id       NUMBER
16       ,contract_id       NUMBER
17       ,credit_khr_id     NUMBER
18       ,currency          VARCHAR2(15)
19       ,txn_amount        NUMBER
20       ,requested_amount  NUMBER
21       ,term              NUMBER
22       ,party_contact_id  NUMBER
23       ,org_id            NUMBER
24       );
25 
26   ---------------------------------------------------------------------------
27 
28   PROCEDURE create_credit_app_event
29 ( p_quote_id   IN NUMBER,
30   p_requestor_id IN NUMBER,
31   x_return_status OUT NOCOPY VARCHAR2);
32 
33   procedure create_credit_app ( itemtype	in varchar2,
34 				itemkey  	in varchar2,
35 				actid		in number,
36 				funcmode	in varchar2,
37 				resultout out nocopy varchar2	);
38 
39    procedure CREATE_CREDIT_LINE ( itemtype	in varchar2,
40 				itemkey  	in varchar2,
41 				actid		in number,
42 				funcmode	in varchar2,
43 				resultout out nocopy varchar2);
44 
45      procedure UPDATE_STATUS ( itemtype	in varchar2,
46 				itemkey  	in varchar2,
47 				actid		in number,
48 				funcmode	in varchar2,
49 				resultout out nocopy varchar2);
50 
51 
52     procedure send_message ( itemtype	in varchar2,
53 				itemkey  	in varchar2,
54 				actid		in number,
55 				funcmode	in varchar2,
56 				resultout out nocopy varchar2	);
57 
58   PROCEDURE SET_REQUESTOR(itemtype  IN VARCHAR2,
59                           itemkey   IN VARCHAR2,
60                           actid     IN NUMBER,
61                           funcmode  IN VARCHAR2,
62                           resultout OUT NOCOPY VARCHAR2);
63 
64   PROCEDURE SET_APPROVER (itemtype  IN VARCHAR2,
65                           itemkey   IN VARCHAR2,
66                           actid     IN NUMBER,
67                           funcmode  IN VARCHAR2,
68                           resultout OUT NOCOPY VARCHAR2);
69 
70   PROCEDURE CREDIT_APP_DETAILS( itemtype  IN VARCHAR2,
71                           itemkey   IN VARCHAR2,
72                           actid     IN NUMBER,
73                           funcmode  IN VARCHAR2,
74                           resultout OUT NOCOPY VARCHAR2);
75 
76   PROCEDURE CREDIT_K_END_DATED
77                          (itemtype  IN VARCHAR2,
78                           itemkey   IN VARCHAR2,
79                           actid     IN NUMBER,
80                           funcmode  IN VARCHAR2,
81                           resultout OUT NOCOPY VARCHAR2);
82 
83 END OKL_SO_CREDIT_APP_WF;