[Home] [Help]
PACKAGE: APPS.OKL_INVOKE_PRICING_ENGINE_PVT
Source
1 PACKAGE Okl_Invoke_Pricing_Engine_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRSSMS.pls 115.10 2002/07/22 23:17:41 mvasudev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
8 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
9 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
10 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
11 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_INVOKE_PRICING_APP_PVT';
12
13
14 G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
15 G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
16 G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
17 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
18 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
19
20 G_EXC_NAME_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_ERROR';
21 G_EXC_NAME_UNEXP_ERROR CONSTANT VARCHAR2(50) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
22 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
23 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
24 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
25
26 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
27 G_EXCEPTION_ERROR EXCEPTION;
28 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
29
30 -- SET UP FOLLOWING in XML GATEWAY
31
32 G_XMLG_TRX_TYPE CONSTANT VARCHAR2(30) := 'OKL_ST';
33
34 -- 4/26/2002 -- mvasudev
35 G_XMLG_TRX_SUBTYPE_LS_BOOK_OUT CONSTANT VARCHAR2(30) := 'LSBO';
36 G_XMLG_TRX_SUBTYPE_LN_BOOK_OUT CONSTANT VARCHAR2(30) := 'LNBO';
37 G_XMLG_TRX_SUBTYPE_LS_REST_OUT CONSTANT VARCHAR2(30) := 'LSRO';
38 G_XMLG_TRX_SUBTYPE_LN_REST_OUT CONSTANT VARCHAR2(30) := 'LNRO';
39 G_XMLG_TRX_SUBTYPE_LS_BOOK_IN CONSTANT VARCHAR2(30) := 'LSBI';
40 G_XMLG_TRX_SUBTYPE_LN_BOOK_IN CONSTANT VARCHAR2(30) := 'LNBI';
41 G_XMLG_TRX_SUBTYPE_LS_REST_IN CONSTANT VARCHAR2(30) := 'LSRI';
42 G_XMLG_TRX_SUBTYPE_LN_REST_IN CONSTANT VARCHAR2(30) := 'LNRI';
43 -- end, 4/26/2002 -- mvasudev
44
45 -- 06/27/2002, sno
46 G_XMLG_TRX_SUBTYPE_LS_QUOT_OUT CONSTANT VARCHAR2(30) := 'LSQO';
47 G_XMLG_TRX_SUBTYPE_LN_QUOT_OUT CONSTANT VARCHAR2(30) := 'LNQO';
48 G_XMLG_TRX_SUBTYPE_LS_QUOT_IN CONSTANT VARCHAR2(30) := 'LSQI';
49 G_XMLG_TRX_SUBTYPE_LN_QUOT_IN CONSTANT VARCHAR2(30) := 'LNQI';
50
51
52 G_XMLG_SEND_EVENT CONSTANT VARCHAR2(50) := 'oracle.apps.okl.outbound.lease.send';
53
54 G_ECX_TRANSACTION_TYPE CONSTANT VARCHAR2(25) := 'ECX_TRANSACTION_TYPE';
55 G_ECX_TRANSACTION_SUBTYPE CONSTANT VARCHAR2(25) := 'ECX_TRANSACTION_SUBTYPE';
56 G_ECX_PARTY_ID CONSTANT VARCHAR2(25) := 'ECX_PARTY_ID';
57 G_ECX_PARTY_SITE_ID CONSTANT VARCHAR2(25) := 'ECX_PARTY_SITE_ID';
58 G_ECX_DOCUMENT_ID CONSTANT VARCHAR2(25) := 'ECX_DOCUMENT_ID';
59 G_ECX_PARAMETER1 CONSTANT VARCHAR2(25) := 'ECX_PARAMETER1';
60 G_ECX_PARAMETER2 CONSTANT VARCHAR2(25) := 'ECX_PARAMETER2';
61 G_ECX_PARAMETER3 CONSTANT VARCHAR2(25) := 'ECX_PARAMETER3';
62 G_ECX_PARAMETER4 CONSTANT VARCHAR2(25) := 'ECX_PARAMETER4';
63 G_ECX_PARAMETER5 CONSTANT VARCHAR2(25) := 'ECX_PARAMETER5';
64
65 G_FILENAME_PRE CONSTANT VARCHAR2(15) := 'OKLSTXMLG_';
66 G_FILENAME_EXT CONSTANT VARCHAR2(15) := '.log';
67
68 -- REMOVE THIS HARD-CODING, SELECT FROM HZ TABLES
69 --G_XMLG_PARTY_NAME CONSTANT VARCHAR2(30) := 'SuperTrump';
70 G_PRC_ENG_PROFILE CONSTANT VARCHAR2(30) := 'OKL_ST_PRCENG_NAME';
71
72 G_XMLG_PARTY_TYPE CONSTANT VARCHAR2(30) := 'ORGANIZATION';
73
74
75
76 ---------------------------------------------------------------------------
77 -- PRCODURE generate_streams_st
78 ---------------------------------------------------------------------------
79 PROCEDURE generate_streams_st(
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_xmlg_trx_type IN VARCHAR2,
86 p_xmlg_trx_sub_type IN VARCHAR2,
87 p_sifv_rec IN OKL_SIF_PVT.SIFV_REC_TYPE);
88
89
90 END Okl_Invoke_Pricing_Engine_Pvt;