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 910: ,p_adv_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR

906: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
907: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
908: ,p_adv_action_set_id IN NUMBER := FND_API.G_MISS_NUM
909: ,p_start_adv_action_set_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
910: ,p_adv_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
911: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
912: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
913: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
914: ,p_number_of_requirements IN NUMBER := 1

Line 2182: FROM pa_action_sets

2178:
2179: -- get advertisement action set details
2180: CURSOR get_action_set IS
2181: SELECT action_set_id, record_version_number
2182: FROM pa_action_sets
2183: WHERE object_id = p_assignment_rec.source_assignment_id
2184: AND object_type = 'OPEN_ASSIGNMENT'
2185: AND action_set_type_code = 'ADVERTISEMENT'
2186: AND status_code <> 'DELETED';

Line 3081: PA_ACTION_SETS_PUB.Update_Action_Set(

3077: OPEN get_action_set;
3078: FETCH get_action_set INTO l_action_set_id, l_record_version_number;
3079: CLOSE get_action_set;
3080:
3081: PA_ACTION_SETS_PUB.Update_Action_Set(
3082: p_action_set_id => l_action_set_id
3083: ,p_object_id => l_source_assignment_rec.assignment_id
3084: ,p_object_type => 'OPEN_ASSIGNMENT'
3085: ,p_action_set_type_code => 'ADVERTISEMENT'

Line 6113: l_adv_action_set_id pa_action_sets.action_set_id%TYPE;

6109: l_msg_index_out NUMBER;
6110: l_assignment_rec assignment_rec_type;
6111: l_resource_id pa_resources_denorm.resource_id%TYPE;
6112: l_start_req_status_code pa_project_statuses.project_status_code%TYPE;
6113: l_adv_action_set_id pa_action_sets.action_set_id%TYPE;
6114:
6115: BEGIN
6116:
6117: --dbms_output.put_line('PA_ASSIGNMENTS_PUB.Copy_Team_Role');

Line 6276: pa_action_sets asets

6272: ,l_assignment_rec.tp_calc_base_code_override
6273: ,l_assignment_rec.tp_percent_applied_override
6274: ,l_assignment_rec.resource_list_member_id
6275: FROM pa_project_assignments pa,
6276: pa_action_sets asets
6277: WHERE pa.assignment_id = p_assignment_id
6278: AND asets.object_id(+) = pa.assignment_id
6279: AND asets.object_type(+) = 'OPEN_ASSIGNMENT'
6280: AND asets.action_set_type_code(+) = 'ADVERTISEMENT'