APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_CREDITCARD_ISSUERS_B

Line 3166: cursor C is select ROWID from IBY_CREDITCARD_ISSUERS_B

3162: X_LAST_UPDATE_DATE in DATE,
3163: X_LAST_UPDATED_BY in NUMBER,
3164: X_LAST_UPDATE_LOGIN in NUMBER
3165: ) is
3166: cursor C is select ROWID from IBY_CREDITCARD_ISSUERS_B
3167: where CARD_ISSUER_CODE = X_CARD_ISSUER_CODE
3168: ;
3169: begin
3170: insert into IBY_CREDITCARD_ISSUERS_B (

Line 3170: insert into IBY_CREDITCARD_ISSUERS_B (

3166: cursor C is select ROWID from IBY_CREDITCARD_ISSUERS_B
3167: where CARD_ISSUER_CODE = X_CARD_ISSUER_CODE
3168: ;
3169: begin
3170: insert into IBY_CREDITCARD_ISSUERS_B (
3171: OBJECT_VERSION_NUMBER,
3172: CARD_ISSUER_CODE,
3173: CARD_ISSUER_ACCEPTED_FLAG,
3174: AUTHORIZATION_VALIDITY_PERIOD,

Line 3249: update IBY_CREDITCARD_ISSUERS_B set

3245: X_LAST_UPDATED_BY in NUMBER,
3246: X_LAST_UPDATE_LOGIN in NUMBER
3247: ) is
3248: begin
3249: update IBY_CREDITCARD_ISSUERS_B set
3250: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
3251: CARD_ISSUER_ACCEPTED_FLAG = X_CARD_ISSUER_ACCEPTED_FLAG,
3252: AUTHORIZATION_VALIDITY_PERIOD = X_AUTHORIZATION_VALIDITY_PERIO,
3253: DIGIT_CHECK_FLAG = X_DIGIT_CHECK_FLAG,

Line 3289: delete from IBY_CREDITCARD_ISSUERS_B

3285: if (sql%notfound) then
3286: raise no_data_found;
3287: end if;
3288:
3289: delete from IBY_CREDITCARD_ISSUERS_B
3290: where CARD_ISSUER_CODE = X_CARD_ISSUER_CODE;
3291:
3292: if (sql%notfound) then
3293: raise no_data_found;

Line 3303: from IBY_CREDITCARD_ISSUERS_B B

3299: begin
3300: delete from IBY_CREDITCARD_ISSUERS_TL T
3301: where not exists
3302: (select NULL
3303: from IBY_CREDITCARD_ISSUERS_B B
3304: where B.CARD_ISSUER_CODE = T.CARD_ISSUER_CODE
3305: );
3306:
3307: update IBY_CREDITCARD_ISSUERS_TL T set (