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_DOCUMENTS_PKG dependencies on FND_API

Line 46: ,DECODE(P_SOURCE_ID, FND_API.G_MISS_NUM, NULL, P_SOURCE_ID)

42: ,OBJECT_VERSION_NUMBER
43: ,REASON
44: ) VALUES (
45: LNS_LOAN_DOCUMENTS_S.NEXTVAL
46: ,DECODE(P_SOURCE_ID, FND_API.G_MISS_NUM, NULL, P_SOURCE_ID)
47: ,DECODE(P_SOURCE_TABLE, FND_API.G_MISS_CHAR, NULL, P_SOURCE_TABLE)
48: ,DECODE(P_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL, P_DOCUMENT_TYPE)
49: ,DECODE(P_VERSION, FND_API.G_MISS_NUM, NULL, P_VERSION)
50: ,P_DOCUMENT_XML

Line 47: ,DECODE(P_SOURCE_TABLE, FND_API.G_MISS_CHAR, NULL, P_SOURCE_TABLE)

43: ,REASON
44: ) VALUES (
45: LNS_LOAN_DOCUMENTS_S.NEXTVAL
46: ,DECODE(P_SOURCE_ID, FND_API.G_MISS_NUM, NULL, P_SOURCE_ID)
47: ,DECODE(P_SOURCE_TABLE, FND_API.G_MISS_CHAR, NULL, P_SOURCE_TABLE)
48: ,DECODE(P_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL, P_DOCUMENT_TYPE)
49: ,DECODE(P_VERSION, FND_API.G_MISS_NUM, NULL, P_VERSION)
50: ,P_DOCUMENT_XML
51: ,LNS_UTILITY_PUB.CREATED_BY

Line 48: ,DECODE(P_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL, P_DOCUMENT_TYPE)

44: ) VALUES (
45: LNS_LOAN_DOCUMENTS_S.NEXTVAL
46: ,DECODE(P_SOURCE_ID, FND_API.G_MISS_NUM, NULL, P_SOURCE_ID)
47: ,DECODE(P_SOURCE_TABLE, FND_API.G_MISS_CHAR, NULL, P_SOURCE_TABLE)
48: ,DECODE(P_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL, P_DOCUMENT_TYPE)
49: ,DECODE(P_VERSION, FND_API.G_MISS_NUM, NULL, P_VERSION)
50: ,P_DOCUMENT_XML
51: ,LNS_UTILITY_PUB.CREATED_BY
52: ,LNS_UTILITY_PUB.CREATION_DATE

Line 49: ,DECODE(P_VERSION, FND_API.G_MISS_NUM, NULL, P_VERSION)

45: LNS_LOAN_DOCUMENTS_S.NEXTVAL
46: ,DECODE(P_SOURCE_ID, FND_API.G_MISS_NUM, NULL, P_SOURCE_ID)
47: ,DECODE(P_SOURCE_TABLE, FND_API.G_MISS_CHAR, NULL, P_SOURCE_TABLE)
48: ,DECODE(P_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL, P_DOCUMENT_TYPE)
49: ,DECODE(P_VERSION, FND_API.G_MISS_NUM, NULL, P_VERSION)
50: ,P_DOCUMENT_XML
51: ,LNS_UTILITY_PUB.CREATED_BY
52: ,LNS_UTILITY_PUB.CREATION_DATE
53: ,LNS_UTILITY_PUB.LAST_UPDATED_BY

Line 60: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)

56: ,LNS_UTILITY_PUB.PROGRAM_UPDATE_DATE
57: ,LNS_UTILITY_PUB.PROGRAM_APPLICATION_ID
58: ,LNS_UTILITY_PUB.PROGRAM_ID
59: ,LNS_UTILITY_PUB.REQUEST_ID
60: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
61: ,P_REASON
62: ) RETURNING
63: DOCUMENT_ID
64: INTO

Line 91: ,SOURCE_ID = DECODE(P_SOURCE_ID, FND_API.G_MISS_NUM, NULL, P_SOURCE_ID)

87: ) IS
88: BEGIN
89: UPDATE LNS_LOAN_DOCUMENTS SET
90: DOCUMENT_ID = LNS_LOAN_DOCUMENTS_S.NEXTVAL
91: ,SOURCE_ID = DECODE(P_SOURCE_ID, FND_API.G_MISS_NUM, NULL, P_SOURCE_ID)
92: ,SOURCE_TABLE = DECODE(P_SOURCE_TABLE, FND_API.G_MISS_CHAR, NULL, P_SOURCE_TABLE)
93: ,DOCUMENT_TYPE = DECODE(P_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL, P_DOCUMENT_TYPE)
94: ,VERSION = DECODE(P_VERSION, FND_API.G_MISS_NUM, NULL, P_VERSION)
95: ,DOCUMENT_XML = P_DOCUMENT_XML

Line 92: ,SOURCE_TABLE = DECODE(P_SOURCE_TABLE, FND_API.G_MISS_CHAR, NULL, P_SOURCE_TABLE)

88: BEGIN
89: UPDATE LNS_LOAN_DOCUMENTS SET
90: DOCUMENT_ID = LNS_LOAN_DOCUMENTS_S.NEXTVAL
91: ,SOURCE_ID = DECODE(P_SOURCE_ID, FND_API.G_MISS_NUM, NULL, P_SOURCE_ID)
92: ,SOURCE_TABLE = DECODE(P_SOURCE_TABLE, FND_API.G_MISS_CHAR, NULL, P_SOURCE_TABLE)
93: ,DOCUMENT_TYPE = DECODE(P_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL, P_DOCUMENT_TYPE)
94: ,VERSION = DECODE(P_VERSION, FND_API.G_MISS_NUM, NULL, P_VERSION)
95: ,DOCUMENT_XML = P_DOCUMENT_XML
96: ,CREATED_BY = LNS_UTILITY_PUB.CREATED_BY

Line 93: ,DOCUMENT_TYPE = DECODE(P_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL, P_DOCUMENT_TYPE)

89: UPDATE LNS_LOAN_DOCUMENTS SET
90: DOCUMENT_ID = LNS_LOAN_DOCUMENTS_S.NEXTVAL
91: ,SOURCE_ID = DECODE(P_SOURCE_ID, FND_API.G_MISS_NUM, NULL, P_SOURCE_ID)
92: ,SOURCE_TABLE = DECODE(P_SOURCE_TABLE, FND_API.G_MISS_CHAR, NULL, P_SOURCE_TABLE)
93: ,DOCUMENT_TYPE = DECODE(P_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL, P_DOCUMENT_TYPE)
94: ,VERSION = DECODE(P_VERSION, FND_API.G_MISS_NUM, NULL, P_VERSION)
95: ,DOCUMENT_XML = P_DOCUMENT_XML
96: ,CREATED_BY = LNS_UTILITY_PUB.CREATED_BY
97: ,CREATION_DATE = LNS_UTILITY_PUB.CREATION_DATE

Line 94: ,VERSION = DECODE(P_VERSION, FND_API.G_MISS_NUM, NULL, P_VERSION)

90: DOCUMENT_ID = LNS_LOAN_DOCUMENTS_S.NEXTVAL
91: ,SOURCE_ID = DECODE(P_SOURCE_ID, FND_API.G_MISS_NUM, NULL, P_SOURCE_ID)
92: ,SOURCE_TABLE = DECODE(P_SOURCE_TABLE, FND_API.G_MISS_CHAR, NULL, P_SOURCE_TABLE)
93: ,DOCUMENT_TYPE = DECODE(P_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL, P_DOCUMENT_TYPE)
94: ,VERSION = DECODE(P_VERSION, FND_API.G_MISS_NUM, NULL, P_VERSION)
95: ,DOCUMENT_XML = P_DOCUMENT_XML
96: ,CREATED_BY = LNS_UTILITY_PUB.CREATED_BY
97: ,CREATION_DATE = LNS_UTILITY_PUB.CREATION_DATE
98: ,LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY

Line 105: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)

101: ,PROGRAM_UPDATE_DATE = LNS_UTILITY_PUB.PROGRAM_UPDATE_DATE
102: ,PROGRAM_APPLICATION_ID = LNS_UTILITY_PUB.PROGRAM_APPLICATION_ID
103: ,PROGRAM_ID = LNS_UTILITY_PUB.PROGRAM_ID
104: ,REQUEST_ID = LNS_UTILITY_PUB.REQUEST_ID
105: ,OBJECT_VERSION_NUMBER = DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
106: ,REASON = P_REASON
107:
108: where SOURCE_ID = P_SOURCE_ID;
109: