DBA Data[Home] [Help]

APPS.AR_CMGT_DATA_POINTS_PKG dependencies on FND_GLOBAL

Line 2607: last_updated_by = fnd_global.user_id,

2603: ELSIF p_mode = 'REFRESH'
2604: THEN
2605: UPDATE ar_cmgt_cf_dnb_dtls
2606: SET source_key = p_source_key,
2607: last_updated_by = fnd_global.user_id,
2608: last_update_date = sysdate,
2609: last_update_login = fnd_global.login_id
2610: WHERE case_folder_id = p_case_folder_id
2611: AND source_table_name = p_source_table_name

Line 2609: last_update_login = fnd_global.login_id

2605: UPDATE ar_cmgt_cf_dnb_dtls
2606: SET source_key = p_source_key,
2607: last_updated_by = fnd_global.user_id,
2608: last_update_date = sysdate,
2609: last_update_login = fnd_global.login_id
2610: WHERE case_folder_id = p_case_folder_id
2611: AND source_table_name = p_source_table_name
2612: AND nvl(source_key,'X') = nvl(p_source_key,'X')
2613: AND nvl(source_key_type,'X') = nvl(p_source_key_type,'X')

Line 2730: last_updated_by = fnd_global.user_id,

2726: limit_currency = p_limit_currency,
2727: exchange_rate_type = p_exchange_rate_type,
2728: credit_classification = p_credit_classification,
2729: last_update_date = SYSDATE,
2730: last_updated_by = fnd_global.user_id,
2731: last_update_login = fnd_global.login_id,
2732: last_updated = sysdate,
2733: credit_request_id = p_credit_request_id
2734: WHERE party_id = p_party_id

Line 2731: last_update_login = fnd_global.login_id,

2727: exchange_rate_type = p_exchange_rate_type,
2728: credit_classification = p_credit_classification,
2729: last_update_date = SYSDATE,
2730: last_updated_by = fnd_global.user_id,
2731: last_update_login = fnd_global.login_id,
2732: last_updated = sysdate,
2733: credit_request_id = p_credit_request_id
2734: WHERE party_id = p_party_id
2735: AND cust_account_id = p_cust_account_id

Line 5822: LAST_UPDATED_BY = FND_GLOBAL.user_id,

5818: -- update credit request with the limit currency
5819: update ar_cmgt_credit_requests
5820: set limit_currency = l_limit_currency,
5821: LAST_UPDATE_DATE = sysdate,
5822: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5823: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
5824: WHERE credit_request_id = p_credit_request_id;
5825: --AND limit_currency IS NULL;
5826:

Line 5823: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

5819: update ar_cmgt_credit_requests
5820: set limit_currency = l_limit_currency,
5821: LAST_UPDATE_DATE = sysdate,
5822: LAST_UPDATED_BY = FND_GLOBAL.user_id,
5823: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
5824: WHERE credit_request_id = p_credit_request_id;
5825: --AND limit_currency IS NULL;
5826:
5827:

Line 5857: last_updated_by = fnd_global.user_id,

5853: -- Referesh case
5854: UPDATE ar_cmgt_case_folders
5855: set last_updated = SYSDATE,
5856: last_update_date = SYSDATE,
5857: last_updated_by = fnd_global.user_id,
5858: last_update_login = fnd_global.login_id
5859: WHERE case_folder_id = p_case_folder_id;
5860: END IF;
5861:

Line 5858: last_update_login = fnd_global.login_id

5854: UPDATE ar_cmgt_case_folders
5855: set last_updated = SYSDATE,
5856: last_update_date = SYSDATE,
5857: last_updated_by = fnd_global.user_id,
5858: last_update_login = fnd_global.login_id
5859: WHERE case_folder_id = p_case_folder_id;
5860: END IF;
5861:
5862:

Line 6387: last_updated_by = fnd_global.user_id,

6383: -- error in generating the score, so update the score to null
6384: p_resultout := 0;
6385: UPDATE ar_cmgt_cf_dtls
6386: SET score = null,
6387: last_updated_by = fnd_global.user_id,
6388: last_update_date = sysdate,
6389: last_update_login = fnd_global.login_id
6390: WHERE case_folder_id = p_case_folder_id;
6391: END IF;

Line 6389: last_update_login = fnd_global.login_id

6385: UPDATE ar_cmgt_cf_dtls
6386: SET score = null,
6387: last_updated_by = fnd_global.user_id,
6388: last_update_date = sysdate,
6389: last_update_login = fnd_global.login_id
6390: WHERE case_folder_id = p_case_folder_id;
6391: END IF;
6392: UPDATE ar_cmgt_case_folders
6393: SET status = 'SAVED',

Line 6396: last_updated_by = fnd_global.user_id,

6392: UPDATE ar_cmgt_case_folders
6393: SET status = 'SAVED',
6394: last_updated = SYSDATE,
6395: last_update_date = SYSDATE,
6396: last_updated_by = fnd_global.user_id,
6397: last_update_login = fnd_global.login_id
6398: WHERE case_folder_id = p_case_folder_id
6399: AND type = 'CASE';
6400:

Line 6397: last_update_login = fnd_global.login_id

6393: SET status = 'SAVED',
6394: last_updated = SYSDATE,
6395: last_update_date = SYSDATE,
6396: last_updated_by = fnd_global.user_id,
6397: last_update_login = fnd_global.login_id
6398: WHERE case_folder_id = p_case_folder_id
6399: AND type = 'CASE';
6400:
6401: