DBA Data[Home] [Help]

APPS.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_CONTROLS

Line 2921: AR_CMGT_CONTROLS.populate_recommendation(

2917: -- Now check if any auto recommendation exists
2918: FOR c_auto_rec IN c_auto_reco
2919: LOOP
2920: l_auto_reco_exist := 'Y';
2921: AR_CMGT_CONTROLS.populate_recommendation(
2922: p_case_folder_id => l_case_folder_id,
2923: p_credit_request_id => to_number(itemkey),
2924: p_score => l_score,
2925: p_recommended_credit_limit => l_credit_limit,

Line 3581: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (

3577: END;
3578: l_risk_factor := (1 - round((l_credit_limit/l_exposure),2));
3579:
3580:
3581: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (
3582: p_case_folder_id => l_case_folder_id,
3583: p_data_point_id => 182,
3584: p_data_point_value => l_risk_factor,
3585: p_score => NULL,

Line 4124: AR_CMGT_CONTROLS.DUPLICATE_CASE_FOLDER_TBL(

4120: END;
4121:
4122: --generate case folder for new credit request.
4123:
4124: AR_CMGT_CONTROLS.DUPLICATE_CASE_FOLDER_TBL(
4125: p_parnt_case_folder_id => l_parent_cf_id,
4126: p_credit_request_id => to_number(itemkey),
4127: p_errmsg => l_errmsg,
4128: p_resultout => l_resultout);

Line 4143: AR_CMGT_CONTROLS.DUPLICATE_CASE_FOLDER_DTLS(

4139: THEN
4140: raise populate_failure;
4141: END IF;
4142:
4143: AR_CMGT_CONTROLS.DUPLICATE_CASE_FOLDER_DTLS(
4144: p_parnt_case_folder_id => l_parent_cf_id,
4145: p_credit_request_id => to_number(itemkey),
4146: p_errmsg => l_errmsg,
4147: p_resultout => l_resultout);

Line 4157: AR_CMGT_CONTROLS.DUPLICATE_AGING_DATA(

4153:
4154:
4155: --populate AR_CMGT_CF_AGING_DTLS
4156:
4157: AR_CMGT_CONTROLS.DUPLICATE_AGING_DATA(
4158: p_parnt_case_folder_id => l_parent_cf_id,
4159: p_credit_request_id => to_number(itemkey),
4160: p_errmsg => l_errmsg,
4161: p_resultout => l_resultout);

Line 4171: AR_CMGT_CONTROLS.DUPLICATE_DNB_DATA(

4167: END IF;
4168:
4169: --populate ar_cmgt_cf_dnb_dtls
4170:
4171: AR_CMGT_CONTROLS.DUPLICATE_DNB_DATA(
4172: p_parnt_case_folder_id => l_parent_cf_id,
4173: p_credit_request_id => to_number(itemkey),
4174: p_errmsg => l_errmsg,
4175: p_resultout => l_resultout);

Line 4193: AR_CMGT_CONTROLS.DUPLICATE_NOTES_DATA(

4189: p_called_from => 'APPEAL',
4190: resultout => l_resultout);
4191: --populate AR_CMGT_CF_ANL_NOTES
4192:
4193: AR_CMGT_CONTROLS.DUPLICATE_NOTES_DATA(
4194: p_parnt_case_folder_id => l_parent_cf_id,
4195: p_credit_request_id => to_number(itemkey),
4196: p_errmsg => l_errmsg,
4197: p_resultout => l_resultout);

Line 4207: AR_CMGT_CONTROLS.DUPLICATE_FINANCIAL_DATA(

4203: END IF;
4204:
4205: --populate ar_cmgt_financial_data
4206:
4207: AR_CMGT_CONTROLS.DUPLICATE_FINANCIAL_DATA(
4208: p_parnt_credit_req_id => l_parent_creq_id,
4209: p_credit_request_id => to_number(itemkey),
4210: p_errmsg => l_errmsg,
4211: p_resultout => l_resultout);

Line 4222: AR_CMGT_CONTROLS.DUPLICATE_TRADE_DATA(

4218:
4219:
4220: --populate ar_cmgt_trade_ref_data
4221:
4222: AR_CMGT_CONTROLS.DUPLICATE_TRADE_DATA(
4223: p_parnt_credit_req_id => l_parent_creq_id,
4224: p_credit_request_id => to_number(itemkey),
4225: p_errmsg => l_errmsg,
4226: p_resultout => l_resultout);

Line 4237: AR_CMGT_CONTROLS.DUPLICATE_BANK_DATA(

4233:
4234:
4235: --populate ar_cmgt_bank_ref_data
4236:
4237: AR_CMGT_CONTROLS.DUPLICATE_BANK_DATA(
4238: p_parnt_credit_req_id => l_parent_creq_id,
4239: p_credit_request_id => to_number(itemkey),
4240: p_errmsg => l_errmsg,
4241: p_resultout => l_resultout);

Line 4252: AR_CMGT_CONTROLS.DUPLICATE_COLLATERAL_DATA(

4248:
4249:
4250: --populate ar_cmgt_collateral_data
4251:
4252: AR_CMGT_CONTROLS.DUPLICATE_COLLATERAL_DATA(
4253: p_parnt_credit_req_id => l_parent_creq_id,
4254: p_credit_request_id => to_number(itemkey),
4255: p_errmsg => l_errmsg,
4256: p_resultout => l_resultout);

Line 4267: AR_CMGT_CONTROLS.DUPLICATE_OTHER_DATA(

4263:
4264:
4265: --populate ar_cmgt_other_data
4266:
4267: AR_CMGT_CONTROLS.DUPLICATE_OTHER_DATA(
4268: p_parnt_credit_req_id => l_parent_creq_id,
4269: p_credit_request_id => to_number(itemkey),
4270: p_errmsg => l_errmsg,
4271: p_resultout => l_resultout);

Line 4281: AR_CMGT_CONTROLS.DUPLICATE_RECO_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),
4284: p_errmsg => l_errmsg,
4285: p_resultout => l_resultout);

Line 4809: AR_CMGT_CONTROLS.populate_recommendation(

4805: --loop through the auto rule cursor
4806: FOR c_auto_rec IN c_auto_reco
4807: LOOP
4808:
4809: AR_CMGT_CONTROLS.populate_recommendation(
4810: p_case_folder_id => p_cf_id,
4811: p_credit_request_id => to_number(itemkey),
4812: p_score => l_score,
4813: p_recommended_credit_limit => l_credit_limit,