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 163: l_amount ar_cmgt_cf_recommends.recommendation_value2%type;

159:
160: /* Added for Bug 10083461 */
161: FUNCTION unformat_amount(p_amount IN VARCHAR2)
162: RETURN VARCHAR2 IS
163: l_amount ar_cmgt_cf_recommends.recommendation_value2%type;
164: l_index_pos1 NUMBER;
165: l_index_pos2 NUMBER;
166: BEGIN
167: l_amount := p_amount;

Line 1753: l_trx_credit_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;

1749:
1750: l_manual_analysis_flag VARCHAR2(1);
1751:
1752: -- Fix for Bug 8792071 - Start
1753: l_trx_credit_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
1754: l_cred_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
1755: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;
1756:
1757: CURSOR c_get_cf_reco_info1 IS

Line 1754: l_cred_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;

1750: l_manual_analysis_flag VARCHAR2(1);
1751:
1752: -- Fix for Bug 8792071 - Start
1753: l_trx_credit_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
1754: l_cred_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
1755: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;
1756:
1757: CURSOR c_get_cf_reco_info1 IS
1758: SELECT recommendation_value2

Line 1755: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;

1751:
1752: -- Fix for Bug 8792071 - Start
1753: l_trx_credit_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
1754: l_cred_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
1755: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;
1756:
1757: CURSOR c_get_cf_reco_info1 IS
1758: SELECT recommendation_value2
1759: FROM ar_cmgt_cf_recommends

Line 1759: FROM ar_cmgt_cf_recommends

1755: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;
1756:
1757: CURSOR c_get_cf_reco_info1 IS
1758: SELECT recommendation_value2
1759: FROM ar_cmgt_cf_recommends
1760: WHERE credit_recommendation = 'CREDIT_LIMIT'
1761: AND credit_request_id = itemkey;
1762:
1763: CURSOR c_get_cf_reco_info2 IS

Line 1765: FROM ar_cmgt_cf_recommends

1761: AND credit_request_id = itemkey;
1762:
1763: CURSOR c_get_cf_reco_info2 IS
1764: SELECT recommendation_value2
1765: FROM ar_cmgt_cf_recommends
1766: WHERE credit_recommendation = 'TXN_CREDIT_LIMIT'
1767: AND credit_request_id = itemkey;
1768: -- Fix for Bug 8792071 - End
1769:

Line 2543: l_trx_credit_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;

2539:
2540: l_skip_approval VARCHAR2(1);
2541:
2542: -- Fix for Bug 8792071 - Start
2543: l_trx_credit_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
2544: l_cred_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
2545: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;
2546:
2547: CURSOR c_get_cf_reco_info1 IS

Line 2544: l_cred_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;

2540: l_skip_approval VARCHAR2(1);
2541:
2542: -- Fix for Bug 8792071 - Start
2543: l_trx_credit_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
2544: l_cred_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
2545: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;
2546:
2547: CURSOR c_get_cf_reco_info1 IS
2548: SELECT recommendation_value2

Line 2545: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;

2541:
2542: -- Fix for Bug 8792071 - Start
2543: l_trx_credit_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
2544: l_cred_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
2545: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;
2546:
2547: CURSOR c_get_cf_reco_info1 IS
2548: SELECT recommendation_value2
2549: FROM ar_cmgt_cf_recommends

Line 2549: FROM ar_cmgt_cf_recommends

2545: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;
2546:
2547: CURSOR c_get_cf_reco_info1 IS
2548: SELECT recommendation_value2
2549: FROM ar_cmgt_cf_recommends
2550: WHERE credit_recommendation = 'CREDIT_LIMIT'
2551: AND credit_request_id = itemkey;
2552:
2553: CURSOR c_get_cf_reco_info2 IS

Line 2555: FROM ar_cmgt_cf_recommends

2551: AND credit_request_id = itemkey;
2552:
2553: CURSOR c_get_cf_reco_info2 IS
2554: SELECT recommendation_value2
2555: FROM ar_cmgt_cf_recommends
2556: WHERE credit_recommendation = 'TXN_CREDIT_LIMIT'
2557: AND credit_request_id = itemkey;
2558: -- Fix for Bug 8792071 - End
2559:

Line 2954: 'Error while inserting into ar_cmgt_cf_recommends',

2950: EXCEPTION
2951: WHEN insert_failure THEN
2952: wf_core.context('AR_CMGT_WF_ENGINE','GENERATE_RECOMMENDATION',itemtype,
2953: itemkey,
2954: 'Error while inserting into ar_cmgt_cf_recommends',
2955: sqlerrm);
2956: raise;
2957: END;
2958:

Line 3052: l_trx_credit_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;

3048: l_case_folder_id number;
3049: l_approver_id number;
3050:
3051: -- Fix for Bug 8792071 - Start
3052: l_trx_credit_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3053: l_cred_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3054: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3055:
3056: CURSOR c_get_cf_reco_info1 IS

Line 3053: l_cred_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;

3049: l_approver_id number;
3050:
3051: -- Fix for Bug 8792071 - Start
3052: l_trx_credit_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3053: l_cred_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3054: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3055:
3056: CURSOR c_get_cf_reco_info1 IS
3057: SELECT recommendation_value2

Line 3054: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;

3050:
3051: -- Fix for Bug 8792071 - Start
3052: l_trx_credit_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3053: l_cred_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3054: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3055:
3056: CURSOR c_get_cf_reco_info1 IS
3057: SELECT recommendation_value2
3058: FROM ar_cmgt_cf_recommends

Line 3058: FROM ar_cmgt_cf_recommends

3054: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3055:
3056: CURSOR c_get_cf_reco_info1 IS
3057: SELECT recommendation_value2
3058: FROM ar_cmgt_cf_recommends
3059: WHERE credit_recommendation = 'CREDIT_LIMIT'
3060: AND credit_request_id = itemkey;
3061:
3062: CURSOR c_get_cf_reco_info2 IS

Line 3064: FROM ar_cmgt_cf_recommends

3060: AND credit_request_id = itemkey;
3061:
3062: CURSOR c_get_cf_reco_info2 IS
3063: SELECT recommendation_value2
3064: FROM ar_cmgt_cf_recommends
3065: WHERE credit_recommendation = 'TXN_CREDIT_LIMIT'
3066: AND credit_request_id = itemkey;
3067: -- Fix for Bug 8792071 - End
3068:

Line 3144: Update ar_cmgt_cf_recommends

3140: transactionIdIn => l_case_folder_id,
3141: approvalStatusIn => AME_UTIL.rejectStatus,
3142: approverPersonIdIn => l_approver_id,
3143: transactionTypeIn => 'ARCMGTAP');
3144: Update ar_cmgt_cf_recommends
3145: set status = 'R',
3146: last_update_date = sysdate,
3147: last_updated_by = fnd_global.user_id,
3148: last_update_login = fnd_global.login_id

Line 3184: l_reco_id ar_cmgt_cf_recommends.RECOMMENDATION_ID%TYPE;

3180: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
3181: l_error_msg VARCHAR2(2000);
3182: l_return_status VARCHAR2(1);
3183: HOLD_ERROR EXCEPTION;
3184: l_reco_id ar_cmgt_cf_recommends.RECOMMENDATION_ID%TYPE;
3185: l_dayz ar_cmgt_cf_recommends.RECOMMENDATION_VALUE1%TYPE;
3186: no_data_found EXCEPTION;
3187: l_last_revw_date hz_customer_profiles.LAST_CREDIT_REVIEW_DATE%TYPE;
3188: l_entity_code VARCHAR2(1);

Line 3185: l_dayz ar_cmgt_cf_recommends.RECOMMENDATION_VALUE1%TYPE;

3181: l_error_msg VARCHAR2(2000);
3182: l_return_status VARCHAR2(1);
3183: HOLD_ERROR EXCEPTION;
3184: l_reco_id ar_cmgt_cf_recommends.RECOMMENDATION_ID%TYPE;
3185: l_dayz ar_cmgt_cf_recommends.RECOMMENDATION_VALUE1%TYPE;
3186: no_data_found EXCEPTION;
3187: l_last_revw_date hz_customer_profiles.LAST_CREDIT_REVIEW_DATE%TYPE;
3188: l_entity_code VARCHAR2(1);
3189: l_entity_id NUMBER;

Line 3195: FROM ar_cmgt_cf_recommends

3191:
3192: CURSOR c_reco IS
3193: SELECT credit_recommendation, recommendation_value1,
3194: recommendation_value2
3195: FROM ar_cmgt_cf_recommends
3196: WHERE case_folder_id = l_case_folder_id
3197: AND credit_type = l_credit_type;
3198:
3199: l_amount ar_cmgt_cf_recommends.RECOMMENDATION_VALUE2%TYPE;

Line 3199: l_amount ar_cmgt_cf_recommends.RECOMMENDATION_VALUE2%TYPE;

3195: FROM ar_cmgt_cf_recommends
3196: WHERE case_folder_id = l_case_folder_id
3197: AND credit_type = l_credit_type;
3198:
3199: l_amount ar_cmgt_cf_recommends.RECOMMENDATION_VALUE2%TYPE;
3200: BEGIN
3201: IF pg_wf_debug = 'Y'
3202: THEN
3203: debug('ar_cmgt_wf_engine.implement_recommendation()+');

Line 3350: FROM ar_cmgt_cf_recommends

3346: BEGIN
3347:
3348: SELECT recommendation_value1,RECOMMENDATION_ID
3349: INTO l_dayz,l_reco_id
3350: FROM ar_cmgt_cf_recommends
3351: WHERE CASE_FOLDER_ID = l_case_folder_id
3352: AND credit_recommendation = 'AUTHORIZE_APPEAL';
3353:
3354:

Line 3374: --update number of days in ar_cmgt_cf_recommends

3370:
3371: END;
3372:
3373:
3374: --update number of days in ar_cmgt_cf_recommends
3375:
3376: UPDATE AR_CMGT_CF_RECOMMENDS
3377: SET RECOMMENDATION_VALUE2 = fnd_date.DATE_TO_CANONICAL(trunc(sysdate) + to_number(trunc(l_dayz))),
3378: last_update_date = sysdate,

Line 3376: UPDATE AR_CMGT_CF_RECOMMENDS

3372:
3373:
3374: --update number of days in ar_cmgt_cf_recommends
3375:
3376: UPDATE AR_CMGT_CF_RECOMMENDS
3377: SET RECOMMENDATION_VALUE2 = fnd_date.DATE_TO_CANONICAL(trunc(sysdate) + to_number(trunc(l_dayz))),
3378: last_update_date = sysdate,
3379: last_updated_by = fnd_global.user_id,
3380: last_update_login = fnd_global.login_id

Line 3431: Update ar_cmgt_cf_recommends

3427: END IF;
3428:
3429: END LOOP;
3430:
3431: Update ar_cmgt_cf_recommends
3432: set status = 'I',
3433: last_update_date = sysdate,
3434: last_updated_by = fnd_global.user_id,
3435: last_update_login = fnd_global.login_id

Line 3484: l_trx_credit_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;

3480: l_resultout VARCHAR2(1);
3481: l_parent_credit_request_id NUMBER;
3482:
3483: -- Fix for Bug 8660531 - Start
3484: l_trx_credit_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3485: l_cred_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3486: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3487:
3488: CURSOR c_get_cf_reco_info1 IS

Line 3485: l_cred_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;

3481: l_parent_credit_request_id NUMBER;
3482:
3483: -- Fix for Bug 8660531 - Start
3484: l_trx_credit_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3485: l_cred_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3486: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3487:
3488: CURSOR c_get_cf_reco_info1 IS
3489: SELECT recommendation_value2

Line 3486: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;

3482:
3483: -- Fix for Bug 8660531 - Start
3484: l_trx_credit_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3485: l_cred_limit ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3486: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3487:
3488: CURSOR c_get_cf_reco_info1 IS
3489: SELECT recommendation_value2
3490: FROM ar_cmgt_cf_recommends

Line 3490: FROM ar_cmgt_cf_recommends

3486: l_amount_requested ar_cmgt_cf_recommends.recommendation_value2%TYPE;
3487:
3488: CURSOR c_get_cf_reco_info1 IS
3489: SELECT recommendation_value2
3490: FROM ar_cmgt_cf_recommends
3491: WHERE credit_recommendation = 'CREDIT_LIMIT'
3492: AND credit_request_id = itemkey;
3493:
3494: CURSOR c_get_cf_reco_info2 IS

Line 3496: FROM ar_cmgt_cf_recommends

3492: AND credit_request_id = itemkey;
3493:
3494: CURSOR c_get_cf_reco_info2 IS
3495: SELECT recommendation_value2
3496: FROM ar_cmgt_cf_recommends
3497: WHERE credit_recommendation = 'TXN_CREDIT_LIMIT'
3498: AND credit_request_id = itemkey;
3499: -- Fix for Bug 8660531 - End
3500:

Line 3626: l_reco_name ar_cmgt_cf_recommends.CREDIT_RECOMMENDATION%type;

3622: funcmode in varchar2,
3623: resultout out NOCOPY varchar2) IS
3624:
3625: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3626: l_reco_name ar_cmgt_cf_recommends.CREDIT_RECOMMENDATION%type;
3627: l_dayz AR_CMGT_SETUP_OPTIONS.CER_DSO_DAYS%TYPE;
3628: l_reco_id ar_cmgt_cf_recommends.RECOMMENDATION_ID%TYPE;
3629: CURSOR reco_check IS
3630: SELECT CREDIT_RECOMMENDATION,RECOMMENDATION_ID

Line 3628: l_reco_id ar_cmgt_cf_recommends.RECOMMENDATION_ID%TYPE;

3624:
3625: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3626: l_reco_name ar_cmgt_cf_recommends.CREDIT_RECOMMENDATION%type;
3627: l_dayz AR_CMGT_SETUP_OPTIONS.CER_DSO_DAYS%TYPE;
3628: l_reco_id ar_cmgt_cf_recommends.RECOMMENDATION_ID%TYPE;
3629: CURSOR reco_check IS
3630: SELECT CREDIT_RECOMMENDATION,RECOMMENDATION_ID
3631: FROM AR_CMGT_CF_RECOMMENDS
3632: WHERE CREDIT_REQUEST_ID = itemkey;

Line 3631: FROM AR_CMGT_CF_RECOMMENDS

3627: l_dayz AR_CMGT_SETUP_OPTIONS.CER_DSO_DAYS%TYPE;
3628: l_reco_id ar_cmgt_cf_recommends.RECOMMENDATION_ID%TYPE;
3629: CURSOR reco_check IS
3630: SELECT CREDIT_RECOMMENDATION,RECOMMENDATION_ID
3631: FROM AR_CMGT_CF_RECOMMENDS
3632: WHERE CREDIT_REQUEST_ID = itemkey;
3633: BEGIN
3634:
3635: select case_folder_id

Line 3879: FROM ar_cmgt_cf_recommends

3875: UNEXP_ERROR EXCEPTION;
3876: --this will check if recommendations exists or not.
3877: CURSOR CHECK_RECO_EXISTS IS
3878: SELECT 'Y'
3879: FROM ar_cmgt_cf_recommends
3880: WHERE CASE_FOLDER_ID=l_case_folder_id;
3881:
3882: BEGIN
3883: IF funcmode = 'RUN'

Line 3942: FROM ar_cmgt_cf_recommends cf, ar_cmgt_credit_requests req

3938: -- do the next validations
3939: BEGIN
3940: SELECT 'X'
3941: INTO l_flag
3942: FROM ar_cmgt_cf_recommends cf, ar_cmgt_credit_requests req
3943: WHERE req.credit_request_id = itemkey
3944: AND req.credit_request_id = cf.credit_request_id
3945: AND req.cust_account_id = -99
3946: AND req.site_use_id = -99

Line 4279: --populate ar_cmgt_cf_recommends

4275:
4276: raise l_other_data;
4277: END IF;
4278:
4279: --populate ar_cmgt_cf_recommends
4280:
4281: AR_CMGT_CONTROLS.DUPLICATE_RECO_DATA(
4282: p_parnt_case_folder_id => to_number(l_parent_cf_id),
4283: p_credit_request_id => to_number(itemkey),