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 338: FROM ar_cmgt_case_folders

334: THEN
335: BEGIN
336: SELECT check_list_id
337: INTO l_check_list_id
338: FROM ar_cmgt_case_folders
339: WHERE case_folder_id = p_case_folder_id
340: AND type = 'CASE';
341:
342: EXCEPTION

Line 557: UPDATE ar_cmgt_case_folders

553: last_update_login = fnd_global.login_id
554: WHERE credit_request_id = itemkey
555: AND credit_analyst_id IS NULL;
556:
557: UPDATE ar_cmgt_case_folders
558: set credit_analyst_id = l_resource_id,
559: last_updated = sysdate,
560: last_update_date = sysdate,
561: last_updated_by = fnd_global.user_id,

Line 879: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

875: resultout out NOCOPY varchar2) IS
876:
877: l_user_name VARCHAR2(60);
878: l_display_name VARCHAR2(240);
879: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
880: l_credit_analyst_id ar_cmgt_credit_requests.credit_analyst_id%type;
881: l_employee_id per_people_f.person_id%type;
882: l_dummy VARCHAR2(1);
883: BEGIN

Line 997: update ar_cmgt_case_folders

993: itemKey => itemkey,
994: aname => 'CASE_FOLDER_ID');
995: IF l_case_folder_id IS NOT NULL
996: THEN
997: update ar_cmgt_case_folders
998: set credit_analyst_id = l_credit_analyst_id,
999: last_updated = sysdate,
1000: last_update_date = sysdate,
1001: last_updated_by = fnd_global.user_id,

Line 1006: update ar_cmgt_case_folders

1002: last_update_login = fnd_global.login_id
1003: WHERE case_folder_id = l_case_folder_id;
1004:
1005: -- Also upadate data records with credit_analyst_id
1006: update ar_cmgt_case_folders
1007: set credit_analyst_id = l_credit_analyst_id,
1008: last_updated = sysdate,
1009: last_update_date = sysdate,
1010: last_updated_by = fnd_global.user_id,

Line 1226: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

1222: actid in number,
1223: funcmode in varchar2,
1224: resultout out NOCOPY varchar2) IS
1225:
1226: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
1227: BEGIN
1228:
1229: IF funcmode = 'RUN'
1230: THEN

Line 1237: UPDATE ar_cmgt_case_folders

1233: (itemtype => itemtype,
1234: itemkey => itemkey,
1235: aname => 'CASE_FOLDER_ID');
1236:
1237: UPDATE ar_cmgt_case_folders
1238: SET status = 'SUBMITTED',
1239: last_updated = sysdate,
1240: last_update_date = sysdate,
1241: last_updated_by = fnd_global.user_id,

Line 1402: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;

1398: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1399: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
1400: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
1401: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
1402: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
1403: l_source_name ar_cmgt_credit_requests.source_name%type;
1404: l_classification_meaning ar_lookups.meaning%type;
1405: l_review_type_meaning ar_lookups.meaning%type;
1406: l_application_number ar_cmgt_credit_requests.application_number%type;

Line 1973: delete ar_cmgt_case_folders

1969: l_case_folder_id := WF_ENGINE.getItemAttrText
1970: (itemtype => itemtype,
1971: itemkey => itemkey,
1972: aname => 'CASE_FOLDER_ID');
1973: delete ar_cmgt_case_folders
1974: WHERE case_folder_id = case_folder_id;
1975: delete ar_cmgt_cf_dtls
1976: WHERE case_folder_id = case_folder_id;
1977: END IF;

Line 2003: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;

1999: l_cust_acct_site_id ar_cmgt_credit_requests.cust_acct_site_id%type;
2000: l_request_id ar_cmgt_credit_requests.credit_request_id%type;
2001: l_trx_currency ar_cmgt_credit_requests.trx_currency%type;
2002: l_limit_currency ar_cmgt_credit_requests.limit_currency%type;
2003: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
2004: l_org_id NUMBER ;
2005: l_score_model_id NUMBER;
2006: l_credit_request_id NUMBER;
2007: l_case_folder_id NUMBER;

Line 2011: l_case_folder_date ar_cmgt_case_folders.last_updated%type;

2007: l_case_folder_id NUMBER;
2008: l_resultout VARCHAR2(200);
2009: BUILD_FAILURE EXCEPTION;
2010: l_error_message VARCHAR2(2000);
2011: l_case_folder_date ar_cmgt_case_folders.last_updated%type;
2012:
2013: BEGIN
2014: IF funcmode = 'RUN'
2015: THEN

Line 2103: FROM ar_cmgt_case_folders

2099: -- Get case folder details
2100: BEGIN
2101: SELECT case_folder_number, last_updated
2102: INTO l_case_folder_number, l_case_folder_date
2103: FROM ar_cmgt_case_folders
2104: WHERE case_folder_id = l_case_folder_id;
2105:
2106: WF_ENGINE.setItemAttrText
2107: (itemtype => itemtype,

Line 2140: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;

2136: actid in number,
2137: funcmode in varchar2,
2138: resultout out NOCOPY varchar2) IS
2139:
2140: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
2141: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
2142: l_score NUMBER;
2143: l_resultout VARCHAR2(1);
2144: l_debug_msg VARCHAR2(2000);

Line 2273: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE; -- Fixed for bug 9871620

2269: l_override_checklist ar_cmgt_auto_rule_dtls.override_checklist_flag%type;
2270: l_skip_approval ar_cmgt_auto_rule_dtls.skip_approval_flag%type;
2271: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
2272: l_trans_currency ar_cmgt_credit_requests.trx_currency%TYPE; -- Fixed for bug 9871620
2273: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE; -- Fixed for bug 9871620
2274: BEGIN
2275: IF funcmode = 'RUN'
2276: THEN
2277:

Line 2306: FROM ar_cmgt_case_folders

2302: SELECT currency
2303: INTO l_trans_currency
2304: FROM ar_cmgt_scores
2305: where score_model_id = (SELECT score_model_id
2306: FROM ar_cmgt_case_folders
2307: WHERE case_folder_id = l_case_folder_id);
2308: -- Fixed for bug 9871620 - End
2309:
2310: SELECT override_checklist_flag, skip_approval_flag

Line 3151: Update ar_cmgt_case_folders

3147: last_updated_by = fnd_global.user_id,
3148: last_update_login = fnd_global.login_id
3149: WHERE case_folder_id = l_case_folder_id;
3150:
3151: Update ar_cmgt_case_folders
3152: set status = 'CLOSED',
3153: last_updated = sysdate,
3154: last_update_date = sysdate,
3155: last_updated_by = fnd_global.user_id,

Line 3176: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

3172: actid in number,
3173: funcmode in varchar2,
3174: resultout out NOCOPY varchar2) IS
3175:
3176: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3177: l_credit_type ar_cmgt_credit_requests.credit_type%type;
3178: l_party_id ar_cmgt_credit_requests.party_id%type;
3179: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
3180: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;

Line 3438: Update ar_cmgt_case_folders

3434: last_updated_by = fnd_global.user_id,
3435: last_update_login = fnd_global.login_id
3436: WHERE case_folder_id = l_case_folder_id;
3437:
3438: Update ar_cmgt_case_folders
3439: set status = 'CLOSED',
3440: last_updated = sysdate,
3441: last_update_date = sysdate,
3442: last_updated_by = fnd_global.user_id,

Line 3471: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

3467: actid in number,
3468: funcmode in varchar2,
3469: resultout out NOCOPY varchar2) IS
3470:
3471: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3472: l_party_id ar_cmgt_credit_requests.party_id%type;
3473: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
3474: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
3475: l_credit_limit NUMBER := 0;

Line 3478: l_limit_currency ar_cmgt_case_folders.limit_currency%type;

3474: l_site_use_id ar_cmgt_credit_requests.site_use_id%type;
3475: l_credit_limit NUMBER := 0;
3476: l_exposure NUMBER;
3477: l_risk_factor NUMBER;
3478: l_limit_currency ar_cmgt_case_folders.limit_currency%type;
3479: l_errmsg VARCHAR2(2000);
3480: l_resultout VARCHAR2(1);
3481: l_parent_credit_request_id NUMBER;
3482:

Line 3625: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

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

Line 3637: FROM ar_cmgt_case_folders

3633: BEGIN
3634:
3635: select case_folder_id
3636: INTO l_case_folder_id
3637: FROM ar_cmgt_case_folders
3638: WHERE credit_request_id = itemkey
3639: and type = 'CASE';
3640:
3641: raise_recco_event(l_case_folder_id);

Line 3685: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

3681: actid in number,
3682: funcmode in varchar2,
3683: resultout out NOCOPY varchar2) IS
3684:
3685: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
3686: BEGIN
3687: l_case_folder_id := WF_ENGINE.GetItemAttrNumber
3688: (itemtype => itemtype,
3689: itemkey => itemkey,

Line 3692: UPDATE ar_cmgt_case_folders

3688: (itemtype => itemtype,
3689: itemkey => itemkey,
3690: aname => 'CASE_FOLDER_ID');
3691:
3692: UPDATE ar_cmgt_case_folders
3693: set status = 'CREATED',
3694: last_updated = sysdate,
3695: last_update_date = sysdate,
3696: last_updated_by = fnd_global.user_id,

Line 3715: ar_cmgt_case_folders

3711: CURSOR get_case_analyst_info IS
3712: SELECT credit_analyst_id, original_credit_analyst_id,
3713: previous_credit_analyst_id, case_folder_number
3714: FROM
3715: ar_cmgt_case_folders
3716: WHERE credit_request_id = p_itemkey
3717: AND type = 'CASE';
3718: BEGIN
3719:

Line 3728: UPDATE ar_cmgt_case_folders

3724: l_prev_credit_analyst_id, l_case_folder_number;
3725: CLOSE get_case_analyst_info;
3726:
3727: IF (l_orig_credit_analyst_id IS NULL AND l_prev_credit_analyst_id IS NULL) THEN
3728: UPDATE ar_cmgt_case_folders
3729: SET original_credit_analyst_id = l_credit_analyst_id,
3730: previous_credit_analyst_id = l_credit_analyst_id
3731: WHERE case_folder_number = l_case_folder_number;
3732: ELSIF (l_orig_credit_analyst_id IS NOT NULL AND l_prev_credit_analyst_id IS NOT NULL) THEN

Line 3734: UPDATE ar_cmgt_case_folders

3730: previous_credit_analyst_id = l_credit_analyst_id
3731: WHERE case_folder_number = l_case_folder_number;
3732: ELSIF (l_orig_credit_analyst_id IS NOT NULL AND l_prev_credit_analyst_id IS NOT NULL) THEN
3733: IF (l_orig_credit_analyst_id = l_new_credit_analyst_id) THEN
3734: UPDATE ar_cmgt_case_folders
3735: SET original_credit_analyst_id = NULL,
3736: previous_credit_analyst_id = NULL
3737: WHERE case_folder_number = l_case_folder_number;
3738: ELSE

Line 3739: UPDATE ar_cmgt_case_folders

3735: SET original_credit_analyst_id = NULL,
3736: previous_credit_analyst_id = NULL
3737: WHERE case_folder_number = l_case_folder_number;
3738: ELSE
3739: UPDATE ar_cmgt_case_folders
3740: SET previous_credit_analyst_id = l_credit_analyst_id
3741: WHERE case_folder_number = l_case_folder_number;
3742: END IF;
3743: END IF;

Line 3834: l_status ar_cmgt_case_folders.status%type;

3830: resultout out NOCOPY varchar2) IS
3831:
3832: l_credit_request_id ar_cmgt_credit_requests.credit_request_id%type;
3833: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
3834: l_status ar_cmgt_case_folders.status%type;
3835:
3836: BEGIN
3837: IF funcmode = 'RUN'
3838: THEN

Line 3871: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;

3867: actid in number,
3868: funcmode in varchar2,
3869: resultout out NOCOPY varchar2) IS
3870:
3871: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
3872: l_reco_exist VARCHAR2(1) := 'N';
3873: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
3874: l_flag varchar2(1);
3875: UNEXP_ERROR EXCEPTION;

Line 4034: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

4030: l_processng_flag VARCHAR2(1);
4031: l_case_rec_num NUMBER;
4032: l_credit_type ar_cmgt_credit_requests.credit_type%type;
4033: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
4034: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
4035: l_parent_cf_id ar_cmgt_case_folders.case_folder_id%type;
4036: l_parent_creq_id ar_cmgt_credit_requests.parent_credit_request_id%type;
4037: insert_failure EXCEPTION;
4038: l_cf_id ar_cmgt_case_folders.case_folder_id%type;

Line 4035: l_parent_cf_id ar_cmgt_case_folders.case_folder_id%type;

4031: l_case_rec_num NUMBER;
4032: l_credit_type ar_cmgt_credit_requests.credit_type%type;
4033: l_credit_request_type ar_cmgt_credit_requests.credit_request_type%type;
4034: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
4035: l_parent_cf_id ar_cmgt_case_folders.case_folder_id%type;
4036: l_parent_creq_id ar_cmgt_credit_requests.parent_credit_request_id%type;
4037: insert_failure EXCEPTION;
4038: l_cf_id ar_cmgt_case_folders.case_folder_id%type;
4039: populate_failure EXCEPTION;

Line 4038: l_cf_id ar_cmgt_case_folders.case_folder_id%type;

4034: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
4035: l_parent_cf_id ar_cmgt_case_folders.case_folder_id%type;
4036: l_parent_creq_id ar_cmgt_credit_requests.parent_credit_request_id%type;
4037: insert_failure EXCEPTION;
4038: l_cf_id ar_cmgt_case_folders.case_folder_id%type;
4039: populate_failure EXCEPTION;
4040:
4041:
4042: BEGIN

Line 4110: FROM AR_CMGT_CASE_FOLDERS

4106: BEGIN
4107:
4108: SELECT CASE_FOLDER_ID
4109: INTO l_parent_cf_id
4110: FROM AR_CMGT_CASE_FOLDERS
4111: WHERE CREDIT_REQUEST_ID = l_parent_creq_id
4112: and type = 'CASE';
4113:
4114: EXCEPTION

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

4113:
4114: EXCEPTION
4115: WHEN OTHERS THEN
4116: wf_core.context ('AR_CMGT_WF_ENGINE','APPEAL_RESUB_DECISION',itemtype,itemkey,
4117: 'Error while getting parent records from AR_CMGT_CASE_FOLDERS',
4118: 'Sql Error: '||sqlerrm);
4119: raise;
4120: END;
4121:

Line 4321: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;

4317: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
4318: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
4319: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
4320: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
4321: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
4322: l_source_name ar_cmgt_credit_requests.source_name%type;
4323: l_classification_meaning ar_lookups.meaning%type;
4324: l_review_type_meaning ar_lookups.meaning%type;
4325: l_application_number ar_cmgt_credit_requests.application_number%type;

Line 4340: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;

4336: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
4337: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
4338: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
4339: l_notes ar_cmgt_credit_requests.notes%type;
4340: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
4341: l_limit_currency ar_cmgt_case_folders.limit_currency%TYPE;
4342: l_creation_date_time ar_cmgt_case_folders.creation_date_time%TYPE;
4343: l_requestor_type ar_cmgt_credit_requests.requestor_type%TYPE;
4344:

Line 4341: l_limit_currency ar_cmgt_case_folders.limit_currency%TYPE;

4337: l_source_column2 ar_cmgt_credit_requests.source_column2%type;
4338: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
4339: l_notes ar_cmgt_credit_requests.notes%type;
4340: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
4341: l_limit_currency ar_cmgt_case_folders.limit_currency%TYPE;
4342: l_creation_date_time ar_cmgt_case_folders.creation_date_time%TYPE;
4343: l_requestor_type ar_cmgt_credit_requests.requestor_type%TYPE;
4344:
4345: BEGIN

Line 4342: l_creation_date_time ar_cmgt_case_folders.creation_date_time%TYPE;

4338: l_source_column3 ar_cmgt_credit_requests.source_column3%type;
4339: l_notes ar_cmgt_credit_requests.notes%type;
4340: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
4341: l_limit_currency ar_cmgt_case_folders.limit_currency%TYPE;
4342: l_creation_date_time ar_cmgt_case_folders.creation_date_time%TYPE;
4343: l_requestor_type ar_cmgt_credit_requests.requestor_type%TYPE;
4344:
4345: BEGIN
4346: IF funcmode = 'RUN'

Line 4577: FROM ar_cmgt_case_folders

4573: SELECT case_folder_id, case_folder_number, check_list_id, score_model_id,
4574: limit_currency, creation_date_time
4575: INTO l_case_folder_id, l_case_folder_number, l_check_list_id, l_score_model_id,
4576: l_limit_currency, l_creation_date_time
4577: FROM ar_cmgt_case_folders
4578: WHERE credit_request_id = itemkey
4579: AND type = 'CASE';
4580:
4581: WF_ENGINE.setItemAttrNumber

Line 4649: l_cf_number ar_cmgt_case_folders.case_folder_number%type;

4645: l_null_zero_flag VARCHAR2(1);
4646: l_success_flg VARCHAR2(1);
4647: l_data_point_name AR_CMGT_SCORABLE_DATA_POINTS_V.DATA_POINT_NAME%type;
4648: l_raise_event VARCHAR2(1);
4649: l_cf_number ar_cmgt_case_folders.case_folder_number%type;
4650: l_request_id NUMBER;
4651: l_list WF_PARAMETER_LIST_T;
4652: l_param WF_PARAMETER_T;
4653: l_key VARCHAR2(240);

Line 4712: UPDATE ar_cmgt_case_folders

4708:
4709: IF l_request_id <> 0
4710: THEN
4711: resultout := 'COMPLETE:Y';
4712: UPDATE ar_cmgt_case_folders
4713: SET request_id = l_request_id,
4714: status = 'IN_PROCESS',
4715: last_update_date = sysdate,
4716: last_updated_by = fnd_global.user_id,

Line 4742: l_score_model_id ar_cmgt_case_folders.score_model_id%type;

4738: p_cf_id in NUMBER,
4739: resultout out NOCOPY varchar2) IS
4740:
4741: l_score NUMBER;
4742: l_score_model_id ar_cmgt_case_folders.score_model_id%type;
4743: l_credit_type ar_cmgt_credit_requests.credit_type%type;
4744: l_resultout VARCHAR2(1);
4745: l_errmsg VARCHAR2(32767);
4746: l_credit_limit NUMBER := 0;

Line 4761: from ar_cmgt_case_folders cf,ar_cmgt_credit_requests cr

4757:
4758: --get detailz
4759: CURSOR get_details IS
4760: SELECT cf.score_model_id,cr.credit_type
4761: from ar_cmgt_case_folders cf,ar_cmgt_credit_requests cr
4762: where case_folder_id=p_cf_id
4763: and cr.credit_request_id=cf.credit_request_id;
4764:
4765:

Line 4858: UPDATE ar_cmgt_case_folders

4854: ,'','','','','','','','','',''
4855: ,'','','','','','','','','','');
4856: /* IF p_request_id <> 0
4857: THEN
4858: UPDATE ar_cmgt_case_folders
4859: SET request_id = p_request_id,
4860: status = 'IN_PROCESS',
4861: last_update_date = sysdate,
4862: last_updated_by = fnd_global.user_id