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.3.12020000.2 2013/02/11 14:46:08 scherkas ship $ */
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 1341: | P_EXT_LOAN_REC IN OUT NOCOPY LNS_EXT_LOAN_PUB.NEW_TERM_REC record

1337: | P_API_VERSION IN Standard in parameter
1338: | P_INIT_MSG_LIST IN Standard in parameter
1339: | P_COMMIT IN Standard in parameter
1340: | P_VALIDATION_LEVEL IN Standard in parameter
1341: | P_EXT_LOAN_REC IN OUT NOCOPY LNS_EXT_LOAN_PUB.NEW_TERM_REC record
1342: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1343: | X_MSG_COUNT OUT NOCOPY Standard out parameter
1344: | X_MSG_DATA OUT NOCOPY Standard out parameter
1345: |

Line 1361: P_NEW_TERM_REC IN OUT NOCOPY LNS_EXT_LOAN_PUB.NEW_TERM_REC,

1357: P_API_VERSION IN NUMBER,
1358: P_INIT_MSG_LIST IN VARCHAR2,
1359: P_COMMIT IN VARCHAR2,
1360: P_VALIDATION_LEVEL IN NUMBER,
1361: P_NEW_TERM_REC IN OUT NOCOPY LNS_EXT_LOAN_PUB.NEW_TERM_REC,
1362: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1363: X_MSG_COUNT OUT NOCOPY NUMBER,
1364: X_MSG_DATA OUT NOCOPY VARCHAR2)
1365: IS