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_SCORES

Line 1399: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;

1395:
1396: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
1397: l_review_type ar_cmgt_check_lists.review_type%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;

Line 1832: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;

1828: funcmode in varchar2,
1829: resultout out NOCOPY varchar2) IS
1830:
1831:
1832: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
1833: l_score_model_id_1 ar_cmgt_scores.score_model_id%TYPE;
1834: l_trx_amount ar_cmgt_credit_requests.TRX_AMOUNT%TYPE;
1835:
1836:

Line 1833: l_score_model_id_1 ar_cmgt_scores.score_model_id%TYPE;

1829: resultout out NOCOPY varchar2) IS
1830:
1831:
1832: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
1833: l_score_model_id_1 ar_cmgt_scores.score_model_id%TYPE;
1834: l_trx_amount ar_cmgt_credit_requests.TRX_AMOUNT%TYPE;
1835:
1836:
1837: BEGIN

Line 1880: FROM ar_cmgt_scores

1876: -- check whether the score is valid or not
1877: BEGIN
1878: SELECT score_model_id
1879: INTO l_score_model_id_1
1880: FROM ar_cmgt_scores
1881: WHERE score_model_id = l_score_model_id
1882: AND submit_flag = 'Y'
1883: AND TRUNC(sysdate) between TRUNC(start_date) and TRUNC(nvl(end_date,SYSDATE));
1884:

Line 1904: l_score_currency ar_cmgt_scores.currency%type;

1900: funcmode in varchar2,
1901: resultout out NOCOPY varchar2) IS
1902:
1903: l_limit_currency ar_cmgt_credit_requests.limit_currency%type;
1904: l_score_currency ar_cmgt_scores.currency%type;
1905: l_score_model_id ar_cmgt_scores.score_model_id%type;
1906: BEGIN
1907:
1908: -- First get the requested currency and score_model_id

Line 1905: l_score_model_id ar_cmgt_scores.score_model_id%type;

1901: resultout out NOCOPY varchar2) IS
1902:
1903: l_limit_currency ar_cmgt_credit_requests.limit_currency%type;
1904: l_score_currency ar_cmgt_scores.currency%type;
1905: l_score_model_id ar_cmgt_scores.score_model_id%type;
1906: BEGIN
1907:
1908: -- First get the requested currency and score_model_id
1909: IF funcmode = 'RUN'

Line 1929: FROM ar_cmgt_scores

1925: BEGIN
1926: /* bug4527823: Added trunc function while comparing dates */
1927: SELECT currency
1928: INTO l_score_currency
1929: FROM ar_cmgt_scores
1930: WHERE score_model_id = l_score_model_id
1931: and submit_flag = 'Y'
1932: and TRUNC(nvl(end_date, SYSDATE)) >= TRUNC(sysdate)
1933: and ((currency = l_limit_currency) OR (nvl(skip_currency_test_flag, 'N') = 'Y')); -- Added for bug 8600040

Line 2198: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;

2194: actid in number,
2195: funcmode in varchar2,
2196: resultout out NOCOPY varchar2) IS
2197:
2198: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
2199: l_auto_rules_id ar_cmgt_auto_rules.auto_rules_id%type;
2200: l_score_model_id_1 ar_cmgt_scores.score_model_id%TYPE;
2201:
2202: BEGIN

Line 2200: l_score_model_id_1 ar_cmgt_scores.score_model_id%TYPE;

2196: resultout out NOCOPY varchar2) IS
2197:
2198: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
2199: l_auto_rules_id ar_cmgt_auto_rules.auto_rules_id%type;
2200: l_score_model_id_1 ar_cmgt_scores.score_model_id%TYPE;
2201:
2202: BEGIN
2203: IF funcmode = 'RUN'
2204: THEN

Line 2223: FROM ar_cmgt_scores

2219: -- first check whether score model is valid for this date or not.
2220: BEGIN
2221: SELECT score_model_id
2222: INTO l_score_model_id_1
2223: FROM ar_cmgt_scores
2224: WHERE score_model_id = l_score_model_id
2225: AND submit_flag = 'Y'
2226: AND TRUNC(sysdate) between TRUNC(start_date) and TRUNC(nvl(end_date,SYSDATE));
2227:

Line 2304: FROM ar_cmgt_scores

2300: -- Fetch the transaction currency (will be same as the one defined for
2301: -- scoring model and automated rules associated to it)
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

Line 2453: FROM ar_cmgt_scores

2449:
2450: BEGIN
2451: SELECT nvl(null_zero_flag,'N')
2452: INTO l_null_zero_flag
2453: FROM ar_cmgt_scores
2454: WHERE score_model_id = l_score_model_id;
2455:
2456: EXCEPTION
2457: WHEN OTHERS THEN

Line 4318: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;

4314:
4315: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
4316: l_review_type ar_cmgt_check_lists.review_type%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;