DBA Data[Home] [Help]

APPS.OKL_COPY_CONTRACT_PVT dependencies on FND_GLOBAL

Line 42: l_created_by NUMBER := fnd_global.user_id;

38:
39: --Bug# 16425139 : Changing the below global variables to local variables
40: -- within copy_lease_contract_new and copy_var_int_rate_params
41: /*
42: l_created_by NUMBER := fnd_global.user_id;
43: l_last_updated_by NUMBER := fnd_global.user_id;
44: l_last_update_login NUMBER := fnd_global.login_id;
45: */
46:

Line 43: l_last_updated_by NUMBER := fnd_global.user_id;

39: --Bug# 16425139 : Changing the below global variables to local variables
40: -- within copy_lease_contract_new and copy_var_int_rate_params
41: /*
42: l_created_by NUMBER := fnd_global.user_id;
43: l_last_updated_by NUMBER := fnd_global.user_id;
44: l_last_update_login NUMBER := fnd_global.login_id;
45: */
46:
47: l_contract_exists BOOLEAN := FALSE;

Line 44: l_last_update_login NUMBER := fnd_global.login_id;

40: -- within copy_lease_contract_new and copy_var_int_rate_params
41: /*
42: l_created_by NUMBER := fnd_global.user_id;
43: l_last_updated_by NUMBER := fnd_global.user_id;
44: l_last_update_login NUMBER := fnd_global.login_id;
45: */
46:
47: l_contract_exists BOOLEAN := FALSE;
48:

Line 4882: l_created_by NUMBER := fnd_global.user_id;

4878: l_rebook_date DATE; */
4879: l_prev_counter NUMBER;
4880:
4881: --Bug# 16425139: Changing the global variables to local variables
4882: l_created_by NUMBER := fnd_global.user_id;
4883: l_last_updated_by NUMBER := fnd_global.user_id;
4884: l_last_update_login NUMBER := fnd_global.login_id;
4885:
4886: CURSOR C30(p_id NUMBER) IS

Line 4883: l_last_updated_by NUMBER := fnd_global.user_id;

4879: l_prev_counter NUMBER;
4880:
4881: --Bug# 16425139: Changing the global variables to local variables
4882: l_created_by NUMBER := fnd_global.user_id;
4883: l_last_updated_by NUMBER := fnd_global.user_id;
4884: l_last_update_login NUMBER := fnd_global.login_id;
4885:
4886: CURSOR C30(p_id NUMBER) IS
4887: SELECT

Line 4884: l_last_update_login NUMBER := fnd_global.login_id;

4880:
4881: --Bug# 16425139: Changing the global variables to local variables
4882: l_created_by NUMBER := fnd_global.user_id;
4883: l_last_updated_by NUMBER := fnd_global.user_id;
4884: l_last_update_login NUMBER := fnd_global.login_id;
4885:
4886: CURSOR C30(p_id NUMBER) IS
4887: SELECT
4888: a.khr_id, a.parameter_type_code, a.effective_from_date,

Line 7310: l_created_by NUMBER := fnd_global.user_id;

7306: l_sts_code okc_k_headers_b.sts_code%TYPE;
7307: l_sts_code_orig okc_k_headers_b.sts_code%TYPE;
7308:
7309: --Bug# 16425139: Changing the global variables to local variables
7310: l_created_by NUMBER := fnd_global.user_id;
7311: l_last_updated_by NUMBER := fnd_global.user_id;
7312: l_last_update_login NUMBER := fnd_global.login_id;
7313:
7314: PROCEDURE validate_currency_code(

Line 7311: l_last_updated_by NUMBER := fnd_global.user_id;

7307: l_sts_code_orig okc_k_headers_b.sts_code%TYPE;
7308:
7309: --Bug# 16425139: Changing the global variables to local variables
7310: l_created_by NUMBER := fnd_global.user_id;
7311: l_last_updated_by NUMBER := fnd_global.user_id;
7312: l_last_update_login NUMBER := fnd_global.login_id;
7313:
7314: PROCEDURE validate_currency_code(
7315: x_return_status OUT NOCOPY VARCHAR2,

Line 7312: l_last_update_login NUMBER := fnd_global.login_id;

7308:
7309: --Bug# 16425139: Changing the global variables to local variables
7310: l_created_by NUMBER := fnd_global.user_id;
7311: l_last_updated_by NUMBER := fnd_global.user_id;
7312: l_last_update_login NUMBER := fnd_global.login_id;
7313:
7314: PROCEDURE validate_currency_code(
7315: x_return_status OUT NOCOPY VARCHAR2,
7316: p_ccy_code IN okc_k_headers_b.currency_code%TYPE) IS

Line 20890: --FND_GLOBAL.SECURITY_GROUP_ID

20886: ) VALUES (
20887: l_copied_id, 0, 1,
20888: 1, l_created_by, SYSDATE,
20889: l_last_updated_by, SYSDATE, l_last_update_login
20890: --FND_GLOBAL.SECURITY_GROUP_ID
20891: );
20892: EXCEPTION WHEN OTHERS THEN
20893: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
20894: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);