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 1152: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;

1148: actid in number,
1149: funcmode in varchar2,
1150: resultout out NOCOPY varchar2) IS
1151:
1152: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
1153: l_review_type ar_cmgt_check_lists.review_type%TYPE;
1154: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1155: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
1156: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;

Line 1153: l_review_type ar_cmgt_check_lists.review_type%TYPE;

1149: funcmode in varchar2,
1150: resultout out NOCOPY varchar2) IS
1151:
1152: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
1153: l_review_type ar_cmgt_check_lists.review_type%TYPE;
1154: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1155: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
1156: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
1157: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;

Line 1154: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;

1150: resultout out NOCOPY varchar2) IS
1151:
1152: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
1153: l_review_type ar_cmgt_check_lists.review_type%TYPE;
1154: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1155: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
1156: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
1157: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
1158: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;

Line 1439: FROM ar_cmgt_check_lists

1435: END IF;
1436: BEGIN
1437: SELECT check_list_id, score_model_id
1438: INTO l_check_list_id, l_score_model_id
1439: FROM ar_cmgt_check_lists
1440: WHERE submit_flag = 'Y'
1441: AND credit_classification = l_credit_classification
1442: AND review_type = l_review_type
1443: AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date) and TRUNC(nvl(end_date,SYSDATE));

Line 1682: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;

1678: actid in number,
1679: funcmode in varchar2,
1680: resultout out NOCOPY varchar2) IS
1681:
1682: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
1683: l_review_type ar_cmgt_check_lists.review_type%TYPE;
1684: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1685: l_party_id ar_cmgt_credit_requests.party_id%type;
1686: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;

Line 1683: l_review_type ar_cmgt_check_lists.review_type%TYPE;

1679: funcmode in varchar2,
1680: resultout out NOCOPY varchar2) IS
1681:
1682: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
1683: l_review_type ar_cmgt_check_lists.review_type%TYPE;
1684: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1685: l_party_id ar_cmgt_credit_requests.party_id%type;
1686: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
1687: l_cust_acct_site_id ar_cmgt_credit_requests.cust_acct_site_id%type;

Line 1684: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;

1680: resultout out NOCOPY varchar2) IS
1681:
1682: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
1683: l_review_type ar_cmgt_check_lists.review_type%TYPE;
1684: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1685: l_party_id ar_cmgt_credit_requests.party_id%type;
1686: l_cust_account_id ar_cmgt_credit_requests.cust_account_id%type;
1687: l_cust_acct_site_id ar_cmgt_credit_requests.cust_acct_site_id%type;
1688: l_request_id ar_cmgt_credit_requests.credit_request_id%type;

Line 1829: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;

1825: funcmode in varchar2,
1826: resultout out NOCOPY varchar2) IS
1827:
1828: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
1829: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
1830: l_score NUMBER;
1831: l_resultout VARCHAR2(1);
1832: l_debug_msg VARCHAR2(2000);
1833: l_error_msg VARCHAR2(2000);

Line 3807: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;

3803: funcmode in varchar2,
3804: p_called_from IN VARCHAR2,
3805: resultout out NOCOPY varchar2) IS
3806:
3807: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
3808: l_review_type ar_cmgt_check_lists.review_type%TYPE;
3809: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
3810: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
3811: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;

Line 3808: l_review_type ar_cmgt_check_lists.review_type%TYPE;

3804: p_called_from IN VARCHAR2,
3805: resultout out NOCOPY varchar2) IS
3806:
3807: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
3808: l_review_type ar_cmgt_check_lists.review_type%TYPE;
3809: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
3810: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
3811: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
3812: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;

Line 3809: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;

3805: resultout out NOCOPY varchar2) IS
3806:
3807: l_credit_classification ar_cmgt_check_lists.credit_classification%TYPE;
3808: l_review_type ar_cmgt_check_lists.review_type%TYPE;
3809: l_check_list_id ar_cmgt_check_lists.check_list_id%TYPE;
3810: l_score_model_id ar_cmgt_scores.score_model_id%TYPE;
3811: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
3812: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
3813: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;