DBA Data[Home] [Help]

APPS.LNS_LOAN_DOCUMENTS_PKG dependencies on FND_API

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

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

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

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

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

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

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

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

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

54: ,LNS_UTILITY_PUB.PROGRAM_UPDATE_DATE
55: ,LNS_UTILITY_PUB.PROGRAM_APPLICATION_ID
56: ,LNS_UTILITY_PUB.PROGRAM_ID
57: ,LNS_UTILITY_PUB.REQUEST_ID
58: ,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
59: ) RETURNING
60: DOCUMENT_ID
61: INTO
62: X_DOCUMENT_ID;