APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_CREDITCARD_ISSUERS_TL

Line 3194: insert into IBY_CREDITCARD_ISSUERS_TL (

3190: X_LAST_UPDATED_BY,
3191: X_LAST_UPDATE_LOGIN
3192: );
3193:
3194: insert into IBY_CREDITCARD_ISSUERS_TL (
3195: CARD_ISSUER_CODE,
3196: CARD_ISSUER_NAME,
3197: DESCRIPTION,
3198: CREATED_BY,

Line 3222: from IBY_CREDITCARD_ISSUERS_TL T

3218: from FND_LANGUAGES L
3219: where L.INSTALLED_FLAG in ('I', 'B')
3220: and not exists
3221: (select NULL
3222: from IBY_CREDITCARD_ISSUERS_TL T
3223: where T.CARD_ISSUER_CODE = X_CARD_ISSUER_CODE
3224: and T.LANGUAGE = L.LANGUAGE_CODE);
3225:
3226: open c;

Line 3263: update IBY_CREDITCARD_ISSUERS_TL set

3259: if (sql%notfound) then
3260: raise no_data_found;
3261: end if;
3262:
3263: update IBY_CREDITCARD_ISSUERS_TL set
3264: CARD_ISSUER_NAME = X_CARD_ISSUER_NAME,
3265: DESCRIPTION = X_DESCRIPTION,
3266: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
3267: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 3282: delete from IBY_CREDITCARD_ISSUERS_TL

3278: procedure CC_ISSUER_DELETE_ROW (
3279: X_CARD_ISSUER_CODE in VARCHAR2
3280: ) is
3281: begin
3282: delete from IBY_CREDITCARD_ISSUERS_TL
3283: where CARD_ISSUER_CODE = X_CARD_ISSUER_CODE;
3284:
3285: if (sql%notfound) then
3286: raise no_data_found;

Line 3300: delete from IBY_CREDITCARD_ISSUERS_TL T

3296:
3297: procedure CC_ISSUER_ADD_LANGUAGE
3298: is
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

Line 3307: update IBY_CREDITCARD_ISSUERS_TL T set (

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 (
3308: CARD_ISSUER_NAME,
3309: DESCRIPTION
3310: ) = (select
3311: B.CARD_ISSUER_NAME,

Line 3313: from IBY_CREDITCARD_ISSUERS_TL B

3309: DESCRIPTION
3310: ) = (select
3311: B.CARD_ISSUER_NAME,
3312: B.DESCRIPTION
3313: from IBY_CREDITCARD_ISSUERS_TL B
3314: where B.CARD_ISSUER_CODE = T.CARD_ISSUER_CODE
3315: and B.LANGUAGE = T.SOURCE_LANG)
3316: where (
3317: T.CARD_ISSUER_CODE,

Line 3322: from IBY_CREDITCARD_ISSUERS_TL SUBB, IBY_CREDITCARD_ISSUERS_TL SUBT

3318: T.LANGUAGE
3319: ) in (select
3320: SUBT.CARD_ISSUER_CODE,
3321: SUBT.LANGUAGE
3322: from IBY_CREDITCARD_ISSUERS_TL SUBB, IBY_CREDITCARD_ISSUERS_TL SUBT
3323: where SUBB.CARD_ISSUER_CODE = SUBT.CARD_ISSUER_CODE
3324: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
3325: and (SUBB.CARD_ISSUER_NAME <> SUBT.CARD_ISSUER_NAME
3326: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 3331: insert into IBY_CREDITCARD_ISSUERS_TL (

3327: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
3328: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
3329: ));
3330:
3331: insert into IBY_CREDITCARD_ISSUERS_TL (
3332: CARD_ISSUER_CODE,
3333: CARD_ISSUER_NAME,
3334: DESCRIPTION,
3335: CREATED_BY,

Line 3355: from IBY_CREDITCARD_ISSUERS_TL B, FND_LANGUAGES L

3351: B.LAST_UPDATE_LOGIN,
3352: B.OBJECT_VERSION_NUMBER,
3353: L.LANGUAGE_CODE,
3354: B.SOURCE_LANG
3355: from IBY_CREDITCARD_ISSUERS_TL B, FND_LANGUAGES L
3356: where L.INSTALLED_FLAG in ('I', 'B')
3357: and B.LANGUAGE = userenv('LANG')
3358: and not exists
3359: (select NULL

Line 3360: from IBY_CREDITCARD_ISSUERS_TL T

3356: where L.INSTALLED_FLAG in ('I', 'B')
3357: and B.LANGUAGE = userenv('LANG')
3358: and not exists
3359: (select NULL
3360: from IBY_CREDITCARD_ISSUERS_TL T
3361: where T.CARD_ISSUER_CODE = B.CARD_ISSUER_CODE
3362: and T.LANGUAGE = L.LANGUAGE_CODE);
3363: end CC_ISSUER_ADD_LANGUAGE;
3364:

Line 3416: update iby_creditcard_issuers_tl set

3412: X_LAST_UPDATE_DATE in DATE,
3413: X_OWNER in VARCHAR2)
3414: is
3415: begin
3416: update iby_creditcard_issuers_tl set
3417: CARD_ISSUER_NAME = X_CARD_ISSUER_NAME,
3418: DESCRIPTION = X_DESCRIPTION,
3419: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
3420: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),