DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_ACTION_SETS

Line 70: ,p_adv_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR

66: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
67: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
68: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
69: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
70: ,p_adv_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
71: ,p_bill_rate_override IN pa_project_assignments.bill_rate_override%TYPE := FND_API.G_MISS_NUM
72: ,p_bill_rate_curr_override IN pa_project_assignments.bill_rate_curr_override%TYPE := FND_API.G_MISS_CHAR
73: ,p_markup_percent_override IN pa_project_assignments.markup_percent_override%TYPE := FND_API.G_MISS_NUM
74: ,p_discount_percentage IN pa_project_assignments.discount_percentage%TYPE := FND_API.G_MISS_NUM

Line 875: ,p_adv_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR

871: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
872: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
873: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
874: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
875: ,p_adv_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
876: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
877: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
878: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
879: ,p_number_of_requirements IN NUMBER := 1

Line 2119: FROM pa_action_sets

2115:
2116: -- get advertisement action set details
2117: CURSOR get_action_set IS
2118: SELECT action_set_id, record_version_number
2119: FROM pa_action_sets
2120: WHERE object_id = p_assignment_rec.source_assignment_id
2121: AND object_type = 'OPEN_ASSIGNMENT'
2122: AND action_set_type_code = 'ADVERTISEMENT'
2123: AND status_code <> 'DELETED';

Line 3016: PA_ACTION_SETS_PUB.Update_Action_Set(

3012: OPEN get_action_set;
3013: FETCH get_action_set INTO l_action_set_id, l_record_version_number;
3014: CLOSE get_action_set;
3015:
3016: PA_ACTION_SETS_PUB.Update_Action_Set(
3017: p_action_set_id => l_action_set_id
3018: ,p_object_id => l_source_assignment_rec.assignment_id
3019: ,p_object_type => 'OPEN_ASSIGNMENT'
3020: ,p_action_set_type_code => 'ADVERTISEMENT'

Line 5137: l_adv_action_set_id pa_action_sets.action_set_id%TYPE;

5133: l_msg_index_out NUMBER;
5134: l_assignment_rec assignment_rec_type;
5135: l_resource_id pa_resources_denorm.resource_id%TYPE;
5136: l_start_req_status_code pa_project_statuses.project_status_code%TYPE;
5137: l_adv_action_set_id pa_action_sets.action_set_id%TYPE;
5138:
5139: BEGIN
5140:
5141: --dbms_output.put_line('PA_ASSIGNMENTS_PUB.Copy_Team_Role');

Line 5300: pa_action_sets asets

5296: ,l_assignment_rec.tp_calc_base_code_override
5297: ,l_assignment_rec.tp_percent_applied_override
5298: ,l_assignment_rec.resource_list_member_id
5299: FROM pa_project_assignments pa,
5300: pa_action_sets asets
5301: WHERE pa.assignment_id = p_assignment_id
5302: AND asets.object_id(+) = pa.assignment_id
5303: AND asets.object_type(+) = 'OPEN_ASSIGNMENT'
5304: AND asets.action_set_type_code(+) = 'ADVERTISEMENT'