[Home] [Help]
PACKAGE: APPS.OKL_GTP_PVT
Source
1 PACKAGE OKL_GTP_PVT AS
2 /* $Header: OKLSGTPS.pls 120.2 2006/07/11 10:19:46 dkagrawa noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7
8 TYPE gtp_rec_type IS RECORD (
9 id NUMBER DEFAULT Okl_Api.G_MISS_NUM
10 ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
11 ,name OKL_ST_GEN_PRC_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12 ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13 ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14 ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15 ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16 ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17 ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
18 ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
19 ,creation_date OKL_ST_GEN_PRC_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
20 ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
21 ,last_update_date OKL_ST_GEN_PRC_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
22 ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
23 ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
24 );
25
26
27 G_MISS_gtp_REC gtp_rec_type;
28 TYPE gtp_tbl_type IS TABLE OF gtp_rec_type
29 INDEX BY BINARY_INTEGER;
30
31 TYPE gtpv_rec_type IS RECORD (
32 id NUMBER DEFAULT Okl_Api.G_MISS_NUM
33 ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
34 ,name OKL_ST_GEN_PRC_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
35 ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36 ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37 ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38 ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39 ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
40 ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
41 ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
42 ,creation_date OKL_ST_GEN_PRC_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
43 ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
44 ,last_update_date OKL_ST_GEN_PRC_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
45 ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
46 ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
47 );
48
49
50 G_MISS_gtpv_REC gtpv_rec_type;
51 TYPE gtpv_tbl_type IS TABLE OF gtpv_rec_type
52 INDEX BY BINARY_INTEGER;
53
54 ---------------------------------------------------------------------------
55 -- GLOBAL VARIABLES
56 ---------------------------------------------------------------------------
57 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_GTP_PVT';
58 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
59 --------------------------------------------------------------------------------
60 -- ERRORS AND EXCEPTIONS
61 --------------------------------------------------------------------------------
62 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
63 ---------------------------------------------------------------------------
64 -- GLOBAL MESSAGE CONSTANTS
65 ---------------------------------------------------------------------------
66 -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM'
67 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
68 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
69 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
70 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
71 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
72 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
73 ---------------------------------------------------------------------------
74 -- Procedures and Functions
75 ---------------------------------------------------------------------------
76 PROCEDURE qc;
77 PROCEDURE change_version;
78 PROCEDURE api_copy;
79
80
81 PROCEDURE insert_row(
82 p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 p_gtpv_rec IN gtpv_rec_type,
88 x_gtpv_rec OUT NOCOPY gtpv_rec_type );
89
90 PROCEDURE insert_row(
91 p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2,
96 p_gtpv_tbl IN gtpv_tbl_type,
97 x_gtpv_tbl OUT NOCOPY gtpv_tbl_type);
98
99 PROCEDURE update_row(
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 p_gtpv_rec IN gtpv_rec_type,
106 x_gtpv_rec OUT NOCOPY gtpv_rec_type);
107
108 PROCEDURE update_row(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_gtpv_tbl IN gtpv_tbl_type,
115 x_gtpv_tbl OUT NOCOPY gtpv_tbl_type);
116
117 PROCEDURE delete_row(
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 p_gtpv_rec IN gtpv_rec_type);
124
125 PROCEDURE delete_row(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_gtpv_tbl IN gtpv_tbl_type);
132
133 END okl_gtp_pvt;