[Home] [Help]
PACKAGE: APPS.OKS_REPRICE_PVT
Source
1 PACKAGE OKS_REPRICE_PVT AS
2 /* $Header: OKSRRPRS.pls 120.1.12000000.1 2007/01/16 22:11:53 appldev ship $*/
3
4 -- GLOBAL VARIABLES
5 -------------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_REPRICE_PVT';
7 G_APP_NAME_OKS CONSTANT VARCHAR2(3) := 'OKS';
8 G_APP_NAME_OKC CONSTANT VARCHAR2(3) := 'OKC';
9 -------------------------------------------------------------------------------
10
11
12 -- GLOBAL_MESSAGE_CONSTANTS
13 ---------------------------------------------------------------------------------------------
14 G_TRUE CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
15 G_FALSE CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
16 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
17 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
18 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
19 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKS_UNEXPECTED_ERROR';
20 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'ERROR_MESSAGE';
21 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'ERROR_CODE';
22 G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := OKC_API.G_REQUIRED_VALUE;
23 G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKC_API.G_COL_NAME_TOKEN;
24 ---------------------------------------------------------------------------------------------
25
26 -- GLOBAL EXCEPTION
27 ---------------------------------------
28 G_ERROR EXCEPTION;
29 G_SKIP_PRORATION EXCEPTION;
30 G_BUILD_RECORD_FAILED EXCEPTION;
31 ---------------------------------------
32
33 TYPE REPRICE_REC_TYPE IS RECORD
34 (
35 Contract_Id Number,
36 Price_List_Id Number,
37 Price_Type Varchar2(3),
38 Markup_Percent Number
39 );
40
41 TYPE SUB_LINE_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
42
43 PROCEDURE CALL_PRICING_API(
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2,
46 p_id IN NUMBER,
47 p_id_type IN VARCHAR2,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2
51 );
52
53 PROCEDURE CALL_PRICING_API(
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2,
56 p_reprice_rec IN REPRICE_REC_TYPE,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2
60 );
61
62 PROCEDURE CALL_PRICING_API(
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_subject_chr_id IN NUMBER,
69 p_subject_top_line_id IN NUMBER,
70 p_subject_sub_line_tbl IN sub_line_tbl_type
71 );
72
73 END OKS_REPRICE_PVT;