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_WORK_FLOW dependencies on LNS_LOAN_HEADERS

Line 222: l_open_to_term_flag lns_loan_headers_all.open_to_term_flag%TYPE;

218:
219: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_SEC_STATUS_CHANGE';
220: l_api_version CONSTANT NUMBER := 1.0;
221: l_event_name VARCHAR2(250);
222: l_open_to_term_flag lns_loan_headers_all.open_to_term_flag%TYPE;
223: l_open_to_term_event lns_loan_headers_all.open_to_term_event%TYPE;
224:
225: /*-----------------------------------------------------------------------+
226: | Cursor Declarations |

Line 223: l_open_to_term_event lns_loan_headers_all.open_to_term_event%TYPE;

219: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_SEC_STATUS_CHANGE';
220: l_api_version CONSTANT NUMBER := 1.0;
221: l_event_name VARCHAR2(250);
222: l_open_to_term_flag lns_loan_headers_all.open_to_term_flag%TYPE;
223: l_open_to_term_event lns_loan_headers_all.open_to_term_event%TYPE;
224:
225: /*-----------------------------------------------------------------------+
226: | Cursor Declarations |
227: +-----------------------------------------------------------------------*/

Line 231: FROM lns_loan_headers_all

227: +-----------------------------------------------------------------------*/
228: CURSOR csr_loan_details IS
229: SELECT open_to_term_flag
230: ,open_to_term_event
231: FROM lns_loan_headers_all
232: WHERE loan_id = p_loan_id;
233:
234: BEGIN
235: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

Line 327: l_loan_number lns_loan_headers_all.loan_number%TYPE;

323: +-----------------------------------------------------------------------*/
324:
325: l_api_name CONSTANT VARCHAR2(30) := 'RAISE_EVENT';
326: l_api_version CONSTANT NUMBER := 1.0;
327: l_loan_number lns_loan_headers_all.loan_number%TYPE;
328: l_requested_amount lns_loan_headers_all.requested_amount%TYPE;
329: l_loan_description lns_loan_headers_all.loan_description%TYPE;
330: l_loan_class_code lns_loan_headers_all.loan_class_code%TYPE;
331: l_loan_type lns_loan_types.loan_type_name%TYPE;

Line 328: l_requested_amount lns_loan_headers_all.requested_amount%TYPE;

324:
325: l_api_name CONSTANT VARCHAR2(30) := 'RAISE_EVENT';
326: l_api_version CONSTANT NUMBER := 1.0;
327: l_loan_number lns_loan_headers_all.loan_number%TYPE;
328: l_requested_amount lns_loan_headers_all.requested_amount%TYPE;
329: l_loan_description lns_loan_headers_all.loan_description%TYPE;
330: l_loan_class_code lns_loan_headers_all.loan_class_code%TYPE;
331: l_loan_type lns_loan_types.loan_type_name%TYPE;
332: l_loan_type_id lns_loan_types.loan_type_id%TYPE;

Line 329: l_loan_description lns_loan_headers_all.loan_description%TYPE;

325: l_api_name CONSTANT VARCHAR2(30) := 'RAISE_EVENT';
326: l_api_version CONSTANT NUMBER := 1.0;
327: l_loan_number lns_loan_headers_all.loan_number%TYPE;
328: l_requested_amount lns_loan_headers_all.requested_amount%TYPE;
329: l_loan_description lns_loan_headers_all.loan_description%TYPE;
330: l_loan_class_code lns_loan_headers_all.loan_class_code%TYPE;
331: l_loan_type lns_loan_types.loan_type_name%TYPE;
332: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
333: l_current_user_id lns_loan_headers_all.created_by%TYPE;

Line 330: l_loan_class_code lns_loan_headers_all.loan_class_code%TYPE;

326: l_api_version CONSTANT NUMBER := 1.0;
327: l_loan_number lns_loan_headers_all.loan_number%TYPE;
328: l_requested_amount lns_loan_headers_all.requested_amount%TYPE;
329: l_loan_description lns_loan_headers_all.loan_description%TYPE;
330: l_loan_class_code lns_loan_headers_all.loan_class_code%TYPE;
331: l_loan_type lns_loan_types.loan_type_name%TYPE;
332: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
333: l_current_user_id lns_loan_headers_all.created_by%TYPE;
334: l_loan_formatted_amount VARCHAR2(50);

Line 333: l_current_user_id lns_loan_headers_all.created_by%TYPE;

329: l_loan_description lns_loan_headers_all.loan_description%TYPE;
330: l_loan_class_code lns_loan_headers_all.loan_class_code%TYPE;
331: l_loan_type lns_loan_types.loan_type_name%TYPE;
332: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
333: l_current_user_id lns_loan_headers_all.created_by%TYPE;
334: l_loan_formatted_amount VARCHAR2(50);
335: l_loan_undisbursed_amount VARCHAR2(50);
336: l_function_name VARCHAR2(50);
337: ItemType VARCHAR2(30) ;

Line 363: FROM lns_events le, lns_loan_headers_all_vl lh, lns_loan_types_vl lt

359: || ' ' || lh.loan_currency loan_undisbursed_amount
360: ,decode(lh.loan_class_code,'ERS','LNS_ERS_CONTEXT_HOMEPAGE_MENU',
361: 'LNS_LOAN_CONTEXT_HOMEPAGE_MENU') function_name
362: ,lh.last_updated_by current_user_id
363: FROM lns_events le, lns_loan_headers_all_vl lh, lns_loan_types_vl lt
364: WHERE lh.loan_class_code = le.loan_class_code
365: AND le.enabled_flag = 'Y'
366: AND le.event_name = p_event_name
367: AND lt.loan_type_id = lh.loan_type_id

Line 492: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;

488: +-----------------------------------------------------------------------*/
489:
490: l_api_name CONSTANT VARCHAR2(30) := 'LOG_EVENT_HISTORY';
491: l_api_version CONSTANT NUMBER := 1.0;
492: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
493: l_event_action_id LNS_EVT_ACTION_HISTORY_H.EVENT_ACTION_ID%TYPE;
494: l_ev_action_hist_id LNS_EVT_ACTION_HISTORY_H.EVENT_ACTION_HISTORY_ID%TYPE;
495:
496: /*-----------------------------------------------------------------------+

Line 659: l_loan_number LNS_LOAN_HEADERS.LOAN_NUMBER%TYPE;

655: l_api_version CONSTANT NUMBER := 1.0;
656: l_user_roles VARCHAR2(32000);
657: l_user_name FND_USER.user_name%TYPE;
658: l_role_name VARCHAR2(100);
659: l_loan_number LNS_LOAN_HEADERS.LOAN_NUMBER%TYPE;
660: l_primary_recipient_type lns_event_actions.primary_recipient_type%TYPE;
661: l_primary_recipient_name lns_event_actions.primary_recipient_name%TYPE;
662: l_priority_num lns_event_actions.priority_num%TYPE;
663: l_active_for_num lns_event_actions.active_for_num%TYPE;

Line 672: l_loan_subtype lns_loan_headers_all.loan_subtype%TYPE;

668: l_borrower_name hz_parties.party_name%TYPE;
669: l_loan_class lns_lookups.meaning%TYPE;
670: l_loan_type lns_loan_types.loan_type_name%TYPE;
671: l_loan_purpose lns_lookups.meaning%TYPE;
672: l_loan_subtype lns_loan_headers_all.loan_subtype%TYPE;
673: l_collateral_percent VARCHAR2(10);
674: l_loan_amount lns_pay_sum_v.total_principal_balance%TYPE;
675: l_loan_formatted_amount VARCHAR2(30);
676: l_loan_start_date lns_loan_headers_all.loan_start_date%TYPE;

Line 676: l_loan_start_date lns_loan_headers_all.loan_start_date%TYPE;

672: l_loan_subtype lns_loan_headers_all.loan_subtype%TYPE;
673: l_collateral_percent VARCHAR2(10);
674: l_loan_amount lns_pay_sum_v.total_principal_balance%TYPE;
675: l_loan_formatted_amount VARCHAR2(30);
676: l_loan_start_date lns_loan_headers_all.loan_start_date%TYPE;
677: l_term VARCHAR2(15);
678: l_loan_maturity_date lns_loan_headers_all.loan_maturity_date%TYPE;
679: l_interest_rate VARCHAR2(30);
680: l_overdue_amount VARCHAR2(30);

Line 678: l_loan_maturity_date lns_loan_headers_all.loan_maturity_date%TYPE;

674: l_loan_amount lns_pay_sum_v.total_principal_balance%TYPE;
675: l_loan_formatted_amount VARCHAR2(30);
676: l_loan_start_date lns_loan_headers_all.loan_start_date%TYPE;
677: l_term VARCHAR2(15);
678: l_loan_maturity_date lns_loan_headers_all.loan_maturity_date%TYPE;
679: l_interest_rate VARCHAR2(30);
680: l_overdue_amount VARCHAR2(30);
681: l_overdue_num lns_pay_sum_overdue_v.number_overdue_bills%TYPE;
682: l_event_action_id LNS_EVENT_ACTIONS.EVENT_ACTION_ID%TYPE;

Line 742: FROM lns_loan_headers_all_vl llh, hz_parties hp,

738: ,llh.loan_maturity_date
739: ,LNS_FINANCIALS.getActiveRate(llh.LOAN_ID) interest_rate
740: ,llkp.meaning loan_purpose
741: ,llh.org_id
742: FROM lns_loan_headers_all_vl llh, hz_parties hp,
743: jtf_rs_resource_extns res, fnd_user fnd,
744: lns_payments_summary_v ps,
745: lns_lookups llktt,
746: lns_lookups llklc,

Line 774: FROM lns_loan_headers_all llh

770: ,to_char((CASE WHEN llh.loan_status in ('INCOMPLETE','REJECTED','DELETED','PENDING','APPROVED','IN_FUNDING','FUNDING_ERROR','CANCELLED') OR llh.FUNDED_AMOUNT = 0 THEN llh.requested_amount
771: ELSE ps.total_principal_balance END),
772: FND_CURRENCY.SAFE_GET_FORMAT_MASK(llh.LOAN_CURRENCY,50))
773: || ' ' || llh.loan_currency loan_formatted_amount
774: FROM lns_loan_headers_all llh
775: ,lns_pay_sum_v ps
776: WHERE llh.loan_id = p_loan_id
777: AND ps.loan_id = llh.loan_id;
778: CURSOR csr_loan_details2 IS

Line 783: FROM lns_loan_headers_all llh

779: SELECT to_char(ps.total_overdue,
780: FND_CURRENCY.SAFE_GET_FORMAT_MASK(llh.LOAN_CURRENCY,50))
781: || ' ' || llh.loan_currency overdue_amount
782: ,ps.number_overdue_bills overdue_num
783: FROM lns_loan_headers_all llh
784: ,lns_pay_sum_overdue_v ps
785: WHERE llh.loan_id = p_loan_id
786: AND ps.loan_id = llh.loan_id;
787:

Line 1012: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;

1008: +-----------------------------------------------------------------------*/
1009:
1010: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_EVENT';
1011: l_api_version CONSTANT NUMBER := 1.0;
1012: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1013: l_loan_class_code LNS_LOAN_HEADERS_ALL.LOAN_CLASS_CODE%TYPE;
1014: l_loan_type LNS_LOAN_TYPES.LOAN_TYPE_NAME%TYPE;
1015: l_loan_type_id LNS_LOAN_TYPES.LOAN_TYPE_ID%TYPE;
1016: l_current_user_id LNS_LOAN_HEADERS_ALL.CREATED_BY%TYPE;

Line 1013: l_loan_class_code LNS_LOAN_HEADERS_ALL.LOAN_CLASS_CODE%TYPE;

1009:
1010: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_EVENT';
1011: l_api_version CONSTANT NUMBER := 1.0;
1012: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1013: l_loan_class_code LNS_LOAN_HEADERS_ALL.LOAN_CLASS_CODE%TYPE;
1014: l_loan_type LNS_LOAN_TYPES.LOAN_TYPE_NAME%TYPE;
1015: l_loan_type_id LNS_LOAN_TYPES.LOAN_TYPE_ID%TYPE;
1016: l_current_user_id LNS_LOAN_HEADERS_ALL.CREATED_BY%TYPE;
1017: l_event_name LNS_EVENTS.EVENT_NAME%TYPE;

Line 1016: l_current_user_id LNS_LOAN_HEADERS_ALL.CREATED_BY%TYPE;

1012: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1013: l_loan_class_code LNS_LOAN_HEADERS_ALL.LOAN_CLASS_CODE%TYPE;
1014: l_loan_type LNS_LOAN_TYPES.LOAN_TYPE_NAME%TYPE;
1015: l_loan_type_id LNS_LOAN_TYPES.LOAN_TYPE_ID%TYPE;
1016: l_current_user_id LNS_LOAN_HEADERS_ALL.CREATED_BY%TYPE;
1017: l_event_name LNS_EVENTS.EVENT_NAME%TYPE;
1018:
1019: /*-----------------------------------------------------------------------+
1020: | Cursor Declarations |