DBA Data[Home] [Help]

APPS.PSP_PERIOD_FREQUENCY_API dependencies on PSP_REPORT_PERIOD_FREQUENCY_B

Line 52: l_period_frequency_id psp_report_period_frequency_b.period_frequency_id%TYPE;

48: ) is
49: l_proc varchar2(72) := g_package || 'Create_Period_frequency';
50: --l_period_frequency psp_report_period_frequency_tl.period_frequency%TYPE;
51: l_period_frequency_name psp_report_period_frequency_tl.period_frequency%TYPE;
52: l_period_frequency_id psp_report_period_frequency_b.period_frequency_id%TYPE;
53: l_object_version_number psp_report_period_frequency_b.object_version_number%TYPE;
54: l_api_warning varchar2(250);
55: l_language_code varchar2(30) := p_language_code;
56: --

Line 53: l_object_version_number psp_report_period_frequency_b.object_version_number%TYPE;

49: l_proc varchar2(72) := g_package || 'Create_Period_frequency';
50: --l_period_frequency psp_report_period_frequency_tl.period_frequency%TYPE;
51: l_period_frequency_name psp_report_period_frequency_tl.period_frequency%TYPE;
52: l_period_frequency_id psp_report_period_frequency_b.period_frequency_id%TYPE;
53: l_object_version_number psp_report_period_frequency_b.object_version_number%TYPE;
54: l_api_warning varchar2(250);
55: l_language_code varchar2(30) := p_language_code;
56: --
57: -- cursor to check Duplicate Period Frequency

Line 211: l_object_version_number psp_report_period_frequency_b.object_version_number%TYPE;

207: ,p_api_warning out nocopy varchar2
208: ) is
209: l_proc varchar2(150) := g_package||'Update_Period_Frequency';
210: l_api_warning varchar2(250);
211: l_object_version_number psp_report_period_frequency_b.object_version_number%TYPE;
212: l_language_code varchar2(30);
213: begin
214: hr_utility.set_location('Entering:'|| l_proc, 10);
215: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Line 334: l_object_version_number psp_report_period_frequency_b.object_version_number%TYPE;

330: ,p_object_version_number in out nocopy number
331: ,p_api_warning out nocopy varchar2
332: ) is
333: l_proc varchar2(150) := g_package||'Delete_Period_Frequency';
334: l_object_version_number psp_report_period_frequency_b.object_version_number%TYPE;
335: l_api_warning varchar2(250);
336: begin
337: hr_utility.set_location('Entering:'|| l_proc, 10);
338: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~