DBA Data[Home] [Help]

APPS.LNS_WORK_FLOW dependencies on FND_PROFILE_OPTION_VALUES

Line 2114: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;

2110: l_msg_index_out NUMBER;
2111: l_org_id NUMBER;
2112: l_approver_user_name VARCHAR2(320);
2113: approverRecord ame_util.approverRecord2;
2114: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;
2115: l_IS_AME_INSTALLED fnd_profile_option_values.profile_option_value%TYPE;
2116:
2117: BEGIN
2118: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' +');

Line 2115: l_IS_AME_INSTALLED fnd_profile_option_values.profile_option_value%TYPE;

2111: l_org_id NUMBER;
2112: l_approver_user_name VARCHAR2(320);
2113: approverRecord ame_util.approverRecord2;
2114: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;
2115: l_IS_AME_INSTALLED fnd_profile_option_values.profile_option_value%TYPE;
2116:
2117: BEGIN
2118: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME || '.' || l_api_name || ' +');
2119:

Line 2352: l_loan_approval_from_ntf fnd_profile_option_values.profile_option_value%TYPE;

2348: actid in number,
2349: funcmode in varchar2,
2350: resultout out NOCOPY varchar2 ) IS
2351:
2352: l_loan_approval_from_ntf fnd_profile_option_values.profile_option_value%TYPE;
2353: BEGIN
2354: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.APPROVE_LOAN_FROM_NTF' || ' +');
2355:
2356: IF (funcmode <> wf_engine.eng_run) THEN

Line 2640: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;

2636:
2637: l_next_approver ame_util.approverrecord;
2638: l_error_message fnd_new_messages.message_text%TYPE;
2639: l_approver_user_name VARCHAR2(320);
2640: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;
2641:
2642:
2643: BEGIN
2644: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || 'LNS_WORK_FLOW.AME_FIND_PRIMARY_APPROVER' || ' +');

Line 2749: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;

2745: l_approver_user_name VARCHAR2(320);
2746: approverRecord ame_util.approverRecord2;
2747: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
2748: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_APPROVAL_STATUS_TO_AME';
2749: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;
2750: l_loan_approve_note VARCHAR2(2000);
2751:
2752: BEGIN
2753:

Line 2857: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;

2853: l_approver_user_name VARCHAR2(320);
2854: approverRecord ame_util.approverRecord2;
2855: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
2856: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_REJECTED_STATUS_TO_AME';
2857: l_transaction_type fnd_profile_option_values.profile_option_value%TYPE;
2858:
2859: BEGIN
2860:
2861: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

Line 2941: l_loan_approval_using_ame fnd_profile_option_values.profile_option_value%TYPE;

2937: actid in number,
2938: funcmode in varchar2,
2939: resultout out NOCOPY varchar2 ) IS
2940:
2941: l_loan_approval_using_ame fnd_profile_option_values.profile_option_value%TYPE;
2942: l_api_name CONSTANT VARCHAR2(30) := 'APPROVE_LOAN_USING_AME';
2943: BEGIN
2944: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
2945: