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 LNS_EVENT_ACTIONS

Line 950: l_primary_recipient_type lns_event_actions.primary_recipient_type%TYPE;

946: l_user_roles VARCHAR2(32000);
947: l_user_name FND_USER.user_name%TYPE;
948: l_role_name VARCHAR2(100);
949: l_loan_number LNS_LOAN_HEADERS.LOAN_NUMBER%TYPE;
950: l_primary_recipient_type lns_event_actions.primary_recipient_type%TYPE;
951: l_primary_recipient_name lns_event_actions.primary_recipient_name%TYPE;
952: l_priority_num lns_event_actions.priority_num%TYPE;
953: l_active_for_num lns_event_actions.active_for_num%TYPE;
954: l_delivery_method lns_event_actions.delivery_method%TYPE;

Line 951: l_primary_recipient_name lns_event_actions.primary_recipient_name%TYPE;

947: l_user_name FND_USER.user_name%TYPE;
948: l_role_name VARCHAR2(100);
949: l_loan_number LNS_LOAN_HEADERS.LOAN_NUMBER%TYPE;
950: l_primary_recipient_type lns_event_actions.primary_recipient_type%TYPE;
951: l_primary_recipient_name lns_event_actions.primary_recipient_name%TYPE;
952: l_priority_num lns_event_actions.priority_num%TYPE;
953: l_active_for_num lns_event_actions.active_for_num%TYPE;
954: l_delivery_method lns_event_actions.delivery_method%TYPE;
955: l_loan_assigned_name jtf_rs_resource_extns.source_name%TYPE;

Line 952: l_priority_num lns_event_actions.priority_num%TYPE;

948: l_role_name VARCHAR2(100);
949: l_loan_number LNS_LOAN_HEADERS.LOAN_NUMBER%TYPE;
950: l_primary_recipient_type lns_event_actions.primary_recipient_type%TYPE;
951: l_primary_recipient_name lns_event_actions.primary_recipient_name%TYPE;
952: l_priority_num lns_event_actions.priority_num%TYPE;
953: l_active_for_num lns_event_actions.active_for_num%TYPE;
954: l_delivery_method lns_event_actions.delivery_method%TYPE;
955: l_loan_assigned_name jtf_rs_resource_extns.source_name%TYPE;
956: l_loan_assigned_user fnd_user.user_name%TYPE;

Line 953: l_active_for_num lns_event_actions.active_for_num%TYPE;

949: l_loan_number LNS_LOAN_HEADERS.LOAN_NUMBER%TYPE;
950: l_primary_recipient_type lns_event_actions.primary_recipient_type%TYPE;
951: l_primary_recipient_name lns_event_actions.primary_recipient_name%TYPE;
952: l_priority_num lns_event_actions.priority_num%TYPE;
953: l_active_for_num lns_event_actions.active_for_num%TYPE;
954: l_delivery_method lns_event_actions.delivery_method%TYPE;
955: l_loan_assigned_name jtf_rs_resource_extns.source_name%TYPE;
956: l_loan_assigned_user fnd_user.user_name%TYPE;
957: l_current_user fnd_user.user_name%TYPE;

Line 954: l_delivery_method lns_event_actions.delivery_method%TYPE;

950: l_primary_recipient_type lns_event_actions.primary_recipient_type%TYPE;
951: l_primary_recipient_name lns_event_actions.primary_recipient_name%TYPE;
952: l_priority_num lns_event_actions.priority_num%TYPE;
953: l_active_for_num lns_event_actions.active_for_num%TYPE;
954: l_delivery_method lns_event_actions.delivery_method%TYPE;
955: l_loan_assigned_name jtf_rs_resource_extns.source_name%TYPE;
956: l_loan_assigned_user fnd_user.user_name%TYPE;
957: l_current_user fnd_user.user_name%TYPE;
958: l_borrower_name hz_parties.party_name%TYPE;

Line 972: l_event_action_id LNS_EVENT_ACTIONS.EVENT_ACTION_ID%TYPE;

968: l_loan_maturity_date lns_loan_headers_all.loan_maturity_date%TYPE;
969: l_interest_rate VARCHAR2(30);
970: l_overdue_amount VARCHAR2(30);
971: l_overdue_num lns_pay_sum_overdue_v.number_overdue_bills%TYPE;
972: l_event_action_id LNS_EVENT_ACTIONS.EVENT_ACTION_ID%TYPE;
973: l_org_id NUMBER;
974: l_user_id NUMBER;
975: l_product_name LNS_LOAN_PRODUCTS_ALL.LOAN_PRODUCT_NAME%TYPE;
976: l_loan_approval_agent_note JTF_NOTES_TL.NOTES%TYPE;

Line 989: FROM lns_events le, lns_event_actions lea

985: , priority_num
986: , nvl(active_for_num,0)*24*60 -- This has to be converted into minutes
987: , delivery_method
988: , event_action_id
989: FROM lns_events le, lns_event_actions lea
990: WHERE le.event_name = p_event_name
991: AND le.enabled_flag = 'Y'
992: AND le.loan_class_code = p_loan_class_code
993: AND lea.event_id = le.event_id

Line 2410: insert into lns_event_actions (

2406: l_api_name CONSTANT VARCHAR2(30) := 'SYNCH_EVENT_ACTIONS';
2407: l_api_version CONSTANT NUMBER := 1.0;
2408: BEGIN
2409: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2410: insert into lns_event_actions (
2411: EVENT_ACTION_ID
2412: , EVENT_ID
2413: , EVENT_ACTION_NAME
2414: , DESCRIPTION

Line 2435: select LNS_EVENT_ACTIONS_S.nextval --event_action_id

2431: , CREATED_BY
2432: , LAST_UPDATE_DATE
2433: , LAST_UPDATED_BY
2434: , LAST_UPDATE_LOGIN )
2435: select LNS_EVENT_ACTIONS_S.nextval --event_action_id
2436: , ea.EVENT_ID
2437: , ea.EVENT_ACTION_NAME
2438: , ea.DESCRIPTION
2439: , missingvalues.LOAN_TYPE_ID

Line 2459: from lns_event_actions ea, lns_events ev,

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
2463: select ev.loan_class_code loan_class_code, ea.loan_type_id loan_type_id

Line 2464: from lns_events ev, lns_event_actions ea

2460: (select loan_class_code, loan_type_id
2461: from lns_loan_types_vl
2462: minus
2463: select ev.loan_class_code loan_class_code, ea.loan_type_id loan_type_id
2464: from lns_events ev, lns_event_actions ea
2465: where ea.event_id = ev.event_id
2466: and ea.event_action_name = 'NOTIFICATION') missingvalues
2467: where ev.loan_class_code = missingvalues.loan_class_code
2468: and ea.event_id = ev.event_id

Line 2482: | PUBLIC PROCEDURE DELETE_LNS_EVENT_ACTIONS

2478: raise;
2479: END;
2480:
2481: /*========================================================================
2482: | PUBLIC PROCEDURE DELETE_LNS_EVENT_ACTIONS
2483: |
2484: | DESCRIPTION
2485: | This procedure deletes the event action records from the table
2486: | lns_event_actions table for the provided loanType.

Line 2486: | lns_event_actions table for the provided loanType.

Line 2503: PROCEDURE DELETE_LNS_EVENT_ACTIONS ( p_loan_type_id IN NUMBER) IS

2499: | Date Author Description of Changes
2500: | 16-Mar-2009 MBOLLI Created
2501: |
2502: *=======================================================================*/
2503: PROCEDURE DELETE_LNS_EVENT_ACTIONS ( p_loan_type_id IN NUMBER) IS
2504: /*-----------------------------------------------------------------------+
2505: | Local Variable Declarations and initializations |
2506: +-----------------------------------------------------------------------*/
2507:

Line 2508: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_LNS_EVENT_ACTIONS';

2504: /*-----------------------------------------------------------------------+
2505: | Local Variable Declarations and initializations |
2506: +-----------------------------------------------------------------------*/
2507:
2508: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_LNS_EVENT_ACTIONS';
2509: l_api_version CONSTANT NUMBER := 1.0;
2510: BEGIN
2511: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2512:

Line 2513: DELETE FROM lns_event_actions

2509: l_api_version CONSTANT NUMBER := 1.0;
2510: BEGIN
2511: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2512:
2513: DELETE FROM lns_event_actions
2514: WHERE loan_type_id = p_loan_type_id;
2515:
2516: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2517: EXCEPTION

Line 2519: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Error in delete_lns_event_actions: ' || sqlerrm);

2515:
2516: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2517: EXCEPTION
2518: WHEN OTHERS THEN
2519: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Error in delete_lns_event_actions: ' || sqlerrm);
2520: /* This error message needs to be seeded in the future */
2521: FND_MESSAGE.SET_NAME('LNS', 'LNS_ERR_DEL_EVNT_ACTION');
2522: FND_MSG_PUB.ADD;
2523: raise;