[Home] [Help]
PACKAGE: APPS.OKL_GTL_PVT
Source
1 PACKAGE OKL_GTL_PVT AS
2 /* $Header: OKLSGTLS.pls 120.2 2006/07/11 10:19:28 dkagrawa noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7
8 TYPE gtl_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 ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
12 ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13 ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
14 ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
15 ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16 ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
17 ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
18 ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
19 ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
20 ,last_update_date OKL_ST_GEN_TMPT_LNS.last_update_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
21 ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
22 );
23
24
25 G_MISS_GTL_REC gtl_rec_type;
26 TYPE gtl_tbl_type IS TABLE OF gtl_rec_type
27 INDEX BY BINARY_INTEGER;
28
29 TYPE gtlv_rec_type IS RECORD (
30 id NUMBER DEFAULT Okl_Api.G_MISS_NUM
31 ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
32 ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
33 ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
34 ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35 ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
36 ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37 ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
38 ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
39 ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
40 ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
41 ,last_update_date OKL_ST_GEN_TMPT_LNS.last_update_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
42 ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
43 );
44
45
46 G_MISS_GTLV_REC gtlv_rec_type;
47 TYPE gtlv_tbl_type IS TABLE OF gtlv_rec_type
48 INDEX BY BINARY_INTEGER;
49
50 ---------------------------------------------------------------------------
51 -- GLOBAL VARIABLES
52 ---------------------------------------------------------------------------
53 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_GTL_PVT';
54 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
55 --------------------------------------------------------------------------------
56 -- ERRORS AND EXCEPTIONS
57 --------------------------------------------------------------------------------
58 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
59 ---------------------------------------------------------------------------
60 -- GLOBAL MESSAGE CONSTANTS
61 ---------------------------------------------------------------------------
62 -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM'
63 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
64 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
65 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
66 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
67 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
68 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
69 ---------------------------------------------------------------------------
70 -- Procedures and Functions
71 ---------------------------------------------------------------------------
72 PROCEDURE qc;
73 PROCEDURE change_version;
74 PROCEDURE api_copy;
75
76
77 PROCEDURE insert_row(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_gtlv_rec IN gtlv_rec_type,
84 x_gtlv_rec OUT NOCOPY gtlv_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_gtlv_tbl IN gtlv_tbl_type,
93 x_gtlv_tbl OUT NOCOPY gtlv_tbl_type);
94
95 PROCEDURE update_row(
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_gtlv_rec IN gtlv_rec_type,
102 x_gtlv_rec OUT NOCOPY gtlv_rec_type);
103
104 PROCEDURE update_row(
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 p_gtlv_tbl IN gtlv_tbl_type,
111 x_gtlv_tbl OUT NOCOPY gtlv_tbl_type);
112
113 PROCEDURE delete_row(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_gtlv_rec IN gtlv_rec_type);
120
121 PROCEDURE delete_row(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_gtlv_tbl IN gtlv_tbl_type);
128
129 END okl_gtl_pvt;