DBA Data[Home] [Help]

APPS.LNS_EXT_LOAN_PUB dependencies on LNS_EXT_LOAN_PUB

Line 1: PACKAGE BODY LNS_EXT_LOAN_PUB as

1: PACKAGE BODY LNS_EXT_LOAN_PUB as
2: /* $Header: LNS_EXT_LOAN_B.pls 120.0.12010000.1 2008/11/25 14:16:35 scherkas noship $ */
3:
4:
5: /*=======================================================================+

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'LNS_EXT_LOAN_PUB';

4:
5: /*=======================================================================+
6: | Package Global Constants
7: +=======================================================================*/
8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'LNS_EXT_LOAN_PUB';
9: G_LOG_ENABLED varchar2(5);
10: G_MSG_LEVEL NUMBER;
11:
12:

Line 91: Procedure VALIDATE_EXTN(P_LOAN_EXT_REC IN LNS_EXT_LOAN_PUB.LOAN_EXT_REC

87: | Date Author Description of Changes
88: | 09-27-2007 scherkas Created
89: |
90: *=======================================================================*/
91: Procedure VALIDATE_EXTN(P_LOAN_EXT_REC IN LNS_EXT_LOAN_PUB.LOAN_EXT_REC
92: ,P_ACTION IN VARCHAR2)
93: IS
94:
95: /*-----------------------------------------------------------------------+

Line 489: | P_LOAN_EXT_REC IN OUT NOCOPY LNS_EXT_LOAN_PUB.LOAN_EXT_REC record

485: | P_API_VERSION IN Standard in parameter
486: | P_INIT_MSG_LIST IN Standard in parameter
487: | P_COMMIT IN Standard in parameter
488: | P_VALIDATION_LEVEL IN Standard in parameter
489: | P_LOAN_EXT_REC IN OUT NOCOPY LNS_EXT_LOAN_PUB.LOAN_EXT_REC record
490: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
491: | X_MSG_COUNT OUT NOCOPY Standard out parameter
492: | X_MSG_DATA OUT NOCOPY Standard out parameter
493: |

Line 509: P_LOAN_EXT_REC IN OUT NOCOPY LNS_EXT_LOAN_PUB.LOAN_EXT_REC,

505: P_API_VERSION IN NUMBER,
506: P_INIT_MSG_LIST IN VARCHAR2,
507: P_COMMIT IN VARCHAR2,
508: P_VALIDATION_LEVEL IN NUMBER,
509: P_LOAN_EXT_REC IN OUT NOCOPY LNS_EXT_LOAN_PUB.LOAN_EXT_REC,
510: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
511: X_MSG_COUNT OUT NOCOPY NUMBER,
512: X_MSG_DATA OUT NOCOPY VARCHAR2)
513: IS

Line 525: l_NEW_TERM_REC LNS_EXT_LOAN_PUB.NEW_TERM_REC;

521: l_return_status VARCHAR2(1);
522: l_msg_count NUMBER;
523: l_msg_data VARCHAR2(32767);
524:
525: l_NEW_TERM_REC LNS_EXT_LOAN_PUB.NEW_TERM_REC;
526: l_is_exist VARCHAR2(1) := 'N';
527:
528: /*-----------------------------------------------------------------------+
529: | Cursor Declarations |

Line 1349: | P_EXT_LOAN_REC IN OUT NOCOPY LNS_EXT_LOAN_PUB.NEW_TERM_REC record

1345: | P_API_VERSION IN Standard in parameter
1346: | P_INIT_MSG_LIST IN Standard in parameter
1347: | P_COMMIT IN Standard in parameter
1348: | P_VALIDATION_LEVEL IN Standard in parameter
1349: | P_EXT_LOAN_REC IN OUT NOCOPY LNS_EXT_LOAN_PUB.NEW_TERM_REC record
1350: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1351: | X_MSG_COUNT OUT NOCOPY Standard out parameter
1352: | X_MSG_DATA OUT NOCOPY Standard out parameter
1353: |

Line 1369: P_NEW_TERM_REC IN OUT NOCOPY LNS_EXT_LOAN_PUB.NEW_TERM_REC,

1365: P_API_VERSION IN NUMBER,
1366: P_INIT_MSG_LIST IN VARCHAR2,
1367: P_COMMIT IN VARCHAR2,
1368: P_VALIDATION_LEVEL IN NUMBER,
1369: P_NEW_TERM_REC IN OUT NOCOPY LNS_EXT_LOAN_PUB.NEW_TERM_REC,
1370: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1371: X_MSG_COUNT OUT NOCOPY NUMBER,
1372: X_MSG_DATA OUT NOCOPY VARCHAR2)
1373: IS