APPS.OKE_RLE_PVT dependencies on OKE_K_RELATED_ENTITIES

Line 503: INSERT INTO OKE_K_RELATED_ENTITIES(

499: RAISE OKE_API.G_EXCEPTION_ERROR;
500: END IF;
501:
502:
503: INSERT INTO OKE_K_RELATED_ENTITIES(
504:
505: K_HEADER_ID ,
506: CHG_REQUEST_ID ,
507: RELATED_ENTITY_ID ,

Line 534: FROM OKE_K_RELATED_ENTITIES

530: -- Set OUT values
531: x_rle_rec := l_def_rle_rec;
532:
533: SELECT rowid INTO x_rle_rec.ROW_ID
534: FROM OKE_K_RELATED_ENTITIES
535: WHERE K_HEADER_ID=x_rle_rec.K_HEADER_ID
536: AND
537: (CHG_REQUEST_ID = x_rle_rec.CHG_REQUEST_ID
538: OR

Line 774: UPDATE OKE_K_RELATED_ENTITIES

770: RAISE OKE_API.G_EXCEPTION_ERROR;
771: END IF;
772:
773:
774: UPDATE OKE_K_RELATED_ENTITIES
775: SET
776: K_HEADER_ID = l_def_rle_rec.K_HEADER_ID,
777: CHG_REQUEST_ID = l_def_rle_rec.CHG_REQUEST_ID,
778: RELATED_ENTITY_ID = l_def_rle_rec.RELATED_ENTITY_ID,

Line 937: DELETE FROM OKE_K_RELATED_ENTITIES

933: RAISE OKE_API.G_EXCEPTION_ERROR;
934: END IF;
935:
936:
937: DELETE FROM OKE_K_RELATED_ENTITIES
938: WHERE rowid = p_rle_rec.ROW_ID;
939:
940: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
941:

Line 1237: SELECT k_header_id,related_entity_id,related_entity_version FROM oke_k_related_entities a

1233: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1234:
1235:
1236: CURSOR lock_csr (p IN rle_rec_type) IS
1237: SELECT k_header_id,related_entity_id,related_entity_version FROM oke_k_related_entities a
1238: WHERE a.rowid = p.ROW_ID
1239:
1240: FOR UPDATE NOWAIT;
1241: