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.65.12020000.2 2012/07/19 20:58:18 scherkas 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 353: WHEN LNS_FUNDING_PUB.IS_DISB_HDR_READ_ONLY(line.DISB_HEADER_ID) = 'Y' THEN

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

Line 470: | P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC

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

Line 492: P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC,

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

Line 661: | P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC

657: | P_API_VERSION IN Standard in parameter
658: | P_INIT_MSG_LIST IN Standard in parameter
659: | P_COMMIT IN Standard in parameter
660: | P_VALIDATION_LEVEL IN Standard in parameter
661: | P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC
662: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
663: | X_MSG_COUNT OUT NOCOPY Standard out parameter
664: | X_MSG_DATA OUT NOCOPY Standard out parameter
665: |

Line 683: P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC,

679: P_API_VERSION IN NUMBER,
680: P_INIT_MSG_LIST IN VARCHAR2,
681: P_COMMIT IN VARCHAR2,
682: P_VALIDATION_LEVEL IN NUMBER,
683: P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC,
684: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
685: X_MSG_COUNT OUT NOCOPY NUMBER,
686: X_MSG_DATA OUT NOCOPY VARCHAR2)
687: IS

Line 1089: | P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC

1085: | P_API_VERSION IN Standard in parameter
1086: | P_INIT_MSG_LIST IN Standard in parameter
1087: | P_COMMIT IN Standard in parameter
1088: | P_VALIDATION_LEVEL IN Standard in parameter
1089: | P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC
1090: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1091: | X_MSG_COUNT OUT NOCOPY Standard out parameter
1092: | X_MSG_DATA OUT NOCOPY Standard out parameter
1093: |

Line 1111: P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC,

1107: P_API_VERSION IN NUMBER,
1108: P_INIT_MSG_LIST IN VARCHAR2,
1109: P_COMMIT IN VARCHAR2,
1110: P_VALIDATION_LEVEL IN NUMBER,
1111: P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC,
1112: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1113: X_MSG_COUNT OUT NOCOPY NUMBER,
1114: X_MSG_DATA OUT NOCOPY VARCHAR2)
1115: IS

Line 1292: | P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC

1288: | P_API_VERSION IN Standard in parameter
1289: | P_INIT_MSG_LIST IN Standard in parameter
1290: | P_COMMIT IN Standard in parameter
1291: | P_VALIDATION_LEVEL IN Standard in parameter
1292: | P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC
1293: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1294: | X_MSG_COUNT OUT NOCOPY Standard out parameter
1295: | X_MSG_DATA OUT NOCOPY Standard out parameter
1296: |

Line 1314: P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC,

1310: P_API_VERSION IN NUMBER,
1311: P_INIT_MSG_LIST IN VARCHAR2,
1312: P_COMMIT IN VARCHAR2,
1313: P_VALIDATION_LEVEL IN NUMBER,
1314: P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC,
1315: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1316: X_MSG_COUNT OUT NOCOPY NUMBER,
1317: X_MSG_DATA OUT NOCOPY VARCHAR2)
1318: IS

Line 1900: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

1896: l_party_site_id number;
1897: l_due_date date;
1898: l_current_phase varchar2(30);
1899:
1900: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
1901: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
1902:
1903: /*-----------------------------------------------------------------------+
1904: | Cursor Declarations |

Line 1901: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

1897: l_due_date date;
1898: l_current_phase varchar2(30);
1899:
1900: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
1901: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
1902:
1903: /*-----------------------------------------------------------------------+
1904: | Cursor Declarations |
1905: +-----------------------------------------------------------------------*/

Line 2363: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

2359: l_msg_data VARCHAR2(32767);
2360: l_no_pay_mtd_count NUMBER;
2361: l_open_start_date DATE;
2362:
2363: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
2364:
2365: /*-----------------------------------------------------------------------+
2366: | Cursor Declarations |
2367: +-----------------------------------------------------------------------*/

Line 2597: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

2593: l_disb_number number;
2594: l_due_date date;
2595: l_party_site_id number;
2596:
2597: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
2598: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
2599: l_DISB_LINES_TBL DISB_LINES_TBL;
2600:
2601:

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

2594: l_due_date date;
2595: l_party_site_id number;
2596:
2597: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
2598: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
2599: l_DISB_LINES_TBL DISB_LINES_TBL;
2600:
2601:
2602: /*-----------------------------------------------------------------------+

Line 2954: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

2950: l_loan_maturity_date date;
2951: l_loan_status varchar2(30);
2952: l_move_maturity_date number;
2953:
2954: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
2955: TYPE DISB_HEADERS_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC INDEX BY BINARY_INTEGER;
2956: l_DISB_HEADERS_TBL DISB_HEADERS_TBL;
2957:
2958: /*-----------------------------------------------------------------------+

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

2951: l_loan_status varchar2(30);
2952: l_move_maturity_date number;
2953:
2954: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
2955: TYPE DISB_HEADERS_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC INDEX BY BINARY_INTEGER;
2956: l_DISB_HEADERS_TBL DISB_HEADERS_TBL;
2957:
2958: /*-----------------------------------------------------------------------+
2959: | Cursor Declarations |

Line 3335: | P_Trxn_Attributes_Rec IN LNS_FUNDING_PUB.Trxn_Attributes_Rec_Type,

3331: | P_API_VERSION IN Standard in parameter
3332: | P_INIT_MSG_LIST IN Standard in parameter
3333: | P_COMMIT IN Standard in parameter
3334: | P_VALIDATION_LEVEL IN Standard in parameter
3335: | P_Trxn_Attributes_Rec IN LNS_FUNDING_PUB.Trxn_Attributes_Rec_Type,
3336: | x_default_pmt_attrs_rec OUT NOCOPY LNS_FUNDING_PUB.Default_Pmt_Attrs_Rec_Type,
3337: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
3338: | X_MSG_COUNT OUT NOCOPY Standard out parameter
3339: | X_MSG_DATA OUT NOCOPY Standard out parameter

Line 3336: | x_default_pmt_attrs_rec OUT NOCOPY LNS_FUNDING_PUB.Default_Pmt_Attrs_Rec_Type,

3332: | P_INIT_MSG_LIST IN Standard in parameter
3333: | P_COMMIT IN Standard in parameter
3334: | P_VALIDATION_LEVEL IN Standard in parameter
3335: | P_Trxn_Attributes_Rec IN LNS_FUNDING_PUB.Trxn_Attributes_Rec_Type,
3336: | x_default_pmt_attrs_rec OUT NOCOPY LNS_FUNDING_PUB.Default_Pmt_Attrs_Rec_Type,
3337: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
3338: | X_MSG_COUNT OUT NOCOPY Standard out parameter
3339: | X_MSG_DATA OUT NOCOPY Standard out parameter
3340: |

Line 3356: P_Trxn_Attributes_Rec IN LNS_FUNDING_PUB.Trxn_Attributes_Rec_Type,

3352: P_API_VERSION IN NUMBER,
3353: P_INIT_MSG_LIST IN VARCHAR2,
3354: P_COMMIT IN VARCHAR2,
3355: P_VALIDATION_LEVEL IN NUMBER,
3356: P_Trxn_Attributes_Rec IN LNS_FUNDING_PUB.Trxn_Attributes_Rec_Type,
3357: X_default_pmt_attrs_rec OUT NOCOPY LNS_FUNDING_PUB.Default_Pmt_Attrs_Rec_Type,
3358: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3359: X_MSG_COUNT OUT NOCOPY NUMBER,
3360: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 3357: X_default_pmt_attrs_rec OUT NOCOPY LNS_FUNDING_PUB.Default_Pmt_Attrs_Rec_Type,

3353: P_INIT_MSG_LIST IN VARCHAR2,
3354: P_COMMIT IN VARCHAR2,
3355: P_VALIDATION_LEVEL IN NUMBER,
3356: P_Trxn_Attributes_Rec IN LNS_FUNDING_PUB.Trxn_Attributes_Rec_Type,
3357: X_default_pmt_attrs_rec OUT NOCOPY LNS_FUNDING_PUB.Default_Pmt_Attrs_Rec_Type,
3358: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3359: X_MSG_COUNT OUT NOCOPY NUMBER,
3360: X_MSG_DATA OUT NOCOPY VARCHAR2)
3361: IS

Line 3773: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

3769: l_api_version CONSTANT NUMBER := 1.0;
3770: l_return_status VARCHAR2(1);
3771: l_msg_count NUMBER;
3772: l_msg_data VARCHAR2(32767);
3773: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
3774: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
3775:
3776: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
3777: l_DISB_LINES_TBL DISB_LINES_TBL;

Line 3774: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

3770: l_return_status VARCHAR2(1);
3771: l_msg_count NUMBER;
3772: l_msg_data VARCHAR2(32767);
3773: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
3774: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
3775:
3776: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
3777: l_DISB_LINES_TBL DISB_LINES_TBL;
3778:

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

3772: l_msg_data VARCHAR2(32767);
3773: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
3774: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
3775:
3776: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
3777: l_DISB_LINES_TBL DISB_LINES_TBL;
3778:
3779: l_org_id number;
3780: l_invoice_line_id number;

Line 5084: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

5080: l_api_version CONSTANT NUMBER := 1.0;
5081: l_return_status VARCHAR2(1);
5082: l_msg_count NUMBER;
5083: l_msg_data VARCHAR2(32767);
5084: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
5085: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
5086:
5087: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
5088: l_DISB_LINES_TBL DISB_LINES_TBL;

Line 5085: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

5081: l_return_status VARCHAR2(1);
5082: l_msg_count NUMBER;
5083: l_msg_data VARCHAR2(32767);
5084: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
5085: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
5086:
5087: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
5088: l_DISB_LINES_TBL DISB_LINES_TBL;
5089:

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

5083: l_msg_data VARCHAR2(32767);
5084: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
5085: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
5086:
5087: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
5088: l_DISB_LINES_TBL DISB_LINES_TBL;
5089:
5090: l_loan_number varchar2(60);
5091: l_Count number;

Line 5502: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

5498: l_iso_territory FND_LANGUAGES.iso_territory%TYPE;
5499: l_last_api_called varchar2(500);
5500: l_agreement_reason varchar2(500);
5501:
5502: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
5503: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
5504: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
5505: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
5506: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;

Line 5503: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

5499: l_last_api_called varchar2(500);
5500: l_agreement_reason varchar2(500);
5501:
5502: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
5503: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
5504: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
5505: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
5506: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
5507: l_event_table lns_distributions_pub.acc_event_tbl;

Line 6829: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

6825: l_Token varchar2(30);
6826: l_success boolean;
6827: l_success_str varchar2(10);
6828:
6829: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
6830: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
6831: l_cancel_fed_disb varchar2(1);
6832: l_dist_count NUMBER;
6833:

Line 6830: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

6826: l_success boolean;
6827: l_success_str varchar2(10);
6828:
6829: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
6830: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
6831: l_cancel_fed_disb varchar2(1);
6832: l_dist_count NUMBER;
6833:
6834: /*-----------------------------------------------------------------------+

Line 7817: P_PAYEE_REC IN LNS_FUNDING_PUB.LOAN_PAYEE_REC,

7813: P_API_VERSION IN NUMBER,
7814: P_INIT_MSG_LIST IN VARCHAR2,
7815: P_COMMIT IN VARCHAR2,
7816: P_VALIDATION_LEVEL IN NUMBER,
7817: P_PAYEE_REC IN LNS_FUNDING_PUB.LOAN_PAYEE_REC,
7818: X_PAYEE_ID OUT NOCOPY NUMBER,
7819: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
7820: X_MSG_COUNT OUT NOCOPY NUMBER,
7821: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 7897: P_PAYEE_SITE_REC IN LNS_FUNDING_PUB.LOAN_PAYEE_SITE_REC,

7893: P_API_VERSION IN NUMBER,
7894: P_INIT_MSG_LIST IN VARCHAR2,
7895: P_COMMIT IN VARCHAR2,
7896: P_VALIDATION_LEVEL IN NUMBER,
7897: P_PAYEE_SITE_REC IN LNS_FUNDING_PUB.LOAN_PAYEE_SITE_REC,
7898: X_PAYEE_SITE_ID OUT NOCOPY NUMBER,
7899: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
7900: X_MSG_COUNT OUT NOCOPY NUMBER,
7901: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 7969: P_SITE_CONTACT_REC IN LNS_FUNDING_PUB.SITE_CONTACT_REC,

7965: P_API_VERSION IN NUMBER,
7966: P_INIT_MSG_LIST IN VARCHAR2,
7967: P_COMMIT IN VARCHAR2,
7968: P_VALIDATION_LEVEL IN NUMBER,
7969: P_SITE_CONTACT_REC IN LNS_FUNDING_PUB.SITE_CONTACT_REC,
7970: X_SITE_CONTACT_ID OUT NOCOPY NUMBER,
7971: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
7972: X_MSG_COUNT OUT NOCOPY NUMBER,
7973: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 8042: P_BANK_ACC_USE_REC IN LNS_FUNDING_PUB.BANK_ACCOUNT_USE_REC,

8038: P_API_VERSION IN NUMBER,
8039: P_INIT_MSG_LIST IN VARCHAR2,
8040: P_COMMIT IN VARCHAR2,
8041: P_VALIDATION_LEVEL IN NUMBER,
8042: P_BANK_ACC_USE_REC IN LNS_FUNDING_PUB.BANK_ACCOUNT_USE_REC,
8043: X_BANK_ACC_USE_ID OUT NOCOPY NUMBER,
8044: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
8045: X_MSG_COUNT OUT NOCOPY NUMBER,
8046: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 8058: l_BANK_ACC_USE_REC LNS_FUNDING_PUB.BANK_ACCOUNT_USE_REC;

8054: l_api_version CONSTANT NUMBER := 1.0;
8055: l_return_status VARCHAR2(1);
8056: l_msg_count NUMBER;
8057: l_msg_data VARCHAR2(32767);
8058: l_BANK_ACC_USE_REC LNS_FUNDING_PUB.BANK_ACCOUNT_USE_REC;
8059: l_bank_acc_use_id number;
8060: l_primary_flag varchar2(1);
8061: l_currency VARCHAR2(15);
8062:

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

8097: | Date Author Description of Changes
8098: | 09-29-2004 scherkas Created
8099: |
8100: *=======================================================================*/
8101: PROCEDURE CREATE_AP_INVOICE(P_FUNDING_ADVICE_REC IN OUT NOCOPY LNS_FUNDING_PUB.FUNDING_ADVICE_REC)
8102: IS
8103:
8104: /*-----------------------------------------------------------------------+
8105: | Local Variable Declarations and initializations |

Line 8179: P_INIT_FUNDING_REC IN LNS_FUNDING_PUB.INIT_FUNDING_ADVICE_REC,

8175: P_API_VERSION IN NUMBER,
8176: P_INIT_MSG_LIST IN VARCHAR2,
8177: P_COMMIT IN VARCHAR2,
8178: P_VALIDATION_LEVEL IN NUMBER,
8179: P_INIT_FUNDING_REC IN LNS_FUNDING_PUB.INIT_FUNDING_ADVICE_REC,
8180: X_FUNDING_ADVICE_ID OUT NOCOPY NUMBER,
8181: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
8182: X_MSG_COUNT OUT NOCOPY NUMBER,
8183: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 8197: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;

8193: l_msg_count NUMBER;
8194: l_msg_data VARCHAR2(32767);
8195: l_funding_advice_id NUMBER;
8196: l_loan_class VARCHAR2(30);
8197: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;
8198:
8199: /*-----------------------------------------------------------------------+
8200: | Cursor Declarations |
8201: +-----------------------------------------------------------------------*/

Line 8270: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

8266: l_DISB_HEADER_ID NUMBER;
8267: l_OBJECT_VERSION_NUMBER NUMBER;
8268: l_cond_count number;
8269:
8270: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
8271:
8272: /*-----------------------------------------------------------------------+
8273: | Cursor Declarations |
8274: +-----------------------------------------------------------------------*/

Line 8528: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;

8524: l_api_version CONSTANT NUMBER := 1.0;
8525: l_return_status VARCHAR2(1);
8526: l_msg_count NUMBER;
8527: l_msg_data VARCHAR2(32767);
8528: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;
8529: l_AUTOFUNDING_FLAG varchar2(1);
8530: l_loan_class varchar2(30);
8531:
8532: /*-----------------------------------------------------------------------+

Line 8582: P_FUNDING_ADVICE_REC IN LNS_FUNDING_PUB.FUNDING_ADVICE_REC,

8578: P_API_VERSION IN NUMBER,
8579: P_INIT_MSG_LIST IN VARCHAR2,
8580: P_COMMIT IN VARCHAR2,
8581: P_VALIDATION_LEVEL IN NUMBER,
8582: P_FUNDING_ADVICE_REC IN LNS_FUNDING_PUB.FUNDING_ADVICE_REC,
8583: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
8584: X_MSG_COUNT OUT NOCOPY NUMBER,
8585: X_MSG_DATA OUT NOCOPY VARCHAR2)
8586: IS

Line 8665: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;

8661: l_api_version CONSTANT NUMBER := 1.0;
8662: l_return_status VARCHAR2(1);
8663: l_msg_count NUMBER;
8664: l_msg_data VARCHAR2(32767);
8665: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;
8666: l_AUTOFUNDING_FLAG VARCHAR2(1);
8667:
8668: /*-----------------------------------------------------------------------+
8669: | Cursor Declarations |

Line 8719: P_FUNDING_ADVICE_REC IN LNS_FUNDING_PUB.FUNDING_ADVICE_REC,

8715: P_API_VERSION IN NUMBER,
8716: P_INIT_MSG_LIST IN VARCHAR2,
8717: P_COMMIT IN VARCHAR2,
8718: P_VALIDATION_LEVEL IN NUMBER,
8719: P_FUNDING_ADVICE_REC IN LNS_FUNDING_PUB.FUNDING_ADVICE_REC,
8720: X_FUNDING_ADVICE_ID OUT NOCOPY NUMBER,
8721: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
8722: X_MSG_COUNT OUT NOCOPY NUMBER,
8723: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 8735: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;

8731: l_api_version CONSTANT NUMBER := 1.0;
8732: l_return_status VARCHAR2(1);
8733: l_msg_count NUMBER;
8734: l_msg_data VARCHAR2(32767);
8735: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;
8736: l_loan_version number;
8737: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
8738: l_BANK_ACC_USE_REC LNS_FUNDING_PUB.BANK_ACCOUNT_USE_REC;
8739: l_BANK_ACC_USE_ID number;

Line 8738: l_BANK_ACC_USE_REC LNS_FUNDING_PUB.BANK_ACCOUNT_USE_REC;

8734: l_msg_data VARCHAR2(32767);
8735: l_FUNDING_ADVICE_REC LNS_FUNDING_PUB.FUNDING_ADVICE_REC;
8736: l_loan_version number;
8737: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
8738: l_BANK_ACC_USE_REC LNS_FUNDING_PUB.BANK_ACCOUNT_USE_REC;
8739: l_BANK_ACC_USE_ID number;
8740: l_funding_advice_id number;
8741: l_loan_class varchar2(80);
8742:

Line 9273: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

9269: l_hist_id number;
9270: l_hist_version number;
9271: l_found boolean;
9272:
9273: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
9274: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
9275: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
9276: l_ids_tbl DBMS_SQL.NUMBER_TABLE;
9277:

Line 9274: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

9270: l_hist_version number;
9271: l_found boolean;
9272:
9273: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
9274: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
9275: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
9276: l_ids_tbl DBMS_SQL.NUMBER_TABLE;
9277:
9278: /*-----------------------------------------------------------------------+

Line 9702: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

9698: l_payee_party_id lns_disb_lines.payee_party_id%TYPE;
9699: l_current_phase varchar2(30);
9700: l_currency varchar2(15);
9701:
9702: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
9703: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
9704:
9705: /*-----------------------------------------------------------------------+
9706: | Cursor Declarations |

Line 9703: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

9699: l_current_phase varchar2(30);
9700: l_currency varchar2(15);
9701:
9702: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
9703: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
9704:
9705: /*-----------------------------------------------------------------------+
9706: | Cursor Declarations |
9707: +-----------------------------------------------------------------------*/