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_FUNDING_PUB dependencies on LNS_FUNDING_PUB

Line 1: PACKAGE BODY LNS_FUNDING_PUB as

1: PACKAGE BODY LNS_FUNDING_PUB as
2: /* $Header: LNS_FUNDING_B.pls 120.47.12010000.2 2008/11/06 11:11:29 gparuchu ship $ */
3:
4:
5: /*=======================================================================+

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

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

Line 352: WHEN LNS_FUNDING_PUB.IS_DISB_HDR_READ_ONLY(line.DISB_HEADER_ID) = 'Y' THEN

348: select
349: CASE
350: WHEN (loan.loan_status = 'INCOMPLETE') THEN
351: 'N'
352: WHEN LNS_FUNDING_PUB.IS_DISB_HDR_READ_ONLY(line.DISB_HEADER_ID) = 'Y' THEN
353: 'Y'
354: ELSE
355: CASE
356: WHEN (line.status is not null and (line.status = 'FULLY_FUNDED' or

Line 469: | P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC

465: | P_API_VERSION IN Standard in parameter
466: | P_INIT_MSG_LIST IN Standard in parameter
467: | P_COMMIT IN Standard in parameter
468: | P_VALIDATION_LEVEL IN Standard in parameter
469: | P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC
470: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
471: | X_MSG_COUNT OUT NOCOPY Standard out parameter
472: | X_MSG_DATA OUT NOCOPY Standard out parameter
473: |

Line 491: P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC,

487: P_API_VERSION IN NUMBER,
488: P_INIT_MSG_LIST IN VARCHAR2,
489: P_COMMIT IN VARCHAR2,
490: P_VALIDATION_LEVEL IN NUMBER,
491: P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC,
492: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
493: X_MSG_COUNT OUT NOCOPY NUMBER,
494: X_MSG_DATA OUT NOCOPY VARCHAR2)
495: IS

Line 640: | P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC

636: | P_API_VERSION IN Standard in parameter
637: | P_INIT_MSG_LIST IN Standard in parameter
638: | P_COMMIT IN Standard in parameter
639: | P_VALIDATION_LEVEL IN Standard in parameter
640: | P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC
641: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
642: | X_MSG_COUNT OUT NOCOPY Standard out parameter
643: | X_MSG_DATA OUT NOCOPY Standard out parameter
644: |

Line 662: P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC,

658: P_API_VERSION IN NUMBER,
659: P_INIT_MSG_LIST IN VARCHAR2,
660: P_COMMIT IN VARCHAR2,
661: P_VALIDATION_LEVEL IN NUMBER,
662: P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC,
663: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
664: X_MSG_COUNT OUT NOCOPY NUMBER,
665: X_MSG_DATA OUT NOCOPY VARCHAR2)
666: IS

Line 1062: | P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC

1058: | P_API_VERSION IN Standard in parameter
1059: | P_INIT_MSG_LIST IN Standard in parameter
1060: | P_COMMIT IN Standard in parameter
1061: | P_VALIDATION_LEVEL IN Standard in parameter
1062: | P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC
1063: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1064: | X_MSG_COUNT OUT NOCOPY Standard out parameter
1065: | X_MSG_DATA OUT NOCOPY Standard out parameter
1066: |

Line 1084: P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC,

1080: P_API_VERSION IN NUMBER,
1081: P_INIT_MSG_LIST IN VARCHAR2,
1082: P_COMMIT IN VARCHAR2,
1083: P_VALIDATION_LEVEL IN NUMBER,
1084: P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC,
1085: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1086: X_MSG_COUNT OUT NOCOPY NUMBER,
1087: X_MSG_DATA OUT NOCOPY VARCHAR2)
1088: IS

Line 1259: | P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC

1255: | P_API_VERSION IN Standard in parameter
1256: | P_INIT_MSG_LIST IN Standard in parameter
1257: | P_COMMIT IN Standard in parameter
1258: | P_VALIDATION_LEVEL IN Standard in parameter
1259: | P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC
1260: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1261: | X_MSG_COUNT OUT NOCOPY Standard out parameter
1262: | X_MSG_DATA OUT NOCOPY Standard out parameter
1263: |

Line 1281: P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC,

1277: P_API_VERSION IN NUMBER,
1278: P_INIT_MSG_LIST IN VARCHAR2,
1279: P_COMMIT IN VARCHAR2,
1280: P_VALIDATION_LEVEL IN NUMBER,
1281: P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC,
1282: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1283: X_MSG_COUNT OUT NOCOPY NUMBER,
1284: X_MSG_DATA OUT NOCOPY VARCHAR2)
1285: IS

Line 1856: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

1852: l_loan_maturity_date date;
1853: l_party_site_id number;
1854: l_due_date date;
1855:
1856: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
1857: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
1858:
1859: /*-----------------------------------------------------------------------+
1860: | Cursor Declarations |

Line 1857: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

1853: l_party_site_id number;
1854: l_due_date date;
1855:
1856: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
1857: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
1858:
1859: /*-----------------------------------------------------------------------+
1860: | Cursor Declarations |
1861: +-----------------------------------------------------------------------*/

Line 2300: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

2296: l_msg_data VARCHAR2(32767);
2297: l_no_pay_mtd_count NUMBER;
2298: l_open_start_date DATE;
2299:
2300: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
2301:
2302: /*-----------------------------------------------------------------------+
2303: | Cursor Declarations |
2304: +-----------------------------------------------------------------------*/

Line 2528: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

2524: l_disb_number number;
2525: l_due_date date;
2526: l_party_site_id number;
2527:
2528: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
2529: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
2530: l_DISB_LINES_TBL DISB_LINES_TBL;
2531:
2532:

Line 2529: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;

2525: l_due_date date;
2526: l_party_site_id number;
2527:
2528: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
2529: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
2530: l_DISB_LINES_TBL DISB_LINES_TBL;
2531:
2532:
2533: /*-----------------------------------------------------------------------+

Line 2884: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

2880: l_loan_maturity_date date;
2881: l_loan_status varchar2(30);
2882: l_move_maturity_date number;
2883:
2884: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
2885: TYPE DISB_HEADERS_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC INDEX BY BINARY_INTEGER;
2886: l_DISB_HEADERS_TBL DISB_HEADERS_TBL;
2887:
2888: /*-----------------------------------------------------------------------+

Line 2885: TYPE DISB_HEADERS_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC INDEX BY BINARY_INTEGER;

2881: l_loan_status varchar2(30);
2882: l_move_maturity_date number;
2883:
2884: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
2885: TYPE DISB_HEADERS_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC INDEX BY BINARY_INTEGER;
2886: l_DISB_HEADERS_TBL DISB_HEADERS_TBL;
2887:
2888: /*-----------------------------------------------------------------------+
2889: | Cursor Declarations |

Line 3231: | P_Trxn_Attributes_Rec IN LNS_FUNDING_PUB.Trxn_Attributes_Rec_Type,

3227: | P_API_VERSION IN Standard in parameter
3228: | P_INIT_MSG_LIST IN Standard in parameter
3229: | P_COMMIT IN Standard in parameter
3230: | P_VALIDATION_LEVEL IN Standard in parameter
3231: | P_Trxn_Attributes_Rec IN LNS_FUNDING_PUB.Trxn_Attributes_Rec_Type,
3232: | x_default_pmt_attrs_rec OUT NOCOPY LNS_FUNDING_PUB.Default_Pmt_Attrs_Rec_Type,
3233: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
3234: | X_MSG_COUNT OUT NOCOPY Standard out parameter
3235: | X_MSG_DATA OUT NOCOPY Standard out parameter

Line 3232: | x_default_pmt_attrs_rec OUT NOCOPY LNS_FUNDING_PUB.Default_Pmt_Attrs_Rec_Type,

3228: | P_INIT_MSG_LIST IN Standard in parameter
3229: | P_COMMIT IN Standard in parameter
3230: | P_VALIDATION_LEVEL IN Standard in parameter
3231: | P_Trxn_Attributes_Rec IN LNS_FUNDING_PUB.Trxn_Attributes_Rec_Type,
3232: | x_default_pmt_attrs_rec OUT NOCOPY LNS_FUNDING_PUB.Default_Pmt_Attrs_Rec_Type,
3233: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
3234: | X_MSG_COUNT OUT NOCOPY Standard out parameter
3235: | X_MSG_DATA OUT NOCOPY Standard out parameter
3236: |

Line 3252: P_Trxn_Attributes_Rec IN LNS_FUNDING_PUB.Trxn_Attributes_Rec_Type,

3248: P_API_VERSION IN NUMBER,
3249: P_INIT_MSG_LIST IN VARCHAR2,
3250: P_COMMIT IN VARCHAR2,
3251: P_VALIDATION_LEVEL IN NUMBER,
3252: P_Trxn_Attributes_Rec IN LNS_FUNDING_PUB.Trxn_Attributes_Rec_Type,
3253: X_default_pmt_attrs_rec OUT NOCOPY LNS_FUNDING_PUB.Default_Pmt_Attrs_Rec_Type,
3254: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3255: X_MSG_COUNT OUT NOCOPY NUMBER,
3256: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 3253: X_default_pmt_attrs_rec OUT NOCOPY LNS_FUNDING_PUB.Default_Pmt_Attrs_Rec_Type,

3249: P_INIT_MSG_LIST IN VARCHAR2,
3250: P_COMMIT IN VARCHAR2,
3251: P_VALIDATION_LEVEL IN NUMBER,
3252: P_Trxn_Attributes_Rec IN LNS_FUNDING_PUB.Trxn_Attributes_Rec_Type,
3253: X_default_pmt_attrs_rec OUT NOCOPY LNS_FUNDING_PUB.Default_Pmt_Attrs_Rec_Type,
3254: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3255: X_MSG_COUNT OUT NOCOPY NUMBER,
3256: X_MSG_DATA OUT NOCOPY VARCHAR2)
3257: IS

Line 3609: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

3605: l_api_version CONSTANT NUMBER := 1.0;
3606: l_return_status VARCHAR2(1);
3607: l_msg_count NUMBER;
3608: l_msg_data VARCHAR2(32767);
3609: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
3610: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
3611:
3612: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
3613: l_DISB_LINES_TBL DISB_LINES_TBL;

Line 3610: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

3606: l_return_status VARCHAR2(1);
3607: l_msg_count NUMBER;
3608: l_msg_data VARCHAR2(32767);
3609: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
3610: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
3611:
3612: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
3613: l_DISB_LINES_TBL DISB_LINES_TBL;
3614:

Line 3612: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;

3608: l_msg_data VARCHAR2(32767);
3609: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
3610: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
3611:
3612: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
3613: l_DISB_LINES_TBL DISB_LINES_TBL;
3614:
3615: l_org_id number;
3616: l_invoice_line_id number;

Line 4848: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

4844: l_api_version CONSTANT NUMBER := 1.0;
4845: l_return_status VARCHAR2(1);
4846: l_msg_count NUMBER;
4847: l_msg_data VARCHAR2(32767);
4848: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
4849: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
4850:
4851: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
4852: l_DISB_LINES_TBL DISB_LINES_TBL;

Line 4849: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

4845: l_return_status VARCHAR2(1);
4846: l_msg_count NUMBER;
4847: l_msg_data VARCHAR2(32767);
4848: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
4849: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
4850:
4851: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
4852: l_DISB_LINES_TBL DISB_LINES_TBL;
4853:

Line 4851: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;

4847: l_msg_data VARCHAR2(32767);
4848: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
4849: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
4850:
4851: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
4852: l_DISB_LINES_TBL DISB_LINES_TBL;
4853:
4854: l_loan_number varchar2(60);
4855: l_Count number;

Line 5219: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

5215: l_iso_territory FND_LANGUAGES.iso_territory%TYPE;
5216: l_last_api_called varchar2(500);
5217:
5218:
5219: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
5220: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
5221: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
5222: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
5223: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;

Line 5220: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

5216: l_last_api_called varchar2(500);
5217:
5218:
5219: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
5220: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
5221: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
5222: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
5223: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
5224: l_event_table lns_distributions_pub.acc_event_tbl;

Line 6432: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

6428: l_Token varchar2(30);
6429: l_success boolean;
6430: l_success_str varchar2(10);
6431:
6432: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
6433: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
6434:
6435: /*-----------------------------------------------------------------------+
6436: | Cursor Declarations |

Line 6433: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

6429: l_success boolean;
6430: l_success_str varchar2(10);
6431:
6432: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
6433: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
6434:
6435: /*-----------------------------------------------------------------------+
6436: | Cursor Declarations |
6437: +-----------------------------------------------------------------------*/

Line 7336: P_PAYEE_REC IN LNS_FUNDING_PUB.LOAN_PAYEE_REC,

7332: P_API_VERSION IN NUMBER,
7333: P_INIT_MSG_LIST IN VARCHAR2,
7334: P_COMMIT IN VARCHAR2,
7335: P_VALIDATION_LEVEL IN NUMBER,
7336: P_PAYEE_REC IN LNS_FUNDING_PUB.LOAN_PAYEE_REC,
7337: X_PAYEE_ID OUT NOCOPY NUMBER,
7338: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
7339: X_MSG_COUNT OUT NOCOPY NUMBER,
7340: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 7416: P_PAYEE_SITE_REC IN LNS_FUNDING_PUB.LOAN_PAYEE_SITE_REC,

7412: P_API_VERSION IN NUMBER,
7413: P_INIT_MSG_LIST IN VARCHAR2,
7414: P_COMMIT IN VARCHAR2,
7415: P_VALIDATION_LEVEL IN NUMBER,
7416: P_PAYEE_SITE_REC IN LNS_FUNDING_PUB.LOAN_PAYEE_SITE_REC,
7417: X_PAYEE_SITE_ID OUT NOCOPY NUMBER,
7418: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
7419: X_MSG_COUNT OUT NOCOPY NUMBER,
7420: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 7488: P_SITE_CONTACT_REC IN LNS_FUNDING_PUB.SITE_CONTACT_REC,

7484: P_API_VERSION IN NUMBER,
7485: P_INIT_MSG_LIST IN VARCHAR2,
7486: P_COMMIT IN VARCHAR2,
7487: P_VALIDATION_LEVEL IN NUMBER,
7488: P_SITE_CONTACT_REC IN LNS_FUNDING_PUB.SITE_CONTACT_REC,
7489: X_SITE_CONTACT_ID OUT NOCOPY NUMBER,
7490: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
7491: X_MSG_COUNT OUT NOCOPY NUMBER,
7492: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 7561: P_BANK_ACC_USE_REC IN LNS_FUNDING_PUB.BANK_ACCOUNT_USE_REC,

7557: P_API_VERSION IN NUMBER,
7558: P_INIT_MSG_LIST IN VARCHAR2,
7559: P_COMMIT IN VARCHAR2,
7560: P_VALIDATION_LEVEL IN NUMBER,
7561: P_BANK_ACC_USE_REC IN LNS_FUNDING_PUB.BANK_ACCOUNT_USE_REC,
7562: X_BANK_ACC_USE_ID OUT NOCOPY NUMBER,
7563: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
7564: X_MSG_COUNT OUT NOCOPY NUMBER,
7565: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 7577: l_BANK_ACC_USE_REC LNS_FUNDING_PUB.BANK_ACCOUNT_USE_REC;

7573: l_api_version CONSTANT NUMBER := 1.0;
7574: l_return_status VARCHAR2(1);
7575: l_msg_count NUMBER;
7576: l_msg_data VARCHAR2(32767);
7577: l_BANK_ACC_USE_REC LNS_FUNDING_PUB.BANK_ACCOUNT_USE_REC;
7578: l_bank_acc_use_id number;
7579: l_primary_flag varchar2(1);
7580: l_currency VARCHAR2(15);
7581:

Line 7620: PROCEDURE CREATE_AP_INVOICE(P_FUNDING_ADVICE_REC IN OUT NOCOPY LNS_FUNDING_PUB.FUNDING_ADVICE_REC)

7616: | Date Author Description of Changes
7617: | 09-29-2004 scherkas Created
7618: |
7619: *=======================================================================*/
7620: PROCEDURE CREATE_AP_INVOICE(P_FUNDING_ADVICE_REC IN OUT NOCOPY LNS_FUNDING_PUB.FUNDING_ADVICE_REC)
7621: IS
7622:
7623: /*-----------------------------------------------------------------------+
7624: | Local Variable Declarations and initializations |

Line 7698: P_INIT_FUNDING_REC IN LNS_FUNDING_PUB.INIT_FUNDING_ADVICE_REC,

7694: P_API_VERSION IN NUMBER,
7695: P_INIT_MSG_LIST IN VARCHAR2,
7696: P_COMMIT IN VARCHAR2,
7697: P_VALIDATION_LEVEL IN NUMBER,
7698: P_INIT_FUNDING_REC IN LNS_FUNDING_PUB.INIT_FUNDING_ADVICE_REC,
7699: X_FUNDING_ADVICE_ID OUT NOCOPY NUMBER,
7700: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
7701: X_MSG_COUNT OUT NOCOPY NUMBER,
7702: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 7716: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;

7712: l_msg_count NUMBER;
7713: l_msg_data VARCHAR2(32767);
7714: l_funding_advice_id NUMBER;
7715: l_loan_class VARCHAR2(30);
7716: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;
7717:
7718: /*-----------------------------------------------------------------------+
7719: | Cursor Declarations |
7720: +-----------------------------------------------------------------------*/

Line 7789: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

7785: l_DISB_HEADER_ID NUMBER;
7786: l_OBJECT_VERSION_NUMBER NUMBER;
7787: l_cond_count number;
7788:
7789: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
7790:
7791: /*-----------------------------------------------------------------------+
7792: | Cursor Declarations |
7793: +-----------------------------------------------------------------------*/

Line 8026: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;

8022: l_api_version CONSTANT NUMBER := 1.0;
8023: l_return_status VARCHAR2(1);
8024: l_msg_count NUMBER;
8025: l_msg_data VARCHAR2(32767);
8026: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;
8027: l_AUTOFUNDING_FLAG varchar2(1);
8028: l_loan_class varchar2(30);
8029:
8030: /*-----------------------------------------------------------------------+

Line 8080: P_FUNDING_ADVICE_REC IN LNS_FUNDING_PUB.FUNDING_ADVICE_REC,

8076: P_API_VERSION IN NUMBER,
8077: P_INIT_MSG_LIST IN VARCHAR2,
8078: P_COMMIT IN VARCHAR2,
8079: P_VALIDATION_LEVEL IN NUMBER,
8080: P_FUNDING_ADVICE_REC IN LNS_FUNDING_PUB.FUNDING_ADVICE_REC,
8081: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
8082: X_MSG_COUNT OUT NOCOPY NUMBER,
8083: X_MSG_DATA OUT NOCOPY VARCHAR2)
8084: IS

Line 8163: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;

8159: l_api_version CONSTANT NUMBER := 1.0;
8160: l_return_status VARCHAR2(1);
8161: l_msg_count NUMBER;
8162: l_msg_data VARCHAR2(32767);
8163: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;
8164: l_AUTOFUNDING_FLAG VARCHAR2(1);
8165:
8166: /*-----------------------------------------------------------------------+
8167: | Cursor Declarations |

Line 8217: P_FUNDING_ADVICE_REC IN LNS_FUNDING_PUB.FUNDING_ADVICE_REC,

8213: P_API_VERSION IN NUMBER,
8214: P_INIT_MSG_LIST IN VARCHAR2,
8215: P_COMMIT IN VARCHAR2,
8216: P_VALIDATION_LEVEL IN NUMBER,
8217: P_FUNDING_ADVICE_REC IN LNS_FUNDING_PUB.FUNDING_ADVICE_REC,
8218: X_FUNDING_ADVICE_ID OUT NOCOPY NUMBER,
8219: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
8220: X_MSG_COUNT OUT NOCOPY NUMBER,
8221: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 8233: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;

8229: l_api_version CONSTANT NUMBER := 1.0;
8230: l_return_status VARCHAR2(1);
8231: l_msg_count NUMBER;
8232: l_msg_data VARCHAR2(32767);
8233: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;
8234: l_loan_version number;
8235: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
8236: l_BANK_ACC_USE_REC LNS_FUNDING_PUB.BANK_ACCOUNT_USE_REC;
8237: l_BANK_ACC_USE_ID number;

Line 8236: l_BANK_ACC_USE_REC LNS_FUNDING_PUB.BANK_ACCOUNT_USE_REC;

8232: l_msg_data VARCHAR2(32767);
8233: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;
8234: l_loan_version number;
8235: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
8236: l_BANK_ACC_USE_REC LNS_FUNDING_PUB.BANK_ACCOUNT_USE_REC;
8237: l_BANK_ACC_USE_ID number;
8238: l_funding_advice_id number;
8239: l_loan_class varchar2(80);
8240: