DBA Data[Home] [Help]

APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_PROJECT_ASSIGNMENTS

Line 133: , p_project_id IN pa_project_assignments.project_id%TYPE

129: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
130: , p_method IN VARCHAR2
131: , p_person_id IN pa_resources_denorm.person_id%TYPE := FND_API.G_MISS_NUM
132: , p_project_role_id IN pa_project_role_types.project_role_id%TYPE := FND_API.G_MISS_NUM
133: , p_project_id IN pa_project_assignments.project_id%TYPE
134: , p_insert_audit_flag IN VARCHAR2 := 'T'
135: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
136: );
137:

Line 152: , p_assignment_id IN pa_project_assignments.assignment_id%TYPE

148: , p_ntf_recipient_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
149: , p_wf_user_name IN VARCHAR2 := NULL
150: , p_wf_process IN VARCHAR2
151: , p_wf_item_type IN VARCHAR2 := 'PARADVWF'
152: , p_assignment_id IN pa_project_assignments.assignment_id%TYPE
153: , p_project_id IN pa_projects_all.project_id%TYPE
154: , p_insert_audit_flag IN VARCHAR2 := 'T'
155: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
156: );

Line 170: , p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE

166: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
167: , p_object_id IN pa_action_sets.object_id%TYPE
168: , p_action_code IN pa_action_set_lines.action_code%TYPE
169: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
170: , p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE
171: , p_record_version_number IN pa_project_assignments.record_version_number%TYPE
172: , p_insert_audit_flag IN VARCHAR2 := 'T'
173: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
174: );

Line 171: , p_record_version_number IN pa_project_assignments.record_version_number%TYPE

167: , p_object_id IN pa_action_sets.object_id%TYPE
168: , p_action_code IN pa_action_set_lines.action_code%TYPE
169: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
170: , p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE
171: , p_record_version_number IN pa_project_assignments.record_version_number%TYPE
172: , p_insert_audit_flag IN VARCHAR2 := 'T'
173: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
174: );
175: