APPS.OKE_BILLING_METHODS_PKG dependencies on OKE_BILLING_METHODS_B

Line 35: cursor C is select ROWID from OKE_BILLING_METHODS_B

31: , X_ATTRIBUTE13 in VARCHAR2
32: , X_ATTRIBUTE14 in VARCHAR2
33: , X_ATTRIBUTE15 in VARCHAR2
34: ) is
35: cursor C is select ROWID from OKE_BILLING_METHODS_B
36: where BILLING_METHOD_CODE = X_BILLING_METHOD_CODE
37: ;
38: begin
39: insert into OKE_BILLING_METHODS_B (

Line 39: insert into OKE_BILLING_METHODS_B (

35: cursor C is select ROWID from OKE_BILLING_METHODS_B
36: where BILLING_METHOD_CODE = X_BILLING_METHOD_CODE
37: ;
38: begin
39: insert into OKE_BILLING_METHODS_B (
40: BILLING_METHOD_CODE
41: , CREATION_DATE
42: , CREATED_BY
43: , LAST_UPDATE_DATE

Line 187: from OKE_BILLING_METHODS_B

183: , ATTRIBUTE12
184: , ATTRIBUTE13
185: , ATTRIBUTE14
186: , ATTRIBUTE15
187: from OKE_BILLING_METHODS_B
188: where BILLING_METHOD_CODE = X_BILLING_METHOD_CODE
189: for update of BILLING_METHOD_CODE nowait;
190: recinfo c%rowtype;
191:

Line 312: update OKE_BILLING_METHODS_B set

308: , X_ATTRIBUTE14 in VARCHAR2
309: , X_ATTRIBUTE15 in VARCHAR2
310: ) is
311: begin
312: update OKE_BILLING_METHODS_B set
313: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
314: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
315: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
316: , INCLUDE_PRICE_FLAG = X_INCLUDE_PRICE_FLAG

Line 367: from OKE_BILLING_METHODS_B B

363: begin
364: delete from OKE_BILLING_METHODS_TL T
365: where not exists
366: (select NULL
367: from OKE_BILLING_METHODS_B B
368: where B.BILLING_METHOD_CODE = T.BILLING_METHOD_CODE
369: );
370:
371: update OKE_BILLING_METHODS_TL T set (