70: ) is
71: --
72: -- Declare cursors and local variables
73: --
74: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
75: l_business_group_id per_pay_bases.business_group_id%TYPE;
76: l_name per_pay_bases.name%TYPE;
77: l_proc varchar2(72) := g_package||'create_salary_basis';
78: l_object_version_number per_pay_bases.object_version_number%TYPE;
71: --
72: -- Declare cursors and local variables
73: --
74: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
75: l_business_group_id per_pay_bases.business_group_id%TYPE;
76: l_name per_pay_bases.name%TYPE;
77: l_proc varchar2(72) := g_package||'create_salary_basis';
78: l_object_version_number per_pay_bases.object_version_number%TYPE;
79: l_input_value_id per_pay_bases.input_value_id%TYPE;
72: -- Declare cursors and local variables
73: --
74: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
75: l_business_group_id per_pay_bases.business_group_id%TYPE;
76: l_name per_pay_bases.name%TYPE;
77: l_proc varchar2(72) := g_package||'create_salary_basis';
78: l_object_version_number per_pay_bases.object_version_number%TYPE;
79: l_input_value_id per_pay_bases.input_value_id%TYPE;
80: l_rate_id per_pay_bases.rate_id%TYPE;
74: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
75: l_business_group_id per_pay_bases.business_group_id%TYPE;
76: l_name per_pay_bases.name%TYPE;
77: l_proc varchar2(72) := g_package||'create_salary_basis';
78: l_object_version_number per_pay_bases.object_version_number%TYPE;
79: l_input_value_id per_pay_bases.input_value_id%TYPE;
80: l_rate_id per_pay_bases.rate_id%TYPE;
81: l_pay_basis per_pay_bases.pay_basis%TYPE;
82: l_rate_basis per_pay_bases.rate_basis%TYPE;
75: l_business_group_id per_pay_bases.business_group_id%TYPE;
76: l_name per_pay_bases.name%TYPE;
77: l_proc varchar2(72) := g_package||'create_salary_basis';
78: l_object_version_number per_pay_bases.object_version_number%TYPE;
79: l_input_value_id per_pay_bases.input_value_id%TYPE;
80: l_rate_id per_pay_bases.rate_id%TYPE;
81: l_pay_basis per_pay_bases.pay_basis%TYPE;
82: l_rate_basis per_pay_bases.rate_basis%TYPE;
83: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
76: l_name per_pay_bases.name%TYPE;
77: l_proc varchar2(72) := g_package||'create_salary_basis';
78: l_object_version_number per_pay_bases.object_version_number%TYPE;
79: l_input_value_id per_pay_bases.input_value_id%TYPE;
80: l_rate_id per_pay_bases.rate_id%TYPE;
81: l_pay_basis per_pay_bases.pay_basis%TYPE;
82: l_rate_basis per_pay_bases.rate_basis%TYPE;
83: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
84: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
77: l_proc varchar2(72) := g_package||'create_salary_basis';
78: l_object_version_number per_pay_bases.object_version_number%TYPE;
79: l_input_value_id per_pay_bases.input_value_id%TYPE;
80: l_rate_id per_pay_bases.rate_id%TYPE;
81: l_pay_basis per_pay_bases.pay_basis%TYPE;
82: l_rate_basis per_pay_bases.rate_basis%TYPE;
83: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
84: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
85: --
78: l_object_version_number per_pay_bases.object_version_number%TYPE;
79: l_input_value_id per_pay_bases.input_value_id%TYPE;
80: l_rate_id per_pay_bases.rate_id%TYPE;
81: l_pay_basis per_pay_bases.pay_basis%TYPE;
82: l_rate_basis per_pay_bases.rate_basis%TYPE;
83: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
84: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
85: --
86: begin
79: l_input_value_id per_pay_bases.input_value_id%TYPE;
80: l_rate_id per_pay_bases.rate_id%TYPE;
81: l_pay_basis per_pay_bases.pay_basis%TYPE;
82: l_rate_basis per_pay_bases.rate_basis%TYPE;
83: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
84: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
85: --
86: begin
87: --
80: l_rate_id per_pay_bases.rate_id%TYPE;
81: l_pay_basis per_pay_bases.pay_basis%TYPE;
82: l_rate_basis per_pay_bases.rate_basis%TYPE;
83: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
84: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
85: --
86: begin
87: --
88: hr_utility.set_location('Entering:'|| l_proc, 10);
420: --
421: -- Declare cursors and local variables
422: --
423: --
424: l_object_version_number per_pay_bases.object_version_number%TYPE;
425: l_api_updating boolean;
426: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
427: l_business_group_id per_pay_bases.business_group_id%TYPE;
428: l_name per_pay_bases.name%TYPE;
422: --
423: --
424: l_object_version_number per_pay_bases.object_version_number%TYPE;
425: l_api_updating boolean;
426: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
427: l_business_group_id per_pay_bases.business_group_id%TYPE;
428: l_name per_pay_bases.name%TYPE;
429: l_proc varchar2(72) := g_package||'update_salary_basis';
430: l_input_value_id per_pay_bases.input_value_id%TYPE;
423: --
424: l_object_version_number per_pay_bases.object_version_number%TYPE;
425: l_api_updating boolean;
426: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
427: l_business_group_id per_pay_bases.business_group_id%TYPE;
428: l_name per_pay_bases.name%TYPE;
429: l_proc varchar2(72) := g_package||'update_salary_basis';
430: l_input_value_id per_pay_bases.input_value_id%TYPE;
431: l_rate_id per_pay_bases.rate_id%TYPE;
424: l_object_version_number per_pay_bases.object_version_number%TYPE;
425: l_api_updating boolean;
426: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
427: l_business_group_id per_pay_bases.business_group_id%TYPE;
428: l_name per_pay_bases.name%TYPE;
429: l_proc varchar2(72) := g_package||'update_salary_basis';
430: l_input_value_id per_pay_bases.input_value_id%TYPE;
431: l_rate_id per_pay_bases.rate_id%TYPE;
432: l_pay_basis per_pay_bases.pay_basis%TYPE;
426: l_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
427: l_business_group_id per_pay_bases.business_group_id%TYPE;
428: l_name per_pay_bases.name%TYPE;
429: l_proc varchar2(72) := g_package||'update_salary_basis';
430: l_input_value_id per_pay_bases.input_value_id%TYPE;
431: l_rate_id per_pay_bases.rate_id%TYPE;
432: l_pay_basis per_pay_bases.pay_basis%TYPE;
433: l_rate_basis per_pay_bases.rate_basis%TYPE;
434: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
427: l_business_group_id per_pay_bases.business_group_id%TYPE;
428: l_name per_pay_bases.name%TYPE;
429: l_proc varchar2(72) := g_package||'update_salary_basis';
430: l_input_value_id per_pay_bases.input_value_id%TYPE;
431: l_rate_id per_pay_bases.rate_id%TYPE;
432: l_pay_basis per_pay_bases.pay_basis%TYPE;
433: l_rate_basis per_pay_bases.rate_basis%TYPE;
434: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
435: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
428: l_name per_pay_bases.name%TYPE;
429: l_proc varchar2(72) := g_package||'update_salary_basis';
430: l_input_value_id per_pay_bases.input_value_id%TYPE;
431: l_rate_id per_pay_bases.rate_id%TYPE;
432: l_pay_basis per_pay_bases.pay_basis%TYPE;
433: l_rate_basis per_pay_bases.rate_basis%TYPE;
434: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
435: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
436: --
429: l_proc varchar2(72) := g_package||'update_salary_basis';
430: l_input_value_id per_pay_bases.input_value_id%TYPE;
431: l_rate_id per_pay_bases.rate_id%TYPE;
432: l_pay_basis per_pay_bases.pay_basis%TYPE;
433: l_rate_basis per_pay_bases.rate_basis%TYPE;
434: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
435: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
436: --
437: --
430: l_input_value_id per_pay_bases.input_value_id%TYPE;
431: l_rate_id per_pay_bases.rate_id%TYPE;
432: l_pay_basis per_pay_bases.pay_basis%TYPE;
433: l_rate_basis per_pay_bases.rate_basis%TYPE;
434: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
435: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
436: --
437: --
438: -- Declare cursors
431: l_rate_id per_pay_bases.rate_id%TYPE;
432: l_pay_basis per_pay_bases.pay_basis%TYPE;
433: l_rate_basis per_pay_bases.rate_basis%TYPE;
434: l_pay_annualization_factor per_pay_bases.pay_annualization_factor%TYPE;
435: l_grade_annualization_factor per_pay_bases.grade_annualization_factor%TYPE;
436: --
437: --
438: -- Declare cursors
439: --
548:
549: --
550: select business_group_id
551: into l_business_group_id
552: from per_pay_bases
553: where pay_basis_id = p_pay_basis_id;
554:
555: per_ppb_upd.upd
556: (p_pay_basis_id => p_pay_basis_id