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 476: FROM ar_cmgt_case_folders

472: determine if we are attempting to update one that is literally
473: in progress at the time of the call */
474: SELECT case_folder_id, status
475: INTO l_case_folder_id, l_case_folder_status
476: FROM ar_cmgt_case_folders
477: WHERE credit_request_id = l_credit_request_id
478: AND type = 'CASE';
479:
480: -- Now upadate the records

Line 481: UPDATE ar_cmgt_case_folders

477: WHERE credit_request_id = l_credit_request_id
478: AND type = 'CASE';
479:
480: -- Now upadate the records
481: UPDATE ar_cmgt_case_folders
482: SET STATUS = 'REFRESH',
483: last_updated_by = fnd_global.user_id,
484: last_update_date = sysdate,
485: last_updated = sysdate