APPS.OKC_RESP_PARTIES_PKG dependencies on OKC_RESP_PARTIES_B

Line 19: cursor C is select ROWID from OKC_RESP_PARTIES_B

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from OKC_RESP_PARTIES_B
20: where DOCUMENT_TYPE_CLASS = X_DOCUMENT_TYPE_CLASS
21: and RESP_PARTY_CODE = X_RESP_PARTY_CODE
22: and INTENT = X_INTENT
23: ;

Line 25: insert into OKC_RESP_PARTIES_B (

21: and RESP_PARTY_CODE = X_RESP_PARTY_CODE
22: and INTENT = X_INTENT
23: ;
24: begin
25: insert into OKC_RESP_PARTIES_B (
26: OBJECT_VERSION_NUMBER,
27: DOCUMENT_TYPE_CLASS,
28: RESP_PARTY_CODE,
29: INTENT,

Line 110: from OKC_RESP_PARTIES_B

106: ) is
107: cursor c is select
108: OBJECT_VERSION_NUMBER,
109: INTERNAL_EXTERNAL_FLAG
110: from OKC_RESP_PARTIES_B
111: where DOCUMENT_TYPE_CLASS = X_DOCUMENT_TYPE_CLASS
112: and RESP_PARTY_CODE = X_RESP_PARTY_CODE
113: and INTENT = X_INTENT
114: for update of DOCUMENT_TYPE_CLASS nowait;

Line 179: update OKC_RESP_PARTIES_B set

175: X_LAST_UPDATED_BY in NUMBER,
176: X_LAST_UPDATE_LOGIN in NUMBER
177: ) is
178: begin
179: update OKC_RESP_PARTIES_B set
180: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
181: INTERNAL_EXTERNAL_FLAG = X_INTERNAL_EXTERNAL_FLAG,
182: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
183: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 226: delete from OKC_RESP_PARTIES_B

222: if (sql%notfound) then
223: raise no_data_found;
224: end if;
225:
226: delete from OKC_RESP_PARTIES_B
227: where DOCUMENT_TYPE_CLASS = X_DOCUMENT_TYPE_CLASS
228: and RESP_PARTY_CODE = X_RESP_PARTY_CODE
229: and INTENT = X_INTENT;
230:

Line 242: from OKC_RESP_PARTIES_B B

238: begin
239: delete from OKC_RESP_PARTIES_TL T
240: where not exists
241: (select NULL
242: from OKC_RESP_PARTIES_B B
243: where B.DOCUMENT_TYPE_CLASS = T.DOCUMENT_TYPE_CLASS
244: and B.RESP_PARTY_CODE = T.RESP_PARTY_CODE
245: and B.INTENT = T.INTENT
246: );