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_BANK_REF_DATA

Line 1243: l_data_point_id ar_cmgt_bank_ref_data.DATAPOINT_ID%TYPE;

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:
1247: CURSOR bank_data IS

Line 1244: l_next_val ar_cmgt_bank_ref_data.DATAPOINT_ID%TYPE;

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:
1247: CURSOR bank_data IS
1248: SELECT DATAPOINT_ID

Line 1249: FROM ar_cmgt_bank_ref_data

1245: l_processing_flag VARCHAR2(1);
1246:
1247: CURSOR bank_data IS
1248: SELECT DATAPOINT_ID
1249: FROM ar_cmgt_bank_ref_data
1250: WHERE CREDIT_REQUEST_ID = p_parnt_credit_req_id;
1251:
1252: BEGIN
1253: l_credit_request_id := p_credit_request_id;

Line 1285: SELECT AR_CMGT_BANK_REF_DATA_S.NEXTVAL

1281: BEGIN
1282:
1283: l_data_point_id := bank_data_rec.DATAPOINT_ID;
1284:
1285: SELECT AR_CMGT_BANK_REF_DATA_S.NEXTVAL
1286: INTO l_next_val FROM dual;
1287:
1288: INSERT INTO ar_cmgt_bank_ref_data
1289: (DATAPOINT_ID,

Line 1288: INSERT INTO ar_cmgt_bank_ref_data

1284:
1285: SELECT AR_CMGT_BANK_REF_DATA_S.NEXTVAL
1286: INTO l_next_val FROM dual;
1287:
1288: INSERT INTO ar_cmgt_bank_ref_data
1289: (DATAPOINT_ID,
1290: CREDIT_REQUEST_ID,
1291: LAST_UPDATE_DATE,
1292: LAST_UPDATED_BY,

Line 1333: FROM ar_cmgt_bank_ref_data

1329: URL,
1330: BANK_ROUTING_NUMBER,
1331: nvl(l_case_folders_id,-99),
1332: NOTES
1333: FROM ar_cmgt_bank_ref_data
1334: WHERE CREDIT_REQUEST_ID = p_parnt_credit_req_id
1335: AND DATAPOINT_ID = l_data_point_id);
1336:
1337: -- duplicate the account details.