[Home] [Help]
PACKAGE: APPS.OKC_RDS_PVT
Source
1 Package OKC_RDS_PVT AS
2 /* $Header: OKCSRDSS.pls 120.0 2005/05/25 22:47:10 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE rds_rec_type IS RECORD (
7 rgr_rgd_code OKC_RULE_DEF_SOURCES.RGR_RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
8 rgr_rdf_code OKC_RULE_DEF_SOURCES.RGR_RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
9 buy_or_sell OKC_RULE_DEF_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
10 access_level OKC_RULE_DEF_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
11 start_date OKC_RULE_DEF_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
12 end_date OKC_RULE_DEF_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
13 jtot_object_code OKC_RULE_DEF_SOURCES.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
14 object_id_number NUMBER := OKC_API.G_MISS_NUM,
15 object_version_number NUMBER := OKC_API.G_MISS_NUM,
16 created_by NUMBER := OKC_API.G_MISS_NUM,
17 creation_date OKC_RULE_DEF_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19 last_update_date OKC_RULE_DEF_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20 last_update_login NUMBER := OKC_API.G_MISS_NUM);
21 g_miss_rds_rec rds_rec_type;
22 TYPE rds_tbl_type IS TABLE OF rds_rec_type
23 INDEX BY BINARY_INTEGER;
24 TYPE rdsv_rec_type IS RECORD (
25 row_id ROWID,
26 jtot_object_code OKC_RULE_DEF_SOURCES_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
27 rgr_rgd_code OKC_RULE_DEF_SOURCES_V.RGR_RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
28 rgr_rdf_code OKC_RULE_DEF_SOURCES_V.RGR_RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
29 buy_or_sell OKC_RULE_DEF_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
30 access_level OKC_RULE_DEF_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
31 start_date OKC_RULE_DEF_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
32 end_date OKC_RULE_DEF_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
33 object_version_number NUMBER := OKC_API.G_MISS_NUM,
34 object_id_number NUMBER := OKC_API.G_MISS_NUM,
35 created_by NUMBER := OKC_API.G_MISS_NUM,
36 creation_date OKC_RULE_DEF_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
38 last_update_date OKC_RULE_DEF_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
39 last_update_login NUMBER := OKC_API.G_MISS_NUM);
40 g_miss_rdsv_rec rdsv_rec_type;
41 TYPE rdsv_tbl_type IS TABLE OF rdsv_rec_type
42 INDEX BY BINARY_INTEGER;
43 ---------------------------------------------------------------------------
44 -- GLOBAL MESSAGE CONSTANTS
45 ---------------------------------------------------------------------------
46 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
47 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
48 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
49 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
50 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
51 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
52 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
53 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
54 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
55 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
56 ---------------------------------------------------------------------------
57 -- GLOBAL VARIABLES
58 ---------------------------------------------------------------------------
59 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_RDS_PVT';
60 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
61 ---------------------------------------------------------------------------
62 -- Procedures and Functions
63 ---------------------------------------------------------------------------
64
65 PROCEDURE qc;
66 PROCEDURE change_version;
67 PROCEDURE api_copy;
68 PROCEDURE insert_row(
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_rdsv_rec IN rdsv_rec_type,
75 x_rdsv_rec OUT NOCOPY rdsv_rec_type);
76
77 PROCEDURE insert_row(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_rdsv_tbl IN rdsv_tbl_type,
84 x_rdsv_tbl OUT NOCOPY rdsv_tbl_type);
85
86 PROCEDURE lock_row(
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_rdsv_rec IN rdsv_rec_type);
93
94 PROCEDURE lock_row(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_rdsv_tbl IN rdsv_tbl_type);
101
102 PROCEDURE update_row(
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 p_rdsv_rec IN rdsv_rec_type,
109 x_rdsv_rec OUT NOCOPY rdsv_rec_type);
110
111 PROCEDURE update_row(
112 p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2,
117 p_rdsv_tbl IN rdsv_tbl_type,
118 x_rdsv_tbl OUT NOCOPY rdsv_tbl_type);
119
120 PROCEDURE delete_row(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_rdsv_rec IN rdsv_rec_type);
127
128 PROCEDURE delete_row(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_rdsv_tbl IN rdsv_tbl_type);
135
136 PROCEDURE validate_row(
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_rdsv_rec IN rdsv_rec_type);
143
144 PROCEDURE validate_row(
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_rdsv_tbl IN rdsv_tbl_type);
151
152 END OKC_RDS_PVT;