eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_LOAN_HEADER_ALL_PKG dependencies on LNS_LOAN_HEADERS_ALL

Line 105: SELECT ROWID FROM LNS_LOAN_HEADERS_ALL

101: X_FORGIVENESS_PERCENT IN NUMBER
102: ) IS
103:
104: CURSOR l_insert is
105: SELECT ROWID FROM LNS_LOAN_HEADERS_ALL
106: WHERE LOAN_ID = X_LOAN_ID ;
107:
108: l_rowid varchar2(2000);
109:

Line 121: INSERT INTO LNS_LOAN_HEADERS_ALL

117: ELSE
118: L_RESET_EXCHANGE_DATA := 'N';
119: END IF;
120:
121: INSERT INTO LNS_LOAN_HEADERS_ALL
122: (
123: LOAN_ID
124: ,LAST_UPDATE_DATE
125: ,LAST_UPDATED_BY

Line 336: INSERT INTO LNS_LOAN_HEADERS_ALL_TL (

332: X_LOAN_ID,
333: X_LOAN_NUMBER;
334:
335:
336: INSERT INTO LNS_LOAN_HEADERS_ALL_TL (
337: LOAN_ID
338: ,LOAN_DESCRIPTION
339: ,REFERENCE_DESCRIPTION
340: ,LANGUAGE

Line 362: from LNS_LOAN_HEADERS_ALL_TL T

358: FROM FND_LANGUAGES L
359: where L.INSTALLED_FLAG in ('I', 'B')
360: AND not exists
361: (select NULL
362: from LNS_LOAN_HEADERS_ALL_TL T
363: where T.LOAN_ID = X_LOAN_ID
364: and T.LANGUAGE = L.LANGUAGE_CODE);
365:
366: OPEN l_insert;

Line 492: p_table_name => 'LNS_LOAN_HEADERS_ALL'

488: --Call to record history
489: LNS_LOAN_HISTORY_PUB.log_record_pre(
490: p_id => X_LOAN_ID,
491: p_primary_key_name => 'LOAN_ID',
492: p_table_name => 'LNS_LOAN_HEADERS_ALL'
493: );
494:
495: UPDATE LNS_LOAN_HEADERS_ALL SET
496: LOAN_ID = DECODE( X_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )

Line 495: UPDATE LNS_LOAN_HEADERS_ALL SET

491: p_primary_key_name => 'LOAN_ID',
492: p_table_name => 'LNS_LOAN_HEADERS_ALL'
493: );
494:
495: UPDATE LNS_LOAN_HEADERS_ALL SET
496: LOAN_ID = DECODE( X_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
497: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
498: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
499: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

Line 603: UPDATE LNS_LOAN_HEADERS_ALL_TL SET

599: IF (SQL%NOTFOUND) THEN
600: RAISE NO_DATA_FOUND;
601: END IF;
602:
603: UPDATE LNS_LOAN_HEADERS_ALL_TL SET
604: LOAN_DESCRIPTION = DECODE( X_LOAN_DESCRIPTION, NULL, LOAN_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_LOAN_DESCRIPTION )
605: ,REFERENCE_DESCRIPTION = DECODE( X_REFERENCE_DESCRIPTION, NULL, REFERENCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, X_REFERENCE_DESCRIPTION )
606: ,LAST_UPDATE_DATE = sysdate
607: ,LAST_UPDATED_BY = fnd_global.user_id

Line 622: p_table_name => 'LNS_LOAN_HEADERS_ALL',

618: --Call to record history
619: LNS_LOAN_HISTORY_PUB.log_record_post(
620: p_id => X_LOAN_ID,
621: p_primary_key_name => 'LOAN_ID',
622: p_table_name => 'LNS_LOAN_HEADERS_ALL',
623: p_loan_id => X_LOAN_ID
624: );
625: END Update_Row;
626:

Line 734: CURSOR C IS SELECT * FROM LNS_LOAN_HEADERS_ALL

730: ,p_PARTY_TYPE VARCHAR2
731: ,p_FORGIVENESS_FLAG VARCHAR2
732: ,p_FORGIVENESS_PERCENT NUMBER
733: ) IS
734: CURSOR C IS SELECT * FROM LNS_LOAN_HEADERS_ALL
735: WHERE rowid = x_rowid
736: FOR UPDATE of LOAN_ID NOWAIT;
737: Recinfo C%ROWTYPE;
738:

Line 743: FROM LNS_LOAN_HEADERS_ALL_TL

739: CURSOR C_TL IS SELECT
740: LOAN_DESCRIPTION
741: ,REFERENCE_DESCRIPTION
742: ,decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
743: FROM LNS_LOAN_HEADERS_ALL_TL
744: WHERE rowid = x_rowid
745: FOR UPDATE of LOAN_ID NOWAIT;
746:
747: BEGIN

Line 793: delete from LNS_LOAN_HEADERS_ALL_TL T

789:
790: procedure ADD_LANGUAGE
791: is
792: begin
793: delete from LNS_LOAN_HEADERS_ALL_TL T
794: where not exists
795: (select NULL
796: from LNS_LOAN_HEADERS_ALL B
797: where B.LOAN_ID = T.LOAN_ID

Line 796: from LNS_LOAN_HEADERS_ALL B

792: begin
793: delete from LNS_LOAN_HEADERS_ALL_TL T
794: where not exists
795: (select NULL
796: from LNS_LOAN_HEADERS_ALL B
797: where B.LOAN_ID = T.LOAN_ID
798: );
799:
800: update LNS_LOAN_HEADERS_ALL_TL T set (

Line 800: update LNS_LOAN_HEADERS_ALL_TL T set (

796: from LNS_LOAN_HEADERS_ALL B
797: where B.LOAN_ID = T.LOAN_ID
798: );
799:
800: update LNS_LOAN_HEADERS_ALL_TL T set (
801: LOAN_DESCRIPTION,
802: REFERENCE_DESCRIPTION
803: ) = (select
804: B.LOAN_DESCRIPTION,

Line 806: from LNS_LOAN_HEADERS_ALL_TL B

802: REFERENCE_DESCRIPTION
803: ) = (select
804: B.LOAN_DESCRIPTION,
805: B.REFERENCE_DESCRIPTION
806: from LNS_LOAN_HEADERS_ALL_TL B
807: where B.LOAN_ID = T.LOAN_ID
808: and B.LANGUAGE = T.SOURCE_LANG)
809: where (
810: T.LOAN_ID,

Line 815: from LNS_LOAN_HEADERS_ALL_TL SUBB, LNS_LOAN_HEADERS_ALL_TL SUBT

811: T.LANGUAGE
812: ) in (select
813: SUBT.LOAN_ID,
814: SUBT.LANGUAGE
815: from LNS_LOAN_HEADERS_ALL_TL SUBB, LNS_LOAN_HEADERS_ALL_TL SUBT
816: where SUBB.LOAN_ID = SUBT.LOAN_ID
817: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
818: and (SUBB.LOAN_DESCRIPTION <> SUBT.LOAN_DESCRIPTION
819: or (SUBB.LOAN_DESCRIPTION is null and SUBT.LOAN_DESCRIPTION is not null)

Line 826: insert into LNS_LOAN_HEADERS_ALL_TL (

822: or (SUBB.REFERENCE_DESCRIPTION is null and SUBT.REFERENCE_DESCRIPTION is not null)
823: or (SUBB.REFERENCE_DESCRIPTION is not null and SUBT.REFERENCE_DESCRIPTION is null)
824: ));
825:
826: insert into LNS_LOAN_HEADERS_ALL_TL (
827: LOAN_ID,
828: LOAN_DESCRIPTION,
829: REFERENCE_DESCRIPTION,
830: LAST_UPDATE_DATE,

Line 848: from LNS_LOAN_HEADERS_ALL_TL B, FND_LANGUAGES L

844: B.CREATED_BY,
845: B.LAST_UPDATE_LOGIN,
846: L.LANGUAGE_CODE,
847: B.SOURCE_LANG
848: from LNS_LOAN_HEADERS_ALL_TL B, FND_LANGUAGES L
849: where L.INSTALLED_FLAG in ('I', 'B')
850: and B.LANGUAGE = userenv('LANG')
851: and not exists
852: (select NULL

Line 853: from LNS_LOAN_HEADERS_ALL_TL T

849: where L.INSTALLED_FLAG in ('I', 'B')
850: and B.LANGUAGE = userenv('LANG')
851: and not exists
852: (select NULL
853: from LNS_LOAN_HEADERS_ALL_TL T
854: where T.LOAN_ID = B.LOAN_ID
855: and T.LANGUAGE = L.LANGUAGE_CODE);
856: end ADD_LANGUAGE;
857:

Line 1153: FROM LNS_LOAN_HEADERS_ALL_VL

1149: X_CREATED_BY_MODULE,
1150: X_PARTY_TYPE,
1151: X_FORGIVENESS_FLAG,
1152: X_FORGIVENESS_PERCENT
1153: FROM LNS_LOAN_HEADERS_ALL_VL
1154: WHERE LOAN_ID = X_LOAN_ID;
1155:
1156: EXCEPTION
1157: WHEN NO_DATA_FOUND THEN

Line 1172: DELETE FROM LNS_LOAN_HEADERS_ALL_TL

1168: ) IS
1169:
1170: BEGIN
1171:
1172: DELETE FROM LNS_LOAN_HEADERS_ALL_TL
1173: WHERE LOAN_ID = X_LOAN_ID;
1174:
1175: IF ( SQL%NOTFOUND ) THEN
1176: RAISE NO_DATA_FOUND;

Line 1180: DELETE FROM LNS_LOAN_HEADERS_ALL

1176: RAISE NO_DATA_FOUND;
1177: END IF;
1178:
1179:
1180: DELETE FROM LNS_LOAN_HEADERS_ALL
1181: WHERE LOAN_ID = X_LOAN_ID;
1182:
1183: IF ( SQL%NOTFOUND ) THEN
1184: RAISE NO_DATA_FOUND;