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_CONTROLS dependencies on AR_CMGT_CREDIT_REQUESTS

Line 375: l_recommendation_name ar_cmgt_credit_requests.recommendation_name%type;

371: p_credit_type IN VARCHAR2,
372: p_errmsg OUT NOCOPY VARCHAR2,
373: p_resultout OUT NOCOPY VARCHAR2 ) IS
374:
375: l_recommendation_name ar_cmgt_credit_requests.recommendation_name%type;
376: l_appl_id ar_cmgt_credit_requests.source_resp_appln_id%type;
377: BEGIN
378: p_resultout := 0;
379: BEGIN

Line 376: l_appl_id ar_cmgt_credit_requests.source_resp_appln_id%type;

372: p_errmsg OUT NOCOPY VARCHAR2,
373: p_resultout OUT NOCOPY VARCHAR2 ) IS
374:
375: l_recommendation_name ar_cmgt_credit_requests.recommendation_name%type;
376: l_appl_id ar_cmgt_credit_requests.source_resp_appln_id%type;
377: BEGIN
378: p_resultout := 0;
379: BEGIN
380: SELECT recommendation_name,source_resp_appln_id

Line 382: FROM ar_cmgt_credit_requests

378: p_resultout := 0;
379: BEGIN
380: SELECT recommendation_name,source_resp_appln_id
381: INTO l_recommendation_name, l_appl_id
382: FROM ar_cmgt_credit_requests
383: WHERE credit_request_id = p_credit_request_id;
384: EXCEPTION
385: WHEN OTHERS THEN
386: p_resultout := 1;

Line 601: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;

597: p_credit_request_id IN NUMBER ,
598: p_errmsg OUT NOCOPY VARCHAR2,
599: p_resultout OUT NOCOPY VARCHAR2
600: ) IS
601: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;
602: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;
603: BEGIN
604:
605: l_credit_request_id := p_credit_request_id;

Line 677: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;

673: p_credit_request_id IN NUMBER ,
674: p_errmsg OUT NOCOPY VARCHAR2,
675: p_resultout OUT NOCOPY VARCHAR2
676: ) IS
677: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;
678: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;
679: l_processing_flag VARCHAR2(1);
680: TYPE list_change_id IS RECORD (
681: parent NUMBER,

Line 854: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;

850: p_credit_request_id IN NUMBER ,
851: p_errmsg OUT NOCOPY VARCHAR2,
852: p_resultout OUT NOCOPY VARCHAR2
853: ) IS
854: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;
855: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;
856: l_processing_flag VARCHAR2(1);
857: BEGIN
858:

Line 924: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;

920: p_credit_request_id IN NUMBER ,
921: p_errmsg OUT NOCOPY VARCHAR2,
922: p_resultout OUT NOCOPY VARCHAR2
923: ) IS
924: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;
925: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;
926: l_processing_flag VARCHAR2(1);
927: BEGIN
928:

Line 993: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;

989: p_credit_request_id IN NUMBER ,
990: p_errmsg OUT NOCOPY VARCHAR2,
991: p_resultout OUT NOCOPY VARCHAR2
992: ) IS
993: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;
994: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;
995: l_processing_flag VARCHAR2(1);
996: BEGIN
997: l_credit_request_id := p_credit_request_id;

Line 1127: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;

1123: p_credit_request_id IN NUMBER ,
1124: p_errmsg OUT NOCOPY VARCHAR2,
1125: p_resultout OUT NOCOPY VARCHAR2
1126: ) IS
1127: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;
1128: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;
1129: l_processing_flag VARCHAR2(1);
1130: BEGIN
1131: l_credit_request_id := p_credit_request_id;

Line 1241: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;

1237: p_credit_request_id IN NUMBER ,
1238: p_errmsg OUT NOCOPY VARCHAR2,
1239: p_resultout OUT NOCOPY VARCHAR2
1240: ) IS
1241: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;
1242: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;
1243: l_data_point_id ar_cmgt_bank_ref_data.DATAPOINT_ID%TYPE;
1244: l_next_val ar_cmgt_bank_ref_data.DATAPOINT_ID%TYPE;
1245: l_processing_flag VARCHAR2(1);

Line 1395: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;

1391: p_credit_request_id IN NUMBER ,
1392: p_errmsg OUT NOCOPY VARCHAR2,
1393: p_resultout OUT NOCOPY VARCHAR2
1394: ) IS
1395: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;
1396: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;
1397: l_processing_flag VARCHAR2(1);
1398: BEGIN
1399:

Line 1485: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;

1481: p_credit_request_id IN NUMBER ,
1482: p_errmsg OUT NOCOPY VARCHAR2,
1483: p_resultout OUT NOCOPY VARCHAR2
1484: ) IS
1485: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;
1486: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;
1487: l_processing_flag VARCHAR2(1);
1488: BEGIN
1489:

Line 1589: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;

1585: p_credit_request_id IN NUMBER ,
1586: p_errmsg OUT NOCOPY VARCHAR2,
1587: p_resultout OUT NOCOPY VARCHAR2
1588: ) IS
1589: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;
1590: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;
1591: l_processing_flag VARCHAR2(1);
1592: BEGIN
1593:

Line 1672: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;

1668: p_credit_request_id IN NUMBER ,
1669: p_errmsg OUT NOCOPY VARCHAR2,
1670: p_resultout OUT NOCOPY VARCHAR2
1671: ) IS
1672: l_credit_request_id AR_CMGT_CREDIT_REQUESTS.CREDIT_REQUEST_ID%TYPE;
1673: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;
1674: l_processing_flag VARCHAR2(1);
1675: BEGIN
1676: