2751: ELSIF p_mode = 'REFRESH'
2752: THEN
2753: UPDATE ar_cmgt_cf_dnb_dtls
2754: SET source_key = p_source_key,
2755: last_updated_by = fnd_global.user_id,
2756: last_update_date = sysdate,
2757: last_update_login = fnd_global.login_id
2758: WHERE case_folder_id = p_case_folder_id
2759: AND source_table_name = p_source_table_name
2753: UPDATE ar_cmgt_cf_dnb_dtls
2754: SET source_key = p_source_key,
2755: last_updated_by = fnd_global.user_id,
2756: last_update_date = sysdate,
2757: last_update_login = fnd_global.login_id
2758: WHERE case_folder_id = p_case_folder_id
2759: AND source_table_name = p_source_table_name
2760: AND nvl(source_key,'X') = nvl(p_source_key,'X')
2761: AND nvl(source_key_type,'X') = nvl(p_source_key_type,'X')
2875: limit_currency = p_limit_currency,
2876: exchange_rate_type = p_exchange_rate_type,
2877: credit_classification = p_credit_classification,
2878: last_update_date = SYSDATE,
2879: last_updated_by = fnd_global.user_id,
2880: last_update_login = fnd_global.login_id,
2881: last_updated = sysdate,
2882: credit_request_id = p_credit_request_id
2883: WHERE party_id = p_party_id
2876: exchange_rate_type = p_exchange_rate_type,
2877: credit_classification = p_credit_classification,
2878: last_update_date = SYSDATE,
2879: last_updated_by = fnd_global.user_id,
2880: last_update_login = fnd_global.login_id,
2881: last_updated = sysdate,
2882: credit_request_id = p_credit_request_id
2883: WHERE party_id = p_party_id
2884: AND cust_account_id = p_cust_account_id
5926: -- update credit request with the limit currency
5927: update ar_cmgt_credit_requests
5928: set limit_currency = l_limit_currency,
5929: LAST_UPDATE_DATE = sysdate,
5930: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5931: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
5932: WHERE credit_request_id = p_credit_request_id;
5933: --AND limit_currency IS NULL;
5934:
5927: update ar_cmgt_credit_requests
5928: set limit_currency = l_limit_currency,
5929: LAST_UPDATE_DATE = sysdate,
5930: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5931: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
5932: WHERE credit_request_id = p_credit_request_id;
5933: --AND limit_currency IS NULL;
5934:
5935:
5961: -- Referesh case
5962: UPDATE ar_cmgt_case_folders
5963: set last_updated = SYSDATE,
5964: last_update_date = SYSDATE,
5965: last_updated_by = fnd_global.user_id,
5966: last_update_login = fnd_global.login_id
5967: WHERE case_folder_id = p_case_folder_id;
5968: END IF;
5969:
5962: UPDATE ar_cmgt_case_folders
5963: set last_updated = SYSDATE,
5964: last_update_date = SYSDATE,
5965: last_updated_by = fnd_global.user_id,
5966: last_update_login = fnd_global.login_id
5967: WHERE case_folder_id = p_case_folder_id;
5968: END IF;
5969:
5970:
6653: -- error in generating the score, so update the score to null
6654: p_resultout := 0;
6655: UPDATE ar_cmgt_cf_dtls
6656: SET score = null,
6657: last_updated_by = fnd_global.user_id,
6658: last_update_date = sysdate,
6659: last_update_login = fnd_global.login_id
6660: WHERE case_folder_id = p_case_folder_id;
6661: END IF;
6655: UPDATE ar_cmgt_cf_dtls
6656: SET score = null,
6657: last_updated_by = fnd_global.user_id,
6658: last_update_date = sysdate,
6659: last_update_login = fnd_global.login_id
6660: WHERE case_folder_id = p_case_folder_id;
6661: END IF;
6662: UPDATE ar_cmgt_case_folders
6663: SET status = 'SAVED',
6662: UPDATE ar_cmgt_case_folders
6663: SET status = 'SAVED',
6664: last_updated = SYSDATE,
6665: last_update_date = SYSDATE,
6666: last_updated_by = fnd_global.user_id,
6667: last_update_login = fnd_global.login_id
6668: WHERE case_folder_id = p_case_folder_id
6669: AND type = 'CASE';
6670:
6663: SET status = 'SAVED',
6664: last_updated = SYSDATE,
6665: last_update_date = SYSDATE,
6666: last_updated_by = fnd_global.user_id,
6667: last_update_login = fnd_global.login_id
6668: WHERE case_folder_id = p_case_folder_id
6669: AND type = 'CASE';
6670:
6671: