APPS.IBY_UPG_PPP_PKG dependencies on IBY_UPG_PPP_TL

Line 281: insert into IBY_UPG_PPP_TL (

277: X_BATCH_BOOKING_FLAG,
278: X_INST_GROUP_BY_PAYMENT_METHOD
279: );
280:
281: insert into IBY_UPG_PPP_TL (
282: SYSTEM_PROFILE_CODE,
283: SYSTEM_PROFILE_NAME,
284: SYSTEM_PROFILE_DESCRIPTION,
285: CREATED_BY,

Line 309: from IBY_UPG_PPP_TL T

305: from FND_LANGUAGES L
306: where L.INSTALLED_FLAG in ('I', 'B')
307: and not exists
308: (select NULL
309: from IBY_UPG_PPP_TL T
310: where T.SYSTEM_PROFILE_CODE = X_SYSTEM_PROFILE_CODE
311: and T.LANGUAGE = L.LANGUAGE_CODE);
312:
313: open c;

Line 502: from IBY_UPG_PPP_TL

498: cursor c1 is select
499: SYSTEM_PROFILE_NAME,
500: SYSTEM_PROFILE_DESCRIPTION,
501: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
502: from IBY_UPG_PPP_TL
503: where SYSTEM_PROFILE_CODE = X_SYSTEM_PROFILE_CODE
504: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
505: for update of SYSTEM_PROFILE_CODE nowait;
506: begin

Line 908: iby_upg_ppp_tl ppp,

904: UNION ALL
905:
906: SELECT distinct(ppb.system_profile_code) system_profile_code
907: FROM iby_formats_b ipf,
908: iby_upg_ppp_tl ppp,
909: iby_upg_ppp_b ppb,
910: iby_acct_pmt_profiles_b app,
911: iby_bepinfo bep,
912: iby_bepkeys key1

Line 1192: update IBY_UPG_PPP_TL set

1188:
1189:
1190: END LOOP;
1191:
1192: update IBY_UPG_PPP_TL set
1193: SYSTEM_PROFILE_NAME = X_SYSTEM_PROFILE_NAME,
1194: SYSTEM_PROFILE_DESCRIPTION = X_SYSTEM_PROFILE_DESCRIPTION,
1195: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1196: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 1211: delete from IBY_UPG_PPP_TL

1207: procedure DELETE_ROW (
1208: X_SYSTEM_PROFILE_CODE in VARCHAR2
1209: ) is
1210: begin
1211: delete from IBY_UPG_PPP_TL
1212: where SYSTEM_PROFILE_CODE = X_SYSTEM_PROFILE_CODE;
1213:
1214: if (sql%notfound) then
1215: raise no_data_found;

Line 1229: delete from IBY_UPG_PPP_TL T

1225:
1226: procedure ADD_LANGUAGE
1227: is
1228: begin
1229: delete from IBY_UPG_PPP_TL T
1230: where not exists
1231: (select NULL
1232: from IBY_UPG_PPP_B B
1233: where B.SYSTEM_PROFILE_CODE = T.SYSTEM_PROFILE_CODE

Line 1236: update IBY_UPG_PPP_TL T set (

1232: from IBY_UPG_PPP_B B
1233: where B.SYSTEM_PROFILE_CODE = T.SYSTEM_PROFILE_CODE
1234: );
1235:
1236: update IBY_UPG_PPP_TL T set (
1237: SYSTEM_PROFILE_NAME,
1238: SYSTEM_PROFILE_DESCRIPTION
1239: ) = (select
1240: B.SYSTEM_PROFILE_NAME,

Line 1242: from IBY_UPG_PPP_TL B

1238: SYSTEM_PROFILE_DESCRIPTION
1239: ) = (select
1240: B.SYSTEM_PROFILE_NAME,
1241: B.SYSTEM_PROFILE_DESCRIPTION
1242: from IBY_UPG_PPP_TL B
1243: where B.SYSTEM_PROFILE_CODE = T.SYSTEM_PROFILE_CODE
1244: and B.LANGUAGE = T.SOURCE_LANG)
1245: where (
1246: T.SYSTEM_PROFILE_CODE,

Line 1251: from IBY_UPG_PPP_TL SUBB, IBY_UPG_PPP_TL SUBT

1247: T.LANGUAGE
1248: ) in (select
1249: SUBT.SYSTEM_PROFILE_CODE,
1250: SUBT.LANGUAGE
1251: from IBY_UPG_PPP_TL SUBB, IBY_UPG_PPP_TL SUBT
1252: where SUBB.SYSTEM_PROFILE_CODE = SUBT.SYSTEM_PROFILE_CODE
1253: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1254: and (SUBB.SYSTEM_PROFILE_NAME <> SUBT.SYSTEM_PROFILE_NAME
1255: or SUBB.SYSTEM_PROFILE_DESCRIPTION <> SUBT.SYSTEM_PROFILE_DESCRIPTION

Line 1260: insert into IBY_UPG_PPP_TL (

1256: or (SUBB.SYSTEM_PROFILE_DESCRIPTION is null and SUBT.SYSTEM_PROFILE_DESCRIPTION is not null)
1257: or (SUBB.SYSTEM_PROFILE_DESCRIPTION is not null and SUBT.SYSTEM_PROFILE_DESCRIPTION is null)
1258: ));
1259:
1260: insert into IBY_UPG_PPP_TL (
1261: SYSTEM_PROFILE_CODE,
1262: SYSTEM_PROFILE_NAME,
1263: SYSTEM_PROFILE_DESCRIPTION,
1264: CREATED_BY,

Line 1284: from IBY_UPG_PPP_TL B, FND_LANGUAGES L

1280: B.LAST_UPDATE_LOGIN,
1281: B.OBJECT_VERSION_NUMBER,
1282: L.LANGUAGE_CODE,
1283: B.SOURCE_LANG
1284: from IBY_UPG_PPP_TL B, FND_LANGUAGES L
1285: where L.INSTALLED_FLAG in ('I', 'B')
1286: and B.LANGUAGE = userenv('LANG')
1287: and not exists
1288: (select NULL

Line 1289: from IBY_UPG_PPP_TL T

1285: where L.INSTALLED_FLAG in ('I', 'B')
1286: and B.LANGUAGE = userenv('LANG')
1287: and not exists
1288: (select NULL
1289: from IBY_UPG_PPP_TL T
1290: where T.SYSTEM_PROFILE_CODE = B.SYSTEM_PROFILE_CODE
1291: and T.LANGUAGE = L.LANGUAGE_CODE);
1292: end ADD_LANGUAGE;
1293:

Line 1586: update IBY_UPG_PPP_TL set

1582: X_LAST_UPDATED_BY in NUMBER,
1583: X_LAST_UPDATE_LOGIN in NUMBER)
1584: is
1585: begin
1586: update IBY_UPG_PPP_TL set
1587: SYSTEM_PROFILE_NAME = X_SYSTEM_PROFILE_NAME,
1588: SYSTEM_PROFILE_DESCRIPTION = X_SYSTEM_PROFILE_DESCRIPTION,
1589: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1590: LAST_UPDATED_BY = X_LAST_UPDATED_BY,