DBA Data[Home] [Help]

APPS.LNS_LOAN_DOCUMENTS_PKG dependencies on LNS_LOAN_DOCUMENTS

Line 1: PACKAGE BODY LNS_LOAN_DOCUMENTS_PKG AS

1: PACKAGE BODY LNS_LOAN_DOCUMENTS_PKG AS
2: /* $Header: LNS_LNDOC_TBLH_B.pls 120.0 2005/05/31 17:25:29 appldev noship $ */
3:
4: /* Insert_Row procedure */
5: PROCEDURE Insert_Row(

Line 24: INSERT INTO LNS_LOAN_DOCUMENTS

20: ,P_REQUEST_ID IN NUMBER DEFAULT NULL
21: ,P_OBJECT_VERSION_NUMBER IN NUMBER
22: ) IS
23: BEGIN
24: INSERT INTO LNS_LOAN_DOCUMENTS
25: (
26: DOCUMENT_ID
27: ,SOURCE_ID
28: ,SOURCE_TABLE

Line 43: LNS_LOAN_DOCUMENTS_S.NEXTVAL

39: ,PROGRAM_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)

Line 65: END LNS_LOAN_DOCUMENTS_PKG;

61: INTO
62: X_DOCUMENT_ID;
63: END Insert_Row;
64:
65: END LNS_LOAN_DOCUMENTS_PKG;
66: