APPS.IBY_PP_MLSUTL_PVT dependencies on IBY_TRANSMIT_PARAMETERS_TL

Line 874: insert into IBY_TRANSMIT_PARAMETERS_TL (

870: X_LAST_UPDATED_BY,
871: X_LAST_UPDATE_LOGIN
872: );
873:
874: insert into IBY_TRANSMIT_PARAMETERS_TL (
875: TRANSMIT_PARAMETER_CODE,
876: TRANSMIT_PROTOCOL_CODE,
877: TRANSMIT_PARAMETER_NAME,
878: CREATED_BY,

Line 902: from IBY_TRANSMIT_PARAMETERS_TL T

898: from FND_LANGUAGES L
899: where L.INSTALLED_FLAG in ('I', 'B')
900: and not exists
901: (select NULL
902: from IBY_TRANSMIT_PARAMETERS_TL T
903: where T.TRANSMIT_PROTOCOL_CODE = X_TRANSMIT_PROTOCOL_CODE
904: and T.TRANSMIT_PARAMETER_CODE = X_TRANSMIT_PARAMETER_CODE
905: and T.LANGUAGE = L.LANGUAGE_CODE);
906:

Line 955: update IBY_TRANSMIT_PARAMETERS_TL set

951: if (sql%notfound) then
952: raise no_data_found;
953: end if;
954:
955: update IBY_TRANSMIT_PARAMETERS_TL set
956: TRANSMIT_PARAMETER_NAME = X_TRANSMIT_PARAMETER_NAME,
957: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
958: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
959: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 975: delete from IBY_TRANSMIT_PARAMETERS_TL

971: X_TRANSMIT_PROTOCOL_CODE in VARCHAR2,
972: X_TRANSMIT_PARAMETER_CODE in VARCHAR2
973: ) is
974: begin
975: delete from IBY_TRANSMIT_PARAMETERS_TL
976: where TRANSMIT_PROTOCOL_CODE = X_TRANSMIT_PROTOCOL_CODE
977: and TRANSMIT_PARAMETER_CODE = X_TRANSMIT_PARAMETER_CODE;
978:
979: if (sql%notfound) then

Line 995: delete from IBY_TRANSMIT_PARAMETERS_TL T

991:
992: procedure TRANS_PARAM_ADD_LANGUAGE
993: is
994: begin
995: delete from IBY_TRANSMIT_PARAMETERS_TL T
996: where not exists
997: (select NULL
998: from IBY_TRANSMIT_PARAMETERS_B B
999: where B.TRANSMIT_PROTOCOL_CODE = T.TRANSMIT_PROTOCOL_CODE

Line 1003: update IBY_TRANSMIT_PARAMETERS_TL T set (

999: where B.TRANSMIT_PROTOCOL_CODE = T.TRANSMIT_PROTOCOL_CODE
1000: and B.TRANSMIT_PARAMETER_CODE = T.TRANSMIT_PARAMETER_CODE
1001: );
1002:
1003: update IBY_TRANSMIT_PARAMETERS_TL T set (
1004: TRANSMIT_PARAMETER_NAME
1005: ) = (select
1006: B.TRANSMIT_PARAMETER_NAME
1007: from IBY_TRANSMIT_PARAMETERS_TL B

Line 1007: from IBY_TRANSMIT_PARAMETERS_TL B

1003: update IBY_TRANSMIT_PARAMETERS_TL T set (
1004: TRANSMIT_PARAMETER_NAME
1005: ) = (select
1006: B.TRANSMIT_PARAMETER_NAME
1007: from IBY_TRANSMIT_PARAMETERS_TL B
1008: where B.TRANSMIT_PROTOCOL_CODE = T.TRANSMIT_PROTOCOL_CODE
1009: and B.TRANSMIT_PARAMETER_CODE = T.TRANSMIT_PARAMETER_CODE
1010: and B.LANGUAGE = T.SOURCE_LANG)
1011: where (

Line 1019: from IBY_TRANSMIT_PARAMETERS_TL SUBB, IBY_TRANSMIT_PARAMETERS_TL SUBT

1015: ) in (select
1016: SUBT.TRANSMIT_PROTOCOL_CODE,
1017: SUBT.TRANSMIT_PARAMETER_CODE,
1018: SUBT.LANGUAGE
1019: from IBY_TRANSMIT_PARAMETERS_TL SUBB, IBY_TRANSMIT_PARAMETERS_TL SUBT
1020: where SUBB.TRANSMIT_PROTOCOL_CODE = SUBT.TRANSMIT_PROTOCOL_CODE
1021: and SUBB.TRANSMIT_PARAMETER_CODE = SUBT.TRANSMIT_PARAMETER_CODE
1022: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1023: and (SUBB.TRANSMIT_PARAMETER_NAME <> SUBT.TRANSMIT_PARAMETER_NAME

Line 1026: insert into IBY_TRANSMIT_PARAMETERS_TL (

1022: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1023: and (SUBB.TRANSMIT_PARAMETER_NAME <> SUBT.TRANSMIT_PARAMETER_NAME
1024: ));
1025:
1026: insert into IBY_TRANSMIT_PARAMETERS_TL (
1027: TRANSMIT_PARAMETER_CODE,
1028: TRANSMIT_PROTOCOL_CODE,
1029: TRANSMIT_PARAMETER_NAME,
1030: CREATED_BY,

Line 1050: from IBY_TRANSMIT_PARAMETERS_TL B, FND_LANGUAGES L

1046: B.LAST_UPDATE_LOGIN,
1047: B.OBJECT_VERSION_NUMBER,
1048: L.LANGUAGE_CODE,
1049: B.SOURCE_LANG
1050: from IBY_TRANSMIT_PARAMETERS_TL B, FND_LANGUAGES L
1051: where L.INSTALLED_FLAG in ('I', 'B')
1052: and B.LANGUAGE = userenv('LANG')
1053: and not exists
1054: (select NULL

Line 1055: from IBY_TRANSMIT_PARAMETERS_TL T

1051: where L.INSTALLED_FLAG in ('I', 'B')
1052: and B.LANGUAGE = userenv('LANG')
1053: and not exists
1054: (select NULL
1055: from IBY_TRANSMIT_PARAMETERS_TL T
1056: where T.TRANSMIT_PROTOCOL_CODE = B.TRANSMIT_PROTOCOL_CODE
1057: and T.TRANSMIT_PARAMETER_CODE = B.TRANSMIT_PARAMETER_CODE
1058: and T.LANGUAGE = L.LANGUAGE_CODE);
1059: end TRANS_PARAM_ADD_LANGUAGE;

Line 1127: update iby_transmit_parameters_tl set

1123: X_LAST_UPDATE_DATE in DATE,
1124: X_OWNER in VARCHAR2)
1125: is
1126: begin
1127: update iby_transmit_parameters_tl set
1128: TRANSMIT_PARAMETER_NAME = X_TRANSMIT_PARAMETER_NAME,
1129: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
1130: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
1131: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,