[Home] [Help]
PACKAGE: APPS.OKL_FULFILLMENT_PVT
Source
1 PACKAGE OKL_FULFILLMENT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRFULS.pls 115.7 2002/07/30 21:19:44 rfedane noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 G_MULTIPLE_FM_SERVERS CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_MULTIPLE_FM_SERVERS';
8 G_SERVER CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_FM_SERVER';
9 G_NO_FM_SERVER CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_FM_SERVER_NOT_FOUND';
10
11
12 ---------------------------------------------------------------------------
13 -- GLOBAL CONSTANTS
14 ---------------------------------------------------------------------------
15 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FULFILLMENT_PVT';
16 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
17 G_API_VERSION CONSTANT NUMBER := 1;
18 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
19 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
20 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
21
22 G_COMMIT CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
23 G_INIT_MSG_LIST CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
24 G_VALIDATION_LEVEL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
25
26
27 ---------------------------------------------------------------------------
28 -- Procedures and Functions
29 ---------------------------------------------------------------------------
30 PROCEDURE create_fulfillment (p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
32 p_agent_id IN NUMBER,
33 p_server_id IN NUMBER,
34 p_content_id IN NUMBER,
35 p_from IN VARCHAR2,
36 p_subject IN VARCHAR2,
37 p_email IN VARCHAR2,
38 p_bind_var IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
39 p_bind_val IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
40 p_bind_var_type IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
41 p_commit IN VARCHAR2,
42 x_request_id OUT NOCOPY NUMBER,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2);
46
47
48 END OKL_FULFILLMENT_PVT;