APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_FNDCPT_SYS_CC_PF_TL

Line 1056: insert into IBY_FNDCPT_SYS_CC_PF_TL (

1052: X_LAST_UPDATED_BY,
1053: X_LAST_UPDATE_LOGIN
1054: );
1055:
1056: insert into IBY_FNDCPT_SYS_CC_PF_TL (
1057: SYS_CC_PROFILE_CODE,
1058: LAST_UPDATED_BY,
1059: LAST_UPDATE_DATE,
1060: LAST_UPDATE_LOGIN,

Line 1082: from IBY_FNDCPT_SYS_CC_PF_TL T

1078: from FND_LANGUAGES L
1079: where L.INSTALLED_FLAG in ('I', 'B')
1080: and not exists
1081: (select NULL
1082: from IBY_FNDCPT_SYS_CC_PF_TL T
1083: where T.SYS_CC_PROFILE_CODE = X_SYS_CC_PROFILE_CODE
1084: and T.LANGUAGE = L.LANGUAGE_CODE);
1085:
1086: open c;

Line 1138: update IBY_FNDCPT_SYS_CC_PF_TL set

1134: if (sql%notfound) then
1135: raise no_data_found;
1136: end if;
1137:
1138: update IBY_FNDCPT_SYS_CC_PF_TL set
1139: SYS_CC_PROFILE_NAME = X_SYS_CC_PROFILE_NAME,
1140: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1141: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1142: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 1156: delete from IBY_FNDCPT_SYS_CC_PF_TL

1152: procedure SYS_CC_PROF_DELETE_ROW (
1153: X_SYS_CC_PROFILE_CODE in VARCHAR2
1154: ) is
1155: begin
1156: delete from IBY_FNDCPT_SYS_CC_PF_TL
1157: where SYS_CC_PROFILE_CODE = X_SYS_CC_PROFILE_CODE;
1158:
1159: if (sql%notfound) then
1160: raise no_data_found;

Line 1174: delete from IBY_FNDCPT_SYS_CC_PF_TL T

1170:
1171: procedure SYS_CC_PROF_ADD_LANGUAGE
1172: is
1173: begin
1174: delete from IBY_FNDCPT_SYS_CC_PF_TL T
1175: where not exists
1176: (select NULL
1177: from IBY_FNDCPT_SYS_CC_PF_B B
1178: where B.SYS_CC_PROFILE_CODE = T.SYS_CC_PROFILE_CODE

Line 1181: update IBY_FNDCPT_SYS_CC_PF_TL T set (

1177: from IBY_FNDCPT_SYS_CC_PF_B B
1178: where B.SYS_CC_PROFILE_CODE = T.SYS_CC_PROFILE_CODE
1179: );
1180:
1181: update IBY_FNDCPT_SYS_CC_PF_TL T set (
1182: SYS_CC_PROFILE_NAME
1183: ) = (select
1184: B.SYS_CC_PROFILE_NAME
1185: from IBY_FNDCPT_SYS_CC_PF_TL B

Line 1185: from IBY_FNDCPT_SYS_CC_PF_TL B

1181: update IBY_FNDCPT_SYS_CC_PF_TL T set (
1182: SYS_CC_PROFILE_NAME
1183: ) = (select
1184: B.SYS_CC_PROFILE_NAME
1185: from IBY_FNDCPT_SYS_CC_PF_TL B
1186: where B.SYS_CC_PROFILE_CODE = T.SYS_CC_PROFILE_CODE
1187: and B.LANGUAGE = T.SOURCE_LANG)
1188: where (
1189: T.SYS_CC_PROFILE_CODE,

Line 1194: from IBY_FNDCPT_SYS_CC_PF_TL SUBB, IBY_FNDCPT_SYS_CC_PF_TL SUBT

1190: T.LANGUAGE
1191: ) in (select
1192: SUBT.SYS_CC_PROFILE_CODE,
1193: SUBT.LANGUAGE
1194: from IBY_FNDCPT_SYS_CC_PF_TL SUBB, IBY_FNDCPT_SYS_CC_PF_TL SUBT
1195: where SUBB.SYS_CC_PROFILE_CODE = SUBT.SYS_CC_PROFILE_CODE
1196: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1197: and (SUBB.SYS_CC_PROFILE_NAME <> SUBT.SYS_CC_PROFILE_NAME
1198: ));

Line 1200: insert into IBY_FNDCPT_SYS_CC_PF_TL (

1196: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1197: and (SUBB.SYS_CC_PROFILE_NAME <> SUBT.SYS_CC_PROFILE_NAME
1198: ));
1199:
1200: insert into IBY_FNDCPT_SYS_CC_PF_TL (
1201: SYS_CC_PROFILE_CODE,
1202: LAST_UPDATED_BY,
1203: LAST_UPDATE_DATE,
1204: LAST_UPDATE_LOGIN,

Line 1222: from IBY_FNDCPT_SYS_CC_PF_TL B, FND_LANGUAGES L

1218: B.SYS_CC_PROFILE_NAME,
1219: B.CREATED_BY,
1220: L.LANGUAGE_CODE,
1221: B.SOURCE_LANG
1222: from IBY_FNDCPT_SYS_CC_PF_TL B, FND_LANGUAGES L
1223: where L.INSTALLED_FLAG in ('I', 'B')
1224: and B.LANGUAGE = userenv('LANG')
1225: and not exists
1226: (select NULL

Line 1227: from IBY_FNDCPT_SYS_CC_PF_TL T

1223: where L.INSTALLED_FLAG in ('I', 'B')
1224: and B.LANGUAGE = userenv('LANG')
1225: and not exists
1226: (select NULL
1227: from IBY_FNDCPT_SYS_CC_PF_TL T
1228: where T.SYS_CC_PROFILE_CODE = B.SYS_CC_PROFILE_CODE
1229: and T.LANGUAGE = L.LANGUAGE_CODE);
1230: end SYS_CC_PROF_ADD_LANGUAGE;
1231:

Line 1303: update iby_fndcpt_sys_cc_pf_tl set

1299: X_LAST_UPDATE_DATE in DATE,
1300: X_OWNER in VARCHAR2)
1301: is
1302: begin
1303: update iby_fndcpt_sys_cc_pf_tl set
1304: SYS_CC_PROFILE_NAME = X_SYS_CC_PROFILE_NAME,
1305: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
1306: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
1307: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,