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_CASE_FOLDERS

Line 141: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

137: p_type IN VARCHAR2 ,
138: p_errmsg OUT NOCOPY VARCHAR2,
139: p_resultout OUT NOCOPY VARCHAR2) IS
140:
141: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
142: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
143: BEGIN
144: p_resultout := 0;
145: IF (p_case_folder_id IS NULL) OR (p_case_folder_id = -99)

Line 142: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;

138: p_errmsg OUT NOCOPY VARCHAR2,
139: p_resultout OUT NOCOPY VARCHAR2) IS
140:
141: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
142: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
143: BEGIN
144: p_resultout := 0;
145: IF (p_case_folder_id IS NULL) OR (p_case_folder_id = -99)
146: THEN

Line 147: SELECT ar_cmgt_case_folders_s.nextval

143: BEGIN
144: p_resultout := 0;
145: IF (p_case_folder_id IS NULL) OR (p_case_folder_id = -99)
146: THEN
147: SELECT ar_cmgt_case_folders_s.nextval
148: INTO l_case_folder_id
149: FROM DUAL;
150: ELSE
151: l_case_folder_id := p_case_folder_id;

Line 161: INSERT INTO ar_cmgt_case_folders (

157: FROM DUAL;
158: ELSE
159: l_case_folder_number := p_case_folder_number;
160: END IF;
161: INSERT INTO ar_cmgt_case_folders (
162: case_folder_id,
163: case_folder_number,
164: credit_request_id,
165: check_list_id,

Line 602: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;

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;
606: l_case_folders_id := p_parnt_case_folder_id;

Line 609: INSERT INTO AR_CMGT_CASE_FOLDERS

605: l_credit_request_id := p_credit_request_id;
606: l_case_folders_id := p_parnt_case_folder_id;
607: p_resultout :=0;
608: -- Create the duplicate record.
609: INSERT INTO AR_CMGT_CASE_FOLDERS
610: (
611: CASE_FOLDER_ID,
612: CASE_FOLDER_NUMBER,
613: LAST_UPDATED_BY,

Line 635: ( SELECT AR_CMGT_CASE_FOLDERS_s.NEXTVAL,

631: LAST_UPDATED,
632: LIMIT_CURRENCY,
633: EXCHANGE_RATE_TYPE,
634: REVIEW_CYCLE)
635: ( SELECT AR_CMGT_CASE_FOLDERS_s.NEXTVAL,
636: ar_cmgt_case_folder_number_s.nextval,
637: fnd_global.user_id,
638: SYSDATE,
639: fnd_global.user_id,

Line 659: FROM AR_CMGT_CASE_FOLDERS

655: SYSDATE,
656: LIMIT_CURRENCY,
657: EXCHANGE_RATE_TYPE,
658: REVIEW_CYCLE
659: FROM AR_CMGT_CASE_FOLDERS
660: WHERE CASE_FOLDER_ID = l_case_folders_id
661: AND TYPE = 'CASE') ;
662: EXCEPTION
663: WHEN OTHERS

Line 678: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;

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,
682: changed NUMBER);

Line 714: FROM AR_CMGT_CASE_FOLDERS

710: BEGIN
711:
712: SELECT CASE_FOLDER_ID
713: INTO l_case_folders_id
714: FROM AR_CMGT_CASE_FOLDERS
715: WHERE CREDIT_REQUEST_ID = p_credit_request_id;
716:
717: EXCEPTION
718: WHEN OTHERS

Line 855: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;

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:
859: p_resultout :=0;

Line 866: FROM AR_CMGT_CASE_FOLDERS

862: BEGIN
863:
864: SELECT CASE_FOLDER_ID
865: INTO l_case_folders_id
866: FROM AR_CMGT_CASE_FOLDERS
867: WHERE CREDIT_REQUEST_ID = p_credit_request_id;
868:
869: EXCEPTION
870: WHEN OTHERS

Line 925: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;

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:
929: p_resultout :=0;

Line 936: FROM AR_CMGT_CASE_FOLDERS

932: BEGIN
933:
934: SELECT CASE_FOLDER_ID
935: INTO l_case_folders_id
936: FROM AR_CMGT_CASE_FOLDERS
937: WHERE CREDIT_REQUEST_ID = p_credit_request_id;
938:
939: EXCEPTION
940: WHEN OTHERS

Line 994: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;

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;
998: p_resultout :=0;

Line 1005: FROM AR_CMGT_CASE_FOLDERS

1001: BEGIN
1002:
1003: SELECT CASE_FOLDER_ID
1004: INTO l_case_folders_id
1005: FROM AR_CMGT_CASE_FOLDERS
1006: WHERE CREDIT_REQUEST_ID = p_credit_request_id;
1007:
1008: EXCEPTION
1009: WHEN OTHERS

Line 1128: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;

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;
1132: p_resultout :=0;

Line 1139: FROM AR_CMGT_CASE_FOLDERS

1135: BEGIN
1136:
1137: SELECT CASE_FOLDER_ID
1138: INTO l_case_folders_id
1139: FROM AR_CMGT_CASE_FOLDERS
1140: WHERE CREDIT_REQUEST_ID = p_credit_request_id;
1141:
1142: EXCEPTION
1143: WHEN OTHERS

Line 1242: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;

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);
1246:

Line 1261: FROM AR_CMGT_CASE_FOLDERS

1257: BEGIN
1258:
1259: SELECT CASE_FOLDER_ID
1260: INTO l_case_folders_id
1261: FROM AR_CMGT_CASE_FOLDERS
1262: WHERE CREDIT_REQUEST_ID = p_credit_request_id;
1263:
1264: EXCEPTION
1265: WHEN OTHERS

Line 1396: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;

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:
1400: l_credit_request_id := p_credit_request_id;

Line 1409: FROM AR_CMGT_CASE_FOLDERS

1405: BEGIN
1406:
1407: SELECT CASE_FOLDER_ID
1408: INTO l_case_folders_id
1409: FROM AR_CMGT_CASE_FOLDERS
1410: WHERE CREDIT_REQUEST_ID = p_credit_request_id;
1411:
1412: EXCEPTION
1413: WHEN OTHERS

Line 1486: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;

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:
1490: l_credit_request_id := p_credit_request_id;

Line 1499: FROM AR_CMGT_CASE_FOLDERS

1495: BEGIN
1496:
1497: SELECT CASE_FOLDER_ID
1498: INTO l_case_folders_id
1499: FROM AR_CMGT_CASE_FOLDERS
1500: WHERE CREDIT_REQUEST_ID = p_credit_request_id;
1501:
1502: EXCEPTION
1503: WHEN OTHERS

Line 1590: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;

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:
1594: l_credit_request_id := p_credit_request_id;

Line 1603: FROM AR_CMGT_CASE_FOLDERS

1599: BEGIN
1600:
1601: SELECT CASE_FOLDER_ID
1602: INTO l_case_folders_id
1603: FROM AR_CMGT_CASE_FOLDERS
1604: WHERE CREDIT_REQUEST_ID = p_credit_request_id;
1605:
1606: EXCEPTION
1607: WHEN OTHERS

Line 1673: l_case_folders_id AR_CMGT_CASE_FOLDERS.CASE_FOLDER_ID%TYPE;

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:
1677: p_resultout :=0;

Line 1684: FROM AR_CMGT_CASE_FOLDERS

1680: BEGIN
1681:
1682: SELECT CASE_FOLDER_ID
1683: INTO l_case_folders_id
1684: FROM AR_CMGT_CASE_FOLDERS
1685: WHERE CREDIT_REQUEST_ID = p_credit_request_id;
1686:
1687: EXCEPTION
1688: WHEN OTHERS