[Home] [Help]
PACKAGE: APPS.OKL_SPM_PVT
Source
1 PACKAGE OKL_SPM_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSSPMS.pls 120.3 2006/07/11 10:27:25 dkagrawa noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7 TYPE spm_rec_type IS RECORD (
8 id NUMBER DEFAULT Okl_Api.G_MISS_NUM
9 ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
10 ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
11 ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
12 ,name OKL_SIF_PRICING_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13 ,display_yn OKL_SIF_PRICING_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14 ,update_yn OKL_SIF_PRICING_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15 ,default_value OKL_SIF_PRICING_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16 ,parameter_value OKL_SIF_PRICING_PARAMS.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17 ,prc_eng_ident OKL_SIF_PRICING_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18 ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19 ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
20 ,creation_date OKL_SIF_PRICING_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
21 ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
22 ,last_update_date OKL_SIF_PRICING_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
23 ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
24 );
25
26 G_MISS_spm_REC spm_rec_type;
27 TYPE spm_tbl_type IS TABLE OF spm_rec_type
28 INDEX BY BINARY_INTEGER;
29
30 TYPE spmv_rec_type IS RECORD (
31 id NUMBER DEFAULT Okl_Api.G_MISS_NUM
32 ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
33 ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
34 ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35 ,name OKL_SIF_PRICING_PARAMS_V.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36 ,display_yn OKL_SIF_PRICING_PARAMS_V.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37 ,update_yn OKL_SIF_PRICING_PARAMS_V.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38 ,default_value OKL_SIF_PRICING_PARAMS_V.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39 ,parameter_value OKL_SIF_PRICING_PARAMS_V.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
40 ,prc_eng_ident OKL_SIF_PRICING_PARAMS_V.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
41 ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
42 ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
43 ,creation_date OKL_SIF_PRICING_PARAMS_V.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
44 ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
45 ,last_update_date OKL_SIF_PRICING_PARAMS_V.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
46 ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
47 );
48
49 G_MISS_spmv_REC spmv_rec_type;
50 TYPE spmv_tbl_type IS TABLE OF spmv_rec_type
51 INDEX BY BINARY_INTEGER;
52
53 ---------------------------------------------------------------------------
54 -- GLOBAL VARIABLES
55 ---------------------------------------------------------------------------
56 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SPM_PVT';
57 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
58 ---------------------------------------------------------------------------
59 -- ERRORS AND EXCEPTIONS
60 ---------------------------------------------------------------------------
61 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
62 ---------------------------------------------------------------------------
63 -- GLOBAL MESSAGE CONSTANTS
64 ---------------------------------------------------------------------------
65 -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM'
66 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
67 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
68 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
69 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
70 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
71 ---------------------------------------------------------------------------
72 -- Procedures and Functions
73 ---------------------------------------------------------------------------
74 PROCEDURE qc;
75 PROCEDURE change_version;
76 PROCEDURE api_copy;
77
78 PROCEDURE insert_row(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 p_spmv_rec IN spmv_rec_type);
85
86 PROCEDURE insert_row(
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_spmv_tbl IN spmv_tbl_type);
93
94 PROCEDURE update_row(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_spmv_rec IN spmv_rec_type);
101
102
103 PROCEDURE update_row(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 p_spmv_tbl IN spmv_tbl_type);
110
111 END; -- Package spec OKL_spm_PVT