APPS.IBY_PP_MLSUTL_PVT dependencies on IBY_TRANSMIT_PROTOCOLS_B

Line 566: cursor C is select ROWID from IBY_TRANSMIT_PROTOCOLS_B

562: X_LAST_UPDATE_DATE in DATE,
563: X_LAST_UPDATED_BY in NUMBER,
564: X_LAST_UPDATE_LOGIN in NUMBER
565: ) is
566: cursor C is select ROWID from IBY_TRANSMIT_PROTOCOLS_B
567: where TRANSMIT_PROTOCOL_CODE = X_TRANSMIT_PROTOCOL_CODE
568: ;
569: begin
570: insert into IBY_TRANSMIT_PROTOCOLS_B (

Line 570: insert into IBY_TRANSMIT_PROTOCOLS_B (

566: cursor C is select ROWID from IBY_TRANSMIT_PROTOCOLS_B
567: where TRANSMIT_PROTOCOL_CODE = X_TRANSMIT_PROTOCOL_CODE
568: ;
569: begin
570: insert into IBY_TRANSMIT_PROTOCOLS_B (
571: OBJECT_VERSION_NUMBER,
572: TRANSMIT_PROTOCOL_CODE,
573: TRANSMIT_CODE_LANGUAGE,
574: TRANSMIT_CODE_PACKAGE,

Line 646: update IBY_TRANSMIT_PROTOCOLS_B set

642: X_LAST_UPDATED_BY in NUMBER,
643: X_LAST_UPDATE_LOGIN in NUMBER
644: ) is
645: begin
646: update IBY_TRANSMIT_PROTOCOLS_B set
647: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
648: TRANSMIT_CODE_LANGUAGE = X_TRANSMIT_CODE_LANGUAGE,
649: TRANSMIT_CODE_PACKAGE = X_TRANSMIT_CODE_PACKAGE,
650: TRANSMIT_CODE_ENTRY_POINT = X_TRANSMIT_CODE_ENTRY_POINT,

Line 685: delete from IBY_TRANSMIT_PROTOCOLS_B

681: if (sql%notfound) then
682: raise no_data_found;
683: end if;
684:
685: delete from IBY_TRANSMIT_PROTOCOLS_B
686: where TRANSMIT_PROTOCOL_CODE = X_TRANSMIT_PROTOCOL_CODE;
687:
688: if (sql%notfound) then
689: raise no_data_found;

Line 699: from IBY_TRANSMIT_PROTOCOLS_B B

695: begin
696: delete from IBY_TRANSMIT_PROTOCOLS_TL T
697: where not exists
698: (select NULL
699: from IBY_TRANSMIT_PROTOCOLS_B B
700: where B.TRANSMIT_PROTOCOL_CODE = T.TRANSMIT_PROTOCOL_CODE
701: );
702:
703: update IBY_TRANSMIT_PROTOCOLS_TL T set (