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_CHECK_LISTS

Line 1396: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;

1392: actid in number,
1393: funcmode in varchar2,
1394: resultout out NOCOPY varchar2) IS
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;

Line 1397: l_review_type ar_cmgt_check_lists.review_type%TYPE;

1393: funcmode in varchar2,
1394: resultout out NOCOPY varchar2) IS
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;

Line 1398: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;

1394: resultout out NOCOPY varchar2) IS
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;

Line 1683: FROM ar_cmgt_check_lists

1679: END IF;
1680: BEGIN
1681: SELECT check_list_id, score_model_id
1682: INTO l_check_list_id, l_score_model_id
1683: FROM ar_cmgt_check_lists
1684: WHERE submit_flag = 'Y'
1685: AND credit_classification = l_credit_classification
1686: AND review_type = l_review_type
1687: AND SYSDATE BETWEEN start_date and nvl(end_date,SYSDATE);

Line 1994: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;

1990: actid in number,
1991: funcmode in varchar2,
1992: resultout out NOCOPY varchar2) IS
1993:
1994: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
1995: l_review_type ar_cmgt_check_lists.review_type%TYPE;
1996: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1997: l_party_id ar_cmgt_credit_requests.party_id%type;
1998: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;

Line 1995: l_review_type ar_cmgt_check_lists.review_type%TYPE;

1991: funcmode in varchar2,
1992: resultout out NOCOPY varchar2) IS
1993:
1994: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
1995: l_review_type ar_cmgt_check_lists.review_type%TYPE;
1996: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1997: l_party_id ar_cmgt_credit_requests.party_id%type;
1998: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
1999: l_cust_acct_site_id ar_cmgt_credit_requests.cust_acct_site_id%type;

Line 1996: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;

1992: resultout out NOCOPY varchar2) IS
1993:
1994: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
1995: l_review_type ar_cmgt_check_lists.review_type%TYPE;
1996: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1997: l_party_id ar_cmgt_credit_requests.party_id%type;
1998: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%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;

Line 2141: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;

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);
2145: l_error_msg VARCHAR2(2000);

Line 4315: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;

4311: funcmode in varchar2,
4312: p_called_from IN VARCHAR2,
4313: resultout out NOCOPY varchar2) IS
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;

Line 4316: l_review_type ar_cmgt_check_lists.review_type%TYPE;

4312: p_called_from IN VARCHAR2,
4313: resultout out NOCOPY varchar2) IS
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;

Line 4317: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;

4313: resultout out NOCOPY varchar2) IS
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;