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_CASE_FOLDERS

Line 41: ar_cmgt_case_folders cf

37: cr.source_resp_appln_id,
38: cr.source_security_group_id,
39: cr.source_org_id
40: FROM ar_cmgt_credit_requests cr,
41: ar_cmgt_case_folders cf
42: WHERE case_folder_id = p_cf_id
43: and cr.credit_request_id = cf.credit_request_id;
44:
45: BEGIN

Line 317: FROM ar_cmgt_case_folders

313: THEN
314: BEGIN
315: SELECT check_list_id
316: INTO l_check_list_id
317: FROM ar_cmgt_case_folders
318: WHERE case_folder_id = p_case_folder_id
319: AND type = 'CASE';
320:
321: EXCEPTION

Line 521: UPDATE ar_cmgt_case_folders

517: last_update_login = fnd_global.login_id
518: WHERE credit_request_id = itemkey
519: AND credit_analyst_id IS NULL;
520:
521: UPDATE ar_cmgt_case_folders
522: set credit_analyst_id = l_resource_id,
523: last_updated = sysdate,
524: last_update_date = sysdate,
525: last_updated_by = fnd_global.user_id,

Line 714: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

710: resultout out NOCOPY varchar2) IS
711:
712: l_user_name VARCHAR2(60);
713: l_display_name VARCHAR2(240);
714: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
715: l_credit_analyst_id ar_cmgt_credit_requests.credit_analyst_id%type;
716: l_employee_id per_people_f.person_id%type;
717: l_dummy VARCHAR2(1);
718: BEGIN

Line 832: update ar_cmgt_case_folders

828: itemKey => itemkey,
829: aname => 'CASE_FOLDER_ID');
830: IF l_case_folder_id IS NOT NULL
831: THEN
832: update ar_cmgt_case_folders
833: set credit_analyst_id = l_credit_analyst_id,
834: last_updated = sysdate,
835: last_update_date = sysdate,
836: last_updated_by = fnd_global.user_id,

Line 841: update ar_cmgt_case_folders

837: last_update_login = fnd_global.login_id
838: WHERE case_folder_id = l_case_folder_id;
839:
840: -- Also upadate data records with credit_analyst_id
841: update ar_cmgt_case_folders
842: set credit_analyst_id = l_credit_analyst_id,
843: last_updated = sysdate,
844: last_update_date = sysdate,
845: last_updated_by = fnd_global.user_id,

Line 1044: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

1040: actid in number,
1041: funcmode in varchar2,
1042: resultout out NOCOPY varchar2) IS
1043:
1044: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
1045: BEGIN
1046:
1047: IF funcmode = 'RUN'
1048: THEN

Line 1055: UPDATE ar_cmgt_case_folders

1051: (itemtype => itemtype,
1052: itemkey => itemkey,
1053: aname => 'CASE_FOLDER_ID');
1054:
1055: UPDATE ar_cmgt_case_folders
1056: SET status = 'SUBMITTED',
1057: last_updated = sysdate,
1058: last_update_date = sysdate,
1059: last_updated_by = fnd_global.user_id,

Line 1158: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;

1154: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1155: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
1156: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
1157: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
1158: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
1159: l_source_name ar_cmgt_credit_requests.source_name%type;
1160: l_classification_meaning ar_lookups.meaning%type;
1161: l_review_type_meaning ar_lookups.meaning%type;
1162: l_application_number ar_cmgt_credit_requests.application_number%type;

Line 1661: delete ar_cmgt_case_folders

1657: l_case_folder_id := WF_ENGINE.getItemAttrText
1658: (itemtype => itemtype,
1659: itemkey => itemkey,
1660: aname => 'CASE_FOLDER_ID');
1661: delete ar_cmgt_case_folders
1662: WHERE case_folder_id = case_folder_id;
1663: delete ar_cmgt_cf_dtls
1664: WHERE case_folder_id = case_folder_id;
1665: END IF;

Line 1691: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;

1687: l_cust_acct_site_id ar_cmgt_credit_requests.cust_acct_site_id%type;
1688: l_request_id ar_cmgt_credit_requests.credit_request_id%type;
1689: l_trx_currency ar_cmgt_credit_requests.trx_currency%type;
1690: l_limit_currency ar_cmgt_credit_requests.limit_currency%type;
1691: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
1692: l_org_id NUMBER ;
1693: l_score_model_id NUMBER;
1694: l_credit_request_id NUMBER;
1695: l_case_folder_id NUMBER;

Line 1699: l_case_folder_date ar_cmgt_case_folders.last_updated%type;

1695: l_case_folder_id NUMBER;
1696: l_resultout VARCHAR2(200);
1697: BUILD_FAILURE EXCEPTION;
1698: l_error_message VARCHAR2(2000);
1699: l_case_folder_date ar_cmgt_case_folders.last_updated%type;
1700:
1701: BEGIN
1702: IF funcmode = 'RUN'
1703: THEN

Line 1791: FROM ar_cmgt_case_folders

1787: -- Get case folder details
1788: BEGIN
1789: SELECT case_folder_number, last_updated
1790: INTO l_case_folder_number, l_case_folder_date
1791: FROM ar_cmgt_case_folders
1792: WHERE case_folder_id = l_case_folder_id;
1793:
1794: WF_ENGINE.setItemAttrText
1795: (itemtype => itemtype,

Line 1828: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;

1824: actid in number,
1825: funcmode in varchar2,
1826: resultout out NOCOPY varchar2) IS
1827:
1828: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
1829: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1830: l_score NUMBER;
1831: l_resultout VARCHAR2(1);
1832: l_debug_msg VARCHAR2(2000);

Line 2735: Update ar_cmgt_case_folders

2731: last_updated_by = fnd_global.user_id,
2732: last_update_login = fnd_global.login_id
2733: WHERE case_folder_id = l_case_folder_id;
2734:
2735: Update ar_cmgt_case_folders
2736: set status = 'CLOSED',
2737: last_updated = sysdate,
2738: last_update_date = sysdate,
2739: last_updated_by = fnd_global.user_id,

Line 2760: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

2756: actid in number,
2757: funcmode in varchar2,
2758: resultout out NOCOPY varchar2) IS
2759:
2760: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
2761: l_credit_type ar_cmgt_credit_requests.credit_type%type;
2762: l_party_id ar_cmgt_credit_requests.party_id%type;
2763: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
2764: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;

Line 3058: Update ar_cmgt_case_folders

3054: last_updated_by = fnd_global.user_id,
3055: last_update_login = fnd_global.login_id
3056: WHERE case_folder_id = l_case_folder_id;
3057:
3058: Update ar_cmgt_case_folders
3059: set status = 'CLOSED',
3060: last_updated = sysdate,
3061: last_update_date = sysdate,
3062: last_updated_by = fnd_global.user_id,

Line 3085: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

3081: actid in number,
3082: funcmode in varchar2,
3083: resultout out NOCOPY varchar2) IS
3084:
3085: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3086: l_party_id ar_cmgt_credit_requests.party_id%type;
3087: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
3088: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
3089: l_credit_limit NUMBER := 0;

Line 3092: l_limit_currency ar_cmgt_case_folders.limit_currency%type;

3088: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
3089: l_credit_limit NUMBER := 0;
3090: l_exposure NUMBER;
3091: l_risk_factor NUMBER;
3092: l_limit_currency ar_cmgt_case_folders.limit_currency%type;
3093: l_errmsg VARCHAR2(2000);
3094: l_resultout VARCHAR2(1);
3095: l_parent_credit_request_id NUMBER;
3096:

Line 3195: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

3191: actid in number,
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

Line 3207: FROM ar_cmgt_case_folders

3203: BEGIN
3204:
3205: select case_folder_id
3206: INTO l_case_folder_id
3207: FROM ar_cmgt_case_folders
3208: WHERE credit_request_id = itemkey
3209: and type = 'CASE';
3210:
3211: raise_recco_event(l_case_folder_id);

Line 3255: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

3251: actid in number,
3252: funcmode in varchar2,
3253: resultout out NOCOPY varchar2) IS
3254:
3255: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3256: BEGIN
3257: l_case_folder_id := WF_ENGINE.GetItemAttrNumber
3258: (itemtype => itemtype,
3259: itemkey => itemkey,

Line 3262: UPDATE ar_cmgt_case_folders

3258: (itemtype => itemtype,
3259: itemkey => itemkey,
3260: aname => 'CASE_FOLDER_ID');
3261:
3262: UPDATE ar_cmgt_case_folders
3263: set status = 'CREATED',
3264: last_updated = sysdate,
3265: last_update_date = sysdate,
3266: last_updated_by = fnd_global.user_id,

Line 3326: l_status ar_cmgt_case_folders.status%type;

3322: resultout out NOCOPY varchar2) IS
3323:
3324: l_credit_request_id ar_cmgt_credit_requests.credit_request_id%type;
3325: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
3326: l_status ar_cmgt_case_folders.status%type;
3327:
3328: BEGIN
3329: IF funcmode = 'RUN'
3330: THEN

Line 3363: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;

3359: actid in number,
3360: funcmode in varchar2,
3361: resultout out NOCOPY varchar2) IS
3362:
3363: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
3364: l_reco_exist VARCHAR2(1) := 'N';
3365: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
3366: l_flag varchar2(1);
3367: UNEXP_ERROR EXCEPTION;

Line 3526: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

3522: l_processng_flag VARCHAR2(1);
3523: l_case_rec_num NUMBER;
3524: l_credit_type ar_cmgt_credit_requests.credit_type%type;
3525: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
3526: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3527: l_parent_cf_id ar_cmgt_case_folders.case_folder_id%type;
3528: l_parent_creq_id ar_cmgt_credit_requests.parent_credit_request_id%type;
3529: insert_failure EXCEPTION;
3530: l_cf_id ar_cmgt_case_folders.case_folder_id%type;

Line 3527: l_parent_cf_id ar_cmgt_case_folders.case_folder_id%type;

3523: l_case_rec_num NUMBER;
3524: l_credit_type ar_cmgt_credit_requests.credit_type%type;
3525: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
3526: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3527: l_parent_cf_id ar_cmgt_case_folders.case_folder_id%type;
3528: l_parent_creq_id ar_cmgt_credit_requests.parent_credit_request_id%type;
3529: insert_failure EXCEPTION;
3530: l_cf_id ar_cmgt_case_folders.case_folder_id%type;
3531: populate_failure EXCEPTION;

Line 3530: l_cf_id ar_cmgt_case_folders.case_folder_id%type;

3526: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3527: l_parent_cf_id ar_cmgt_case_folders.case_folder_id%type;
3528: l_parent_creq_id ar_cmgt_credit_requests.parent_credit_request_id%type;
3529: insert_failure EXCEPTION;
3530: l_cf_id ar_cmgt_case_folders.case_folder_id%type;
3531: populate_failure EXCEPTION;
3532:
3533:
3534: BEGIN

Line 3602: FROM AR_CMGT_CASE_FOLDERS

3598: BEGIN
3599:
3600: SELECT CASE_FOLDER_ID
3601: INTO l_parent_cf_id
3602: FROM AR_CMGT_CASE_FOLDERS
3603: WHERE CREDIT_REQUEST_ID = l_parent_creq_id
3604: and type = 'CASE';
3605:
3606: EXCEPTION

Line 3609: 'Error while getting parent records from AR_CMGT_CASE_FOLDERS',

3605:
3606: EXCEPTION
3607: WHEN OTHERS THEN
3608: wf_core.context ('AR_CMGT_WF_ENGINE','APPEAL_RESUB_DECISION',itemtype,itemkey,
3609: 'Error while getting parent records from AR_CMGT_CASE_FOLDERS',
3610: 'Sql Error: '||sqlerrm);
3611: raise;
3612: END;
3613:

Line 3813: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;

3809: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
3810: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
3811: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
3812: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
3813: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
3814: l_source_name ar_cmgt_credit_requests.source_name%type;
3815: l_classification_meaning ar_lookups.meaning%type;
3816: l_review_type_meaning ar_lookups.meaning%type;
3817: l_application_number ar_cmgt_credit_requests.application_number%type;

Line 3832: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;

3828: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
3829: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
3830: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
3831: l_notes ar_cmgt_credit_requests.notes%type;
3832: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
3833: l_limit_currency ar_cmgt_case_folders.limit_currency%TYPE;
3834: l_creation_date_time ar_cmgt_case_folders.creation_date_time%TYPE;
3835: l_requestor_type ar_cmgt_credit_requests.requestor_type%TYPE;
3836: BEGIN

Line 3833: l_limit_currency ar_cmgt_case_folders.limit_currency%TYPE;

3829: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
3830: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
3831: l_notes ar_cmgt_credit_requests.notes%type;
3832: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
3833: l_limit_currency ar_cmgt_case_folders.limit_currency%TYPE;
3834: l_creation_date_time ar_cmgt_case_folders.creation_date_time%TYPE;
3835: l_requestor_type ar_cmgt_credit_requests.requestor_type%TYPE;
3836: BEGIN
3837: IF funcmode = 'RUN'

Line 3834: l_creation_date_time ar_cmgt_case_folders.creation_date_time%TYPE;

3830: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
3831: l_notes ar_cmgt_credit_requests.notes%type;
3832: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
3833: l_limit_currency ar_cmgt_case_folders.limit_currency%TYPE;
3834: l_creation_date_time ar_cmgt_case_folders.creation_date_time%TYPE;
3835: l_requestor_type ar_cmgt_credit_requests.requestor_type%TYPE;
3836: BEGIN
3837: IF funcmode = 'RUN'
3838: THEN

Line 4068: FROM ar_cmgt_case_folders

4064: SELECT case_folder_id, case_folder_number, check_list_id, score_model_id,
4065: limit_currency, creation_date_time
4066: INTO l_case_folder_id, l_case_folder_number, l_check_list_id, l_score_model_id,
4067: l_limit_currency, l_creation_date_time
4068: FROM ar_cmgt_case_folders
4069: WHERE credit_request_id = itemkey
4070: AND type = 'CASE';
4071:
4072: WF_ENGINE.setItemAttrNumber

Line 4140: l_cf_number ar_cmgt_case_folders.case_folder_number%type;

4136: l_null_zero_flag VARCHAR2(1);
4137: l_success_flg VARCHAR2(1);
4138: l_data_point_name AR_CMGT_SCORABLE_DATA_POINTS_V.DATA_POINT_NAME%type;
4139: l_raise_event VARCHAR2(1);
4140: l_cf_number ar_cmgt_case_folders.case_folder_number%type;
4141: l_request_id NUMBER;
4142: l_list WF_PARAMETER_LIST_T;
4143: l_param WF_PARAMETER_T;
4144: l_key VARCHAR2(240);

Line 4203: UPDATE ar_cmgt_case_folders

4199:
4200: IF l_request_id <> 0
4201: THEN
4202: resultout := 'COMPLETE:Y';
4203: UPDATE ar_cmgt_case_folders
4204: SET request_id = l_request_id,
4205: status = 'IN_PROCESS',
4206: last_update_date = sysdate,
4207: last_updated_by = fnd_global.user_id

Line 4232: l_score_model_id ar_cmgt_case_folders.score_model_id%type;

4228: p_cf_id in NUMBER,
4229: resultout out NOCOPY varchar2) IS
4230:
4231: l_score NUMBER;
4232: l_score_model_id ar_cmgt_case_folders.score_model_id%type;
4233: l_credit_type ar_cmgt_credit_requests.credit_type%type;
4234: l_resultout VARCHAR2(1);
4235: l_errmsg VARCHAR2(32767);
4236: l_credit_limit NUMBER := 0;

Line 4251: from ar_cmgt_case_folders cf,ar_cmgt_credit_requests cr

4247:
4248: --get detailz
4249: CURSOR get_details IS
4250: SELECT cf.score_model_id,cr.credit_type
4251: from ar_cmgt_case_folders cf,ar_cmgt_credit_requests cr
4252: where case_folder_id=p_cf_id
4253: and cr.credit_request_id=cf.credit_request_id;
4254:
4255:

Line 4348: UPDATE ar_cmgt_case_folders

4344: ,'','','','','','','','','',''
4345: ,'','','','','','','','','','');
4346: /* IF p_request_id <> 0
4347: THEN
4348: UPDATE ar_cmgt_case_folders
4349: SET request_id = p_request_id,
4350: status = 'IN_PROCESS',
4351: last_update_date = sysdate,
4352: last_updated_by = fnd_global.user_id