APPS.AR_CMGT_CREDIT_REQUEST_API dependencies on AR_CMGT_CASE_FOLDERS

Line 73: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

69: l_credit_request_status VARCHAR2(10);
70: l_char VARCHAR2(1);
71: l_credit_type ar_cmgt_credit_requests.credit_type%type;
72: l_isupdateable VARCHAR2(1) := 'N';
73: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
74: l_case_folder_status ar_cmgt_case_folders.status%type;
75: p_credit_request_rec OCM_CREDIT_REQUEST_UPDATE_PUB.credit_request_rec;
76: l_parent_cr_status VARCHAR2(15);
77: l_value1 VARCHAR2(60);

Line 74: l_case_folder_status ar_cmgt_case_folders.status%type;

70: l_char VARCHAR2(1);
71: l_credit_type ar_cmgt_credit_requests.credit_type%type;
72: l_isupdateable VARCHAR2(1) := 'N';
73: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
74: l_case_folder_status ar_cmgt_case_folders.status%type;
75: p_credit_request_rec OCM_CREDIT_REQUEST_UPDATE_PUB.credit_request_rec;
76: l_parent_cr_status VARCHAR2(15);
77: l_value1 VARCHAR2(60);
78: l_value2 VARCHAR2(60);

Line 461: FROM ar_cmgt_case_folders

457: determine if we are attempting to update one that is literally
458: in progress at the time of the call */
459: SELECT case_folder_id, status
460: INTO l_case_folder_id, l_case_folder_status
461: FROM ar_cmgt_case_folders
462: WHERE credit_request_id = l_credit_request_id
463: AND type = 'CASE';
464:
465: -- Now upadate the records

Line 466: UPDATE ar_cmgt_case_folders

462: WHERE credit_request_id = l_credit_request_id
463: AND type = 'CASE';
464:
465: -- Now upadate the records
466: UPDATE ar_cmgt_case_folders
467: SET STATUS = 'REFRESH',
468: last_updated_by = fnd_global.user_id,
469: last_update_date = sysdate,
470: last_updated = sysdate