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 DUAL

Line 620: FROM dual;

616: ItemType := 'LNSWF';
617:
618: SELECT lns_workflow_itemkey_s.nextval
619: INTO ItemKey
620: FROM dual;
621:
622: OPEN csr_loan_event_details;
623: FETCH csr_loan_event_details
624: INTO l_wf_event_name

Line 1267: ELSIF l_primary_recipient_type = 'INDIVIDUAL' AND l_primary_recipient_name = 'LOAN_ASSIGNED_TO' THEN

1263: aname => 'LNS_PRIMARY_ROLE',
1264: avalue => l_role_name);
1265: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Set LNS_PRIMARY_ROLE = '||l_role_name);
1266:
1267: ELSIF l_primary_recipient_type = 'INDIVIDUAL' AND l_primary_recipient_name = 'LOAN_ASSIGNED_TO' THEN
1268:
1269: -- l_user_roles := l_loan_assigned_user;
1270: -- l_role_name :=l_loan_assigned_name || '(' ||l_loan_number || '-'|| ItemKey || ')'
1271:

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;