APPS.OKC_NUMBER_SCHEMES_PVT dependencies on OKC_NUMBER_SCHEMES_B

Line 16: cursor C is select ROWID from OKC_NUMBER_SCHEMES_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from OKC_NUMBER_SCHEMES_B
17: where NUM_SCHEME_ID = X_NUM_SCHEME_ID
18: ;
19:
20: l_return_status VARCHAR2(30);

Line 26: insert into OKC_NUMBER_SCHEMES_B (

22: l_msg_data VARCHAR2(2000);
23: l_out_string VARCHAR2(2000);
24:
25: begin
26: insert into OKC_NUMBER_SCHEMES_B (
27: NUM_SCHEME_ID,
28: NUMBER_ARTICLE_YN,
29: OBJECT_VERSION_NUMBER,
30: CREATION_DATE,

Line 111: from OKC_NUMBER_SCHEMES_B

107: ) is
108: cursor c is select
109: NUMBER_ARTICLE_YN,
110: OBJECT_VERSION_NUMBER
111: from OKC_NUMBER_SCHEMES_B
112: where NUM_SCHEME_ID = X_NUM_SCHEME_ID
113: for update of NUM_SCHEME_ID nowait;
114: recinfo c%rowtype;
115:

Line 173: update OKC_NUMBER_SCHEMES_B set

169: l_msg_count NUMBER;
170: l_msg_data VARCHAR2(2000);
171: l_out_string VARCHAR2(2000);
172: begin
173: update OKC_NUMBER_SCHEMES_B set
174: NUMBER_ARTICLE_YN = X_NUMBER_ARTICLE_YN,
175: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
176: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
177: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 235: delete from OKC_NUMBER_SCHEMES_B

231: -- remove child records from okc_number_scheme_dtls
232: delete from okc_number_scheme_dtls
233: where NUM_SCHEME_ID = X_NUM_SCHEME_ID;
234:
235: delete from OKC_NUMBER_SCHEMES_B
236: where NUM_SCHEME_ID = X_NUM_SCHEME_ID;
237:
238: if (sql%notfound) then
239: raise no_data_found;

Line 249: from OKC_NUMBER_SCHEMES_B B

245: begin
246: delete from OKC_NUMBER_SCHEMES_TL T
247: where not exists
248: (select NULL
249: from OKC_NUMBER_SCHEMES_B B
250: where B.NUM_SCHEME_ID = T.NUM_SCHEME_ID
251: );
252:
253: update OKC_NUMBER_SCHEMES_TL T set (