DBA Data[Home] [Help]

APPS.LNS_WORK_FLOW dependencies on LNS_APPROVAL_ACTIONS_S

Line 1680: select LNS_APPROVAL_ACTIONS_S.NEXTVAL into l_loan_approval_action_rec.action_id from dual;

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;

Line 1920: select LNS_APPROVAL_ACTIONS_S.NEXTVAL into l_loan_reject_action_rec.action_id from dual;

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;

Line 2155: select LNS_APPROVAL_ACTIONS_S.NEXTVAL into l_req_loan_info_action_rec.action_id from dual;

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;

Line 3297: select LNS_APPROVAL_ACTIONS_S.NEXTVAL into l_loan_approval_action_rec.action_id from dual;

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;