APPS.OKE_COMMUNICATION_PKG dependencies on OKE_K_COMMUNICATIONS

Line 91: from OKE_K_COMMUNICATIONS

87: attribute12,
88: attribute13,
89: attribute14,
90: attribute15
91: from OKE_K_COMMUNICATIONS
92: where k_header_id = X_k_header_id
93: and communication_num = X_communication_num
94: for update of k_header_id, communication_num nowait;
95:

Line 242: x_prev_action_code OKE_K_COMMUNICATIONS.action_code%TYPE;

238: X_Attribute15 VARCHAR2
239:
240: ) is
241:
242: x_prev_action_code OKE_K_COMMUNICATIONS.action_code%TYPE;
243:
244: cursor C is
245: select wf_item_type
246: , wf_process

Line 248: from OKE_K_COMMUNICATIONS

244: cursor C is
245: select wf_item_type
246: , wf_process
247: , wf_item_key
248: from OKE_K_COMMUNICATIONS
249: where k_header_id = X_k_header_id
250: and communication_num = X_communication_num;
251:
252: cursor C_prev is

Line 254: from OKE_K_COMMUNICATIONS

250: and communication_num = X_communication_num;
251:
252: cursor C_prev is
253: select action_code
254: from OKE_K_COMMUNICATIONS
255: where k_header_id = X_k_header_id
256: and communication_num = X_communication_num;
257:
258: begin

Line 264: update OKE_K_COMMUNICATIONS

260: fetch c_prev into X_prev_action_code;
261: close c_prev;
262:
263:
264: update OKE_K_COMMUNICATIONS
265: set
266: communication_date = X_communication_date,
267: type = X_type,
268: reason_code = X_reason_code,

Line 400: from OKE_K_COMMUNICATIONS

396: select rowid
397: , wf_item_type
398: , wf_process
399: , wf_item_key
400: from OKE_K_COMMUNICATIONS
401: where k_header_id = X_k_header_id
402: and communication_num = X_communication_num;
403:
404: begin

Line 406: insert into OKE_K_COMMUNICATIONS(

402: and communication_num = X_communication_num;
403:
404: begin
405:
406: insert into OKE_K_COMMUNICATIONS(
407: k_header_id,
408: communication_num,
409: communication_date,
410: type,

Line 538: DELETE FROM OKE_K_COMMUNICATIONS

534:
535: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
536: BEGIN
537:
538: DELETE FROM OKE_K_COMMUNICATIONS
539: WHERE rowid = X_Rowid;
540:
541: if (SQL%NOTFOUND) then
542: Raise NO_DATA_FOUND;