APPS.IBY_PP_MLSUTL_PVT dependencies on IBY_TRANSMIT_PARAMETERS_B

Line 833: cursor C is select ROWID from IBY_TRANSMIT_PARAMETERS_B

829: X_LAST_UPDATE_DATE in DATE,
830: X_LAST_UPDATED_BY in NUMBER,
831: X_LAST_UPDATE_LOGIN in NUMBER
832: ) is
833: cursor C is select ROWID from IBY_TRANSMIT_PARAMETERS_B
834: where TRANSMIT_PROTOCOL_CODE = X_TRANSMIT_PROTOCOL_CODE
835: and TRANSMIT_PARAMETER_CODE = X_TRANSMIT_PARAMETER_CODE
836: ;
837: begin

Line 838: insert into IBY_TRANSMIT_PARAMETERS_B (

834: where TRANSMIT_PROTOCOL_CODE = X_TRANSMIT_PROTOCOL_CODE
835: and TRANSMIT_PARAMETER_CODE = X_TRANSMIT_PARAMETER_CODE
836: ;
837: begin
838: insert into IBY_TRANSMIT_PARAMETERS_B (
839: TRANSMIT_PARAMETER_CODE,
840: TRANSMIT_PARAMETER_TYPE,
841: TRANSMIT_PROTOCOL_CODE,
842: MANDATORY_FLAG,

Line 935: update IBY_TRANSMIT_PARAMETERS_B set

931: X_LAST_UPDATED_BY in NUMBER,
932: X_LAST_UPDATE_LOGIN in NUMBER
933: ) is
934: begin
935: update IBY_TRANSMIT_PARAMETERS_B set
936: TRANSMIT_PARAMETER_TYPE = X_TRANSMIT_PARAMETER_TYPE,
937: MANDATORY_FLAG = X_MANDATORY_FLAG,
938: DISPLAY_ORDER = X_DISPLAY_ORDER,
939: DYNAMIC_FLAG = X_DYNAMIC_FLAG,

Line 983: delete from IBY_TRANSMIT_PARAMETERS_B

979: if (sql%notfound) then
980: raise no_data_found;
981: end if;
982:
983: delete from IBY_TRANSMIT_PARAMETERS_B
984: where TRANSMIT_PROTOCOL_CODE = X_TRANSMIT_PROTOCOL_CODE
985: and TRANSMIT_PARAMETER_CODE = X_TRANSMIT_PARAMETER_CODE;
986:
987: if (sql%notfound) then

Line 998: from IBY_TRANSMIT_PARAMETERS_B B

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
1000: and B.TRANSMIT_PARAMETER_CODE = T.TRANSMIT_PARAMETER_CODE
1001: );
1002: