APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_FNDCPT_PMT_CHNNLS_TL

Line 2842: insert into IBY_FNDCPT_PMT_CHNNLS_TL (

2838: X_LAST_UPDATED_BY,
2839: X_LAST_UPDATE_LOGIN
2840: );
2841:
2842: insert into IBY_FNDCPT_PMT_CHNNLS_TL (
2843: PAYMENT_CHANNEL_CODE,
2844: PAYMENT_CHANNEL_NAME,
2845: DESCRIPTION,
2846: CREATED_BY,

Line 2870: from IBY_FNDCPT_PMT_CHNNLS_TL T

2866: from FND_LANGUAGES L
2867: where L.INSTALLED_FLAG in ('I', 'B')
2868: and not exists
2869: (select NULL
2870: from IBY_FNDCPT_PMT_CHNNLS_TL T
2871: where T.PAYMENT_CHANNEL_CODE = X_PAYMENT_CHANNEL_CODE
2872: and T.LANGUAGE = L.LANGUAGE_CODE);
2873:
2874: open c;

Line 2941: update IBY_FNDCPT_PMT_CHNNLS_TL set

2937: if (sql%notfound) then
2938: raise no_data_found;
2939: end if;
2940:
2941: update IBY_FNDCPT_PMT_CHNNLS_TL set
2942: PAYMENT_CHANNEL_NAME = X_PAYMENT_CHANNEL_NAME,
2943: DESCRIPTION = X_DESCRIPTION,
2944: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
2945: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 2960: delete from IBY_FNDCPT_PMT_CHNNLS_TL

2956: procedure PMT_CHANNEL_DELETE_ROW (
2957: X_PAYMENT_CHANNEL_CODE in VARCHAR2
2958: ) is
2959: begin
2960: delete from IBY_FNDCPT_PMT_CHNNLS_TL
2961: where PAYMENT_CHANNEL_CODE = X_PAYMENT_CHANNEL_CODE;
2962:
2963: if (sql%notfound) then
2964: raise no_data_found;

Line 2978: delete from IBY_FNDCPT_PMT_CHNNLS_TL T

2974:
2975: procedure PMT_CHANNEL_ADD_LANGUAGE
2976: is
2977: begin
2978: delete from IBY_FNDCPT_PMT_CHNNLS_TL T
2979: where not exists
2980: (select NULL
2981: from IBY_FNDCPT_PMT_CHNNLS_B B
2982: where B.PAYMENT_CHANNEL_CODE = T.PAYMENT_CHANNEL_CODE

Line 2985: update IBY_FNDCPT_PMT_CHNNLS_TL T set (

2981: from IBY_FNDCPT_PMT_CHNNLS_B B
2982: where B.PAYMENT_CHANNEL_CODE = T.PAYMENT_CHANNEL_CODE
2983: );
2984:
2985: update IBY_FNDCPT_PMT_CHNNLS_TL T set (
2986: PAYMENT_CHANNEL_NAME,
2987: DESCRIPTION
2988: ) = (select
2989: B.PAYMENT_CHANNEL_NAME,

Line 2991: from IBY_FNDCPT_PMT_CHNNLS_TL B

2987: DESCRIPTION
2988: ) = (select
2989: B.PAYMENT_CHANNEL_NAME,
2990: B.DESCRIPTION
2991: from IBY_FNDCPT_PMT_CHNNLS_TL B
2992: where B.PAYMENT_CHANNEL_CODE = T.PAYMENT_CHANNEL_CODE
2993: and B.LANGUAGE = T.SOURCE_LANG)
2994: where (
2995: T.PAYMENT_CHANNEL_CODE,

Line 3000: from IBY_FNDCPT_PMT_CHNNLS_TL SUBB, IBY_FNDCPT_PMT_CHNNLS_TL SUBT

2996: T.LANGUAGE
2997: ) in (select
2998: SUBT.PAYMENT_CHANNEL_CODE,
2999: SUBT.LANGUAGE
3000: from IBY_FNDCPT_PMT_CHNNLS_TL SUBB, IBY_FNDCPT_PMT_CHNNLS_TL SUBT
3001: where SUBB.PAYMENT_CHANNEL_CODE = SUBT.PAYMENT_CHANNEL_CODE
3002: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
3003: and (SUBB.PAYMENT_CHANNEL_NAME <> SUBT.PAYMENT_CHANNEL_NAME
3004: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 3007: insert into IBY_FNDCPT_PMT_CHNNLS_TL (

3003: and (SUBB.PAYMENT_CHANNEL_NAME <> SUBT.PAYMENT_CHANNEL_NAME
3004: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
3005: ));
3006:
3007: insert into IBY_FNDCPT_PMT_CHNNLS_TL (
3008: PAYMENT_CHANNEL_CODE,
3009: PAYMENT_CHANNEL_NAME,
3010: DESCRIPTION,
3011: CREATED_BY,

Line 3031: from IBY_FNDCPT_PMT_CHNNLS_TL B, FND_LANGUAGES L

3027: B.LAST_UPDATE_LOGIN,
3028: B.OBJECT_VERSION_NUMBER,
3029: L.LANGUAGE_CODE,
3030: B.SOURCE_LANG
3031: from IBY_FNDCPT_PMT_CHNNLS_TL B, FND_LANGUAGES L
3032: where L.INSTALLED_FLAG in ('I', 'B')
3033: and B.LANGUAGE = userenv('LANG')
3034: and not exists
3035: (select NULL

Line 3036: from IBY_FNDCPT_PMT_CHNNLS_TL T

3032: where L.INSTALLED_FLAG in ('I', 'B')
3033: and B.LANGUAGE = userenv('LANG')
3034: and not exists
3035: (select NULL
3036: from IBY_FNDCPT_PMT_CHNNLS_TL T
3037: where T.PAYMENT_CHANNEL_CODE = B.PAYMENT_CHANNEL_CODE
3038: and T.LANGUAGE = L.LANGUAGE_CODE);
3039: end PMT_CHANNEL_ADD_LANGUAGE;
3040:

Line 3138: update iby_fndcpt_pmt_chnnls_tl set

3134: X_LAST_UPDATE_DATE in DATE,
3135: X_OWNER in VARCHAR2)
3136: is
3137: begin
3138: update iby_fndcpt_pmt_chnnls_tl set
3139: PAYMENT_CHANNEL_NAME = X_PAYMENT_CHANNEL_NAME,
3140: DESCRIPTION = X_DESCRIPTION,
3141: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
3142: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),