DBA Data[Home] [Help]

APPS.PQH_PSB_INTERFACE_API dependencies on HR_API

Line 34: ,p_budget_id in number default hr_api.g_number

30: procedure update_budget_version
31: (
32: p_validate in boolean default false
33: ,p_budget_version_id in number
34: ,p_budget_id in number default hr_api.g_number
35: ,p_version_number in number default hr_api.g_number
36: ,p_date_from in date default hr_api.g_date
37: ,p_date_to in date default hr_api.g_date
38: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2

Line 35: ,p_version_number in number default hr_api.g_number

31: (
32: p_validate in boolean default false
33: ,p_budget_version_id in number
34: ,p_budget_id in number default hr_api.g_number
35: ,p_version_number in number default hr_api.g_number
36: ,p_date_from in date default hr_api.g_date
37: ,p_date_to in date default hr_api.g_date
38: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
39: ,p_gl_status in varchar2 default hr_api.g_varchar2

Line 36: ,p_date_from in date default hr_api.g_date

32: p_validate in boolean default false
33: ,p_budget_version_id in number
34: ,p_budget_id in number default hr_api.g_number
35: ,p_version_number in number default hr_api.g_number
36: ,p_date_from in date default hr_api.g_date
37: ,p_date_to in date default hr_api.g_date
38: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
39: ,p_gl_status in varchar2 default hr_api.g_varchar2
40: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2

Line 37: ,p_date_to in date default hr_api.g_date

33: ,p_budget_version_id in number
34: ,p_budget_id in number default hr_api.g_number
35: ,p_version_number in number default hr_api.g_number
36: ,p_date_from in date default hr_api.g_date
37: ,p_date_to in date default hr_api.g_date
38: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
39: ,p_gl_status in varchar2 default hr_api.g_varchar2
40: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
41: ,p_object_version_number in out nocopy number

Line 38: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2

34: ,p_budget_id in number default hr_api.g_number
35: ,p_version_number in number default hr_api.g_number
36: ,p_date_from in date default hr_api.g_date
37: ,p_date_to in date default hr_api.g_date
38: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
39: ,p_gl_status in varchar2 default hr_api.g_varchar2
40: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
41: ,p_object_version_number in out nocopy number
42: ,p_budget_unit1_value in number default hr_api.g_number

Line 39: ,p_gl_status in varchar2 default hr_api.g_varchar2

35: ,p_version_number in number default hr_api.g_number
36: ,p_date_from in date default hr_api.g_date
37: ,p_date_to in date default hr_api.g_date
38: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
39: ,p_gl_status in varchar2 default hr_api.g_varchar2
40: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
41: ,p_object_version_number in out nocopy number
42: ,p_budget_unit1_value in number default hr_api.g_number
43: ,p_budget_unit2_value in number default hr_api.g_number

Line 40: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2

36: ,p_date_from in date default hr_api.g_date
37: ,p_date_to in date default hr_api.g_date
38: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
39: ,p_gl_status in varchar2 default hr_api.g_varchar2
40: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
41: ,p_object_version_number in out nocopy number
42: ,p_budget_unit1_value in number default hr_api.g_number
43: ,p_budget_unit2_value in number default hr_api.g_number
44: ,p_budget_unit3_value in number default hr_api.g_number

Line 42: ,p_budget_unit1_value in number default hr_api.g_number

38: ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
39: ,p_gl_status in varchar2 default hr_api.g_varchar2
40: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
41: ,p_object_version_number in out nocopy number
42: ,p_budget_unit1_value in number default hr_api.g_number
43: ,p_budget_unit2_value in number default hr_api.g_number
44: ,p_budget_unit3_value in number default hr_api.g_number
45: ,p_budget_unit1_available in number default hr_api.g_number
46: ,p_budget_unit2_available in number default hr_api.g_number

Line 43: ,p_budget_unit2_value in number default hr_api.g_number

39: ,p_gl_status in varchar2 default hr_api.g_varchar2
40: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
41: ,p_object_version_number in out nocopy number
42: ,p_budget_unit1_value in number default hr_api.g_number
43: ,p_budget_unit2_value in number default hr_api.g_number
44: ,p_budget_unit3_value in number default hr_api.g_number
45: ,p_budget_unit1_available in number default hr_api.g_number
46: ,p_budget_unit2_available in number default hr_api.g_number
47: ,p_budget_unit3_available in number default hr_api.g_number

Line 44: ,p_budget_unit3_value in number default hr_api.g_number

40: ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
41: ,p_object_version_number in out nocopy number
42: ,p_budget_unit1_value in number default hr_api.g_number
43: ,p_budget_unit2_value in number default hr_api.g_number
44: ,p_budget_unit3_value in number default hr_api.g_number
45: ,p_budget_unit1_available in number default hr_api.g_number
46: ,p_budget_unit2_available in number default hr_api.g_number
47: ,p_budget_unit3_available in number default hr_api.g_number
48: ,p_effective_date in date

Line 45: ,p_budget_unit1_available in number default hr_api.g_number

41: ,p_object_version_number in out nocopy number
42: ,p_budget_unit1_value in number default hr_api.g_number
43: ,p_budget_unit2_value in number default hr_api.g_number
44: ,p_budget_unit3_value in number default hr_api.g_number
45: ,p_budget_unit1_available in number default hr_api.g_number
46: ,p_budget_unit2_available in number default hr_api.g_number
47: ,p_budget_unit3_available in number default hr_api.g_number
48: ,p_effective_date in date
49: );

Line 46: ,p_budget_unit2_available in number default hr_api.g_number

42: ,p_budget_unit1_value in number default hr_api.g_number
43: ,p_budget_unit2_value in number default hr_api.g_number
44: ,p_budget_unit3_value in number default hr_api.g_number
45: ,p_budget_unit1_available in number default hr_api.g_number
46: ,p_budget_unit2_available in number default hr_api.g_number
47: ,p_budget_unit3_available in number default hr_api.g_number
48: ,p_effective_date in date
49: );
50: -- ----------------------------------------------------------------------------

Line 47: ,p_budget_unit3_available in number default hr_api.g_number

43: ,p_budget_unit2_value in number default hr_api.g_number
44: ,p_budget_unit3_value in number default hr_api.g_number
45: ,p_budget_unit1_available in number default hr_api.g_number
46: ,p_budget_unit2_available in number default hr_api.g_number
47: ,p_budget_unit3_available in number default hr_api.g_number
48: ,p_effective_date in date
49: );
50: -- ----------------------------------------------------------------------------
51: -- |------------------------< create_budget_element >------------------------|

Line 69: ,p_budget_set_id in number default hr_api.g_number

65: procedure update_budget_element
66: (
67: p_validate in boolean default false
68: ,p_budget_element_id in number
69: ,p_budget_set_id in number default hr_api.g_number
70: ,p_element_type_id in number default hr_api.g_number
71: ,p_distribution_percentage in number default hr_api.g_number
72: ,p_object_version_number in out nocopy number
73: );

Line 70: ,p_element_type_id in number default hr_api.g_number

66: (
67: p_validate in boolean default false
68: ,p_budget_element_id in number
69: ,p_budget_set_id in number default hr_api.g_number
70: ,p_element_type_id in number default hr_api.g_number
71: ,p_distribution_percentage in number default hr_api.g_number
72: ,p_object_version_number in out nocopy number
73: );
74: -- ----------------------------------------------------------------------------

Line 71: ,p_distribution_percentage in number default hr_api.g_number

67: p_validate in boolean default false
68: ,p_budget_element_id in number
69: ,p_budget_set_id in number default hr_api.g_number
70: ,p_element_type_id in number default hr_api.g_number
71: ,p_distribution_percentage in number default hr_api.g_number
72: ,p_object_version_number in out nocopy number
73: );
74: -- ----------------------------------------------------------------------------
75: -- |------------------------< create_budget_fund_src >------------------------|

Line 98: ,p_budget_element_id in number default hr_api.g_number

94: procedure update_budget_fund_src
95: (
96: p_validate in boolean default false
97: ,p_budget_fund_src_id in number
98: ,p_budget_element_id in number default hr_api.g_number
99: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
100: ,p_project_id in number default hr_api.g_number
101: ,p_award_id in number default hr_api.g_number
102: ,p_task_id in number default hr_api.g_number

Line 99: ,p_cost_allocation_keyflex_id in number default hr_api.g_number

95: (
96: p_validate in boolean default false
97: ,p_budget_fund_src_id in number
98: ,p_budget_element_id in number default hr_api.g_number
99: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
100: ,p_project_id in number default hr_api.g_number
101: ,p_award_id in number default hr_api.g_number
102: ,p_task_id in number default hr_api.g_number
103: ,p_expenditure_type in varchar2 default hr_api.g_varchar2

Line 100: ,p_project_id in number default hr_api.g_number

96: p_validate in boolean default false
97: ,p_budget_fund_src_id in number
98: ,p_budget_element_id in number default hr_api.g_number
99: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
100: ,p_project_id in number default hr_api.g_number
101: ,p_award_id in number default hr_api.g_number
102: ,p_task_id in number default hr_api.g_number
103: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
104: ,p_organization_id in number default hr_api.g_number

Line 101: ,p_award_id in number default hr_api.g_number

97: ,p_budget_fund_src_id in number
98: ,p_budget_element_id in number default hr_api.g_number
99: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
100: ,p_project_id in number default hr_api.g_number
101: ,p_award_id in number default hr_api.g_number
102: ,p_task_id in number default hr_api.g_number
103: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
104: ,p_organization_id in number default hr_api.g_number
105: ,p_distribution_percentage in number default hr_api.g_number

Line 102: ,p_task_id in number default hr_api.g_number

98: ,p_budget_element_id in number default hr_api.g_number
99: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
100: ,p_project_id in number default hr_api.g_number
101: ,p_award_id in number default hr_api.g_number
102: ,p_task_id in number default hr_api.g_number
103: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
104: ,p_organization_id in number default hr_api.g_number
105: ,p_distribution_percentage in number default hr_api.g_number
106: ,p_object_version_number in out nocopy number

Line 103: ,p_expenditure_type in varchar2 default hr_api.g_varchar2

99: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
100: ,p_project_id in number default hr_api.g_number
101: ,p_award_id in number default hr_api.g_number
102: ,p_task_id in number default hr_api.g_number
103: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
104: ,p_organization_id in number default hr_api.g_number
105: ,p_distribution_percentage in number default hr_api.g_number
106: ,p_object_version_number in out nocopy number
107: );

Line 104: ,p_organization_id in number default hr_api.g_number

100: ,p_project_id in number default hr_api.g_number
101: ,p_award_id in number default hr_api.g_number
102: ,p_task_id in number default hr_api.g_number
103: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
104: ,p_organization_id in number default hr_api.g_number
105: ,p_distribution_percentage in number default hr_api.g_number
106: ,p_object_version_number in out nocopy number
107: );
108: -- ----------------------------------------------------------------------------

Line 105: ,p_distribution_percentage in number default hr_api.g_number

101: ,p_award_id in number default hr_api.g_number
102: ,p_task_id in number default hr_api.g_number
103: ,p_expenditure_type in varchar2 default hr_api.g_varchar2
104: ,p_organization_id in number default hr_api.g_number
105: ,p_distribution_percentage in number default hr_api.g_number
106: ,p_object_version_number in out nocopy number
107: );
108: -- ----------------------------------------------------------------------------
109: -- |------------------------< create_budget_period >------------------------|

Line 139: ,p_budget_detail_id in number default hr_api.g_number

135: procedure update_budget_period
136: (
137: p_validate in boolean default false
138: ,p_budget_period_id in number
139: ,p_budget_detail_id in number default hr_api.g_number
140: ,p_start_time_period_id in number default hr_api.g_number
141: ,p_end_time_period_id in number default hr_api.g_number
142: ,p_budget_unit1_percent in number default hr_api.g_number
143: ,p_budget_unit2_percent in number default hr_api.g_number

Line 140: ,p_start_time_period_id in number default hr_api.g_number

136: (
137: p_validate in boolean default false
138: ,p_budget_period_id in number
139: ,p_budget_detail_id in number default hr_api.g_number
140: ,p_start_time_period_id in number default hr_api.g_number
141: ,p_end_time_period_id in number default hr_api.g_number
142: ,p_budget_unit1_percent in number default hr_api.g_number
143: ,p_budget_unit2_percent in number default hr_api.g_number
144: ,p_budget_unit3_percent in number default hr_api.g_number

Line 141: ,p_end_time_period_id in number default hr_api.g_number

137: p_validate in boolean default false
138: ,p_budget_period_id in number
139: ,p_budget_detail_id in number default hr_api.g_number
140: ,p_start_time_period_id in number default hr_api.g_number
141: ,p_end_time_period_id in number default hr_api.g_number
142: ,p_budget_unit1_percent in number default hr_api.g_number
143: ,p_budget_unit2_percent in number default hr_api.g_number
144: ,p_budget_unit3_percent in number default hr_api.g_number
145: ,p_budget_unit1_value in number default hr_api.g_number

Line 142: ,p_budget_unit1_percent in number default hr_api.g_number

138: ,p_budget_period_id in number
139: ,p_budget_detail_id in number default hr_api.g_number
140: ,p_start_time_period_id in number default hr_api.g_number
141: ,p_end_time_period_id in number default hr_api.g_number
142: ,p_budget_unit1_percent in number default hr_api.g_number
143: ,p_budget_unit2_percent in number default hr_api.g_number
144: ,p_budget_unit3_percent in number default hr_api.g_number
145: ,p_budget_unit1_value in number default hr_api.g_number
146: ,p_budget_unit2_value in number default hr_api.g_number

Line 143: ,p_budget_unit2_percent in number default hr_api.g_number

139: ,p_budget_detail_id in number default hr_api.g_number
140: ,p_start_time_period_id in number default hr_api.g_number
141: ,p_end_time_period_id in number default hr_api.g_number
142: ,p_budget_unit1_percent in number default hr_api.g_number
143: ,p_budget_unit2_percent in number default hr_api.g_number
144: ,p_budget_unit3_percent in number default hr_api.g_number
145: ,p_budget_unit1_value in number default hr_api.g_number
146: ,p_budget_unit2_value in number default hr_api.g_number
147: ,p_budget_unit3_value in number default hr_api.g_number

Line 144: ,p_budget_unit3_percent in number default hr_api.g_number

140: ,p_start_time_period_id in number default hr_api.g_number
141: ,p_end_time_period_id in number default hr_api.g_number
142: ,p_budget_unit1_percent in number default hr_api.g_number
143: ,p_budget_unit2_percent in number default hr_api.g_number
144: ,p_budget_unit3_percent in number default hr_api.g_number
145: ,p_budget_unit1_value in number default hr_api.g_number
146: ,p_budget_unit2_value in number default hr_api.g_number
147: ,p_budget_unit3_value in number default hr_api.g_number
148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2

Line 145: ,p_budget_unit1_value in number default hr_api.g_number

141: ,p_end_time_period_id in number default hr_api.g_number
142: ,p_budget_unit1_percent in number default hr_api.g_number
143: ,p_budget_unit2_percent in number default hr_api.g_number
144: ,p_budget_unit3_percent in number default hr_api.g_number
145: ,p_budget_unit1_value in number default hr_api.g_number
146: ,p_budget_unit2_value in number default hr_api.g_number
147: ,p_budget_unit3_value in number default hr_api.g_number
148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

Line 146: ,p_budget_unit2_value in number default hr_api.g_number

142: ,p_budget_unit1_percent in number default hr_api.g_number
143: ,p_budget_unit2_percent in number default hr_api.g_number
144: ,p_budget_unit3_percent in number default hr_api.g_number
145: ,p_budget_unit1_value in number default hr_api.g_number
146: ,p_budget_unit2_value in number default hr_api.g_number
147: ,p_budget_unit3_value in number default hr_api.g_number
148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
150: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

Line 147: ,p_budget_unit3_value in number default hr_api.g_number

143: ,p_budget_unit2_percent in number default hr_api.g_number
144: ,p_budget_unit3_percent in number default hr_api.g_number
145: ,p_budget_unit1_value in number default hr_api.g_number
146: ,p_budget_unit2_value in number default hr_api.g_number
147: ,p_budget_unit3_value in number default hr_api.g_number
148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
150: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
151: ,p_budget_unit1_available in number default hr_api.g_number

Line 148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2

144: ,p_budget_unit3_percent in number default hr_api.g_number
145: ,p_budget_unit1_value in number default hr_api.g_number
146: ,p_budget_unit2_value in number default hr_api.g_number
147: ,p_budget_unit3_value in number default hr_api.g_number
148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
150: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
151: ,p_budget_unit1_available in number default hr_api.g_number
152: ,p_budget_unit2_available in number default hr_api.g_number

Line 149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

145: ,p_budget_unit1_value in number default hr_api.g_number
146: ,p_budget_unit2_value in number default hr_api.g_number
147: ,p_budget_unit3_value in number default hr_api.g_number
148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
150: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
151: ,p_budget_unit1_available in number default hr_api.g_number
152: ,p_budget_unit2_available in number default hr_api.g_number
153: ,p_budget_unit3_available in number default hr_api.g_number

Line 150: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

146: ,p_budget_unit2_value in number default hr_api.g_number
147: ,p_budget_unit3_value in number default hr_api.g_number
148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
150: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
151: ,p_budget_unit1_available in number default hr_api.g_number
152: ,p_budget_unit2_available in number default hr_api.g_number
153: ,p_budget_unit3_available in number default hr_api.g_number
154: ,p_object_version_number in out nocopy number

Line 151: ,p_budget_unit1_available in number default hr_api.g_number

147: ,p_budget_unit3_value in number default hr_api.g_number
148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
150: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
151: ,p_budget_unit1_available in number default hr_api.g_number
152: ,p_budget_unit2_available in number default hr_api.g_number
153: ,p_budget_unit3_available in number default hr_api.g_number
154: ,p_object_version_number in out nocopy number
155: );

Line 152: ,p_budget_unit2_available in number default hr_api.g_number

148: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
150: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
151: ,p_budget_unit1_available in number default hr_api.g_number
152: ,p_budget_unit2_available in number default hr_api.g_number
153: ,p_budget_unit3_available in number default hr_api.g_number
154: ,p_object_version_number in out nocopy number
155: );
156: -- ----------------------------------------------------------------------------

Line 153: ,p_budget_unit3_available in number default hr_api.g_number

149: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
150: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
151: ,p_budget_unit1_available in number default hr_api.g_number
152: ,p_budget_unit2_available in number default hr_api.g_number
153: ,p_budget_unit3_available in number default hr_api.g_number
154: ,p_object_version_number in out nocopy number
155: );
156: -- ----------------------------------------------------------------------------
157: -- |------------------------< create_budget_set >------------------------|

Line 187: ,p_dflt_budget_set_id in number default hr_api.g_number

183: procedure update_budget_set
184: (
185: p_validate in boolean default false
186: ,p_budget_set_id in number
187: ,p_dflt_budget_set_id in number default hr_api.g_number
188: ,p_budget_period_id in number default hr_api.g_number
189: ,p_budget_unit1_percent in number default hr_api.g_number
190: ,p_budget_unit2_percent in number default hr_api.g_number
191: ,p_budget_unit3_percent in number default hr_api.g_number

Line 188: ,p_budget_period_id in number default hr_api.g_number

184: (
185: p_validate in boolean default false
186: ,p_budget_set_id in number
187: ,p_dflt_budget_set_id in number default hr_api.g_number
188: ,p_budget_period_id in number default hr_api.g_number
189: ,p_budget_unit1_percent in number default hr_api.g_number
190: ,p_budget_unit2_percent in number default hr_api.g_number
191: ,p_budget_unit3_percent in number default hr_api.g_number
192: ,p_budget_unit1_value in number default hr_api.g_number

Line 189: ,p_budget_unit1_percent in number default hr_api.g_number

185: p_validate in boolean default false
186: ,p_budget_set_id in number
187: ,p_dflt_budget_set_id in number default hr_api.g_number
188: ,p_budget_period_id in number default hr_api.g_number
189: ,p_budget_unit1_percent in number default hr_api.g_number
190: ,p_budget_unit2_percent in number default hr_api.g_number
191: ,p_budget_unit3_percent in number default hr_api.g_number
192: ,p_budget_unit1_value in number default hr_api.g_number
193: ,p_budget_unit2_value in number default hr_api.g_number

Line 190: ,p_budget_unit2_percent in number default hr_api.g_number

186: ,p_budget_set_id in number
187: ,p_dflt_budget_set_id in number default hr_api.g_number
188: ,p_budget_period_id in number default hr_api.g_number
189: ,p_budget_unit1_percent in number default hr_api.g_number
190: ,p_budget_unit2_percent in number default hr_api.g_number
191: ,p_budget_unit3_percent in number default hr_api.g_number
192: ,p_budget_unit1_value in number default hr_api.g_number
193: ,p_budget_unit2_value in number default hr_api.g_number
194: ,p_budget_unit3_value in number default hr_api.g_number

Line 191: ,p_budget_unit3_percent in number default hr_api.g_number

187: ,p_dflt_budget_set_id in number default hr_api.g_number
188: ,p_budget_period_id in number default hr_api.g_number
189: ,p_budget_unit1_percent in number default hr_api.g_number
190: ,p_budget_unit2_percent in number default hr_api.g_number
191: ,p_budget_unit3_percent in number default hr_api.g_number
192: ,p_budget_unit1_value in number default hr_api.g_number
193: ,p_budget_unit2_value in number default hr_api.g_number
194: ,p_budget_unit3_value in number default hr_api.g_number
195: ,p_budget_unit1_available in number default hr_api.g_number

Line 192: ,p_budget_unit1_value in number default hr_api.g_number

188: ,p_budget_period_id in number default hr_api.g_number
189: ,p_budget_unit1_percent in number default hr_api.g_number
190: ,p_budget_unit2_percent in number default hr_api.g_number
191: ,p_budget_unit3_percent in number default hr_api.g_number
192: ,p_budget_unit1_value in number default hr_api.g_number
193: ,p_budget_unit2_value in number default hr_api.g_number
194: ,p_budget_unit3_value in number default hr_api.g_number
195: ,p_budget_unit1_available in number default hr_api.g_number
196: ,p_budget_unit2_available in number default hr_api.g_number

Line 193: ,p_budget_unit2_value in number default hr_api.g_number

189: ,p_budget_unit1_percent in number default hr_api.g_number
190: ,p_budget_unit2_percent in number default hr_api.g_number
191: ,p_budget_unit3_percent in number default hr_api.g_number
192: ,p_budget_unit1_value in number default hr_api.g_number
193: ,p_budget_unit2_value in number default hr_api.g_number
194: ,p_budget_unit3_value in number default hr_api.g_number
195: ,p_budget_unit1_available in number default hr_api.g_number
196: ,p_budget_unit2_available in number default hr_api.g_number
197: ,p_budget_unit3_available in number default hr_api.g_number

Line 194: ,p_budget_unit3_value in number default hr_api.g_number

190: ,p_budget_unit2_percent in number default hr_api.g_number
191: ,p_budget_unit3_percent in number default hr_api.g_number
192: ,p_budget_unit1_value in number default hr_api.g_number
193: ,p_budget_unit2_value in number default hr_api.g_number
194: ,p_budget_unit3_value in number default hr_api.g_number
195: ,p_budget_unit1_available in number default hr_api.g_number
196: ,p_budget_unit2_available in number default hr_api.g_number
197: ,p_budget_unit3_available in number default hr_api.g_number
198: ,p_object_version_number in out nocopy number

Line 195: ,p_budget_unit1_available in number default hr_api.g_number

191: ,p_budget_unit3_percent in number default hr_api.g_number
192: ,p_budget_unit1_value in number default hr_api.g_number
193: ,p_budget_unit2_value in number default hr_api.g_number
194: ,p_budget_unit3_value in number default hr_api.g_number
195: ,p_budget_unit1_available in number default hr_api.g_number
196: ,p_budget_unit2_available in number default hr_api.g_number
197: ,p_budget_unit3_available in number default hr_api.g_number
198: ,p_object_version_number in out nocopy number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2

Line 196: ,p_budget_unit2_available in number default hr_api.g_number

192: ,p_budget_unit1_value in number default hr_api.g_number
193: ,p_budget_unit2_value in number default hr_api.g_number
194: ,p_budget_unit3_value in number default hr_api.g_number
195: ,p_budget_unit1_available in number default hr_api.g_number
196: ,p_budget_unit2_available in number default hr_api.g_number
197: ,p_budget_unit3_available in number default hr_api.g_number
198: ,p_object_version_number in out nocopy number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

Line 197: ,p_budget_unit3_available in number default hr_api.g_number

193: ,p_budget_unit2_value in number default hr_api.g_number
194: ,p_budget_unit3_value in number default hr_api.g_number
195: ,p_budget_unit1_available in number default hr_api.g_number
196: ,p_budget_unit2_available in number default hr_api.g_number
197: ,p_budget_unit3_available in number default hr_api.g_number
198: ,p_object_version_number in out nocopy number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

Line 199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2

195: ,p_budget_unit1_available in number default hr_api.g_number
196: ,p_budget_unit2_available in number default hr_api.g_number
197: ,p_budget_unit3_available in number default hr_api.g_number
198: ,p_object_version_number in out nocopy number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_effective_date in date
203: );

Line 200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

196: ,p_budget_unit2_available in number default hr_api.g_number
197: ,p_budget_unit3_available in number default hr_api.g_number
198: ,p_object_version_number in out nocopy number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_effective_date in date
203: );
204: -- ----------------------------------------------------------------------------

Line 201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

197: ,p_budget_unit3_available in number default hr_api.g_number
198: ,p_object_version_number in out nocopy number
199: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
201: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
202: ,p_effective_date in date
203: );
204: -- ----------------------------------------------------------------------------
205: -- |------------------------< create_budget_detail >------------------------|

Line 238: ,p_organization_id in number default hr_api.g_number

234: procedure update_budget_detail
235: (
236: p_validate in boolean default false
237: ,p_budget_detail_id in number
238: ,p_organization_id in number default hr_api.g_number
239: ,p_job_id in number default hr_api.g_number
240: ,p_position_id in number default hr_api.g_number
241: ,p_grade_id in number default hr_api.g_number
242: ,p_budget_version_id in number default hr_api.g_number

Line 239: ,p_job_id in number default hr_api.g_number

235: (
236: p_validate in boolean default false
237: ,p_budget_detail_id in number
238: ,p_organization_id in number default hr_api.g_number
239: ,p_job_id in number default hr_api.g_number
240: ,p_position_id in number default hr_api.g_number
241: ,p_grade_id in number default hr_api.g_number
242: ,p_budget_version_id in number default hr_api.g_number
243: ,p_budget_unit1_percent in number default hr_api.g_number

Line 240: ,p_position_id in number default hr_api.g_number

236: p_validate in boolean default false
237: ,p_budget_detail_id in number
238: ,p_organization_id in number default hr_api.g_number
239: ,p_job_id in number default hr_api.g_number
240: ,p_position_id in number default hr_api.g_number
241: ,p_grade_id in number default hr_api.g_number
242: ,p_budget_version_id in number default hr_api.g_number
243: ,p_budget_unit1_percent in number default hr_api.g_number
244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2

Line 241: ,p_grade_id in number default hr_api.g_number

237: ,p_budget_detail_id in number
238: ,p_organization_id in number default hr_api.g_number
239: ,p_job_id in number default hr_api.g_number
240: ,p_position_id in number default hr_api.g_number
241: ,p_grade_id in number default hr_api.g_number
242: ,p_budget_version_id in number default hr_api.g_number
243: ,p_budget_unit1_percent in number default hr_api.g_number
244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
245: ,p_budget_unit1_value in number default hr_api.g_number

Line 242: ,p_budget_version_id in number default hr_api.g_number

238: ,p_organization_id in number default hr_api.g_number
239: ,p_job_id in number default hr_api.g_number
240: ,p_position_id in number default hr_api.g_number
241: ,p_grade_id in number default hr_api.g_number
242: ,p_budget_version_id in number default hr_api.g_number
243: ,p_budget_unit1_percent in number default hr_api.g_number
244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
245: ,p_budget_unit1_value in number default hr_api.g_number
246: ,p_budget_unit1_available in number default hr_api.g_number

Line 243: ,p_budget_unit1_percent in number default hr_api.g_number

239: ,p_job_id in number default hr_api.g_number
240: ,p_position_id in number default hr_api.g_number
241: ,p_grade_id in number default hr_api.g_number
242: ,p_budget_version_id in number default hr_api.g_number
243: ,p_budget_unit1_percent in number default hr_api.g_number
244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
245: ,p_budget_unit1_value in number default hr_api.g_number
246: ,p_budget_unit1_available in number default hr_api.g_number
247: ,p_budget_unit2_percent in number default hr_api.g_number

Line 244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2

240: ,p_position_id in number default hr_api.g_number
241: ,p_grade_id in number default hr_api.g_number
242: ,p_budget_version_id in number default hr_api.g_number
243: ,p_budget_unit1_percent in number default hr_api.g_number
244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
245: ,p_budget_unit1_value in number default hr_api.g_number
246: ,p_budget_unit1_available in number default hr_api.g_number
247: ,p_budget_unit2_percent in number default hr_api.g_number
248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

Line 245: ,p_budget_unit1_value in number default hr_api.g_number

241: ,p_grade_id in number default hr_api.g_number
242: ,p_budget_version_id in number default hr_api.g_number
243: ,p_budget_unit1_percent in number default hr_api.g_number
244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
245: ,p_budget_unit1_value in number default hr_api.g_number
246: ,p_budget_unit1_available in number default hr_api.g_number
247: ,p_budget_unit2_percent in number default hr_api.g_number
248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
249: ,p_budget_unit2_value in number default hr_api.g_number

Line 246: ,p_budget_unit1_available in number default hr_api.g_number

242: ,p_budget_version_id in number default hr_api.g_number
243: ,p_budget_unit1_percent in number default hr_api.g_number
244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
245: ,p_budget_unit1_value in number default hr_api.g_number
246: ,p_budget_unit1_available in number default hr_api.g_number
247: ,p_budget_unit2_percent in number default hr_api.g_number
248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
249: ,p_budget_unit2_value in number default hr_api.g_number
250: ,p_budget_unit2_available in number default hr_api.g_number

Line 247: ,p_budget_unit2_percent in number default hr_api.g_number

243: ,p_budget_unit1_percent in number default hr_api.g_number
244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
245: ,p_budget_unit1_value in number default hr_api.g_number
246: ,p_budget_unit1_available in number default hr_api.g_number
247: ,p_budget_unit2_percent in number default hr_api.g_number
248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
249: ,p_budget_unit2_value in number default hr_api.g_number
250: ,p_budget_unit2_available in number default hr_api.g_number
251: ,p_budget_unit3_percent in number default hr_api.g_number

Line 248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2

244: ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
245: ,p_budget_unit1_value in number default hr_api.g_number
246: ,p_budget_unit1_available in number default hr_api.g_number
247: ,p_budget_unit2_percent in number default hr_api.g_number
248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
249: ,p_budget_unit2_value in number default hr_api.g_number
250: ,p_budget_unit2_available in number default hr_api.g_number
251: ,p_budget_unit3_percent in number default hr_api.g_number
252: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

Line 249: ,p_budget_unit2_value in number default hr_api.g_number

245: ,p_budget_unit1_value in number default hr_api.g_number
246: ,p_budget_unit1_available in number default hr_api.g_number
247: ,p_budget_unit2_percent in number default hr_api.g_number
248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
249: ,p_budget_unit2_value in number default hr_api.g_number
250: ,p_budget_unit2_available in number default hr_api.g_number
251: ,p_budget_unit3_percent in number default hr_api.g_number
252: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
253: ,p_budget_unit3_value in number default hr_api.g_number

Line 250: ,p_budget_unit2_available in number default hr_api.g_number

246: ,p_budget_unit1_available in number default hr_api.g_number
247: ,p_budget_unit2_percent in number default hr_api.g_number
248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
249: ,p_budget_unit2_value in number default hr_api.g_number
250: ,p_budget_unit2_available in number default hr_api.g_number
251: ,p_budget_unit3_percent in number default hr_api.g_number
252: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
253: ,p_budget_unit3_value in number default hr_api.g_number
254: ,p_budget_unit3_available in number default hr_api.g_number

Line 251: ,p_budget_unit3_percent in number default hr_api.g_number

247: ,p_budget_unit2_percent in number default hr_api.g_number
248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
249: ,p_budget_unit2_value in number default hr_api.g_number
250: ,p_budget_unit2_available in number default hr_api.g_number
251: ,p_budget_unit3_percent in number default hr_api.g_number
252: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
253: ,p_budget_unit3_value in number default hr_api.g_number
254: ,p_budget_unit3_available in number default hr_api.g_number
255: ,p_gl_status in varchar2 default hr_api.g_varchar2

Line 252: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2

248: ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
249: ,p_budget_unit2_value in number default hr_api.g_number
250: ,p_budget_unit2_available in number default hr_api.g_number
251: ,p_budget_unit3_percent in number default hr_api.g_number
252: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
253: ,p_budget_unit3_value in number default hr_api.g_number
254: ,p_budget_unit3_available in number default hr_api.g_number
255: ,p_gl_status in varchar2 default hr_api.g_varchar2
256: ,p_object_version_number in out nocopy number

Line 253: ,p_budget_unit3_value in number default hr_api.g_number

249: ,p_budget_unit2_value in number default hr_api.g_number
250: ,p_budget_unit2_available in number default hr_api.g_number
251: ,p_budget_unit3_percent in number default hr_api.g_number
252: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
253: ,p_budget_unit3_value in number default hr_api.g_number
254: ,p_budget_unit3_available in number default hr_api.g_number
255: ,p_gl_status in varchar2 default hr_api.g_varchar2
256: ,p_object_version_number in out nocopy number
257: );

Line 254: ,p_budget_unit3_available in number default hr_api.g_number

250: ,p_budget_unit2_available in number default hr_api.g_number
251: ,p_budget_unit3_percent in number default hr_api.g_number
252: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
253: ,p_budget_unit3_value in number default hr_api.g_number
254: ,p_budget_unit3_available in number default hr_api.g_number
255: ,p_gl_status in varchar2 default hr_api.g_varchar2
256: ,p_object_version_number in out nocopy number
257: );
258: -- ---------------------------------------------------------------------------

Line 255: ,p_gl_status in varchar2 default hr_api.g_varchar2

251: ,p_budget_unit3_percent in number default hr_api.g_number
252: ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
253: ,p_budget_unit3_value in number default hr_api.g_number
254: ,p_budget_unit3_available in number default hr_api.g_number
255: ,p_gl_status in varchar2 default hr_api.g_varchar2
256: ,p_object_version_number in out nocopy number
257: );
258: -- ---------------------------------------------------------------------------
259: -- |-----------------< POSITION_CONTROL_ENABLED >---------------------|