APPS.LNS_WORK_FLOW dependencies on LNS_UTILITY_PUB

Line 1683: l_loan_approval_action_rec.created_by := LNS_UTILITY_PUB.CREATED_BY;

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;
1685: l_loan_approval_action_rec.last_updated_by := LNS_UTILITY_PUB.LAST_UPDATED_BY;
1686: l_loan_approval_action_rec.last_update_date := LNS_UTILITY_PUB.LAST_UPDATE_DATE;
1687: l_loan_approval_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;

Line 1684: l_loan_approval_action_rec.creation_date := LNS_UTILITY_PUB.CREATION_DATE;

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;
1685: l_loan_approval_action_rec.last_updated_by := LNS_UTILITY_PUB.LAST_UPDATED_BY;
1686: l_loan_approval_action_rec.last_update_date := LNS_UTILITY_PUB.LAST_UPDATE_DATE;
1687: l_loan_approval_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;
1688: l_loan_approval_action_rec.object_version_number := l_object_version_number;

Line 1685: l_loan_approval_action_rec.last_updated_by := LNS_UTILITY_PUB.LAST_UPDATED_BY;

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;
1685: l_loan_approval_action_rec.last_updated_by := LNS_UTILITY_PUB.LAST_UPDATED_BY;
1686: l_loan_approval_action_rec.last_update_date := LNS_UTILITY_PUB.LAST_UPDATE_DATE;
1687: l_loan_approval_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;
1688: l_loan_approval_action_rec.object_version_number := l_object_version_number;
1689: l_loan_approval_action_rec.loan_id := l_loan_id;

Line 1686: l_loan_approval_action_rec.last_update_date := LNS_UTILITY_PUB.LAST_UPDATE_DATE;

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;
1685: l_loan_approval_action_rec.last_updated_by := LNS_UTILITY_PUB.LAST_UPDATED_BY;
1686: l_loan_approval_action_rec.last_update_date := LNS_UTILITY_PUB.LAST_UPDATE_DATE;
1687: l_loan_approval_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;
1688: l_loan_approval_action_rec.object_version_number := l_object_version_number;
1689: l_loan_approval_action_rec.loan_id := l_loan_id;
1690: l_loan_approval_action_rec.action_type := 'APPROVE';

Line 1687: l_loan_approval_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;

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;
1685: l_loan_approval_action_rec.last_updated_by := LNS_UTILITY_PUB.LAST_UPDATED_BY;
1686: l_loan_approval_action_rec.last_update_date := LNS_UTILITY_PUB.LAST_UPDATE_DATE;
1687: l_loan_approval_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;
1688: l_loan_approval_action_rec.object_version_number := l_object_version_number;
1689: l_loan_approval_action_rec.loan_id := l_loan_id;
1690: l_loan_approval_action_rec.action_type := 'APPROVE';
1691: l_loan_approval_action_rec.amount := null;

Line 1750: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;

1746:
1747: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type := 'LNS_APPROVAL_ACTION';
1748: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;
1749: --G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;
1750: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
1751: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
1752: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
1753: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
1754: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;

Line 1751: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;

1747: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type := 'LNS_APPROVAL_ACTION';
1748: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;
1749: --G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;
1750: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
1751: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
1752: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
1753: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
1754: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
1755:

Line 1752: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;

1748: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;
1749: --G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;
1750: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
1751: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
1752: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
1753: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
1754: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
1755:
1756: LogMessage(FND_LOG.LEVEL_STATEMENT,'Start calling JTF_NOTES_PUB.CREATE_NOTE' );

Line 1753: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;

1749: --G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;
1750: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
1751: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
1752: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
1753: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
1754: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
1755:
1756: LogMessage(FND_LOG.LEVEL_STATEMENT,'Start calling JTF_NOTES_PUB.CREATE_NOTE' );
1757: JTF_NOTES_PUB.CREATE_NOTE(

Line 1754: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;

1750: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
1751: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
1752: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
1753: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
1754: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
1755:
1756: LogMessage(FND_LOG.LEVEL_STATEMENT,'Start calling JTF_NOTES_PUB.CREATE_NOTE' );
1757: JTF_NOTES_PUB.CREATE_NOTE(
1758: P_API_VERSION => 1.0,

Line 1767: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,

1763: P_SOURCE_OBJECT_ID => l_loan_id,
1764: P_SOURCE_OBJECT_CODE => 'LNS_LOAN',
1765: P_NOTES => l_loan_approve_note,
1766: P_NOTES_DETAIL => null,
1767: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
1768: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
1769: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
1770: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
1771: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,

Line 1768: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,

1764: P_SOURCE_OBJECT_CODE => 'LNS_LOAN',
1765: P_NOTES => l_loan_approve_note,
1766: P_NOTES_DETAIL => null,
1767: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
1768: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
1769: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
1770: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
1771: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
1772: P_CREATED_BY => LNS_UTILITY_PUB.created_by,

Line 1769: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,

1765: P_NOTES => l_loan_approve_note,
1766: P_NOTES_DETAIL => null,
1767: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
1768: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
1769: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
1770: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
1771: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
1772: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
1773: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,

Line 1770: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,

1766: P_NOTES_DETAIL => null,
1767: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
1768: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
1769: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
1770: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
1771: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
1772: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
1773: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,
1774: X_JTF_NOTE_ID => l_note_id ,

Line 1771: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,

1767: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
1768: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
1769: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
1770: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
1771: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
1772: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
1773: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,
1774: X_JTF_NOTE_ID => l_note_id ,
1775: P_NOTE_TYPE => 'LNS_ORIG', -- Note Type : origination

Line 1772: P_CREATED_BY => LNS_UTILITY_PUB.created_by,

1768: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
1769: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
1770: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
1771: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
1772: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
1773: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,
1774: X_JTF_NOTE_ID => l_note_id ,
1775: P_NOTE_TYPE => 'LNS_ORIG', -- Note Type : origination
1776: P_NOTE_STATUS => 'I', -- Visibility : public

Line 1773: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,

1769: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
1770: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
1771: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
1772: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
1773: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,
1774: X_JTF_NOTE_ID => l_note_id ,
1775: P_NOTE_TYPE => 'LNS_ORIG', -- Note Type : origination
1776: P_NOTE_STATUS => 'I', -- Visibility : public
1777: X_RETURN_STATUS => l_return_status,

Line 1921: l_loan_reject_action_rec.created_by := LNS_UTILITY_PUB.CREATED_BY;

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;
1925: l_loan_reject_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;

Line 1922: l_loan_reject_action_rec.creation_date := LNS_UTILITY_PUB.CREATION_DATE;

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;
1925: l_loan_reject_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;
1926: l_loan_reject_action_rec.object_version_number := l_object_version_number;

Line 1923: l_loan_reject_action_rec.last_updated_by := LNS_UTILITY_PUB.LAST_UPDATED_BY;

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;
1925: l_loan_reject_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;
1926: l_loan_reject_action_rec.object_version_number := l_object_version_number;
1927: l_loan_reject_action_rec.loan_id := l_loan_id;

Line 1924: l_loan_reject_action_rec.last_update_date := LNS_UTILITY_PUB.LAST_UPDATE_DATE;

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;
1925: l_loan_reject_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;
1926: l_loan_reject_action_rec.object_version_number := l_object_version_number;
1927: l_loan_reject_action_rec.loan_id := l_loan_id;
1928: l_loan_reject_action_rec.action_type := 'REJECT';

Line 1925: l_loan_reject_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;

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;
1925: l_loan_reject_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;
1926: l_loan_reject_action_rec.object_version_number := l_object_version_number;
1927: l_loan_reject_action_rec.loan_id := l_loan_id;
1928: l_loan_reject_action_rec.action_type := 'REJECT';
1929: l_loan_reject_action_rec.amount := null;

Line 1984: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;

1980: MO_GLOBAL.set_policy_context('S',l_org_id);
1981:
1982: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type := 'LNS_APPROVAL_ACTION';
1983: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_reject_action_rec.action_id;
1984: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
1985: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
1986: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
1987: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
1988: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;

Line 1985: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;

1981:
1982: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type := 'LNS_APPROVAL_ACTION';
1983: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_reject_action_rec.action_id;
1984: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
1985: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
1986: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
1987: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
1988: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
1989:

Line 1986: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;

1982: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type := 'LNS_APPROVAL_ACTION';
1983: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_reject_action_rec.action_id;
1984: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
1985: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
1986: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
1987: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
1988: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
1989:
1990: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start calling JTF_NOTES_PUB.CREATE_NOTE' );

Line 1987: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;

1983: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_reject_action_rec.action_id;
1984: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
1985: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
1986: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
1987: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
1988: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
1989:
1990: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start calling JTF_NOTES_PUB.CREATE_NOTE' );
1991:

Line 1988: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;

1984: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
1985: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
1986: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
1987: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
1988: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
1989:
1990: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Start calling JTF_NOTES_PUB.CREATE_NOTE' );
1991:
1992: JTF_NOTES_PUB.CREATE_NOTE(

Line 2002: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,

1998: P_SOURCE_OBJECT_ID => l_loan_id,
1999: P_SOURCE_OBJECT_CODE => 'LNS_LOAN',
2000: P_NOTES => l_loan_reject_note,
2001: P_NOTES_DETAIL => null,
2002: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
2003: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
2004: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
2005: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
2006: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,

Line 2003: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,

1999: P_SOURCE_OBJECT_CODE => 'LNS_LOAN',
2000: P_NOTES => l_loan_reject_note,
2001: P_NOTES_DETAIL => null,
2002: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
2003: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
2004: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
2005: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
2006: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
2007: P_CREATED_BY => LNS_UTILITY_PUB.created_by,

Line 2004: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,

2000: P_NOTES => l_loan_reject_note,
2001: P_NOTES_DETAIL => null,
2002: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
2003: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
2004: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
2005: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
2006: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
2007: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
2008: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,

Line 2005: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,

2001: P_NOTES_DETAIL => null,
2002: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
2003: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
2004: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
2005: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
2006: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
2007: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
2008: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,
2009: X_JTF_NOTE_ID => l_note_id ,

Line 2006: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,

2002: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
2003: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
2004: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
2005: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
2006: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
2007: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
2008: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,
2009: X_JTF_NOTE_ID => l_note_id ,
2010: P_NOTE_TYPE => 'LNS_ORIG', -- Note Type : origination

Line 2007: P_CREATED_BY => LNS_UTILITY_PUB.created_by,

2003: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
2004: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
2005: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
2006: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
2007: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
2008: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,
2009: X_JTF_NOTE_ID => l_note_id ,
2010: P_NOTE_TYPE => 'LNS_ORIG', -- Note Type : origination
2011: P_NOTE_STATUS => 'I', -- Visibility : public

Line 2008: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,

2004: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
2005: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
2006: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
2007: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
2008: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,
2009: X_JTF_NOTE_ID => l_note_id ,
2010: P_NOTE_TYPE => 'LNS_ORIG', -- Note Type : origination
2011: P_NOTE_STATUS => 'I', -- Visibility : public
2012: X_RETURN_STATUS => l_return_status,

Line 2156: l_req_loan_info_action_rec.created_by := LNS_UTILITY_PUB.CREATED_BY;

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;
2160: l_req_loan_info_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;

Line 2157: l_req_loan_info_action_rec.creation_date := LNS_UTILITY_PUB.CREATION_DATE;

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;
2160: l_req_loan_info_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;
2161: l_req_loan_info_action_rec.object_version_number := l_object_version_number;

Line 2158: l_req_loan_info_action_rec.last_updated_by := LNS_UTILITY_PUB.LAST_UPDATED_BY;

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;
2160: l_req_loan_info_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;
2161: l_req_loan_info_action_rec.object_version_number := l_object_version_number;
2162: l_req_loan_info_action_rec.loan_id := l_loan_id;

Line 2159: l_req_loan_info_action_rec.last_update_date := LNS_UTILITY_PUB.LAST_UPDATE_DATE;

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;
2160: l_req_loan_info_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;
2161: l_req_loan_info_action_rec.object_version_number := l_object_version_number;
2162: l_req_loan_info_action_rec.loan_id := l_loan_id;
2163: l_req_loan_info_action_rec.action_type := 'REQUEST_FOR_INFO';

Line 2160: l_req_loan_info_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;

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;
2160: l_req_loan_info_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;
2161: l_req_loan_info_action_rec.object_version_number := l_object_version_number;
2162: l_req_loan_info_action_rec.loan_id := l_loan_id;
2163: l_req_loan_info_action_rec.action_type := 'REQUEST_FOR_INFO';
2164: l_req_loan_info_action_rec.amount := null;

Line 2248: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;

2244: MO_GLOBAL.set_policy_context('S',l_org_id);
2245:
2246: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type := 'LNS_APPROVAL_ACTION';
2247: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_req_loan_info_action_rec.action_id;
2248: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
2249: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
2250: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
2251: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
2252: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;

Line 2249: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;

2245:
2246: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type := 'LNS_APPROVAL_ACTION';
2247: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_req_loan_info_action_rec.action_id;
2248: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
2249: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
2250: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
2251: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
2252: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
2253:

Line 2250: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;

2246: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type := 'LNS_APPROVAL_ACTION';
2247: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_req_loan_info_action_rec.action_id;
2248: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
2249: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
2250: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
2251: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
2252: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
2253:
2254: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Before calling JTF_NOTES_PUB.CREATE_NOTE' );

Line 2251: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;

2247: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_req_loan_info_action_rec.action_id;
2248: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
2249: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
2250: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
2251: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
2252: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
2253:
2254: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Before calling JTF_NOTES_PUB.CREATE_NOTE' );
2255:

Line 2252: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;

2248: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
2249: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
2250: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
2251: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
2252: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
2253:
2254: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Before calling JTF_NOTES_PUB.CREATE_NOTE' );
2255:
2256: JTF_NOTES_PUB.CREATE_NOTE(

Line 2266: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,

2262: P_SOURCE_OBJECT_ID => l_loan_id,
2263: P_SOURCE_OBJECT_CODE => 'LNS_LOAN',
2264: P_NOTES => l_req_loan_info_note,
2265: P_NOTES_DETAIL => null,
2266: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
2267: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
2268: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
2269: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
2270: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,

Line 2267: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,

2263: P_SOURCE_OBJECT_CODE => 'LNS_LOAN',
2264: P_NOTES => l_req_loan_info_note,
2265: P_NOTES_DETAIL => null,
2266: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
2267: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
2268: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
2269: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
2270: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
2271: P_CREATED_BY => LNS_UTILITY_PUB.created_by,

Line 2268: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,

2264: P_NOTES => l_req_loan_info_note,
2265: P_NOTES_DETAIL => null,
2266: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
2267: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
2268: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
2269: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
2270: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
2271: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
2272: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,

Line 2269: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,

2265: P_NOTES_DETAIL => null,
2266: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
2267: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
2268: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
2269: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
2270: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
2271: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
2272: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,
2273: X_JTF_NOTE_ID => l_note_id ,

Line 2270: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,

2266: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
2267: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
2268: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
2269: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
2270: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
2271: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
2272: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,
2273: X_JTF_NOTE_ID => l_note_id ,
2274: P_NOTE_TYPE => 'LNS_ORIG', -- Note Type : origination

Line 2271: P_CREATED_BY => LNS_UTILITY_PUB.created_by,

2267: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
2268: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
2269: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
2270: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
2271: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
2272: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,
2273: X_JTF_NOTE_ID => l_note_id ,
2274: P_NOTE_TYPE => 'LNS_ORIG', -- Note Type : origination
2275: P_NOTE_STATUS => 'I', -- Visibility : public

Line 2272: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,

2268: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
2269: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
2270: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
2271: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
2272: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,
2273: X_JTF_NOTE_ID => l_note_id ,
2274: P_NOTE_TYPE => 'LNS_ORIG', -- Note Type : origination
2275: P_NOTE_STATUS => 'I', -- Visibility : public
2276: X_RETURN_STATUS => l_return_status,

Line 2455: , LNS_UTILITY_PUB.CREATED_BY

2451: , ea.ACTIVE_FOR_NUM
2452: , ea.DELIVERY_METHOD
2453: , ea.OBJECT_VERSION_NUMBER
2454: , sysdate
2455: , LNS_UTILITY_PUB.CREATED_BY
2456: , sysdate
2457: , LNS_UTILITY_PUB.LAST_UPDATED_BY
2458: , LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
2459: from lns_event_actions ea, lns_events ev,

Line 2457: , LNS_UTILITY_PUB.LAST_UPDATED_BY

2453: , ea.OBJECT_VERSION_NUMBER
2454: , sysdate
2455: , LNS_UTILITY_PUB.CREATED_BY
2456: , sysdate
2457: , LNS_UTILITY_PUB.LAST_UPDATED_BY
2458: , LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
2459: from lns_event_actions ea, lns_events ev,
2460: (select loan_class_code, loan_type_id
2461: from lns_loan_types_vl

Line 2458: , LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

2454: , sysdate
2455: , LNS_UTILITY_PUB.CREATED_BY
2456: , sysdate
2457: , LNS_UTILITY_PUB.LAST_UPDATED_BY
2458: , LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
2459: from lns_event_actions ea, lns_events ev,
2460: (select loan_class_code, loan_type_id
2461: from lns_loan_types_vl
2462: minus

Line 3299: l_loan_approval_action_rec.created_by := LNS_UTILITY_PUB.CREATED_BY;

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;
3302: l_loan_approval_action_rec.last_update_date := LNS_UTILITY_PUB.LAST_UPDATE_DATE;
3303: l_loan_approval_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;

Line 3300: l_loan_approval_action_rec.creation_date := LNS_UTILITY_PUB.CREATION_DATE;

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;
3302: l_loan_approval_action_rec.last_update_date := LNS_UTILITY_PUB.LAST_UPDATE_DATE;
3303: l_loan_approval_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;
3304: l_loan_approval_action_rec.object_version_number := l_object_version_number;

Line 3301: l_loan_approval_action_rec.last_updated_by := LNS_UTILITY_PUB.LAST_UPDATED_BY;

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;
3302: l_loan_approval_action_rec.last_update_date := LNS_UTILITY_PUB.LAST_UPDATE_DATE;
3303: l_loan_approval_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;
3304: l_loan_approval_action_rec.object_version_number := l_object_version_number;
3305: l_loan_approval_action_rec.loan_id := l_loan_id;

Line 3302: l_loan_approval_action_rec.last_update_date := LNS_UTILITY_PUB.LAST_UPDATE_DATE;

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;
3302: l_loan_approval_action_rec.last_update_date := LNS_UTILITY_PUB.LAST_UPDATE_DATE;
3303: l_loan_approval_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;
3304: l_loan_approval_action_rec.object_version_number := l_object_version_number;
3305: l_loan_approval_action_rec.loan_id := l_loan_id;
3306: l_loan_approval_action_rec.action_type := 'APPROVE_SINGLE'; --for intermediate approver

Line 3303: l_loan_approval_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;

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;
3302: l_loan_approval_action_rec.last_update_date := LNS_UTILITY_PUB.LAST_UPDATE_DATE;
3303: l_loan_approval_action_rec.last_update_login := LNS_UTILITY_PUB.LAST_UPDATE_LOGIN;
3304: l_loan_approval_action_rec.object_version_number := l_object_version_number;
3305: l_loan_approval_action_rec.loan_id := l_loan_id;
3306: l_loan_approval_action_rec.action_type := 'APPROVE_SINGLE'; --for intermediate approver
3307: l_loan_approval_action_rec.amount := null;

Line 3364: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;

3360:
3361: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type := 'LNS_APPROVAL_ACTION';
3362: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;
3363: --G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;
3364: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
3365: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
3366: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
3367: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
3368: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;

Line 3365: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;

3361: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type := 'LNS_APPROVAL_ACTION';
3362: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;
3363: --G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;
3364: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
3365: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
3366: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
3367: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
3368: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
3369:

Line 3366: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;

3362: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;
3363: --G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;
3364: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
3365: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
3366: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
3367: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
3368: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
3369:
3370: LogMessage(FND_LOG.LEVEL_STATEMENT,'Start calling JTF_NOTES_PUB.CREATE_NOTE' );

Line 3367: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;

3363: --G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;
3364: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
3365: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
3366: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
3367: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
3368: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
3369:
3370: LogMessage(FND_LOG.LEVEL_STATEMENT,'Start calling JTF_NOTES_PUB.CREATE_NOTE' );
3371: JTF_NOTES_PUB.CREATE_NOTE(

Line 3368: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;

3364: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_date := LNS_UTILITY_PUB.last_update_date;
3365: G_JTF_NOTE_CONTEXTS_TAB(1).last_updated_by := LNS_UTILITY_PUB.last_updated_by;
3366: G_JTF_NOTE_CONTEXTS_TAB(1).last_update_login := LNS_UTILITY_PUB.last_update_login;
3367: G_JTF_NOTE_CONTEXTS_TAB(1).creation_date := LNS_UTILITY_PUB.creation_date;
3368: G_JTF_NOTE_CONTEXTS_TAB(1).created_by := LNS_UTILITY_PUB.created_by;
3369:
3370: LogMessage(FND_LOG.LEVEL_STATEMENT,'Start calling JTF_NOTES_PUB.CREATE_NOTE' );
3371: JTF_NOTES_PUB.CREATE_NOTE(
3372: P_API_VERSION => 1.0,

Line 3381: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,

3377: P_SOURCE_OBJECT_ID => l_loan_id,
3378: P_SOURCE_OBJECT_CODE => 'LNS_LOAN',
3379: P_NOTES => l_loan_approve_note,
3380: P_NOTES_DETAIL => null,
3381: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
3382: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
3383: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
3384: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
3385: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,

Line 3382: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,

3378: P_SOURCE_OBJECT_CODE => 'LNS_LOAN',
3379: P_NOTES => l_loan_approve_note,
3380: P_NOTES_DETAIL => null,
3381: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
3382: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
3383: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
3384: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
3385: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
3386: P_CREATED_BY => LNS_UTILITY_PUB.created_by,

Line 3383: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,

3379: P_NOTES => l_loan_approve_note,
3380: P_NOTES_DETAIL => null,
3381: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
3382: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
3383: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
3384: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
3385: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
3386: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
3387: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,

Line 3384: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,

3380: P_NOTES_DETAIL => null,
3381: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
3382: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
3383: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
3384: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
3385: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
3386: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
3387: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,
3388: X_JTF_NOTE_ID => l_note_id ,

Line 3385: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,

3381: P_ENTERED_BY => LNS_UTILITY_PUB.created_by,
3382: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
3383: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
3384: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
3385: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
3386: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
3387: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,
3388: X_JTF_NOTE_ID => l_note_id ,
3389: P_NOTE_TYPE => 'LNS_ORIG', -- Note Type : origination

Line 3386: P_CREATED_BY => LNS_UTILITY_PUB.created_by,

3382: P_ENTERED_DATE => LNS_UTILITY_PUB.creation_date,
3383: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
3384: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
3385: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
3386: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
3387: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,
3388: X_JTF_NOTE_ID => l_note_id ,
3389: P_NOTE_TYPE => 'LNS_ORIG', -- Note Type : origination
3390: P_NOTE_STATUS => 'I', -- Visibility : public

Line 3387: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,

3383: P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.last_update_date,
3384: P_LAST_UPDATED_BY => LNS_UTILITY_PUB.last_updated_by,
3385: P_CREATION_DATE => LNS_UTILITY_PUB.creation_date,
3386: P_CREATED_BY => LNS_UTILITY_PUB.created_by,
3387: P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.last_update_login,
3388: X_JTF_NOTE_ID => l_note_id ,
3389: P_NOTE_TYPE => 'LNS_ORIG', -- Note Type : origination
3390: P_NOTE_STATUS => 'I', -- Visibility : public
3391: X_RETURN_STATUS => l_return_status,