DBA Data[Home] [Help]

APPS.PA_ADVERTISEMENTS_PVT dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 379: , p_org_hierarchy_version_id IN per_org_structure_versions.org_structure_version_id%TYPE

375: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
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

Line 519: l_org_hierarchy_version_id per_org_structure_versions.org_structure_version_id%TYPE;

515: , p_insert_audit_flag IN VARCHAR2 := 'T'
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;