DBA Data[Home] [Help]

APPS.AR_CMGT_DATA_POINTS_PKG dependencies on FND_GLOBAL

Line 2755: last_updated_by = fnd_global.user_id,

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

Line 2757: last_update_login = fnd_global.login_id

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')

Line 2879: last_updated_by = fnd_global.user_id,

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

Line 2880: last_update_login = fnd_global.login_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

Line 5930: LAST_UPDATED_BY = FND_GLOBAL.user_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:

Line 5931: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

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:

Line 5965: last_updated_by = fnd_global.user_id,

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:

Line 5966: last_update_login = fnd_global.login_id

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:

Line 6657: last_updated_by = fnd_global.user_id,

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;

Line 6659: last_update_login = fnd_global.login_id

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',

Line 6666: last_updated_by = fnd_global.user_id,

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:

Line 6667: last_update_login = fnd_global.login_id

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: