DBA Data[Home] [Help]

PACKAGE: APPS.OKL_LEASE_QUOTE_WORKFLOW_PVT

Source


1 PACKAGE OKL_LEASE_QUOTE_WORKFLOW_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRQUWS.pls 120.1 2005/11/23 10:41:46 viselvar noship $ */
3 
4   --------------------
5   -- PACKAGE CONSTANTS
6   --------------------
7   G_PKG_NAME             CONSTANT VARCHAR2(30)  := 'OKL_LEASE_QUOTE_WORKFLOW_PVT';
8   G_APP_NAME             CONSTANT VARCHAR2(30)  := OKL_API.G_APP_NAME;
9   G_API_VERSION          CONSTANT NUMBER        := 1;
10   G_USER_ID              CONSTANT NUMBER        := FND_GLOBAL.USER_ID;
11   G_LOGIN_ID             CONSTANT NUMBER        := FND_GLOBAL.LOGIN_ID;
12   G_FALSE                CONSTANT VARCHAR2(1)   := FND_API.G_FALSE;
13   G_TRUE                 CONSTANT VARCHAR2(1)   := FND_API.G_TRUE;
14   G_RET_STS_SUCCESS      CONSTANT VARCHAR2(1)   := FND_API.G_RET_STS_SUCCESS;
15   G_RET_STS_UNEXP_ERROR  CONSTANT VARCHAR2(1)   := FND_API.G_RET_STS_UNEXP_ERROR;
16   G_RET_STS_ERROR        CONSTANT VARCHAR2(1)   := FND_API.G_RET_STS_ERROR;
17   G_UNEXPECTED_ERROR     CONSTANT VARCHAR2(25)  := 'OKL_QUOTE_UNEXP_ERROR';
18   G_DB_ERROR             CONSTANT VARCHAR2(30)  := 'OKL_DB_ERROR';
19   G_PKG_NAME_TOKEN       CONSTANT VARCHAR2(30)  := 'PKG_NAME';
20   G_PROG_NAME_TOKEN      CONSTANT VARCHAR2(30)  := 'PROG_NAME';
21   G_SQLCODE_TOKEN        CONSTANT VARCHAR2(30)  := 'SQLCODE';
22   G_SQLERRM_TOKEN        CONSTANT VARCHAR2(30)  := 'SQLERRM';
23 
24   ----------------
25   -- PROGRAM UNITS
26   ----------------
27 
28   PROCEDURE raise_quote_accept_event (p_quote_id      IN NUMBER,
29                                       x_return_status OUT NOCOPY VARCHAR2);
30 
31   PROCEDURE populate_accept_attribs(itemtype   IN  VARCHAR2,
32                                 	itemkey    IN  VARCHAR2,
33                                     actid      IN  NUMBER,
34                                     funcmode   IN  VARCHAR2,
35                                     resultout  OUT NOCOPY VARCHAR2);
36 
37   PROCEDURE raise_quote_submit_event (p_quote_id      IN  NUMBER,
38                                       x_return_status OUT NOCOPY VARCHAR2);
39 
40   PROCEDURE populate_submit_attribs(itemtype  IN VARCHAR2,
41                                 	itemkey   IN VARCHAR2,
42                                     actid     IN NUMBER,
43                                     funcmode  IN VARCHAR2,
44                                     resultout OUT NOCOPY VARCHAR2);
45   -- procedure to check the approval process
46   PROCEDURE check_approval_process(itemtype	IN VARCHAR2
47                                     ,itemkey  	IN VARCHAR2
48 	                            ,actid      IN NUMBER
49 	                            ,funcmode	IN VARCHAR2
50 	                            ,resultout OUT NOCOPY VARCHAR2);
51 
52   -- Get the message body for Lease Quotes
53   PROCEDURE get_quote_msg_doc(document_id   IN VARCHAR2,
54                           display_type  IN VARCHAR2,
55                           document      IN OUT nocopy VARCHAR2,
56                           document_type IN OUT nocopy VARCHAR2);
57 
58   -- populate the quote attributes
59   PROCEDURE populate_quote_attr(itemtype IN VARCHAR2,
60                                 itemkey IN VARCHAR2,
61                                 actid IN NUMBER,
62                                 funcmode IN VARCHAR2,
63                                 resultout OUT NOCOPY VARCHAR2);
64 
65   -- handle the quote approval process
66   PROCEDURE handle_approval(itemtype   IN  VARCHAR2,
67                             itemkey    IN  VARCHAR2,
68                             actid      IN  NUMBER,
69                             funcmode   IN  VARCHAR2,
70                             resultout  OUT NOCOPY VARCHAR2);
71 END OKL_LEASE_QUOTE_WORKFLOW_PVT;