APPS.IBY_PAYMENT_METHODS_PKG dependencies on IBY_PAYMENT_METHODS_B

Line 51: cursor C is select ROWID from IBY_PAYMENT_METHODS_B

47: X_LAST_UPDATED_BY in NUMBER,
48: X_LAST_UPDATE_LOGIN in NUMBER,
49: X_SEEDED_FLAG in VARCHAR2
50: ) is
51: cursor C is select ROWID from IBY_PAYMENT_METHODS_B
52: where PAYMENT_METHOD_CODE = X_PAYMENT_METHOD_CODE
53: ;
54: begin
55: insert into IBY_PAYMENT_METHODS_B (

Line 55: insert into IBY_PAYMENT_METHODS_B (

51: cursor C is select ROWID from IBY_PAYMENT_METHODS_B
52: where PAYMENT_METHOD_CODE = X_PAYMENT_METHOD_CODE
53: ;
54: begin
55: insert into IBY_PAYMENT_METHODS_B (
56: ATTRIBUTE14,
57: ATTRIBUTE15,
58: REMITTANCE_MESSAGE1_APL_FLAG,
59: REMITTANCE_MESSAGE2_APL_FLAG,

Line 261: from IBY_PAYMENT_METHODS_B

257: ATTRIBUTE7,
258: ATTRIBUTE8,
259: ATTRIBUTE9,
260: ATTRIBUTE11
261: from IBY_PAYMENT_METHODS_B
262: where PAYMENT_METHOD_CODE = X_PAYMENT_METHOD_CODE
263: for update of PAYMENT_METHOD_CODE nowait;
264: recinfo c%rowtype;
265:

Line 405: update IBY_PAYMENT_METHODS_B set

401: X_LAST_UPDATED_BY in NUMBER,
402: X_LAST_UPDATE_LOGIN in NUMBER
403: ) is
404: begin
405: update IBY_PAYMENT_METHODS_B set
406: ATTRIBUTE14 = X_ATTRIBUTE14,
407: ATTRIBUTE15 = X_ATTRIBUTE15,
408: REMITTANCE_MESSAGE1_APL_FLAG = X_REMITTANCE_MESSAGE1_APL_FLAG,
409: REMITTANCE_MESSAGE2_APL_FLAG = X_REMITTANCE_MESSAGE2_APL_FLAG,

Line 476: delete from IBY_PAYMENT_METHODS_B

472: if (sql%notfound) then
473: raise no_data_found;
474: end if;
475:
476: delete from IBY_PAYMENT_METHODS_B
477: where PAYMENT_METHOD_CODE = X_PAYMENT_METHOD_CODE;
478:
479: if (sql%notfound) then
480: raise no_data_found;

Line 490: from IBY_PAYMENT_METHODS_B B

486: begin
487: delete from IBY_PAYMENT_METHODS_TL T
488: where not exists
489: (select NULL
490: from IBY_PAYMENT_METHODS_B B
491: where B.PAYMENT_METHOD_CODE = T.PAYMENT_METHOD_CODE
492: );
493:
494: update IBY_PAYMENT_METHODS_TL T set (

Line 583: update IBY_PAYMENT_METHODS_B set

579: ) is
580: row_id VARCHAR2(200);
581: begin
582:
583: update IBY_PAYMENT_METHODS_B set
584: REMITTANCE_MESSAGE1_APL_FLAG = X_REMITTANCE_MESSAGE1_APL_FLAG,
585: REMITTANCE_MESSAGE2_APL_FLAG = X_REMITTANCE_MESSAGE2_APL_FLAG,
586: REMITTANCE_MESSAGE3_APL_FLAG = X_REMITTANCE_MESSAGE3_APL_FLAG,
587: UNIQUE_REMITTANCE_ID_APL_FLAG = X_UNIQUE_REMIT_ID_APL_FLAG,