eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_UPG_PPP_PKG dependencies on IBY_UPG_PPP_TL

Line 284: insert into IBY_UPG_PPP_TL (

280: X_INST_GROUP_BY_PAYMENT_METHOD,
281: X_INACTIVE_DATE
282: );
283:
284: insert into IBY_UPG_PPP_TL (
285: SYSTEM_PROFILE_CODE,
286: SYSTEM_PROFILE_NAME,
287: SYSTEM_PROFILE_DESCRIPTION,
288: CREATED_BY,

Line 312: from IBY_UPG_PPP_TL T

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

Line 516: from IBY_UPG_PPP_TL

512: cursor c1 is select
513: SYSTEM_PROFILE_NAME,
514: SYSTEM_PROFILE_DESCRIPTION,
515: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
516: from IBY_UPG_PPP_TL
517: where SYSTEM_PROFILE_CODE = X_SYSTEM_PROFILE_CODE
518: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
519: for update of SYSTEM_PROFILE_CODE nowait;
520: begin

Line 924: iby_upg_ppp_tl ppp,

920: UNION ALL
921:
922: SELECT distinct(ppb.system_profile_code) system_profile_code
923: FROM iby_formats_b ipf,
924: iby_upg_ppp_tl ppp,
925: iby_upg_ppp_b ppb,
926: iby_acct_pmt_profiles_b app,
927: iby_bepinfo bep,
928: iby_bepkeys key1

Line 1218: update IBY_UPG_PPP_TL set

1214:
1215: END LOOP;
1216: END IF;
1217:
1218: update IBY_UPG_PPP_TL set
1219: SYSTEM_PROFILE_NAME = X_SYSTEM_PROFILE_NAME,
1220: SYSTEM_PROFILE_DESCRIPTION = X_SYSTEM_PROFILE_DESCRIPTION,
1221: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1222: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 1232: update IBY_UPG_PPP_TL set

1228: if (sql%notfound) then
1229: raise no_data_found;
1230: end if;
1231:
1232: update IBY_UPG_PPP_TL set
1233: SYSTEM_PROFILE_NAME = X_SYSTEM_PROFILE_NAME,
1234: SYSTEM_PROFILE_DESCRIPTION = X_SYSTEM_PROFILE_DESCRIPTION,
1235: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1236: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 1262: delete from IBY_UPG_PPP_TL

1258: procedure DELETE_ROW (
1259: X_SYSTEM_PROFILE_CODE in VARCHAR2
1260: ) is
1261: begin
1262: delete from IBY_UPG_PPP_TL
1263: where SYSTEM_PROFILE_CODE = X_SYSTEM_PROFILE_CODE;
1264:
1265: /* Commented the code below for fixing Bug# 8691900 */
1266: /*if (sql%notfound) then

Line 1283: delete from IBY_UPG_PPP_TL T

1279:
1280: procedure ADD_LANGUAGE
1281: is
1282: begin
1283: delete from IBY_UPG_PPP_TL T
1284: where not exists
1285: (select NULL
1286: from IBY_UPG_PPP_B B
1287: where B.SYSTEM_PROFILE_CODE = T.SYSTEM_PROFILE_CODE

Line 1290: update IBY_UPG_PPP_TL T set (

1286: from IBY_UPG_PPP_B B
1287: where B.SYSTEM_PROFILE_CODE = T.SYSTEM_PROFILE_CODE
1288: );
1289:
1290: update IBY_UPG_PPP_TL T set (
1291: SYSTEM_PROFILE_NAME,
1292: SYSTEM_PROFILE_DESCRIPTION
1293: ) = (select
1294: B.SYSTEM_PROFILE_NAME,

Line 1296: from IBY_UPG_PPP_TL B

1292: SYSTEM_PROFILE_DESCRIPTION
1293: ) = (select
1294: B.SYSTEM_PROFILE_NAME,
1295: B.SYSTEM_PROFILE_DESCRIPTION
1296: from IBY_UPG_PPP_TL B
1297: where B.SYSTEM_PROFILE_CODE = T.SYSTEM_PROFILE_CODE
1298: and B.LANGUAGE = T.SOURCE_LANG)
1299: where (
1300: T.SYSTEM_PROFILE_CODE,

Line 1305: from IBY_UPG_PPP_TL SUBB, IBY_UPG_PPP_TL SUBT

1301: T.LANGUAGE
1302: ) in (select
1303: SUBT.SYSTEM_PROFILE_CODE,
1304: SUBT.LANGUAGE
1305: from IBY_UPG_PPP_TL SUBB, IBY_UPG_PPP_TL SUBT
1306: where SUBB.SYSTEM_PROFILE_CODE = SUBT.SYSTEM_PROFILE_CODE
1307: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1308: and (SUBB.SYSTEM_PROFILE_NAME <> SUBT.SYSTEM_PROFILE_NAME
1309: or SUBB.SYSTEM_PROFILE_DESCRIPTION <> SUBT.SYSTEM_PROFILE_DESCRIPTION

Line 1314: insert into IBY_UPG_PPP_TL (

1310: or (SUBB.SYSTEM_PROFILE_DESCRIPTION is null and SUBT.SYSTEM_PROFILE_DESCRIPTION is not null)
1311: or (SUBB.SYSTEM_PROFILE_DESCRIPTION is not null and SUBT.SYSTEM_PROFILE_DESCRIPTION is null)
1312: ));
1313:
1314: insert into IBY_UPG_PPP_TL (
1315: SYSTEM_PROFILE_CODE,
1316: SYSTEM_PROFILE_NAME,
1317: SYSTEM_PROFILE_DESCRIPTION,
1318: CREATED_BY,

Line 1338: from IBY_UPG_PPP_TL B, FND_LANGUAGES L

1334: B.LAST_UPDATE_LOGIN,
1335: B.OBJECT_VERSION_NUMBER,
1336: L.LANGUAGE_CODE,
1337: B.SOURCE_LANG
1338: from IBY_UPG_PPP_TL B, FND_LANGUAGES L
1339: where L.INSTALLED_FLAG in ('I', 'B')
1340: and B.LANGUAGE = userenv('LANG')
1341: and not exists
1342: (select NULL

Line 1343: from IBY_UPG_PPP_TL T

1339: where L.INSTALLED_FLAG in ('I', 'B')
1340: and B.LANGUAGE = userenv('LANG')
1341: and not exists
1342: (select NULL
1343: from IBY_UPG_PPP_TL T
1344: where T.SYSTEM_PROFILE_CODE = B.SYSTEM_PROFILE_CODE
1345: and T.LANGUAGE = L.LANGUAGE_CODE);
1346: end ADD_LANGUAGE;
1347:

Line 1643: update IBY_UPG_PPP_TL set

1639: X_LAST_UPDATED_BY in NUMBER,
1640: X_LAST_UPDATE_LOGIN in NUMBER)
1641: is
1642: begin
1643: update IBY_UPG_PPP_TL set
1644: SYSTEM_PROFILE_NAME = X_SYSTEM_PROFILE_NAME,
1645: SYSTEM_PROFILE_DESCRIPTION = X_SYSTEM_PROFILE_DESCRIPTION,
1646: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1647: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 2918: iby_upg_ppp_tl ppp,

2914: FROM
2915: ap_check_formats cf,
2916: ap_payment_programs pp,
2917: iby_formats_b ipf,
2918: iby_upg_ppp_tl ppp,
2919: iby_upg_ppp_b ppb,
2920: iby_acct_pmt_profiles_b app,
2921: iby_bepinfo bep,
2922: iby_bepkeys key,

Line 2960: iby_upg_ppp_tl ppp,

2956: rank() over (partition by app.system_profile_code
2957: order by app.payment_profile_id) create_header
2958: FROM
2959: iby_formats_b ipf,
2960: iby_upg_ppp_tl ppp,
2961: iby_upg_ppp_b ppb,
2962: iby_acct_pmt_profiles_b app,
2963: iby_bepinfo bep,
2964: iby_bepkeys key