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

Line 194: l_loan_class LNS_LOAN_HEADERS.LOAN_CLASS_CODE%TYPE;

190: l_return_status VARCHAR2(1);
191: l_msg_count NUMBER;
192: l_msg_data VARCHAR2(32767);
193: l_loan_id NUMBER;
194: l_loan_class LNS_LOAN_HEADERS.LOAN_CLASS_CODE%TYPE;
195: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE;
196: l_sec_status LNS_LOAN_HEADERS.SECONDARY_STATUS%TYPE;
197: l_credit_review_flag LNS_LOAN_HEADERS.CREDIT_REVIEW_FLAG%TYPE;
198: l_curr_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE;

Line 195: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE;

191: l_msg_count NUMBER;
192: l_msg_data VARCHAR2(32767);
193: l_loan_id NUMBER;
194: l_loan_class LNS_LOAN_HEADERS.LOAN_CLASS_CODE%TYPE;
195: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE;
196: l_sec_status LNS_LOAN_HEADERS.SECONDARY_STATUS%TYPE;
197: l_credit_review_flag LNS_LOAN_HEADERS.CREDIT_REVIEW_FLAG%TYPE;
198: l_curr_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE;
199: l_open_to_term_event LNS_LOAN_HEADERS.OPEN_TO_TERM_EVENT%TYPE;

Line 196: l_sec_status LNS_LOAN_HEADERS.SECONDARY_STATUS%TYPE;

192: l_msg_data VARCHAR2(32767);
193: l_loan_id NUMBER;
194: l_loan_class LNS_LOAN_HEADERS.LOAN_CLASS_CODE%TYPE;
195: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE;
196: l_sec_status LNS_LOAN_HEADERS.SECONDARY_STATUS%TYPE;
197: l_credit_review_flag LNS_LOAN_HEADERS.CREDIT_REVIEW_FLAG%TYPE;
198: l_curr_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE;
199: l_open_to_term_event LNS_LOAN_HEADERS.OPEN_TO_TERM_EVENT%TYPE;
200: l_are_conditions_met VARCHAR2(1);

Line 197: l_credit_review_flag LNS_LOAN_HEADERS.CREDIT_REVIEW_FLAG%TYPE;

193: l_loan_id NUMBER;
194: l_loan_class LNS_LOAN_HEADERS.LOAN_CLASS_CODE%TYPE;
195: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE;
196: l_sec_status LNS_LOAN_HEADERS.SECONDARY_STATUS%TYPE;
197: l_credit_review_flag LNS_LOAN_HEADERS.CREDIT_REVIEW_FLAG%TYPE;
198: l_curr_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE;
199: l_open_to_term_event LNS_LOAN_HEADERS.OPEN_TO_TERM_EVENT%TYPE;
200: l_are_conditions_met VARCHAR2(1);
201: l_loan_approval_access VARCHAR2(1);

Line 198: l_curr_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE;

194: l_loan_class LNS_LOAN_HEADERS.LOAN_CLASS_CODE%TYPE;
195: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE;
196: l_sec_status LNS_LOAN_HEADERS.SECONDARY_STATUS%TYPE;
197: l_credit_review_flag LNS_LOAN_HEADERS.CREDIT_REVIEW_FLAG%TYPE;
198: l_curr_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE;
199: l_open_to_term_event LNS_LOAN_HEADERS.OPEN_TO_TERM_EVENT%TYPE;
200: l_are_conditions_met VARCHAR2(1);
201: l_loan_approval_access VARCHAR2(1);
202: l_validate_loan VARCHAR2(1);

Line 199: l_open_to_term_event LNS_LOAN_HEADERS.OPEN_TO_TERM_EVENT%TYPE;

195: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE;
196: l_sec_status LNS_LOAN_HEADERS.SECONDARY_STATUS%TYPE;
197: l_credit_review_flag LNS_LOAN_HEADERS.CREDIT_REVIEW_FLAG%TYPE;
198: l_curr_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE;
199: l_open_to_term_event LNS_LOAN_HEADERS.OPEN_TO_TERM_EVENT%TYPE;
200: l_are_conditions_met VARCHAR2(1);
201: l_loan_approval_access VARCHAR2(1);
202: l_validate_loan VARCHAR2(1);
203: l_amount_valid VARCHAR2(10);

Line 221: lns_loan_headers

217: CURSOR Cur_loan_details(p_loan_id NUMBER) IS
218: SELECT
219: loan_class_code, loan_status, secondary_status, credit_review_flag, current_phase, open_to_term_event
220: FROM
221: lns_loan_headers
222: WHERE
223: loan_id = p_loan_id;
224:
225: BEGIN

Line 303: lns_loan_headers loan

299: ELSIF l_loan_value_met = 'N' THEN
300: SELECT
301: to_char(loan.collateral_percent) || '%' into l_collateral_percent
302: FROM
303: lns_loan_headers loan
304: WHERE
305: loan.loan_id = l_loan_id;
306:
307: LogErrors(p_message_name=>'LNS_LOAN_TO_VALUE_ERROR'

Line 504: lns_loan_headers loan

500: CURSOR Cur_Loan_Value_Met(p_loan_id IN NUMBER) IS
501: SELECT
502: count(1)
503: FROM
504: lns_loan_headers loan
505: WHERE
506: loan.loan_id = p_loan_id
507: and (loan.loan_subtype <> 'SECURED'
508: OR loan.collateral_percent <=

Line 581: lns_loan_headers l

577: CURSOR Cur_Collateral_Exist(p_loan_id IN NUMBER) IS
578: SELECT
579: COUNT(1)
580: FROM
581: lns_loan_headers l
582: WHERE
583: l.loan_Id = p_loan_id
584: and (l.loan_subtype <> 'SECURED'
585: OR exists

Line 743: lns_loan_products_all prod, lns_loan_headers_all loan

739:
740: SELECT
741: NVL(LOAN_APPR_REQ_FLAG,'Y') into l_appr_req_flag
742: FROM
743: lns_loan_products_all prod, lns_loan_headers_all loan
744: WHERE
745: prod.loan_product_id = loan.product_id
746: and loan.loan_id = p_loan_id;
747: