APPS.IBY_ACCT_PMT_PROFILES_PKG dependencies on IBY_ACCT_PMT_PROFILES_B

Line 31: cursor C is select ROWID from IBY_ACCT_PMT_PROFILES_B

27: X_LAST_UPDATE_DATE in DATE,
28: X_LAST_UPDATED_BY in NUMBER,
29: X_LAST_UPDATE_LOGIN in NUMBER
30: ) is
31: cursor C is select ROWID from IBY_ACCT_PMT_PROFILES_B
32: where PAYMENT_PROFILE_ID = X_PAYMENT_PROFILE_ID
33: ;
34: begin
35: insert into IBY_ACCT_PMT_PROFILES_B (

Line 35: insert into IBY_ACCT_PMT_PROFILES_B (

31: cursor C is select ROWID from IBY_ACCT_PMT_PROFILES_B
32: where PAYMENT_PROFILE_ID = X_PAYMENT_PROFILE_ID
33: ;
34: begin
35: insert into IBY_ACCT_PMT_PROFILES_B (
36: PAYMENT_PROFILE_ID,
37: SYSTEM_PROFILE_CODE,
38: OBJECT_VERSION_NUMBER,
39: BEP_ACCOUNT_ID,

Line 164: from IBY_ACCT_PMT_PROFILES_B

160: RESET_REQUEST_3,
161: INACTIVE_DATE,
162: ACK_SEC_CONFIG_ID,
163: ACK_TRANSMIT_CONFIG_ID
164: from IBY_ACCT_PMT_PROFILES_B
165: where PAYMENT_PROFILE_ID = X_PAYMENT_PROFILE_ID
166: for update of PAYMENT_PROFILE_ID nowait;
167: recinfo c%rowtype;
168:

Line 263: update IBY_ACCT_PMT_PROFILES_B set

259: X_LAST_UPDATED_BY in NUMBER,
260: X_LAST_UPDATE_LOGIN in NUMBER
261: ) is
262: begin
263: update IBY_ACCT_PMT_PROFILES_B set
264: SYSTEM_PROFILE_CODE = X_SYSTEM_PROFILE_CODE,
265: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
266: BEP_ACCOUNT_ID = X_BEP_ACCOUNT_ID,
267: SECURITY_CONFIGURATION_ID = X_SECURITY_CONFIGURATION_ID,

Line 315: delete from IBY_ACCT_PMT_PROFILES_B

311: if (sql%notfound) then
312: raise no_data_found;
313: end if;
314:
315: delete from IBY_ACCT_PMT_PROFILES_B
316: where PAYMENT_PROFILE_ID = X_PAYMENT_PROFILE_ID;
317:
318: if (sql%notfound) then
319: raise no_data_found;

Line 329: from IBY_ACCT_PMT_PROFILES_B B

325: begin
326: delete from IBY_ACCT_PMT_PROFILES_TL T
327: where not exists
328: (select NULL
329: from IBY_ACCT_PMT_PROFILES_B B
330: where B.PAYMENT_PROFILE_ID = T.PAYMENT_PROFILE_ID
331: );
332:
333: update IBY_ACCT_PMT_PROFILES_TL T set (