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 660: l_primary_recipient_type lns_event_actions.primary_recipient_type%TYPE;

656: l_user_roles VARCHAR2(32000);
657: l_user_name FND_USER.user_name%TYPE;
658: l_role_name VARCHAR2(100);
659: l_loan_number LNS_LOAN_HEADERS.LOAN_NUMBER%TYPE;
660: l_primary_recipient_type lns_event_actions.primary_recipient_type%TYPE;
661: l_primary_recipient_name lns_event_actions.primary_recipient_name%TYPE;
662: l_priority_num lns_event_actions.priority_num%TYPE;
663: l_active_for_num lns_event_actions.active_for_num%TYPE;
664: l_delivery_method lns_event_actions.delivery_method%TYPE;

Line 661: l_primary_recipient_name lns_event_actions.primary_recipient_name%TYPE;

657: l_user_name FND_USER.user_name%TYPE;
658: l_role_name VARCHAR2(100);
659: l_loan_number LNS_LOAN_HEADERS.LOAN_NUMBER%TYPE;
660: l_primary_recipient_type lns_event_actions.primary_recipient_type%TYPE;
661: l_primary_recipient_name lns_event_actions.primary_recipient_name%TYPE;
662: l_priority_num lns_event_actions.priority_num%TYPE;
663: l_active_for_num lns_event_actions.active_for_num%TYPE;
664: l_delivery_method lns_event_actions.delivery_method%TYPE;
665: l_loan_assigned_name jtf_rs_resource_extns.source_name%TYPE;

Line 662: l_priority_num lns_event_actions.priority_num%TYPE;

658: l_role_name VARCHAR2(100);
659: l_loan_number LNS_LOAN_HEADERS.LOAN_NUMBER%TYPE;
660: l_primary_recipient_type lns_event_actions.primary_recipient_type%TYPE;
661: l_primary_recipient_name lns_event_actions.primary_recipient_name%TYPE;
662: l_priority_num lns_event_actions.priority_num%TYPE;
663: l_active_for_num lns_event_actions.active_for_num%TYPE;
664: l_delivery_method lns_event_actions.delivery_method%TYPE;
665: l_loan_assigned_name jtf_rs_resource_extns.source_name%TYPE;
666: l_loan_assigned_user fnd_user.user_name%TYPE;

Line 663: l_active_for_num lns_event_actions.active_for_num%TYPE;

659: l_loan_number LNS_LOAN_HEADERS.LOAN_NUMBER%TYPE;
660: l_primary_recipient_type lns_event_actions.primary_recipient_type%TYPE;
661: l_primary_recipient_name lns_event_actions.primary_recipient_name%TYPE;
662: l_priority_num lns_event_actions.priority_num%TYPE;
663: l_active_for_num lns_event_actions.active_for_num%TYPE;
664: l_delivery_method lns_event_actions.delivery_method%TYPE;
665: l_loan_assigned_name jtf_rs_resource_extns.source_name%TYPE;
666: l_loan_assigned_user fnd_user.user_name%TYPE;
667: l_current_user fnd_user.user_name%TYPE;

Line 664: l_delivery_method lns_event_actions.delivery_method%TYPE;

660: l_primary_recipient_type lns_event_actions.primary_recipient_type%TYPE;
661: l_primary_recipient_name lns_event_actions.primary_recipient_name%TYPE;
662: l_priority_num lns_event_actions.priority_num%TYPE;
663: l_active_for_num lns_event_actions.active_for_num%TYPE;
664: l_delivery_method lns_event_actions.delivery_method%TYPE;
665: l_loan_assigned_name jtf_rs_resource_extns.source_name%TYPE;
666: l_loan_assigned_user fnd_user.user_name%TYPE;
667: l_current_user fnd_user.user_name%TYPE;
668: l_borrower_name hz_parties.party_name%TYPE;

Line 682: l_event_action_id LNS_EVENT_ACTIONS.EVENT_ACTION_ID%TYPE;

678: l_loan_maturity_date lns_loan_headers_all.loan_maturity_date%TYPE;
679: l_interest_rate VARCHAR2(30);
680: l_overdue_amount VARCHAR2(30);
681: l_overdue_num lns_pay_sum_overdue_v.number_overdue_bills%TYPE;
682: l_event_action_id LNS_EVENT_ACTIONS.EVENT_ACTION_ID%TYPE;
683: l_org_id NUMBER;
684: l_user_id NUMBER;
685:
686:

Line 697: FROM lns_events le, lns_event_actions lea

693: , priority_num
694: , nvl(active_for_num,0)*24*60 -- This has to be converted into minutes
695: , delivery_method
696: , event_action_id
697: FROM lns_events le, lns_event_actions lea
698: WHERE le.event_name = p_event_name
699: AND le.enabled_flag = 'Y'
700: AND le.loan_class_code = p_loan_class_code
701: AND lea.event_id = le.event_id

Line 1099: insert into lns_event_actions (

1095: l_api_name CONSTANT VARCHAR2(30) := 'SYNCH_EVENT_ACTIONS';
1096: l_api_version CONSTANT NUMBER := 1.0;
1097: BEGIN
1098: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
1099: insert into lns_event_actions (
1100: EVENT_ACTION_ID
1101: , EVENT_ID
1102: , EVENT_ACTION_NAME
1103: , DESCRIPTION

Line 1124: select LNS_EVENT_ACTIONS_S.nextval --event_action_id

1120: , CREATED_BY
1121: , LAST_UPDATE_DATE
1122: , LAST_UPDATED_BY
1123: , LAST_UPDATE_LOGIN )
1124: select LNS_EVENT_ACTIONS_S.nextval --event_action_id
1125: , ea.EVENT_ID
1126: , ea.EVENT_ACTION_NAME
1127: , ea.DESCRIPTION
1128: , missingvalues.LOAN_TYPE_ID

Line 1148: from lns_event_actions ea, lns_events ev,

1144: , LNS_UTILITY_PUB.CREATED_BY
1145: , sysdate
1146: , LNS_UTILITY_PUB.LAST_UPDATED_BY
1147: , LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
1148: from lns_event_actions ea, lns_events ev,
1149: (select loan_class_code, loan_type_id
1150: from lns_loan_types_vl
1151: minus
1152: select ev.loan_class_code loan_class_code, ea.loan_type_id loan_type_id

Line 1153: from lns_events ev, lns_event_actions ea

1149: (select loan_class_code, loan_type_id
1150: from lns_loan_types_vl
1151: minus
1152: select ev.loan_class_code loan_class_code, ea.loan_type_id loan_type_id
1153: from lns_events ev, lns_event_actions ea
1154: where ea.event_id = ev.event_id
1155: and ea.event_action_name = 'NOTIFICATION') missingvalues
1156: where ev.loan_class_code = missingvalues.loan_class_code
1157: and ea.event_id = ev.event_id