APPS.IBY_PP_MLSUTL_PVT dependencies on IBY_TRANSMIT_CONFIGS_TL

Line 1182: insert into IBY_TRANSMIT_CONFIGS_TL (

1178: X_LAST_UPDATED_BY,
1179: X_LAST_UPDATE_LOGIN
1180: );
1181:
1182: insert into IBY_TRANSMIT_CONFIGS_TL (
1183: CREATION_DATE,
1184: LAST_UPDATED_BY,
1185: LAST_UPDATE_DATE,
1186: LAST_UPDATE_LOGIN,

Line 1208: from IBY_TRANSMIT_CONFIGS_TL T

1204: from FND_LANGUAGES L
1205: where L.INSTALLED_FLAG in ('I', 'B')
1206: and not exists
1207: (select NULL
1208: from IBY_TRANSMIT_CONFIGS_TL T
1209: where T.TRANSMIT_CONFIGURATION_ID = X_TRANSMIT_CONFIGURATION_ID
1210: and T.LANGUAGE = L.LANGUAGE_CODE);
1211:
1212: open c;

Line 1248: update IBY_TRANSMIT_CONFIGS_TL set

1244: if (sql%notfound) then
1245: raise no_data_found;
1246: end if;
1247:
1248: update IBY_TRANSMIT_CONFIGS_TL set
1249: TRANSMIT_CONFIGURATION_NAME = X_TRANSMIT_CONFIGURATION_NAME,
1250: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1251: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1252: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 1266: delete from IBY_TRANSMIT_CONFIGS_TL

1262: procedure TRANS_CONFIG_DELETE_ROW (
1263: X_TRANSMIT_CONFIGURATION_ID in NUMBER
1264: ) is
1265: begin
1266: delete from IBY_TRANSMIT_CONFIGS_TL
1267: where TRANSMIT_CONFIGURATION_ID = X_TRANSMIT_CONFIGURATION_ID;
1268:
1269: if (sql%notfound) then
1270: raise no_data_found;

Line 1284: delete from IBY_TRANSMIT_CONFIGS_TL T

1280:
1281: procedure TRANS_CONFIG_ADD_LANGUAGE
1282: is
1283: begin
1284: delete from IBY_TRANSMIT_CONFIGS_TL T
1285: where not exists
1286: (select NULL
1287: from IBY_TRANSMIT_CONFIGS_B B
1288: where B.TRANSMIT_CONFIGURATION_ID = T.TRANSMIT_CONFIGURATION_ID

Line 1291: update IBY_TRANSMIT_CONFIGS_TL T set (

1287: from IBY_TRANSMIT_CONFIGS_B B
1288: where B.TRANSMIT_CONFIGURATION_ID = T.TRANSMIT_CONFIGURATION_ID
1289: );
1290:
1291: update IBY_TRANSMIT_CONFIGS_TL T set (
1292: TRANSMIT_CONFIGURATION_NAME
1293: ) = (select
1294: B.TRANSMIT_CONFIGURATION_NAME
1295: from IBY_TRANSMIT_CONFIGS_TL B

Line 1295: from IBY_TRANSMIT_CONFIGS_TL B

1291: update IBY_TRANSMIT_CONFIGS_TL T set (
1292: TRANSMIT_CONFIGURATION_NAME
1293: ) = (select
1294: B.TRANSMIT_CONFIGURATION_NAME
1295: from IBY_TRANSMIT_CONFIGS_TL B
1296: where B.TRANSMIT_CONFIGURATION_ID = T.TRANSMIT_CONFIGURATION_ID
1297: and B.LANGUAGE = T.SOURCE_LANG)
1298: where (
1299: T.TRANSMIT_CONFIGURATION_ID,

Line 1304: from IBY_TRANSMIT_CONFIGS_TL SUBB, IBY_TRANSMIT_CONFIGS_TL SUBT

1300: T.LANGUAGE
1301: ) in (select
1302: SUBT.TRANSMIT_CONFIGURATION_ID,
1303: SUBT.LANGUAGE
1304: from IBY_TRANSMIT_CONFIGS_TL SUBB, IBY_TRANSMIT_CONFIGS_TL SUBT
1305: where SUBB.TRANSMIT_CONFIGURATION_ID = SUBT.TRANSMIT_CONFIGURATION_ID
1306: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1307: and (SUBB.TRANSMIT_CONFIGURATION_NAME <> SUBT.TRANSMIT_CONFIGURATION_NAME
1308: ));

Line 1310: insert into IBY_TRANSMIT_CONFIGS_TL (

1306: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1307: and (SUBB.TRANSMIT_CONFIGURATION_NAME <> SUBT.TRANSMIT_CONFIGURATION_NAME
1308: ));
1309:
1310: insert into IBY_TRANSMIT_CONFIGS_TL (
1311: CREATION_DATE,
1312: LAST_UPDATED_BY,
1313: LAST_UPDATE_DATE,
1314: LAST_UPDATE_LOGIN,

Line 1332: from IBY_TRANSMIT_CONFIGS_TL B, FND_LANGUAGES L

1328: B.CREATED_BY,
1329: B.TRANSMIT_CONFIGURATION_ID,
1330: L.LANGUAGE_CODE,
1331: B.SOURCE_LANG
1332: from IBY_TRANSMIT_CONFIGS_TL B, FND_LANGUAGES L
1333: where L.INSTALLED_FLAG in ('I', 'B')
1334: and B.LANGUAGE = userenv('LANG')
1335: and not exists
1336: (select NULL

Line 1337: from IBY_TRANSMIT_CONFIGS_TL T

1333: where L.INSTALLED_FLAG in ('I', 'B')
1334: and B.LANGUAGE = userenv('LANG')
1335: and not exists
1336: (select NULL
1337: from IBY_TRANSMIT_CONFIGS_TL T
1338: where T.TRANSMIT_CONFIGURATION_ID = B.TRANSMIT_CONFIGURATION_ID
1339: and T.LANGUAGE = L.LANGUAGE_CODE);
1340: end TRANS_CONFIG_ADD_LANGUAGE;
1341: