DBA Data[Home] [Help]

APPS.OKC_ACTIONS_PVT dependencies on OKC_API

Line 14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

10:
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ACTIONS_PVT';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
16: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
17: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
18: ---------------------------------------------------------------------------

Line 35: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

31:
32: -- Object type procedure for Create
33: PROCEDURE create_actions(
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
36: x_return_status OUT NOCOPY VARCHAR2,
37: x_msg_count OUT NOCOPY NUMBER,
38: x_msg_data OUT NOCOPY VARCHAR2,
39: p_acnv_rec IN acnv_rec_type,

Line 49: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

45: -- (table version)
46:
47: PROCEDURE create_actions(
48: p_api_version IN NUMBER,
49: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,
52: x_msg_data OUT NOCOPY VARCHAR2,
53: p_acnv_tbl IN acnv_tbl_type,

Line 65: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

61:
62: -- Object type procedure for Update
63: PROCEDURE update_actions(
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,
69: p_acnv_rec IN acnv_rec_type,

Line 80: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

76:
77: -- Object type procedure for Validate
78: PROCEDURE validate_actions(
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_acnv_rec IN acnv_rec_type,

Line 94: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

90: -- Routines to manage Actions
91:
92: PROCEDURE create_actions(
93: p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_msg_count OUT NOCOPY NUMBER,
97: x_msg_data OUT NOCOPY VARCHAR2,
98: p_acnv_tbl IN acnv_tbl_type,

Line 105: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

101: -- It calls OKC_ACN_PVT.insert_row
102:
103: PROCEDURE create_actions(
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_acnv_rec IN acnv_rec_type,

Line 116: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

112: -- It calls OKC_ACN_PVT.insert_row
113:
114: PROCEDURE lock_actions(
115: p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_acnv_tbl IN acnv_tbl_type);

Line 126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

122: -- It calls OKC_ACN_PVT.lock_row
123:
124: PROCEDURE lock_actions(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_acnv_rec IN acnv_rec_type);

Line 136: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

132: -- It calls OKC_ACN_PVT.lock_row
133:
134: PROCEDURE update_actions(
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_acnv_tbl IN acnv_tbl_type,

Line 147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

143: -- It calls OKC_ACN_PVT.update_row
144:
145: PROCEDURE update_actions(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_acnv_rec IN acnv_rec_type,

Line 158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

154: -- It calls OKC_ACN_PVT.update_row
155:
156: PROCEDURE delete_actions(
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_acnv_tbl IN acnv_tbl_type);

Line 168: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

164: -- Calls the record version due to business rule enforcement
165:
166: PROCEDURE delete_actions(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_acnv_rec IN acnv_rec_type);

Line 178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

174: -- It calls OKC_ACN_PVT.delete_row
175:
176: PROCEDURE validate_actions(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_acnv_tbl IN acnv_tbl_type);

Line 188: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

184: -- It calls OKC_ACN_PVT.validate_row
185:
186: PROCEDURE validate_actions(
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_acnv_rec IN acnv_rec_type);

Line 200: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

196: -- Routines to manage Action Attributes
197:
198: PROCEDURE create_act_atts(
199: p_api_version IN NUMBER,
200: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_aaev_tbl IN aaev_tbl_type,

Line 212: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

208: -- rule enforcement
209:
210: PROCEDURE create_act_atts(
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_aaev_rec IN aaev_rec_type,

Line 223: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

219: -- It calls the OKC_AAE_PVT.insert_row
220:
221: PROCEDURE lock_act_atts(
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2,
227: p_aaev_tbl IN aaev_tbl_type);

Line 233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

229: -- It calls the OKC_AAE_PVT.lock_row
230:
231: PROCEDURE lock_act_atts(
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_msg_data OUT NOCOPY VARCHAR2,
237: p_aaev_rec IN aaev_rec_type);

Line 243: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

239: -- It calls the OKC_AAE_PVT.lock_row
240:
241: PROCEDURE update_act_atts(
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2,
247: p_aaev_tbl IN aaev_tbl_type,

Line 254: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

250: -- It calls the OKC_AAE_PVT.update_row
251:
252: PROCEDURE update_act_atts(
253: p_api_version IN NUMBER,
254: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,
257: x_msg_data OUT NOCOPY VARCHAR2,
258: p_aaev_rec IN aaev_rec_type,

Line 265: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

261: -- It calls the OKC_AAE_PVT.update_row
262:
263: PROCEDURE delete_act_atts(
264: p_api_version IN NUMBER,
265: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,
268: x_msg_data OUT NOCOPY VARCHAR2,
269: p_aaev_tbl IN aaev_tbl_type);

Line 275: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

271: -- It calls the OKC_AAE_PVT.delete_row
272:
273: PROCEDURE delete_act_atts(
274: p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
278: x_msg_data OUT NOCOPY VARCHAR2,
279: p_aaev_rec IN aaev_rec_type);

Line 285: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

281: -- It calls the OKC_AAE_PVT.delete_row
282:
283: PROCEDURE validate_act_atts(
284: p_api_version IN NUMBER,
285: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
286: x_return_status OUT NOCOPY VARCHAR2,
287: x_msg_count OUT NOCOPY NUMBER,
288: x_msg_data OUT NOCOPY VARCHAR2,
289: p_aaev_tbl IN aaev_tbl_type);

Line 295: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

291: -- It calls the OKC_AAE_PVT.validate_row
292:
293: PROCEDURE validate_act_atts(
294: p_api_version IN NUMBER,
295: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: p_aaev_rec IN aaev_rec_type);