DBA Data[Home] [Help]

APPS.PQH_WDT_UPD dependencies on HR_API

Line 103: p_worksheet_id in number default hr_api.g_number,

99: Procedure upd
100: (
101: p_effective_date in date,
102: p_worksheet_detail_id in number,
103: p_worksheet_id in number default hr_api.g_number,
104: p_organization_id in number default hr_api.g_number,
105: p_job_id in number default hr_api.g_number,
106: p_position_id in number default hr_api.g_number,
107: p_grade_id in number default hr_api.g_number,

Line 104: p_organization_id in number default hr_api.g_number,

100: (
101: p_effective_date in date,
102: p_worksheet_detail_id in number,
103: p_worksheet_id in number default hr_api.g_number,
104: p_organization_id in number default hr_api.g_number,
105: p_job_id in number default hr_api.g_number,
106: p_position_id in number default hr_api.g_number,
107: p_grade_id in number default hr_api.g_number,
108: p_position_transaction_id in number default hr_api.g_number,

Line 105: p_job_id in number default hr_api.g_number,

101: p_effective_date in date,
102: p_worksheet_detail_id in number,
103: p_worksheet_id in number default hr_api.g_number,
104: p_organization_id in number default hr_api.g_number,
105: p_job_id in number default hr_api.g_number,
106: p_position_id in number default hr_api.g_number,
107: p_grade_id in number default hr_api.g_number,
108: p_position_transaction_id in number default hr_api.g_number,
109: p_budget_detail_id in number default hr_api.g_number,

Line 106: p_position_id in number default hr_api.g_number,

102: p_worksheet_detail_id in number,
103: p_worksheet_id in number default hr_api.g_number,
104: p_organization_id in number default hr_api.g_number,
105: p_job_id in number default hr_api.g_number,
106: p_position_id in number default hr_api.g_number,
107: p_grade_id in number default hr_api.g_number,
108: p_position_transaction_id in number default hr_api.g_number,
109: p_budget_detail_id in number default hr_api.g_number,
110: p_parent_worksheet_detail_id in number default hr_api.g_number,

Line 107: p_grade_id in number default hr_api.g_number,

103: p_worksheet_id in number default hr_api.g_number,
104: p_organization_id in number default hr_api.g_number,
105: p_job_id in number default hr_api.g_number,
106: p_position_id in number default hr_api.g_number,
107: p_grade_id in number default hr_api.g_number,
108: p_position_transaction_id in number default hr_api.g_number,
109: p_budget_detail_id in number default hr_api.g_number,
110: p_parent_worksheet_detail_id in number default hr_api.g_number,
111: p_user_id in number default hr_api.g_number,

Line 108: p_position_transaction_id in number default hr_api.g_number,

104: p_organization_id in number default hr_api.g_number,
105: p_job_id in number default hr_api.g_number,
106: p_position_id in number default hr_api.g_number,
107: p_grade_id in number default hr_api.g_number,
108: p_position_transaction_id in number default hr_api.g_number,
109: p_budget_detail_id in number default hr_api.g_number,
110: p_parent_worksheet_detail_id in number default hr_api.g_number,
111: p_user_id in number default hr_api.g_number,
112: p_action_cd in varchar2 default hr_api.g_varchar2,

Line 109: p_budget_detail_id in number default hr_api.g_number,

105: p_job_id in number default hr_api.g_number,
106: p_position_id in number default hr_api.g_number,
107: p_grade_id in number default hr_api.g_number,
108: p_position_transaction_id in number default hr_api.g_number,
109: p_budget_detail_id in number default hr_api.g_number,
110: p_parent_worksheet_detail_id in number default hr_api.g_number,
111: p_user_id in number default hr_api.g_number,
112: p_action_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit1_percent in number default hr_api.g_number,

Line 110: p_parent_worksheet_detail_id in number default hr_api.g_number,

106: p_position_id in number default hr_api.g_number,
107: p_grade_id in number default hr_api.g_number,
108: p_position_transaction_id in number default hr_api.g_number,
109: p_budget_detail_id in number default hr_api.g_number,
110: p_parent_worksheet_detail_id in number default hr_api.g_number,
111: p_user_id in number default hr_api.g_number,
112: p_action_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit1_percent in number default hr_api.g_number,
114: p_budget_unit1_value in number default hr_api.g_number,

Line 111: p_user_id in number default hr_api.g_number,

107: p_grade_id in number default hr_api.g_number,
108: p_position_transaction_id in number default hr_api.g_number,
109: p_budget_detail_id in number default hr_api.g_number,
110: p_parent_worksheet_detail_id in number default hr_api.g_number,
111: p_user_id in number default hr_api.g_number,
112: p_action_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit1_percent in number default hr_api.g_number,
114: p_budget_unit1_value in number default hr_api.g_number,
115: p_budget_unit2_percent in number default hr_api.g_number,

Line 112: p_action_cd in varchar2 default hr_api.g_varchar2,

108: p_position_transaction_id in number default hr_api.g_number,
109: p_budget_detail_id in number default hr_api.g_number,
110: p_parent_worksheet_detail_id in number default hr_api.g_number,
111: p_user_id in number default hr_api.g_number,
112: p_action_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit1_percent in number default hr_api.g_number,
114: p_budget_unit1_value in number default hr_api.g_number,
115: p_budget_unit2_percent in number default hr_api.g_number,
116: p_budget_unit2_value in number default hr_api.g_number,

Line 113: p_budget_unit1_percent in number default hr_api.g_number,

109: p_budget_detail_id in number default hr_api.g_number,
110: p_parent_worksheet_detail_id in number default hr_api.g_number,
111: p_user_id in number default hr_api.g_number,
112: p_action_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit1_percent in number default hr_api.g_number,
114: p_budget_unit1_value in number default hr_api.g_number,
115: p_budget_unit2_percent in number default hr_api.g_number,
116: p_budget_unit2_value in number default hr_api.g_number,
117: p_budget_unit3_percent in number default hr_api.g_number,

Line 114: p_budget_unit1_value in number default hr_api.g_number,

110: p_parent_worksheet_detail_id in number default hr_api.g_number,
111: p_user_id in number default hr_api.g_number,
112: p_action_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit1_percent in number default hr_api.g_number,
114: p_budget_unit1_value in number default hr_api.g_number,
115: p_budget_unit2_percent in number default hr_api.g_number,
116: p_budget_unit2_value in number default hr_api.g_number,
117: p_budget_unit3_percent in number default hr_api.g_number,
118: p_budget_unit3_value in number default hr_api.g_number,

Line 115: p_budget_unit2_percent in number default hr_api.g_number,

111: p_user_id in number default hr_api.g_number,
112: p_action_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit1_percent in number default hr_api.g_number,
114: p_budget_unit1_value in number default hr_api.g_number,
115: p_budget_unit2_percent in number default hr_api.g_number,
116: p_budget_unit2_value in number default hr_api.g_number,
117: p_budget_unit3_percent in number default hr_api.g_number,
118: p_budget_unit3_value in number default hr_api.g_number,
119: p_object_version_number in out nocopy number,

Line 116: p_budget_unit2_value in number default hr_api.g_number,

112: p_action_cd in varchar2 default hr_api.g_varchar2,
113: p_budget_unit1_percent in number default hr_api.g_number,
114: p_budget_unit1_value in number default hr_api.g_number,
115: p_budget_unit2_percent in number default hr_api.g_number,
116: p_budget_unit2_value in number default hr_api.g_number,
117: p_budget_unit3_percent in number default hr_api.g_number,
118: p_budget_unit3_value in number default hr_api.g_number,
119: p_object_version_number in out nocopy number,
120: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,

Line 117: p_budget_unit3_percent in number default hr_api.g_number,

113: p_budget_unit1_percent in number default hr_api.g_number,
114: p_budget_unit1_value in number default hr_api.g_number,
115: p_budget_unit2_percent in number default hr_api.g_number,
116: p_budget_unit2_value in number default hr_api.g_number,
117: p_budget_unit3_percent in number default hr_api.g_number,
118: p_budget_unit3_value in number default hr_api.g_number,
119: p_object_version_number in out nocopy number,
120: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
121: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,

Line 118: p_budget_unit3_value in number default hr_api.g_number,

114: p_budget_unit1_value in number default hr_api.g_number,
115: p_budget_unit2_percent in number default hr_api.g_number,
116: p_budget_unit2_value in number default hr_api.g_number,
117: p_budget_unit3_percent in number default hr_api.g_number,
118: p_budget_unit3_value in number default hr_api.g_number,
119: p_object_version_number in out nocopy number,
120: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
121: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
122: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,

Line 120: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,

116: p_budget_unit2_value in number default hr_api.g_number,
117: p_budget_unit3_percent in number default hr_api.g_number,
118: p_budget_unit3_value in number default hr_api.g_number,
119: p_object_version_number in out nocopy number,
120: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
121: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
122: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
123: p_status in varchar2 default hr_api.g_varchar2,
124: p_budget_unit1_available in number default hr_api.g_number,

Line 121: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,

117: p_budget_unit3_percent in number default hr_api.g_number,
118: p_budget_unit3_value in number default hr_api.g_number,
119: p_object_version_number in out nocopy number,
120: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
121: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
122: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
123: p_status in varchar2 default hr_api.g_varchar2,
124: p_budget_unit1_available in number default hr_api.g_number,
125: p_budget_unit2_available in number default hr_api.g_number,

Line 122: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,

118: p_budget_unit3_value in number default hr_api.g_number,
119: p_object_version_number in out nocopy number,
120: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
121: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
122: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
123: p_status in varchar2 default hr_api.g_varchar2,
124: p_budget_unit1_available in number default hr_api.g_number,
125: p_budget_unit2_available in number default hr_api.g_number,
126: p_budget_unit3_available in number default hr_api.g_number,

Line 123: p_status in varchar2 default hr_api.g_varchar2,

119: p_object_version_number in out nocopy number,
120: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
121: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
122: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
123: p_status in varchar2 default hr_api.g_varchar2,
124: p_budget_unit1_available in number default hr_api.g_number,
125: p_budget_unit2_available in number default hr_api.g_number,
126: p_budget_unit3_available in number default hr_api.g_number,
127: p_old_unit1_value in number default hr_api.g_number,

Line 124: p_budget_unit1_available in number default hr_api.g_number,

120: p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2,
121: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
122: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
123: p_status in varchar2 default hr_api.g_varchar2,
124: p_budget_unit1_available in number default hr_api.g_number,
125: p_budget_unit2_available in number default hr_api.g_number,
126: p_budget_unit3_available in number default hr_api.g_number,
127: p_old_unit1_value in number default hr_api.g_number,
128: p_old_unit2_value in number default hr_api.g_number,

Line 125: p_budget_unit2_available in number default hr_api.g_number,

121: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
122: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
123: p_status in varchar2 default hr_api.g_varchar2,
124: p_budget_unit1_available in number default hr_api.g_number,
125: p_budget_unit2_available in number default hr_api.g_number,
126: p_budget_unit3_available in number default hr_api.g_number,
127: p_old_unit1_value in number default hr_api.g_number,
128: p_old_unit2_value in number default hr_api.g_number,
129: p_old_unit3_value in number default hr_api.g_number,

Line 126: p_budget_unit3_available in number default hr_api.g_number,

122: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2,
123: p_status in varchar2 default hr_api.g_varchar2,
124: p_budget_unit1_available in number default hr_api.g_number,
125: p_budget_unit2_available in number default hr_api.g_number,
126: p_budget_unit3_available in number default hr_api.g_number,
127: p_old_unit1_value in number default hr_api.g_number,
128: p_old_unit2_value in number default hr_api.g_number,
129: p_old_unit3_value in number default hr_api.g_number,
130: p_defer_flag in varchar2 default hr_api.g_varchar2,

Line 127: p_old_unit1_value in number default hr_api.g_number,

123: p_status in varchar2 default hr_api.g_varchar2,
124: p_budget_unit1_available in number default hr_api.g_number,
125: p_budget_unit2_available in number default hr_api.g_number,
126: p_budget_unit3_available in number default hr_api.g_number,
127: p_old_unit1_value in number default hr_api.g_number,
128: p_old_unit2_value in number default hr_api.g_number,
129: p_old_unit3_value in number default hr_api.g_number,
130: p_defer_flag in varchar2 default hr_api.g_varchar2,
131: p_propagation_method in varchar2 default hr_api.g_varchar2

Line 128: p_old_unit2_value in number default hr_api.g_number,

124: p_budget_unit1_available in number default hr_api.g_number,
125: p_budget_unit2_available in number default hr_api.g_number,
126: p_budget_unit3_available in number default hr_api.g_number,
127: p_old_unit1_value in number default hr_api.g_number,
128: p_old_unit2_value in number default hr_api.g_number,
129: p_old_unit3_value in number default hr_api.g_number,
130: p_defer_flag in varchar2 default hr_api.g_varchar2,
131: p_propagation_method in varchar2 default hr_api.g_varchar2
132: );

Line 129: p_old_unit3_value in number default hr_api.g_number,

125: p_budget_unit2_available in number default hr_api.g_number,
126: p_budget_unit3_available in number default hr_api.g_number,
127: p_old_unit1_value in number default hr_api.g_number,
128: p_old_unit2_value in number default hr_api.g_number,
129: p_old_unit3_value in number default hr_api.g_number,
130: p_defer_flag in varchar2 default hr_api.g_varchar2,
131: p_propagation_method in varchar2 default hr_api.g_varchar2
132: );
133: --

Line 130: p_defer_flag in varchar2 default hr_api.g_varchar2,

126: p_budget_unit3_available in number default hr_api.g_number,
127: p_old_unit1_value in number default hr_api.g_number,
128: p_old_unit2_value in number default hr_api.g_number,
129: p_old_unit3_value in number default hr_api.g_number,
130: p_defer_flag in varchar2 default hr_api.g_varchar2,
131: p_propagation_method in varchar2 default hr_api.g_varchar2
132: );
133: --
134: end pqh_wdt_upd;

Line 131: p_propagation_method in varchar2 default hr_api.g_varchar2

127: p_old_unit1_value in number default hr_api.g_number,
128: p_old_unit2_value in number default hr_api.g_number,
129: p_old_unit3_value in number default hr_api.g_number,
130: p_defer_flag in varchar2 default hr_api.g_varchar2,
131: p_propagation_method in varchar2 default hr_api.g_varchar2
132: );
133: --
134: end pqh_wdt_upd;