APPS.IBY_TRXN_TYPES_PKG dependencies on IBY_TRXN_TYPES_B

Line 19: cursor C is select ROWID from IBY_TRXN_TYPES_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 IBY_TRXN_TYPES_B
20: where APPLICATION_ID = X_APPLICATION_ID
21: and PAY_PROC_TRXN_TYPE_CODE = X_PAY_PROC_TRXN_TYPE_CODE
22: ;
23: begin

Line 24: insert into IBY_TRXN_TYPES_B (

20: where APPLICATION_ID = X_APPLICATION_ID
21: and PAY_PROC_TRXN_TYPE_CODE = X_PAY_PROC_TRXN_TYPE_CODE
22: ;
23: begin
24: insert into IBY_TRXN_TYPES_B (
25: OBJECT_VERSION_NUMBER,
26: PAYMENT_FLOW,
27: APPLICATION_ID,
28: PAY_PROC_TRXN_TYPE_CODE,

Line 106: from IBY_TRXN_TYPES_B

102: cursor c is select
103: OBJECT_VERSION_NUMBER,
104: PAYMENT_FLOW,
105: SEEDED_FLAG
106: from IBY_TRXN_TYPES_B
107: where APPLICATION_ID = X_APPLICATION_ID
108: and PAY_PROC_TRXN_TYPE_CODE = X_PAY_PROC_TRXN_TYPE_CODE
109: for update of APPLICATION_ID nowait;
110: recinfo c%rowtype;

Line 169: update IBY_TRXN_TYPES_B set

165: X_LAST_UPDATED_BY in NUMBER,
166: X_LAST_UPDATE_LOGIN in NUMBER
167: ) is
168: begin
169: update IBY_TRXN_TYPES_B set
170: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
171: PAYMENT_FLOW = X_PAYMENT_FLOW,
172: SEEDED_FLAG = X_SEEDED_FLAG,
173: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 212: delete from IBY_TRXN_TYPES_B

208: if (sql%notfound) then
209: raise no_data_found;
210: end if;
211:
212: delete from IBY_TRXN_TYPES_B
213: where APPLICATION_ID = X_APPLICATION_ID
214: and PAY_PROC_TRXN_TYPE_CODE = X_PAY_PROC_TRXN_TYPE_CODE;
215:
216: if (sql%notfound) then

Line 227: from IBY_TRXN_TYPES_B B

223: begin
224: delete from IBY_TRXN_TYPES_TL T
225: where not exists
226: (select NULL
227: from IBY_TRXN_TYPES_B B
228: where B.APPLICATION_ID = T.APPLICATION_ID
229: and B.PAY_PROC_TRXN_TYPE_CODE = T.PAY_PROC_TRXN_TYPE_CODE
230: );
231: