APPS.IBY_PP_MLSUTL_PVT dependencies on IBY_TRANSMIT_CONFIGS_B

Line 1154: cursor C is select ROWID from IBY_TRANSMIT_CONFIGS_B

1150: X_LAST_UPDATE_DATE in DATE,
1151: X_LAST_UPDATED_BY in NUMBER,
1152: X_LAST_UPDATE_LOGIN in NUMBER
1153: ) is
1154: cursor C is select ROWID from IBY_TRANSMIT_CONFIGS_B
1155: where TRANSMIT_CONFIGURATION_ID = X_TRANSMIT_CONFIGURATION_ID
1156: ;
1157: begin
1158: insert into IBY_TRANSMIT_CONFIGS_B (

Line 1158: insert into IBY_TRANSMIT_CONFIGS_B (

1154: cursor C is select ROWID from IBY_TRANSMIT_CONFIGS_B
1155: where TRANSMIT_CONFIGURATION_ID = X_TRANSMIT_CONFIGURATION_ID
1156: ;
1157: begin
1158: insert into IBY_TRANSMIT_CONFIGS_B (
1159: OBJECT_VERSION_NUMBER,
1160: TUNNELING_TRANS_CONFIG_ID,
1161: TRANSMIT_CONFIGURATION_ID,
1162: TRANSMIT_PROTOCOL_CODE,

Line 1234: update IBY_TRANSMIT_CONFIGS_B set

1230: X_LAST_UPDATED_BY in NUMBER,
1231: X_LAST_UPDATE_LOGIN in NUMBER
1232: ) is
1233: begin
1234: update IBY_TRANSMIT_CONFIGS_B set
1235: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
1236: TUNNELING_TRANS_CONFIG_ID = X_TUNNELING_TRANS_CONFIG_ID,
1237: TRANSMIT_PROTOCOL_CODE = X_TRANSMIT_PROTOCOL_CODE,
1238: INACTIVE_DATE = X_INACTIVE_DATE,

Line 1273: delete from IBY_TRANSMIT_CONFIGS_B

1269: if (sql%notfound) then
1270: raise no_data_found;
1271: end if;
1272:
1273: delete from IBY_TRANSMIT_CONFIGS_B
1274: where TRANSMIT_CONFIGURATION_ID = X_TRANSMIT_CONFIGURATION_ID;
1275:
1276: if (sql%notfound) then
1277: raise no_data_found;

Line 1287: from IBY_TRANSMIT_CONFIGS_B B

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
1289: );
1290:
1291: update IBY_TRANSMIT_CONFIGS_TL T set (