APPS.PA_OPEN_ASSIGNMENT_PVT dependencies on PA_ACTION_SETS

Line 63: l_starting_status_code pa_action_sets.status_code%TYPE;

59: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;
60: l_search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE;
61: l_search_country_code pa_project_assignments.search_country_code%TYPE;
62: l_search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE;
63: l_starting_status_code pa_action_sets.status_code%TYPE;
64: l_new_action_set_id NUMBER;
65: l_adv_action_set_id NUMBER;
66: l_start_adv_action_set_flag VARCHAR2(1);
67: l_task_assignment_id_tbl system.pa_num_tbl_type;

Line 976: --dbms_output.put_line('before calling PA_ACTION_SETS_PUB.Apply_Action_Set');

972: -- Is_Action_Set_Started_On_Apply to return to overriding flag
973: /*Commented for bug 2636577*/
974: --PA_ADVERTISEMENTS_PUB.g_start_adv_action_set_flag := l_start_adv_action_set_flag;
975:
976: --dbms_output.put_line('before calling PA_ACTION_SETS_PUB.Apply_Action_Set');
977: --dbms_output.put_line('action set id= '||l_adv_action_set_id);
978: --dbms_output.put_line('start action set ? '||l_start_adv_action_set_flag);
979:
980: --Log Message

Line 983: ,x_msg => 'calling PA_ACTION_SETS_PUB.Apply_Action_Set'

979:
980: --Log Message
981: IF (P_DEBUG_MODE = 'Y') THEN
982: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment'
983: ,x_msg => 'calling PA_ACTION_SETS_PUB.Apply_Action_Set'
984: ,x_log_level => li_message_level);
985: END IF;
986:
987:

Line 1006: PA_ACTION_SETS_PUB.Apply_Action_Set(

1002: ' val='||p_validate_only
1003: ,x_log_level => li_message_level);
1004: END IF;
1005:
1006: PA_ACTION_SETS_PUB.Apply_Action_Set(
1007: p_action_set_id => l_adv_action_set_id
1008: ,p_object_type => 'OPEN_ASSIGNMENT'
1009: ,p_object_id => PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(i).assignment_id
1010: ,p_perform_action_set_flag => 'Y'

Line 1028: --dbms_output.put_line('after calling PA_ACTION_SETS_PUB.Apply_Action_Set');

1024:
1025: END LOOP;
1026: END IF;
1027:
1028: --dbms_output.put_line('after calling PA_ACTION_SETS_PUB.Apply_Action_Set');
1029:
1030: END IF;
1031:
1032:

Line 1920: FROM pa_action_sets

1916:
1917: -- get advertisement action set details
1918: CURSOR get_action_set IS
1919: SELECT action_set_id, record_version_number
1920: FROM pa_action_sets
1921: WHERE object_id = p_assignment_id
1922: AND object_type = 'OPEN_ASSIGNMENT'
1923: AND action_set_type_code = 'ADVERTISEMENT'
1924: AND status_code <> 'DELETED';

Line 1976: PA_ACTION_SETS_PUB.Delete_Action_Set (

1972: IF get_action_set%NOTFOUND THEN
1973: CLOSE get_action_set;
1974: ELSE
1975:
1976: PA_ACTION_SETS_PUB.Delete_Action_Set (
1977: p_init_msg_list => FND_API.G_FALSE -- 5130421
1978: ,p_action_set_id => l_action_set_id
1979: ,p_action_set_type_code => 'ADVERTISEMENT'
1980: ,p_object_id => p_assignment_id