[Home] [Help]
1102: FROM jtf_notes_tl notes
1103: WHERE notes.jtf_note_id = (select jtf_note_id
1104: from jtf_note_contexts
1105: where note_context_type_id = (select max(action_id)
1106: from LNS_APPROVAL_ACTIONS
1107: where loan_id = p_loan_id)
1108: )
1109: AND notes.language = USERENV('LANG');
1110:
1573: /*========================================================================
1574: | PRIVATE PROCEDURE PROCESS_LOAN_APPROVAL
1575: |
1576: | DESCRIPTION
1577: | This procedure insters/updates the Loan Approval Status in LNS_APPROVAL_ACTIONS table.
1578: |
1579: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1580: |
1581: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1676: avalue => l_loan_approve_note);
1677: */
1678: LogMessage(FND_LOG.LEVEL_STATEMENT,'In PROCESS_LOAN_APPROVAL l_loan_approve_note : ' || l_loan_approve_note);
1679:
1680: select LNS_APPROVAL_ACTIONS_S.NEXTVAL into l_loan_approval_action_rec.action_id from dual;
1681:
1682:
1683: l_loan_approval_action_rec.created_by := LNS_UTILITY_PUB.CREATED_BY;
1684: l_loan_approval_action_rec.creation_date := LNS_UTILITY_PUB.CREATION_DATE;
1819: /*========================================================================
1820: | PRIVATE PROCEDURE PROCESS_LOAN_REJECTION
1821: |
1822: | DESCRIPTION
1823: | This procedure insters/updates the Loan Rejection Status in LNS_APPROVAL_ACTIONS table.
1824: |
1825: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1826: |
1827: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
1916: itemkey => itemkey,
1917: aname => 'LNS_LAST_ENTERED_NOTE',
1918: avalue => l_loan_reject_note);
1919: */
1920: select LNS_APPROVAL_ACTIONS_S.NEXTVAL into l_loan_reject_action_rec.action_id from dual;
1921: l_loan_reject_action_rec.created_by := LNS_UTILITY_PUB.CREATED_BY;
1922: l_loan_reject_action_rec.creation_date := LNS_UTILITY_PUB.CREATION_DATE;
1923: l_loan_reject_action_rec.last_updated_by := LNS_UTILITY_PUB.LAST_UPDATED_BY;
1924: l_loan_reject_action_rec.last_update_date := LNS_UTILITY_PUB.LAST_UPDATE_DATE;
2056: /*========================================================================
2057: | PRIVATE PROCEDURE REQUEST_LOAN_INFORMATION
2058: |
2059: | DESCRIPTION
2060: | This procedure updates the Loan Status back to Incomplete in LNS_APPROVAL_ACTIONS table.
2061: |
2062: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
2063: |
2064: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
2151: G_LAST_ENTERED_NOTE := l_req_loan_info_note;
2152: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'G_LAST_ENTERED_NOTE = ' || G_LAST_ENTERED_NOTE);
2153:
2154: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Setting l_req_loan_info_action_rec...');
2155: select LNS_APPROVAL_ACTIONS_S.NEXTVAL into l_req_loan_info_action_rec.action_id from dual;
2156: l_req_loan_info_action_rec.created_by := LNS_UTILITY_PUB.CREATED_BY;
2157: l_req_loan_info_action_rec.creation_date := LNS_UTILITY_PUB.CREATION_DATE;
2158: l_req_loan_info_action_rec.last_updated_by := LNS_UTILITY_PUB.LAST_UPDATED_BY;
2159: l_req_loan_info_action_rec.last_update_date := LNS_UTILITY_PUB.LAST_UPDATE_DATE;
3200: /*========================================================================
3201: | PROCEDURE PROCESS_AME_APPROVAL_ACTION
3202: |
3203: | DESCRIPTION
3204: | This procedure inserts the loan Approval Actions in LNS_APPROVAL_ACTIONS table
3205: | whenever an approver takes any action from notification.
3206: |
3207: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
3208: |
3293: avalue => l_loan_approve_note);
3294:
3295: LogMessage(FND_LOG.LEVEL_STATEMENT,'In PROCESS_AME_APPROVAL_ACTION l_loan_approve_note : ' || l_loan_approve_note);
3296:
3297: select LNS_APPROVAL_ACTIONS_S.NEXTVAL into l_loan_approval_action_rec.action_id from dual;
3298:
3299: l_loan_approval_action_rec.created_by := LNS_UTILITY_PUB.CREATED_BY;
3300: l_loan_approval_action_rec.creation_date := LNS_UTILITY_PUB.CREATION_DATE;
3301: l_loan_approval_action_rec.last_updated_by := LNS_UTILITY_PUB.LAST_UPDATED_BY;