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.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_CF_RECOMMENDS

Line 2580: 'Error while inserting into ar_cmgt_cf_recommends',

2576: EXCEPTION
2577: WHEN insert_failure THEN
2578: wf_core.context('AR_CMGT_WF_ENGINE','GENERATE_RECOMMENDATION',itemtype,
2579: itemkey,
2580: 'Error while inserting into ar_cmgt_cf_recommends',
2581: sqlerrm);
2582: raise;
2583: END;
2584:

Line 2728: Update ar_cmgt_cf_recommends

2724: transactionIdIn => l_case_folder_id,
2725: approvalStatusIn => AME_UTIL.rejectStatus,
2726: approverPersonIdIn => l_approver_id,
2727: transactionTypeIn => 'ARCMGTAP');
2728: Update ar_cmgt_cf_recommends
2729: set status = 'R',
2730: last_update_date = sysdate,
2731: last_updated_by = fnd_global.user_id,
2732: last_update_login = fnd_global.login_id

Line 2768: l_reco_id ar_cmgt_cf_recommends.RECOMMENDATION_ID%TYPE;

2764: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
2765: l_error_msg VARCHAR2(2000);
2766: l_return_status VARCHAR2(1);
2767: HOLD_ERROR EXCEPTION;
2768: l_reco_id ar_cmgt_cf_recommends.RECOMMENDATION_ID%TYPE;
2769: l_dayz ar_cmgt_cf_recommends.RECOMMENDATION_VALUE1%TYPE;
2770: no_data_found EXCEPTION;
2771: l_last_revw_date hz_customer_profiles.LAST_CREDIT_REVIEW_DATE%TYPE;
2772:

Line 2769: l_dayz ar_cmgt_cf_recommends.RECOMMENDATION_VALUE1%TYPE;

2765: l_error_msg VARCHAR2(2000);
2766: l_return_status VARCHAR2(1);
2767: HOLD_ERROR EXCEPTION;
2768: l_reco_id ar_cmgt_cf_recommends.RECOMMENDATION_ID%TYPE;
2769: l_dayz ar_cmgt_cf_recommends.RECOMMENDATION_VALUE1%TYPE;
2770: no_data_found EXCEPTION;
2771: l_last_revw_date hz_customer_profiles.LAST_CREDIT_REVIEW_DATE%TYPE;
2772:
2773: CURSOR c_reco IS

Line 2776: FROM ar_cmgt_cf_recommends

2772:
2773: CURSOR c_reco IS
2774: SELECT credit_recommendation, recommendation_value1,
2775: recommendation_value2
2776: FROM ar_cmgt_cf_recommends
2777: WHERE case_folder_id = l_case_folder_id
2778: AND credit_type = l_credit_type;
2779: BEGIN
2780: IF funcmode = 'RUN'

Line 2865: FROM ar_cmgt_cf_recommends

2861: BEGIN
2862:
2863: SELECT recommendation_value1,RECOMMENDATION_ID
2864: INTO l_dayz,l_reco_id
2865: FROM ar_cmgt_cf_recommends
2866: WHERE CASE_FOLDER_ID = l_case_folder_id
2867: AND credit_recommendation = 'AUTHORIZE_APPEAL';
2868:
2869:

Line 2889: --update number of days in ar_cmgt_cf_recommends

2885:
2886: END;
2887:
2888:
2889: --update number of days in ar_cmgt_cf_recommends
2890:
2891: UPDATE AR_CMGT_CF_RECOMMENDS
2892: SET RECOMMENDATION_VALUE2 = fnd_date.DATE_TO_CANONICAL(trunc(sysdate) + to_number(trunc(l_dayz))),
2893: last_update_date = sysdate,

Line 2891: UPDATE AR_CMGT_CF_RECOMMENDS

2887:
2888:
2889: --update number of days in ar_cmgt_cf_recommends
2890:
2891: UPDATE AR_CMGT_CF_RECOMMENDS
2892: SET RECOMMENDATION_VALUE2 = fnd_date.DATE_TO_CANONICAL(trunc(sysdate) + to_number(trunc(l_dayz))),
2893: last_update_date = sysdate,
2894: last_updated_by = fnd_global.user_id,
2895: last_update_login = fnd_global.login_id

Line 3051: Update ar_cmgt_cf_recommends

3047: END IF;
3048:
3049: END LOOP;
3050:
3051: Update ar_cmgt_cf_recommends
3052: set status = 'I',
3053: last_update_date = sysdate,
3054: last_updated_by = fnd_global.user_id,
3055: last_update_login = fnd_global.login_id

Line 3196: l_reco_name ar_cmgt_cf_recommends.CREDIT_RECOMMENDATION%type;

3192: funcmode in varchar2,
3193: resultout out NOCOPY varchar2) IS
3194:
3195: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3196: l_reco_name ar_cmgt_cf_recommends.CREDIT_RECOMMENDATION%type;
3197: l_dayz AR_CMGT_SETUP_OPTIONS.CER_DSO_DAYS%TYPE;
3198: l_reco_id ar_cmgt_cf_recommends.RECOMMENDATION_ID%TYPE;
3199: CURSOR reco_check IS
3200: SELECT CREDIT_RECOMMENDATION,RECOMMENDATION_ID

Line 3198: l_reco_id ar_cmgt_cf_recommends.RECOMMENDATION_ID%TYPE;

3194:
3195: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3196: l_reco_name ar_cmgt_cf_recommends.CREDIT_RECOMMENDATION%type;
3197: l_dayz AR_CMGT_SETUP_OPTIONS.CER_DSO_DAYS%TYPE;
3198: l_reco_id ar_cmgt_cf_recommends.RECOMMENDATION_ID%TYPE;
3199: CURSOR reco_check IS
3200: SELECT CREDIT_RECOMMENDATION,RECOMMENDATION_ID
3201: FROM AR_CMGT_CF_RECOMMENDS
3202: WHERE CREDIT_REQUEST_ID = itemkey;

Line 3201: FROM AR_CMGT_CF_RECOMMENDS

3197: l_dayz AR_CMGT_SETUP_OPTIONS.CER_DSO_DAYS%TYPE;
3198: l_reco_id ar_cmgt_cf_recommends.RECOMMENDATION_ID%TYPE;
3199: CURSOR reco_check IS
3200: SELECT CREDIT_RECOMMENDATION,RECOMMENDATION_ID
3201: FROM AR_CMGT_CF_RECOMMENDS
3202: WHERE CREDIT_REQUEST_ID = itemkey;
3203: BEGIN
3204:
3205: select case_folder_id

Line 3371: FROM ar_cmgt_cf_recommends

3367: UNEXP_ERROR EXCEPTION;
3368: --this will check if recommendations exists or not.
3369: CURSOR CHECK_RECO_EXISTS IS
3370: SELECT 'Y'
3371: FROM ar_cmgt_cf_recommends
3372: WHERE CASE_FOLDER_ID=l_case_folder_id;
3373:
3374: BEGIN
3375: IF funcmode = 'RUN'

Line 3434: FROM ar_cmgt_cf_recommends cf, ar_cmgt_credit_requests req

3430: -- do the next validations
3431: BEGIN
3432: SELECT 'X'
3433: INTO l_flag
3434: FROM ar_cmgt_cf_recommends cf, ar_cmgt_credit_requests req
3435: WHERE req.credit_request_id = itemkey
3436: AND req.credit_request_id = cf.credit_request_id
3437: AND req.cust_account_id = -99
3438: AND req.site_use_id = -99

Line 3771: --populate ar_cmgt_cf_recommends

3767:
3768: raise l_other_data;
3769: END IF;
3770:
3771: --populate ar_cmgt_cf_recommends
3772:
3773: AR_CMGT_CONTROLS.DUPLICATE_RECO_DATA(
3774: p_parnt_case_folder_id => to_number(l_parent_cf_id),
3775: p_credit_request_id => to_number(itemkey),