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 109: SELECT ROWID FROM LNS_LOAN_HEADERS_ALL

105: X_BILL_ON_APPR_AMOUNT_FLAG IN VARCHAR2
106: ) IS
107:
108: CURSOR l_insert is
109: SELECT ROWID FROM LNS_LOAN_HEADERS_ALL
110: WHERE LOAN_ID = X_LOAN_ID ;
111:
112: l_rowid varchar2(2000);
113:

Line 125: INSERT INTO LNS_LOAN_HEADERS_ALL

121: ELSE
122: L_RESET_EXCHANGE_DATA := 'N';
123: END IF;
124:
125: INSERT INTO LNS_LOAN_HEADERS_ALL
126: (
127: LOAN_ID
128: ,LAST_UPDATE_DATE
129: ,LAST_UPDATED_BY

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 509: p_table_name => 'LNS_LOAN_HEADERS_ALL'

505: --Call to record history
506: LNS_LOAN_HISTORY_PUB.log_record_pre(
507: p_id => X_LOAN_ID,
508: p_primary_key_name => 'LOAN_ID',
509: p_table_name => 'LNS_LOAN_HEADERS_ALL'
510: );
511:
512: UPDATE LNS_LOAN_HEADERS_ALL SET
513: LOAN_ID = DECODE( X_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )

Line 512: UPDATE LNS_LOAN_HEADERS_ALL SET

508: p_primary_key_name => 'LOAN_ID',
509: p_table_name => 'LNS_LOAN_HEADERS_ALL'
510: );
511:
512: UPDATE LNS_LOAN_HEADERS_ALL SET
513: LOAN_ID = DECODE( X_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM, NULL, X_LOAN_ID )
514: ,LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE
515: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY
516: ,LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

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 644: p_table_name => 'LNS_LOAN_HEADERS_ALL',

640: --Call to record history
641: LNS_LOAN_HISTORY_PUB.log_record_post(
642: p_id => X_LOAN_ID,
643: p_primary_key_name => 'LOAN_ID',
644: p_table_name => 'LNS_LOAN_HEADERS_ALL',
645: p_loan_id => X_LOAN_ID
646: );
647: END Update_Row;
648:

Line 760: CURSOR C IS SELECT * FROM LNS_LOAN_HEADERS_ALL

756: ,p_ADD_REQUESTED_AMOUNT NUMBER
757: ,p_DISABLE_INT_ACCRUAL_FLAG VARCHAR2
758: ,p_BILL_ON_APPR_AMOUNT_FLAG VARCHAR2
759: ) IS
760: CURSOR C IS SELECT * FROM LNS_LOAN_HEADERS_ALL
761: WHERE rowid = x_rowid
762: FOR UPDATE of LOAN_ID NOWAIT;
763: Recinfo C%ROWTYPE;
764:

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 822: from LNS_LOAN_HEADERS_ALL B

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
824: );
825:
826: update LNS_LOAN_HEADERS_ALL_TL T set (

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 1188: FROM LNS_LOAN_HEADERS_ALL_VL

1184: X_FORGIVENESS_PERCENT,
1185: X_DISABLE_BILLING_FLAG,
1186: X_ADD_REQUESTED_AMOUNT,
1187: X_DISABLE_INT_ACCRUAL_FLAG
1188: FROM LNS_LOAN_HEADERS_ALL_VL
1189: WHERE LOAN_ID = X_LOAN_ID;
1190:
1191: EXCEPTION
1192: WHEN NO_DATA_FOUND THEN

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;

Line 1215: DELETE FROM LNS_LOAN_HEADERS_ALL

1211: RAISE NO_DATA_FOUND;
1212: END IF;
1213:
1214:
1215: DELETE FROM LNS_LOAN_HEADERS_ALL
1216: WHERE LOAN_ID = X_LOAN_ID;
1217:
1218: IF ( SQL%NOTFOUND ) THEN
1219: RAISE NO_DATA_FOUND;