DBA Data[Home] [Help]

APPS.GCS_ENTRY_PKG dependencies on FND_GLOBAL

Line 88: l_user_id NUMBER := fnd_global.user_id;

84: l_year_to_apply_re NUMBER(4) := NULL;
85: l_event_name VARCHAR2(100) := 'oracle.apps.gcs.transaction.adjustment.update';
86: l_event_key VARCHAR2(100) := NULL;
87: l_parameter_list wf_parameter_list_t;
88: l_user_id NUMBER := fnd_global.user_id;
89: l_login_id NUMBER := fnd_global.login_id;
90: l_wf_itemkey VARCHAR2(100);
91:
92: BEGIN

Line 89: l_login_id NUMBER := fnd_global.login_id;

85: l_event_name VARCHAR2(100) := 'oracle.apps.gcs.transaction.adjustment.update';
86: l_event_key VARCHAR2(100) := NULL;
87: l_parameter_list wf_parameter_list_t;
88: l_user_id NUMBER := fnd_global.user_id;
89: l_login_id NUMBER := fnd_global.login_id;
90: l_wf_itemkey VARCHAR2(100);
91:
92: BEGIN
93:

Line 395: p_user_id => fnd_global.user_id,

391: FOR l_counter IN l_entry_id.FIRST .. l_entry_id.LAST LOOP
392: -- Enhancement for Adjustment Approval Process
393: IF fnd_profile.value('AME_INSTALLED_FLAG') = 'Y' THEN
394: GCS_ADJ_APPROVAL_WF_PKG.create_gcsadj_process(p_entry_id => l_entry_id(l_counter),
395: p_user_id => fnd_global.user_id,
396: p_user_name => fnd_global.user_name,
397: p_orig_entry_id => l_entry_id(l_counter),
398: p_ledger_id => to_number(p_ledger_id),
399: p_cal_period_name => p_cal_period_name,

Line 396: p_user_name => fnd_global.user_name,

392: -- Enhancement for Adjustment Approval Process
393: IF fnd_profile.value('AME_INSTALLED_FLAG') = 'Y' THEN
394: GCS_ADJ_APPROVAL_WF_PKG.create_gcsadj_process(p_entry_id => l_entry_id(l_counter),
395: p_user_id => fnd_global.user_id,
396: p_user_name => fnd_global.user_name,
397: p_orig_entry_id => l_entry_id(l_counter),
398: p_ledger_id => to_number(p_ledger_id),
399: p_cal_period_name => p_cal_period_name,
400: p_conversion_type => p_conversion_type,

Line 657: ' last_updated_by = ' || fnd_global.user_id ||

653: ' description = ' || p_description || ',' || g_nl ||
654: ' entry_name = ' || p_entry_name || ',' || g_nl ||
655: ' category_code = ' || p_category_code || ',' || g_nl ||
656: ' last_update_date = SYSDATE,' || g_nl ||
657: ' last_updated_by = ' || fnd_global.user_id ||
658: ' WHERE entry_id = ' || p_entry_id);
659: END IF;
660: UPDATE gcs_entry_headers
661: SET balance_type_code = p_balance_type_code,

Line 674: last_updated_by = fnd_global.user_id

670: description = p_description,
671: entry_name = p_entry_name,
672: category_code = p_category_code,
673: last_update_date = SYSDATE,
674: last_updated_by = fnd_global.user_id
675: WHERE entry_id = p_entry_id;
676: -- delete old entry lines and flag new lines as loaded
677: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
678: fnd_log.STRING(fnd_log.level_procedure,

Line 899: fnd_global.user_id || ', ' || g_nl || 'SYSDATE, ' ||

895: p_year_to_apply_re || ', ''' || p_description ||
896: ''', ''' || p_entry_type_code || ''', ' || g_nl ||
897: 'NULL, NULL, ''' || p_category_code || ''', ''' || g_nl ||
898: p_process_code || ''', SYSDATE, ' ||
899: fnd_global.user_id || ', ' || g_nl || 'SYSDATE, ' ||
900: fnd_global.user_id || ', ' || fnd_global.login_id ||
901: ', ''' || p_period_init_entry_flag || ''');');
902: END IF;
903: INSERT INTO gcs_entry_headers

Line 900: fnd_global.user_id || ', ' || fnd_global.login_id ||

896: ''', ''' || p_entry_type_code || ''', ' || g_nl ||
897: 'NULL, NULL, ''' || p_category_code || ''', ''' || g_nl ||
898: p_process_code || ''', SYSDATE, ' ||
899: fnd_global.user_id || ', ' || g_nl || 'SYSDATE, ' ||
900: fnd_global.user_id || ', ' || fnd_global.login_id ||
901: ', ''' || p_period_init_entry_flag || ''');');
902: END IF;
903: INSERT INTO gcs_entry_headers
904: (entry_id,

Line 944: fnd_global.user_id,

940: NULL,
941: p_category_code,
942: p_process_code,
943: SYSDATE,
944: fnd_global.user_id,
945: SYSDATE,
946: fnd_global.user_id,
947: fnd_global.login_id,
948: p_period_init_entry_flag);

Line 946: fnd_global.user_id,

942: p_process_code,
943: SYSDATE,
944: fnd_global.user_id,
945: SYSDATE,
946: fnd_global.user_id,
947: fnd_global.login_id,
948: p_period_init_entry_flag);
949: x_retcode := fnd_api.g_ret_sts_success;
950: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

Line 947: fnd_global.login_id,

943: SYSDATE,
944: fnd_global.user_id,
945: SYSDATE,
946: fnd_global.user_id,
947: fnd_global.login_id,
948: p_period_init_entry_flag);
949: x_retcode := fnd_api.g_ret_sts_success;
950: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
951: fnd_log.STRING(fnd_log.level_procedure,

Line 1315: p_user_id => fnd_global.user_id,

1311:
1312: -- Enhancement for Adjustment Approval Process
1313: IF fnd_profile.value('AME_INSTALLED_FLAG') = 'Y' THEN
1314: GCS_ADJ_APPROVAL_WF_PKG.create_gcsadj_process(p_entry_id => l_entry_id,
1315: p_user_id => fnd_global.user_id,
1316: p_user_name => fnd_global.user_name,
1317: p_orig_entry_id => l_orig_entry_id,
1318: p_ledger_id => to_number(p_ledger_id),
1319: p_cal_period_name => p_cal_period_name,

Line 1316: p_user_name => fnd_global.user_name,

1312: -- Enhancement for Adjustment Approval Process
1313: IF fnd_profile.value('AME_INSTALLED_FLAG') = 'Y' THEN
1314: GCS_ADJ_APPROVAL_WF_PKG.create_gcsadj_process(p_entry_id => l_entry_id,
1315: p_user_id => fnd_global.user_id,
1316: p_user_name => fnd_global.user_name,
1317: p_orig_entry_id => l_orig_entry_id,
1318: p_ledger_id => to_number(p_ledger_id),
1319: p_cal_period_name => p_cal_period_name,
1320: p_conversion_type => p_conversion_type,