[Home] [Help]
PACKAGE: APPS.OKC_ATN_PVT
Source
1 Package OKC_ATN_PVT AS
2 /* $Header: OKCSATNS.pls 120.0 2005/05/25 22:54:31 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE atn_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 cat_id NUMBER := OKC_API.G_MISS_NUM,
9 rul_id NUMBER := OKC_API.G_MISS_NUM,
10 cle_id NUMBER := OKC_API.G_MISS_NUM,
11 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
12 object_version_number NUMBER := OKC_API.G_MISS_NUM,
13 created_by NUMBER := OKC_API.G_MISS_NUM,
14 creation_date OKC_ARTICLE_TRANS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16 last_update_date OKC_ARTICLE_TRANS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17 last_update_login NUMBER := OKC_API.G_MISS_NUM);
18 g_miss_atn_rec atn_rec_type;
19 TYPE atn_tbl_type IS TABLE OF atn_rec_type
20 INDEX BY BINARY_INTEGER;
21 TYPE atnv_rec_type IS RECORD (
22 id NUMBER := OKC_API.G_MISS_NUM,
23 object_version_number NUMBER := OKC_API.G_MISS_NUM,
24 cat_id NUMBER := OKC_API.G_MISS_NUM,
25 cle_id NUMBER := OKC_API.G_MISS_NUM,
26 rul_id NUMBER := OKC_API.G_MISS_NUM,
27 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
28 created_by NUMBER := OKC_API.G_MISS_NUM,
29 creation_date OKC_ARTICLE_TRANS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31 last_update_date OKC_ARTICLE_TRANS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32 last_update_login NUMBER := OKC_API.G_MISS_NUM);
33 g_miss_atnv_rec atnv_rec_type;
34 TYPE atnv_tbl_type IS TABLE OF atnv_rec_type
35 INDEX BY BINARY_INTEGER;
36 ---------------------------------------------------------------------------
37 -- GLOBAL MESSAGE CONSTANTS
38 ---------------------------------------------------------------------------
39 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
40 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
41 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
42 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
43 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
44 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
45 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
46 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
47 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
48 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
49 ---------------------------------------------------------------------------
50 -- GLOBAL VARIABLES
51 ---------------------------------------------------------------------------
52 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ATN_PVT';
53 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
54 ---------------------------------------------------------------------------
55 -- Procedures and Functions
56 ---------------------------------------------------------------------------
57
58 PROCEDURE qc;
59 PROCEDURE change_version;
60 PROCEDURE api_copy;
61 PROCEDURE insert_row(
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_atnv_rec IN atnv_rec_type,
68 x_atnv_rec OUT NOCOPY atnv_rec_type);
69
70 PROCEDURE insert_row(
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_atnv_tbl IN atnv_tbl_type,
77 x_atnv_tbl OUT NOCOPY atnv_tbl_type);
78
79 PROCEDURE lock_row(
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_atnv_rec IN atnv_rec_type);
86
87 PROCEDURE lock_row(
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_atnv_tbl IN atnv_tbl_type);
94
95 PROCEDURE update_row(
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_atnv_rec IN atnv_rec_type,
102 x_atnv_rec OUT NOCOPY atnv_rec_type);
103
104 PROCEDURE update_row(
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_atnv_tbl IN atnv_tbl_type,
111 x_atnv_tbl OUT NOCOPY atnv_tbl_type);
112
113 PROCEDURE delete_row(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_atnv_rec IN atnv_rec_type);
120
121 PROCEDURE delete_row(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_atnv_tbl IN atnv_tbl_type);
128
129 PROCEDURE validate_row(
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_atnv_rec IN atnv_rec_type);
136
137 PROCEDURE validate_row(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_atnv_tbl IN atnv_tbl_type);
144
145 FUNCTION create_version(
146 p_chr_id IN NUMBER,
147 p_major_version IN NUMBER) RETURN VARCHAR2;
148
149 FUNCTION restore_version(
150 p_chr_id IN NUMBER,
151 p_major_version IN NUMBER) RETURN VARCHAR2;
152
153 END OKC_ATN_PVT;