APPS.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_CONTROLS

Line 2547: AR_CMGT_CONTROLS.populate_recommendation(

2543: -- Now check if any auto recommendation exists
2544: FOR c_auto_rec IN c_auto_reco
2545: LOOP
2546: l_auto_reco_exist := 'Y';
2547: AR_CMGT_CONTROLS.populate_recommendation(
2548: p_case_folder_id => l_case_folder_id,
2549: p_credit_request_id => to_number(itemkey),
2550: p_score => l_score,
2551: p_recommended_credit_limit => l_credit_limit,

Line 3151: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (

3147: END;
3148: l_risk_factor := (1 - round((l_credit_limit/l_exposure),2));
3149:
3150:
3151: AR_CMGT_CONTROLS.UPDATE_CASE_FOLDER_DETAILS (
3152: p_case_folder_id => l_case_folder_id,
3153: p_data_point_id => 182,
3154: p_data_point_value => l_risk_factor,
3155: p_score => NULL,

Line 3616: AR_CMGT_CONTROLS.DUPLICATE_CASE_FOLDER_TBL(

3612: END;
3613:
3614: --generate case folder for new credit request.
3615:
3616: AR_CMGT_CONTROLS.DUPLICATE_CASE_FOLDER_TBL(
3617: p_parnt_case_folder_id => l_parent_cf_id,
3618: p_credit_request_id => to_number(itemkey),
3619: p_errmsg => l_errmsg,
3620: p_resultout => l_resultout);

Line 3635: AR_CMGT_CONTROLS.DUPLICATE_CASE_FOLDER_DTLS(

3631: THEN
3632: raise populate_failure;
3633: END IF;
3634:
3635: AR_CMGT_CONTROLS.DUPLICATE_CASE_FOLDER_DTLS(
3636: p_parnt_case_folder_id => l_parent_cf_id,
3637: p_credit_request_id => to_number(itemkey),
3638: p_errmsg => l_errmsg,
3639: p_resultout => l_resultout);

Line 3649: AR_CMGT_CONTROLS.DUPLICATE_AGING_DATA(

3645:
3646:
3647: --populate AR_CMGT_CF_AGING_DTLS
3648:
3649: AR_CMGT_CONTROLS.DUPLICATE_AGING_DATA(
3650: p_parnt_case_folder_id => l_parent_cf_id,
3651: p_credit_request_id => to_number(itemkey),
3652: p_errmsg => l_errmsg,
3653: p_resultout => l_resultout);

Line 3663: AR_CMGT_CONTROLS.DUPLICATE_DNB_DATA(

3659: END IF;
3660:
3661: --populate ar_cmgt_cf_dnb_dtls
3662:
3663: AR_CMGT_CONTROLS.DUPLICATE_DNB_DATA(
3664: p_parnt_case_folder_id => l_parent_cf_id,
3665: p_credit_request_id => to_number(itemkey),
3666: p_errmsg => l_errmsg,
3667: p_resultout => l_resultout);

Line 3685: AR_CMGT_CONTROLS.DUPLICATE_NOTES_DATA(

3681: p_called_from => 'APPEAL',
3682: resultout => l_resultout);
3683: --populate AR_CMGT_CF_ANL_NOTES
3684:
3685: AR_CMGT_CONTROLS.DUPLICATE_NOTES_DATA(
3686: p_parnt_case_folder_id => l_parent_cf_id,
3687: p_credit_request_id => to_number(itemkey),
3688: p_errmsg => l_errmsg,
3689: p_resultout => l_resultout);

Line 3699: AR_CMGT_CONTROLS.DUPLICATE_FINANCIAL_DATA(

3695: END IF;
3696:
3697: --populate ar_cmgt_financial_data
3698:
3699: AR_CMGT_CONTROLS.DUPLICATE_FINANCIAL_DATA(
3700: p_parnt_credit_req_id => l_parent_creq_id,
3701: p_credit_request_id => to_number(itemkey),
3702: p_errmsg => l_errmsg,
3703: p_resultout => l_resultout);

Line 3714: AR_CMGT_CONTROLS.DUPLICATE_TRADE_DATA(

3710:
3711:
3712: --populate ar_cmgt_trade_ref_data
3713:
3714: AR_CMGT_CONTROLS.DUPLICATE_TRADE_DATA(
3715: p_parnt_credit_req_id => l_parent_creq_id,
3716: p_credit_request_id => to_number(itemkey),
3717: p_errmsg => l_errmsg,
3718: p_resultout => l_resultout);

Line 3729: AR_CMGT_CONTROLS.DUPLICATE_BANK_DATA(

3725:
3726:
3727: --populate ar_cmgt_bank_ref_data
3728:
3729: AR_CMGT_CONTROLS.DUPLICATE_BANK_DATA(
3730: p_parnt_credit_req_id => l_parent_creq_id,
3731: p_credit_request_id => to_number(itemkey),
3732: p_errmsg => l_errmsg,
3733: p_resultout => l_resultout);

Line 3744: AR_CMGT_CONTROLS.DUPLICATE_COLLATERAL_DATA(

3740:
3741:
3742: --populate ar_cmgt_collateral_data
3743:
3744: AR_CMGT_CONTROLS.DUPLICATE_COLLATERAL_DATA(
3745: p_parnt_credit_req_id => l_parent_creq_id,
3746: p_credit_request_id => to_number(itemkey),
3747: p_errmsg => l_errmsg,
3748: p_resultout => l_resultout);

Line 3759: AR_CMGT_CONTROLS.DUPLICATE_OTHER_DATA(

3755:
3756:
3757: --populate ar_cmgt_other_data
3758:
3759: AR_CMGT_CONTROLS.DUPLICATE_OTHER_DATA(
3760: p_parnt_credit_req_id => l_parent_creq_id,
3761: p_credit_request_id => to_number(itemkey),
3762: p_errmsg => l_errmsg,
3763: p_resultout => l_resultout);

Line 3773: AR_CMGT_CONTROLS.DUPLICATE_RECO_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),
3776: p_errmsg => l_errmsg,
3777: p_resultout => l_resultout);

Line 4299: AR_CMGT_CONTROLS.populate_recommendation(

4295: --loop through the auto rule cursor
4296: FOR c_auto_rec IN c_auto_reco
4297: LOOP
4298:
4299: AR_CMGT_CONTROLS.populate_recommendation(
4300: p_case_folder_id => p_cf_id,
4301: p_credit_request_id => to_number(itemkey),
4302: p_score => l_score,
4303: p_recommended_credit_limit => l_credit_limit,