APPS.LNS_LOAN_HEADER_ALL_PKG dependencies on LNS_LOAN_HEADERS_ALL_TL

Line 349: INSERT INTO LNS_LOAN_HEADERS_ALL_TL (

345: X_LOAN_ID,
346: X_LOAN_NUMBER;
347:
348:
349: INSERT INTO LNS_LOAN_HEADERS_ALL_TL (
350: LOAN_ID
351: ,LOAN_DESCRIPTION
352: ,REFERENCE_DESCRIPTION
353: ,LANGUAGE

Line 375: from LNS_LOAN_HEADERS_ALL_TL T

371: FROM FND_LANGUAGES L
372: where L.INSTALLED_FLAG in ('I', 'B')
373: AND not exists
374: (select NULL
375: from LNS_LOAN_HEADERS_ALL_TL T
376: where T.LOAN_ID = X_LOAN_ID
377: and T.LANGUAGE = L.LANGUAGE_CODE);
378:
379: OPEN l_insert;

Line 625: UPDATE LNS_LOAN_HEADERS_ALL_TL SET

621: IF (SQL%NOTFOUND) THEN
622: RAISE NO_DATA_FOUND;
623: END IF;
624:
625: UPDATE LNS_LOAN_HEADERS_ALL_TL SET
626: LOAN_DESCRIPTION = DECODE( X_LOAN_DESCRIPTION, NULL, LOAN_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_LOAN_DESCRIPTION )
627: ,REFERENCE_DESCRIPTION = DECODE( X_REFERENCE_DESCRIPTION, NULL, REFERENCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_REFERENCE_DESCRIPTION )
628: ,LAST_UPDATE_DATE = sysdate
629: ,LAST_UPDATED_BY = fnd_global.user_id

Line 769: FROM LNS_LOAN_HEADERS_ALL_TL

765: CURSOR C_TL IS SELECT
766: LOAN_DESCRIPTION
767: ,REFERENCE_DESCRIPTION
768: ,decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
769: FROM LNS_LOAN_HEADERS_ALL_TL
770: WHERE rowid = x_rowid
771: FOR UPDATE of LOAN_ID NOWAIT;
772:
773: BEGIN

Line 819: delete from LNS_LOAN_HEADERS_ALL_TL T

815:
816: procedure ADD_LANGUAGE
817: is
818: begin
819: delete from LNS_LOAN_HEADERS_ALL_TL T
820: where not exists
821: (select NULL
822: from LNS_LOAN_HEADERS_ALL B
823: where B.LOAN_ID = T.LOAN_ID

Line 826: update LNS_LOAN_HEADERS_ALL_TL T set (

822: from LNS_LOAN_HEADERS_ALL B
823: where B.LOAN_ID = T.LOAN_ID
824: );
825:
826: update LNS_LOAN_HEADERS_ALL_TL T set (
827: LOAN_DESCRIPTION,
828: REFERENCE_DESCRIPTION
829: ) = (select
830: B.LOAN_DESCRIPTION,

Line 832: from LNS_LOAN_HEADERS_ALL_TL B

828: REFERENCE_DESCRIPTION
829: ) = (select
830: B.LOAN_DESCRIPTION,
831: B.REFERENCE_DESCRIPTION
832: from LNS_LOAN_HEADERS_ALL_TL B
833: where B.LOAN_ID = T.LOAN_ID
834: and B.LANGUAGE = T.SOURCE_LANG)
835: where (
836: T.LOAN_ID,

Line 841: from LNS_LOAN_HEADERS_ALL_TL SUBB, LNS_LOAN_HEADERS_ALL_TL SUBT

837: T.LANGUAGE
838: ) in (select
839: SUBT.LOAN_ID,
840: SUBT.LANGUAGE
841: from LNS_LOAN_HEADERS_ALL_TL SUBB, LNS_LOAN_HEADERS_ALL_TL SUBT
842: where SUBB.LOAN_ID = SUBT.LOAN_ID
843: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
844: and (SUBB.LOAN_DESCRIPTION <> SUBT.LOAN_DESCRIPTION
845: or (SUBB.LOAN_DESCRIPTION is null and SUBT.LOAN_DESCRIPTION is not null)

Line 852: insert into LNS_LOAN_HEADERS_ALL_TL (

848: or (SUBB.REFERENCE_DESCRIPTION is null and SUBT.REFERENCE_DESCRIPTION is not null)
849: or (SUBB.REFERENCE_DESCRIPTION is not null and SUBT.REFERENCE_DESCRIPTION is null)
850: ));
851:
852: insert into LNS_LOAN_HEADERS_ALL_TL (
853: LOAN_ID,
854: LOAN_DESCRIPTION,
855: REFERENCE_DESCRIPTION,
856: LAST_UPDATE_DATE,

Line 874: from LNS_LOAN_HEADERS_ALL_TL B, FND_LANGUAGES L

870: B.CREATED_BY,
871: B.LAST_UPDATE_LOGIN,
872: L.LANGUAGE_CODE,
873: B.SOURCE_LANG
874: from LNS_LOAN_HEADERS_ALL_TL B, FND_LANGUAGES L
875: where L.INSTALLED_FLAG in ('I', 'B')
876: and B.LANGUAGE = userenv('LANG')
877: and not exists
878: (select NULL

Line 879: from LNS_LOAN_HEADERS_ALL_TL T

875: where L.INSTALLED_FLAG in ('I', 'B')
876: and B.LANGUAGE = userenv('LANG')
877: and not exists
878: (select NULL
879: from LNS_LOAN_HEADERS_ALL_TL T
880: where T.LOAN_ID = B.LOAN_ID
881: and T.LANGUAGE = L.LANGUAGE_CODE);
882: end ADD_LANGUAGE;
883:

Line 1207: DELETE FROM LNS_LOAN_HEADERS_ALL_TL

1203: ) IS
1204:
1205: BEGIN
1206:
1207: DELETE FROM LNS_LOAN_HEADERS_ALL_TL
1208: WHERE LOAN_ID = X_LOAN_ID;
1209:
1210: IF ( SQL%NOTFOUND ) THEN
1211: RAISE NO_DATA_FOUND;