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 JTF_NOTE_CONTEXTS

Line 1104: from jtf_note_contexts

1100: CURSOR get_agent_approval_comment IS
1101: SELECT notes.notes
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: )

Line 1621: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;

1617: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1618: l_loan_approve_note VARCHAR2(2000);
1619: l_loan_approval_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;
1620: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;
1621: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;
1622: l_action_id NUMBER;
1623: l_note_id NUMBER;
1624: l_MSG_DATA VARCHAR2(32767);
1625: l_MSG_COUNT NUMBER;

Line 1747: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type := 'LNS_APPROVAL_ACTION';

1743: -- is trying to approve a loan
1744:
1745: -- fix for bug 13785835: moved calls to MO_GLOBAL before call to LNS_APPROVAL_ACTION_PUB.create_approval_action
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;

Line 1748: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;

1744:
1745: -- fix for bug 13785835: moved calls to MO_GLOBAL before call to LNS_APPROVAL_ACTION_PUB.create_approval_action
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;

Line 1749: --G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;

1745: -- fix for bug 13785835: moved calls to MO_GLOBAL before call to LNS_APPROVAL_ACTION_PUB.create_approval_action
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;

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 1780: P_JTF_NOTE_CONTEXTS_TAB => G_JTF_NOTE_CONTEXTS_TAB

1776: P_NOTE_STATUS => 'I', -- Visibility : public
1777: X_RETURN_STATUS => l_return_status,
1778: X_MSG_COUNT => l_msg_count,
1779: X_MSG_DATA => l_msg_data,
1780: P_JTF_NOTE_CONTEXTS_TAB => G_JTF_NOTE_CONTEXTS_TAB
1781:
1782: );
1783:
1784: -- Check for errors

Line 1868: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;

1864: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1865: l_loan_reject_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;
1866: l_loan_reject_note VARCHAR2(2000);
1867: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;
1868: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;
1869: l_action_id NUMBER;
1870: l_note_id NUMBER;
1871: l_MSG_DATA VARCHAR2(32767);
1872: l_MSG_COUNT NUMBER;

Line 1982: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type := 'LNS_APPROVAL_ACTION';

1978: --mo_global.set_policy_context('M', null);
1979: MO_GLOBAL.INIT('LNS');
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;

Line 1983: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_reject_action_rec.action_id;

1979: MO_GLOBAL.INIT('LNS');
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;

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 2015: P_JTF_NOTE_CONTEXTS_TAB => G_JTF_NOTE_CONTEXTS_TAB

2011: P_NOTE_STATUS => 'I', -- Visibility : public
2012: X_RETURN_STATUS => l_return_status,
2013: X_MSG_COUNT => l_msg_count,
2014: X_MSG_DATA => l_msg_data,
2015: P_JTF_NOTE_CONTEXTS_TAB => G_JTF_NOTE_CONTEXTS_TAB
2016: );
2017:
2018: -- Check for errors
2019:

Line 2105: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;

2101: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
2102: l_req_loan_info_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;
2103: l_req_loan_info_note VARCHAR2(2000);
2104: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;
2105: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;
2106: l_action_id NUMBER;
2107: l_note_id NUMBER;
2108: l_MSG_DATA VARCHAR2(32767);
2109: l_MSG_COUNT NUMBER;

Line 2246: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type := 'LNS_APPROVAL_ACTION';

2242: --mo_global.set_policy_context('M', null);
2243: MO_GLOBAL.INIT('LNS');
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;

Line 2247: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_req_loan_info_action_rec.action_id;

2243: MO_GLOBAL.INIT('LNS');
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;

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 2279: P_JTF_NOTE_CONTEXTS_TAB => G_JTF_NOTE_CONTEXTS_TAB

2275: P_NOTE_STATUS => 'I', -- Visibility : public
2276: X_RETURN_STATUS => l_return_status,
2277: X_MSG_COUNT => l_msg_count,
2278: X_MSG_DATA => l_msg_data,
2279: P_JTF_NOTE_CONTEXTS_TAB => G_JTF_NOTE_CONTEXTS_TAB
2280: );
2281:
2282: -- Check for errors
2283:

Line 3249: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;

3245: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
3246: l_loan_approve_note VARCHAR2(2000);
3247: l_loan_approval_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;
3248: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;
3249: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;
3250: l_action_id NUMBER;
3251: l_note_id NUMBER;
3252: l_MSG_DATA VARCHAR2(32767);
3253: l_MSG_COUNT NUMBER;

Line 3361: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type := 'LNS_APPROVAL_ACTION';

3357: --mo_global.set_policy_context('M', null);
3358: MO_GLOBAL.INIT('LNS');
3359: MO_GLOBAL.set_policy_context('S',l_org_id);
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;

Line 3362: G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;

3358: MO_GLOBAL.INIT('LNS');
3359: MO_GLOBAL.set_policy_context('S',l_org_id);
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;

Line 3363: --G_JTF_NOTE_CONTEXTS_TAB(1).note_context_type_id := l_loan_approval_action_rec.action_id;

3359: MO_GLOBAL.set_policy_context('S',l_org_id);
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;

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 3394: P_JTF_NOTE_CONTEXTS_TAB => G_JTF_NOTE_CONTEXTS_TAB

3390: P_NOTE_STATUS => 'I', -- Visibility : public
3391: X_RETURN_STATUS => l_return_status,
3392: X_MSG_COUNT => l_msg_count,
3393: X_MSG_DATA => l_msg_data,
3394: P_JTF_NOTE_CONTEXTS_TAB => G_JTF_NOTE_CONTEXTS_TAB
3395:
3396: );
3397:
3398: -- Check for errors