APPS.IBY_PP_MLSUTL_PVT dependencies on IBY_TRANSMIT_PROTOCOLS_TL

Line 594: insert into IBY_TRANSMIT_PROTOCOLS_TL (

590: X_LAST_UPDATED_BY,
591: X_LAST_UPDATE_LOGIN
592: );
593:
594: insert into IBY_TRANSMIT_PROTOCOLS_TL (
595: TRANSMIT_PROTOCOL_CODE,
596: TRANSMIT_PROTOCOL_NAME,
597: CREATED_BY,
598: CREATION_DATE,

Line 620: from IBY_TRANSMIT_PROTOCOLS_TL T

616: from FND_LANGUAGES L
617: where L.INSTALLED_FLAG in ('I', 'B')
618: and not exists
619: (select NULL
620: from IBY_TRANSMIT_PROTOCOLS_TL T
621: where T.TRANSMIT_PROTOCOL_CODE = X_TRANSMIT_PROTOCOL_CODE
622: and T.LANGUAGE = L.LANGUAGE_CODE);
623:
624: open c;

Line 660: update IBY_TRANSMIT_PROTOCOLS_TL set

656: if (sql%notfound) then
657: raise no_data_found;
658: end if;
659:
660: update IBY_TRANSMIT_PROTOCOLS_TL set
661: TRANSMIT_PROTOCOL_NAME = X_TRANSMIT_PROTOCOL_NAME,
662: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
663: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
664: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 678: delete from IBY_TRANSMIT_PROTOCOLS_TL

674: procedure TRANS_PROT_DELETE_ROW (
675: X_TRANSMIT_PROTOCOL_CODE in VARCHAR2
676: ) is
677: begin
678: delete from IBY_TRANSMIT_PROTOCOLS_TL
679: where TRANSMIT_PROTOCOL_CODE = X_TRANSMIT_PROTOCOL_CODE;
680:
681: if (sql%notfound) then
682: raise no_data_found;

Line 696: delete from IBY_TRANSMIT_PROTOCOLS_TL T

692:
693: procedure TRANS_PROT_ADD_LANGUAGE
694: is
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

Line 703: update IBY_TRANSMIT_PROTOCOLS_TL T set (

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 (
704: TRANSMIT_PROTOCOL_NAME
705: ) = (select
706: B.TRANSMIT_PROTOCOL_NAME
707: from IBY_TRANSMIT_PROTOCOLS_TL B

Line 707: from IBY_TRANSMIT_PROTOCOLS_TL B

703: update IBY_TRANSMIT_PROTOCOLS_TL T set (
704: TRANSMIT_PROTOCOL_NAME
705: ) = (select
706: B.TRANSMIT_PROTOCOL_NAME
707: from IBY_TRANSMIT_PROTOCOLS_TL B
708: where B.TRANSMIT_PROTOCOL_CODE = T.TRANSMIT_PROTOCOL_CODE
709: and B.LANGUAGE = T.SOURCE_LANG)
710: where (
711: T.TRANSMIT_PROTOCOL_CODE,

Line 716: from IBY_TRANSMIT_PROTOCOLS_TL SUBB, IBY_TRANSMIT_PROTOCOLS_TL SUBT

712: T.LANGUAGE
713: ) in (select
714: SUBT.TRANSMIT_PROTOCOL_CODE,
715: SUBT.LANGUAGE
716: from IBY_TRANSMIT_PROTOCOLS_TL SUBB, IBY_TRANSMIT_PROTOCOLS_TL SUBT
717: where SUBB.TRANSMIT_PROTOCOL_CODE = SUBT.TRANSMIT_PROTOCOL_CODE
718: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
719: and (SUBB.TRANSMIT_PROTOCOL_NAME <> SUBT.TRANSMIT_PROTOCOL_NAME
720: ));

Line 722: insert into IBY_TRANSMIT_PROTOCOLS_TL (

718: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
719: and (SUBB.TRANSMIT_PROTOCOL_NAME <> SUBT.TRANSMIT_PROTOCOL_NAME
720: ));
721:
722: insert into IBY_TRANSMIT_PROTOCOLS_TL (
723: TRANSMIT_PROTOCOL_CODE,
724: TRANSMIT_PROTOCOL_NAME,
725: CREATED_BY,
726: CREATION_DATE,

Line 744: from IBY_TRANSMIT_PROTOCOLS_TL B, FND_LANGUAGES L

740: B.LAST_UPDATE_LOGIN,
741: B.OBJECT_VERSION_NUMBER,
742: L.LANGUAGE_CODE,
743: B.SOURCE_LANG
744: from IBY_TRANSMIT_PROTOCOLS_TL B, FND_LANGUAGES L
745: where L.INSTALLED_FLAG in ('I', 'B')
746: and B.LANGUAGE = userenv('LANG')
747: and not exists
748: (select NULL

Line 749: from IBY_TRANSMIT_PROTOCOLS_TL T

745: where L.INSTALLED_FLAG in ('I', 'B')
746: and B.LANGUAGE = userenv('LANG')
747: and not exists
748: (select NULL
749: from IBY_TRANSMIT_PROTOCOLS_TL T
750: where T.TRANSMIT_PROTOCOL_CODE = B.TRANSMIT_PROTOCOL_CODE
751: and T.LANGUAGE = L.LANGUAGE_CODE);
752: end TRANS_PROT_ADD_LANGUAGE;
753:

Line 801: update iby_transmit_protocols_tl set

797: X_LAST_UPDATE_DATE in DATE,
798: X_OWNER in VARCHAR2)
799: is
800: begin
801: update iby_transmit_protocols_tl set
802: TRANSMIT_PROTOCOL_NAME = X_TRANSMIT_PROTOCOL_NAME,
803: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
804: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
805: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,