DBA Data[Home] [Help]

APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_FLEX_UPGRADE_UTILITIES

Line 1: PACKAGE BODY fnd_flex_upgrade_utilities AS

1: PACKAGE BODY fnd_flex_upgrade_utilities AS
2: /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
3:
4:
5: g_package_name VARCHAR2(10) := 'UPU.';

Line 3847: l_number NUMBER := fnd_flex_upgrade_utilities.g_ret_no_error;

3843: p_param5 IN VARCHAR2,
3844: p_param6 IN VARCHAR2,
3845: x_prompt IN OUT nocopy VARCHAR2)
3846: IS
3847: l_number NUMBER := fnd_flex_upgrade_utilities.g_ret_no_error;
3848: BEGIN
3849: x_prompt := NULL;
3850:
3851: SAVEPOINT afffupg1_savepoint;

Line 3853: l_number := fnd_flex_upgrade_utilities.clone_date_vset

3849: x_prompt := NULL;
3850:
3851: SAVEPOINT afffupg1_savepoint;
3852: IF (p_menu_choice = 4) THEN
3853: l_number := fnd_flex_upgrade_utilities.clone_date_vset
3854: (p_old_value_set_name => p_param1,
3855: p_new_value_set_name => p_param2,
3856: p_session_mode => 'customer_data');
3857: ELSIF (p_menu_choice = 5) THEN

Line 3858: l_number := fnd_flex_upgrade_utilities.upgrade_date_report_parameters

3854: (p_old_value_set_name => p_param1,
3855: p_new_value_set_name => p_param2,
3856: p_session_mode => 'customer_data');
3857: ELSIF (p_menu_choice = 5) THEN
3858: l_number := fnd_flex_upgrade_utilities.upgrade_date_report_parameters
3859: (p_appl_short_name => p_param1,
3860: p_value_set_from => p_param2,
3861: p_value_set_to => p_param3,
3862: p_session_mode => 'customer_data',

Line 3865: l_number := fnd_flex_upgrade_utilities.upgrade_date_dff_segments

3861: p_value_set_to => p_param3,
3862: p_session_mode => 'customer_data',
3863: p_report_name_like => p_param4);
3864: ELSIF (p_menu_choice = 6) THEN
3865: l_number := fnd_flex_upgrade_utilities.upgrade_date_dff_segments
3866: (p_appl_short_name => p_param1,
3867: p_value_set_from => p_param2,
3868: p_value_set_to => p_param3,
3869: p_session_mode => 'customer_data',

Line 3873: l_number := fnd_flex_upgrade_utilities.upgrade_date_kff_segments

3869: p_session_mode => 'customer_data',
3870: p_dff_name_like => p_param4,
3871: p_context_code_like => p_param5);
3872: ELSIF (p_menu_choice = 7) THEN
3873: l_number := fnd_flex_upgrade_utilities.upgrade_date_kff_segments
3874: (p_appl_short_name => p_param1,
3875: p_id_flex_code => p_param2,
3876: p_value_set_from => p_param3,
3877: p_value_set_to => p_param4,

Line 3882: l_number := fnd_flex_upgrade_utilities.upgrade_vset_to_translatable

3878: p_session_mode => 'customer_data',
3879: p_struct_num_like => p_param5,
3880: p_struct_name_like => p_param6);
3881: ELSIF (p_menu_choice = 8) THEN
3882: l_number := fnd_flex_upgrade_utilities.upgrade_vset_to_translatable
3883: (p_vset_name => p_param1,
3884: p_session_mode => 'customer_data');
3885: ELSIF (p_menu_choice IN (1,2,3)) THEN
3886: --

Line 3895: IF (l_number = fnd_flex_upgrade_utilities.g_ret_no_error) THEN

3891: ELSE
3892: x_prompt := 'Invalid menu choice.';
3893: RETURN;
3894: END IF;
3895: IF (l_number = fnd_flex_upgrade_utilities.g_ret_no_error) THEN
3896: x_prompt := 'Successful operation, calling COMMIT.';
3897: COMMIT;
3898: ELSE
3899: x_prompt := 'Unsuccessful operation, calling ROLLBACK.';

Line 3904: END fnd_flex_upgrade_utilities;

3900: ROLLBACK TO afffupg1_savepoint;
3901: END IF;
3902: END;
3903:
3904: END fnd_flex_upgrade_utilities;