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_ALL

Line 453: l_open_to_term_flag lns_loan_headers_all.open_to_term_flag%TYPE;

449:
450: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_SEC_STATUS_CHANGE';
451: l_api_version CONSTANT NUMBER := 1.0;
452: l_event_name VARCHAR2(250);
453: l_open_to_term_flag lns_loan_headers_all.open_to_term_flag%TYPE;
454: l_open_to_term_event lns_loan_headers_all.open_to_term_event%TYPE;
455:
456: /*-----------------------------------------------------------------------+
457: | Cursor Declarations |

Line 454: l_open_to_term_event lns_loan_headers_all.open_to_term_event%TYPE;

450: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_SEC_STATUS_CHANGE';
451: l_api_version CONSTANT NUMBER := 1.0;
452: l_event_name VARCHAR2(250);
453: l_open_to_term_flag lns_loan_headers_all.open_to_term_flag%TYPE;
454: l_open_to_term_event lns_loan_headers_all.open_to_term_event%TYPE;
455:
456: /*-----------------------------------------------------------------------+
457: | Cursor Declarations |
458: +-----------------------------------------------------------------------*/

Line 462: FROM lns_loan_headers_all

458: +-----------------------------------------------------------------------*/
459: CURSOR csr_loan_details IS
460: SELECT open_to_term_flag
461: ,open_to_term_event
462: FROM lns_loan_headers_all
463: WHERE loan_id = p_loan_id;
464:
465: BEGIN
466: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

Line 558: l_loan_number lns_loan_headers_all.loan_number%TYPE;

554: +-----------------------------------------------------------------------*/
555:
556: l_api_name CONSTANT VARCHAR2(30) := 'RAISE_EVENT';
557: l_api_version CONSTANT NUMBER := 1.0;
558: l_loan_number lns_loan_headers_all.loan_number%TYPE;
559: l_requested_amount lns_loan_headers_all.requested_amount%TYPE;
560: l_loan_description lns_loan_headers_all.loan_description%TYPE;
561: l_loan_class_code lns_loan_headers_all.loan_class_code%TYPE;
562: l_loan_type lns_loan_types.loan_type_name%TYPE;

Line 559: l_requested_amount lns_loan_headers_all.requested_amount%TYPE;

555:
556: l_api_name CONSTANT VARCHAR2(30) := 'RAISE_EVENT';
557: l_api_version CONSTANT NUMBER := 1.0;
558: l_loan_number lns_loan_headers_all.loan_number%TYPE;
559: l_requested_amount lns_loan_headers_all.requested_amount%TYPE;
560: l_loan_description lns_loan_headers_all.loan_description%TYPE;
561: l_loan_class_code lns_loan_headers_all.loan_class_code%TYPE;
562: l_loan_type lns_loan_types.loan_type_name%TYPE;
563: l_loan_type_id lns_loan_types.loan_type_id%TYPE;

Line 560: l_loan_description lns_loan_headers_all.loan_description%TYPE;

556: l_api_name CONSTANT VARCHAR2(30) := 'RAISE_EVENT';
557: l_api_version CONSTANT NUMBER := 1.0;
558: l_loan_number lns_loan_headers_all.loan_number%TYPE;
559: l_requested_amount lns_loan_headers_all.requested_amount%TYPE;
560: l_loan_description lns_loan_headers_all.loan_description%TYPE;
561: l_loan_class_code lns_loan_headers_all.loan_class_code%TYPE;
562: l_loan_type lns_loan_types.loan_type_name%TYPE;
563: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
564: l_current_user_id lns_loan_headers_all.created_by%TYPE;

Line 561: l_loan_class_code lns_loan_headers_all.loan_class_code%TYPE;

557: l_api_version CONSTANT NUMBER := 1.0;
558: l_loan_number lns_loan_headers_all.loan_number%TYPE;
559: l_requested_amount lns_loan_headers_all.requested_amount%TYPE;
560: l_loan_description lns_loan_headers_all.loan_description%TYPE;
561: l_loan_class_code lns_loan_headers_all.loan_class_code%TYPE;
562: l_loan_type lns_loan_types.loan_type_name%TYPE;
563: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
564: l_current_user_id lns_loan_headers_all.created_by%TYPE;
565: l_loan_formatted_amount VARCHAR2(50);

Line 564: l_current_user_id lns_loan_headers_all.created_by%TYPE;

560: l_loan_description lns_loan_headers_all.loan_description%TYPE;
561: l_loan_class_code lns_loan_headers_all.loan_class_code%TYPE;
562: l_loan_type lns_loan_types.loan_type_name%TYPE;
563: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
564: l_current_user_id lns_loan_headers_all.created_by%TYPE;
565: l_loan_formatted_amount VARCHAR2(50);
566: l_loan_undisbursed_amount VARCHAR2(50);
567: l_function_name VARCHAR2(50);
568: ItemType VARCHAR2(30) ;

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

592: || ' ' || lh.loan_currency loan_undisbursed_amount
593: ,decode(lh.loan_class_code,'ERS','LNS_ERS_CONTEXT_HOMEPAGE_MENU',
594: 'LNS_LOAN_CONTEXT_HOMEPAGE_MENU') function_name
595: ,lh.last_updated_by current_user_id
596: FROM lns_events le, lns_loan_headers_all_vl lh, lns_loan_types_vl lt
597: WHERE lh.loan_class_code = le.loan_class_code
598: AND le.enabled_flag = 'Y'
599: AND le.event_name = p_event_name
600: AND lt.loan_type_id = lh.loan_type_id

Line 779: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;

775: +-----------------------------------------------------------------------*/
776:
777: l_api_name CONSTANT VARCHAR2(30) := 'LOG_EVENT_HISTORY';
778: l_api_version CONSTANT NUMBER := 1.0;
779: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
780: l_event_action_id LNS_EVT_ACTION_HISTORY_H.EVENT_ACTION_ID%TYPE;
781: l_ev_action_hist_id LNS_EVT_ACTION_HISTORY_H.EVENT_ACTION_HISTORY_ID%TYPE;
782:
783: /*-----------------------------------------------------------------------+

Line 962: l_loan_subtype lns_loan_headers_all.loan_subtype%TYPE;

958: l_borrower_name hz_parties.party_name%TYPE;
959: l_loan_class lns_lookups.meaning%TYPE;
960: l_loan_type lns_loan_types.loan_type_name%TYPE;
961: l_loan_purpose lns_lookups.meaning%TYPE;
962: l_loan_subtype lns_loan_headers_all.loan_subtype%TYPE;
963: l_collateral_percent VARCHAR2(10);
964: l_loan_amount lns_pay_sum_v.total_principal_balance%TYPE;
965: l_loan_formatted_amount VARCHAR2(30);
966: l_loan_start_date lns_loan_headers_all.loan_start_date%TYPE;

Line 966: l_loan_start_date lns_loan_headers_all.loan_start_date%TYPE;

962: l_loan_subtype lns_loan_headers_all.loan_subtype%TYPE;
963: l_collateral_percent VARCHAR2(10);
964: l_loan_amount lns_pay_sum_v.total_principal_balance%TYPE;
965: l_loan_formatted_amount VARCHAR2(30);
966: l_loan_start_date lns_loan_headers_all.loan_start_date%TYPE;
967: l_term VARCHAR2(15);
968: l_loan_maturity_date lns_loan_headers_all.loan_maturity_date%TYPE;
969: l_interest_rate VARCHAR2(30);
970: l_overdue_amount VARCHAR2(30);

Line 968: l_loan_maturity_date lns_loan_headers_all.loan_maturity_date%TYPE;

964: l_loan_amount lns_pay_sum_v.total_principal_balance%TYPE;
965: l_loan_formatted_amount VARCHAR2(30);
966: l_loan_start_date lns_loan_headers_all.loan_start_date%TYPE;
967: l_term VARCHAR2(15);
968: l_loan_maturity_date lns_loan_headers_all.loan_maturity_date%TYPE;
969: l_interest_rate VARCHAR2(30);
970: l_overdue_amount VARCHAR2(30);
971: l_overdue_num lns_pay_sum_overdue_v.number_overdue_bills%TYPE;
972: l_event_action_id LNS_EVENT_ACTIONS.EVENT_ACTION_ID%TYPE;

Line 1038: FROM lns_loan_headers_all_vl llh, hz_parties hp,

1034: ,LNS_FINANCIALS.getActiveRate(llh.LOAN_ID) interest_rate
1035: ,llkp.meaning loan_purpose
1036: ,llh.org_id
1037: ,lprod.loan_product_name
1038: FROM lns_loan_headers_all_vl llh, hz_parties hp,
1039: jtf_rs_resource_extns res, fnd_user fnd,
1040: lns_payments_summary_v ps,
1041: lns_lookups llktt,
1042: lns_lookups llklc,

Line 1072: FROM lns_loan_headers_all llh

1068: ,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
1069: ELSE ps.total_principal_balance END),
1070: FND_CURRENCY.SAFE_GET_FORMAT_MASK(llh.LOAN_CURRENCY,50))
1071: || ' ' || llh.loan_currency loan_formatted_amount
1072: FROM lns_loan_headers_all llh
1073: ,lns_pay_sum_v ps
1074: WHERE llh.loan_id = p_loan_id
1075: AND ps.loan_id = llh.loan_id;
1076:

Line 1082: FROM lns_loan_headers_all llh

1078: SELECT to_char(ps.total_overdue,
1079: FND_CURRENCY.SAFE_GET_FORMAT_MASK(llh.LOAN_CURRENCY,50))
1080: || ' ' || llh.loan_currency overdue_amount
1081: ,ps.number_overdue_bills overdue_num
1082: FROM lns_loan_headers_all llh
1083: ,lns_pay_sum_overdue_v ps
1084: WHERE llh.loan_id = p_loan_id
1085: AND ps.loan_id = llh.loan_id;
1086:

Line 1428: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;

1424: +-----------------------------------------------------------------------*/
1425:
1426: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_EVENT';
1427: l_api_version CONSTANT NUMBER := 1.0;
1428: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1429: l_loan_number LNS_LOAN_HEADERS_ALL.LOAN_NUMBER%TYPE;
1430: l_loan_class_code LNS_LOAN_HEADERS_ALL.LOAN_CLASS_CODE%TYPE;
1431: l_loan_type LNS_LOAN_TYPES.LOAN_TYPE_NAME%TYPE;
1432: l_loan_type_id LNS_LOAN_TYPES.LOAN_TYPE_ID%TYPE;

Line 1429: l_loan_number LNS_LOAN_HEADERS_ALL.LOAN_NUMBER%TYPE;

1425:
1426: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_EVENT';
1427: l_api_version CONSTANT NUMBER := 1.0;
1428: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1429: l_loan_number LNS_LOAN_HEADERS_ALL.LOAN_NUMBER%TYPE;
1430: l_loan_class_code LNS_LOAN_HEADERS_ALL.LOAN_CLASS_CODE%TYPE;
1431: l_loan_type LNS_LOAN_TYPES.LOAN_TYPE_NAME%TYPE;
1432: l_loan_type_id LNS_LOAN_TYPES.LOAN_TYPE_ID%TYPE;
1433: l_current_user_id LNS_LOAN_HEADERS_ALL.CREATED_BY%TYPE;

Line 1430: l_loan_class_code LNS_LOAN_HEADERS_ALL.LOAN_CLASS_CODE%TYPE;

1426: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_EVENT';
1427: l_api_version CONSTANT NUMBER := 1.0;
1428: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1429: l_loan_number LNS_LOAN_HEADERS_ALL.LOAN_NUMBER%TYPE;
1430: l_loan_class_code LNS_LOAN_HEADERS_ALL.LOAN_CLASS_CODE%TYPE;
1431: l_loan_type LNS_LOAN_TYPES.LOAN_TYPE_NAME%TYPE;
1432: l_loan_type_id LNS_LOAN_TYPES.LOAN_TYPE_ID%TYPE;
1433: l_current_user_id LNS_LOAN_HEADERS_ALL.CREATED_BY%TYPE;
1434: l_event_name LNS_EVENTS.EVENT_NAME%TYPE;

Line 1433: l_current_user_id LNS_LOAN_HEADERS_ALL.CREATED_BY%TYPE;

1429: l_loan_number LNS_LOAN_HEADERS_ALL.LOAN_NUMBER%TYPE;
1430: l_loan_class_code LNS_LOAN_HEADERS_ALL.LOAN_CLASS_CODE%TYPE;
1431: l_loan_type LNS_LOAN_TYPES.LOAN_TYPE_NAME%TYPE;
1432: l_loan_type_id LNS_LOAN_TYPES.LOAN_TYPE_ID%TYPE;
1433: l_current_user_id LNS_LOAN_HEADERS_ALL.CREATED_BY%TYPE;
1434: l_event_name LNS_EVENTS.EVENT_NAME%TYPE;
1435: l_return_status Varchar2(1);
1436: l_notification_id WF_NOTIFICATIONS.NOTIFICATION_ID%TYPE;
1437: l_search_criteria LNS_LOAN_HEADERS_ALL.LOAN_NUMBER%TYPE;

Line 1437: l_search_criteria LNS_LOAN_HEADERS_ALL.LOAN_NUMBER%TYPE;

1433: l_current_user_id LNS_LOAN_HEADERS_ALL.CREATED_BY%TYPE;
1434: l_event_name LNS_EVENTS.EVENT_NAME%TYPE;
1435: l_return_status Varchar2(1);
1436: l_notification_id WF_NOTIFICATIONS.NOTIFICATION_ID%TYPE;
1437: l_search_criteria LNS_LOAN_HEADERS_ALL.LOAN_NUMBER%TYPE;
1438: l_current_user_name fnd_user.user_name%TYPE;
1439:
1440: /*-----------------------------------------------------------------------+
1441: | Cursor Declarations |

Line 1617: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;

1613:
1614: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_LOAN_APPROVAL';
1615: l_api_version CONSTANT NUMBER := 1.0;
1616: l_object_version_number NUMBER := 1;
1617: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1618: l_loan_approve_note VARCHAR2(2000);
1619: l_loan_approval_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;
1620: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;
1621: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;

Line 1658: from lns_loan_headers_all loan

1654: --gparuchu - Code added to make sure correct object_version_number is passed
1655: --inorder to make sure the header table gets updated correctly upon Approval process.
1656: IF (l_loan_id IS NOT NULL) THEN
1657: select loan.object_version_number, loan.org_id into l_object_version_number,l_org_id
1658: from lns_loan_headers_all loan
1659: where loan.loan_id = l_loan_id;
1660: END IF;
1661:
1662: LogMessage(FND_LOG.LEVEL_STATEMENT,'In PROCESS_LOAN_APPROVAL l_loan_id : ' || l_loan_id);

Line 1864: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;

1860: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_LOAN_REJECTION';
1861: l_api_version CONSTANT NUMBER := 1.0;
1862: l_object_version_number NUMBER := 1;
1863: l_nid NUMBER;
1864: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1865: l_loan_reject_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;
1866: l_loan_reject_note VARCHAR2(2000);
1867: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;
1868: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;

Line 1903: from lns_loan_headers_all loan

1899: --inorder to make sure the header table gets updated correctly upon Rejection process.
1900:
1901: IF (l_loan_id IS NOT NULL) THEN
1902: select loan.object_version_number, loan.org_id into l_object_version_number,l_org_id
1903: from lns_loan_headers_all loan
1904: where loan.loan_id = l_loan_id;
1905: END IF;
1906:
1907: l_loan_reject_note := wf_engine.GetItemAttrText

Line 2101: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;

2097: l_api_name CONSTANT VARCHAR2(30) := 'REQUEST_LOAN_INFORMATION';
2098: l_api_version CONSTANT NUMBER := 1.0;
2099: l_object_version_number NUMBER := 1;
2100: l_nid NUMBER;
2101: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
2102: l_req_loan_info_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;
2103: l_req_loan_info_note VARCHAR2(2000);
2104: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;
2105: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;

Line 2142: from lns_loan_headers_all loan

2138: --gparuchu - Code added to make sure correct object_version_number is passed
2139: --inorder to make sure the header table gets updated correctly upon Approval process.
2140: IF (l_loan_id IS NOT NULL) THEN
2141: select loan.object_version_number, loan.org_id into l_object_version_number,l_org_id
2142: from lns_loan_headers_all loan
2143: where loan.loan_id = l_loan_id;
2144: END IF;
2145:
2146: l_req_loan_info_note := wf_engine.GetItemAttrText

Line 2557: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;

2553: l_next_approver ame_util.approversTable2;
2554: l_error_message fnd_new_messages.message_text%TYPE;
2555: approvalComplete varchar2(20);
2556: i PLS_INTEGER := 1 ;
2557: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
2558: l_api_name CONSTANT VARCHAR2(30) := 'FindNextApprover';
2559:
2560: BEGIN
2561: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

Line 2747: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;

2743:
2744:
2745: l_approver_user_name VARCHAR2(320);
2746: approverRecord ame_util.approverRecord2;
2747: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
2748: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_APPROVAL_STATUS_TO_AME';
2749: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;
2750: l_loan_approve_note VARCHAR2(2000);
2751:

Line 2855: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;

2851:
2852:
2853: l_approver_user_name VARCHAR2(320);
2854: approverRecord ame_util.approverRecord2;
2855: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
2856: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_REJECTED_STATUS_TO_AME';
2857: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;
2858:
2859: BEGIN

Line 3245: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;

3241:
3242: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_AME_APPROVAL_ACTION';
3243: l_api_version CONSTANT NUMBER := 1.0;
3244: l_object_version_number NUMBER := 1;
3245: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
3246: l_loan_approve_note VARCHAR2(2000);
3247: l_loan_approval_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;
3248: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;
3249: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;

Line 3278: from lns_loan_headers_all loan

3274: --gparuchu - Code added to make sure correct object_version_number is passed
3275: --inorder to make sure the header table gets updated correctly upon Approval process.
3276: IF (l_loan_id IS NOT NULL) THEN
3277: select loan.object_version_number, loan.org_id into l_object_version_number,l_org_id
3278: from lns_loan_headers_all loan
3279: where loan.loan_id = l_loan_id;
3280: END IF;
3281:
3282: LogMessage(FND_LOG.LEVEL_STATEMENT,'In PROCESS_AME_APPROVAL_ACTION l_loan_id : ' || l_loan_id);