APPS.PA_ADVERTISEMENTS_PVT dependencies on HR_ORGANIZATION_UNITS

Line 380: , p_starting_organization_id IN hr_organization_units.organization_id%TYPE := NULL

376: , p_object_id IN pa_action_sets.object_id%TYPE
377: , p_action_code IN pa_action_set_lines.action_code%TYPE
378: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
379: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE
380: , p_starting_organization_id IN hr_organization_units.organization_id%TYPE := NULL
381: , p_insert_audit_flag IN VARCHAR2 := 'T'
382: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
383: --, x_msg_count OUT NUMBER
384: --, x_msg_data OUT VARCHAR2

Line 520: l_start_org_id hr_organization_units.organization_id%TYPE;

516: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
517: ) IS
518:
519: l_org_hierarchy_version_id per_org_structure_versions.org_structure_version_id%TYPE;
520: l_start_org_id hr_organization_units.organization_id%TYPE;
521: l_new_start_org_id hr_organization_units.organization_id%TYPE;
522: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;
523: l_index NUMBER;
524: l_msg_count NUMBER;

Line 521: l_new_start_org_id hr_organization_units.organization_id%TYPE;

517: ) IS
518:
519: l_org_hierarchy_version_id per_org_structure_versions.org_structure_version_id%TYPE;
520: l_start_org_id hr_organization_units.organization_id%TYPE;
521: l_new_start_org_id hr_organization_units.organization_id%TYPE;
522: l_action_line_audit_rec pa_action_set_utils.insert_audit_lines_rec_type;
523: l_index NUMBER;
524: l_msg_count NUMBER;
525: l_msg_data VARCHAR2(2000);

Line 724: , p_organization_id IN hr_organization_units.organization_id%TYPE

720: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
721: , p_object_id IN pa_action_sets.object_id%TYPE
722: , p_action_code IN pa_action_set_lines.action_code%TYPE
723: , p_action_status_code IN pa_action_set_lines.status_code%TYPE
724: , p_organization_id IN hr_organization_units.organization_id%TYPE
725: , p_insert_audit_flag IN VARCHAR2 := 'T'
726: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
727: ) IS
728:

Line 1226: l_project_organization_name hr_organization_units.name%TYPE;

1222:
1223: l_assignment_name pa_project_assignments.assignment_name%TYPE;
1224: l_start_date pa_project_assignments.start_date%TYPE;
1225: l_end_date pa_project_assignments.end_date%TYPE;
1226: l_project_organization_name hr_organization_units.name%TYPE;
1227: l_project_role_name pa_project_role_types.meaning%TYPE;
1228: l_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
1229: l_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
1230: l_staffing_priority_name VARCHAR2(80);