eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_OPEN_ASSIGNMENT_PVT dependencies on PA_PROJECT_ASSIGNMENTS

Line 19: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895

15: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
16: ,p_number_of_requirements IN NUMBER := 1
17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
19: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
20: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
21: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
22: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23: )

Line 20: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895

16: ,p_number_of_requirements IN NUMBER := 1
17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
19: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
20: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
21: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
22: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23: )
24: IS

Line 27: l_assignment_id pa_project_assignments.assignment_id%TYPE;

23: )
24: IS
25:
26: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
27: l_assignment_id pa_project_assignments.assignment_id%TYPE;
28: l_def_assignment_name pa_project_assignments.assignment_name%TYPE;
29: l_def_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
30: l_def_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
31: l_source_assignment_id pa_project_assignments.source_assignment_id%TYPE;

Line 28: l_def_assignment_name pa_project_assignments.assignment_name%TYPE;

24: IS
25:
26: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
27: l_assignment_id pa_project_assignments.assignment_id%TYPE;
28: l_def_assignment_name pa_project_assignments.assignment_name%TYPE;
29: l_def_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
30: l_def_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
31: l_source_assignment_id pa_project_assignments.source_assignment_id%TYPE;
32: l_source_calendar_type pa_project_assignments.calendar_type%TYPE;

Line 29: l_def_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;

25:
26: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
27: l_assignment_id pa_project_assignments.assignment_id%TYPE;
28: l_def_assignment_name pa_project_assignments.assignment_name%TYPE;
29: l_def_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
30: l_def_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
31: l_source_assignment_id pa_project_assignments.source_assignment_id%TYPE;
32: l_source_calendar_type pa_project_assignments.calendar_type%TYPE;
33: l_source_status_code pa_project_assignments.status_code%TYPE;

Line 30: l_def_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;

26: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
27: l_assignment_id pa_project_assignments.assignment_id%TYPE;
28: l_def_assignment_name pa_project_assignments.assignment_name%TYPE;
29: l_def_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
30: l_def_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
31: l_source_assignment_id pa_project_assignments.source_assignment_id%TYPE;
32: l_source_calendar_type pa_project_assignments.calendar_type%TYPE;
33: l_source_status_code pa_project_assignments.status_code%TYPE;
34: l_menu_id NUMBER;

Line 31: l_source_assignment_id pa_project_assignments.source_assignment_id%TYPE;

27: l_assignment_id pa_project_assignments.assignment_id%TYPE;
28: l_def_assignment_name pa_project_assignments.assignment_name%TYPE;
29: l_def_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
30: l_def_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
31: l_source_assignment_id pa_project_assignments.source_assignment_id%TYPE;
32: l_source_calendar_type pa_project_assignments.calendar_type%TYPE;
33: l_source_status_code pa_project_assignments.status_code%TYPE;
34: l_menu_id NUMBER;
35: l_return_status VARCHAR2(1);

Line 32: l_source_calendar_type pa_project_assignments.calendar_type%TYPE;

28: l_def_assignment_name pa_project_assignments.assignment_name%TYPE;
29: l_def_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
30: l_def_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
31: l_source_assignment_id pa_project_assignments.source_assignment_id%TYPE;
32: l_source_calendar_type pa_project_assignments.calendar_type%TYPE;
33: l_source_status_code pa_project_assignments.status_code%TYPE;
34: l_menu_id NUMBER;
35: l_return_status VARCHAR2(1);
36: l_competencies_tbl PA_HR_COMPETENCE_UTILS.Competency_Tbl_Typ;

Line 33: l_source_status_code pa_project_assignments.status_code%TYPE;

29: l_def_min_resource_job_level pa_project_assignments.min_resource_job_level%TYPE;
30: l_def_max_resource_job_level pa_project_assignments.max_resource_job_level%TYPE;
31: l_source_assignment_id pa_project_assignments.source_assignment_id%TYPE;
32: l_source_calendar_type pa_project_assignments.calendar_type%TYPE;
33: l_source_status_code pa_project_assignments.status_code%TYPE;
34: l_menu_id NUMBER;
35: l_return_status VARCHAR2(1);
36: l_competencies_tbl PA_HR_COMPETENCE_UTILS.Competency_Tbl_Typ;
37: l_job_id NUMBER;

Line 55: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;

51: l_calendar_id NUMBER;
52: l_work_type_id NUMBER;
53: l_raw_revenue NUMBER;
54:
55: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
56: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
57: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
58: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;
59: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;

Line 56: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;

52: l_work_type_id NUMBER;
53: l_raw_revenue NUMBER;
54:
55: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
56: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
57: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
58: l_search_min_availability pa_project_assignments.search_min_availability%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;

Line 57: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;

53: l_raw_revenue NUMBER;
54:
55: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
56: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
57: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
58: l_search_min_availability pa_project_assignments.search_min_availability%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;

Line 58: l_search_min_availability pa_project_assignments.search_min_availability%TYPE;

54:
55: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
56: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
57: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
58: l_search_min_availability pa_project_assignments.search_min_availability%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;

Line 59: l_search_exp_org_struct_ver_id pa_project_assignments.search_exp_org_struct_ver_id%TYPE;

55: l_comp_match_weighting pa_project_assignments.competence_match_weighting%TYPE;
56: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
57: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
58: l_search_min_availability pa_project_assignments.search_min_availability%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;

Line 60: l_search_exp_start_org_id pa_project_assignments.search_exp_start_org_id%TYPE;

56: l_avail_match_weighting pa_project_assignments.availability_match_weighting%TYPE;
57: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
58: l_search_min_availability pa_project_assignments.search_min_availability%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;

Line 61: l_search_country_code pa_project_assignments.search_country_code%TYPE;

57: l_job_level_match_weighting pa_project_assignments.job_level_match_weighting%TYPE;
58: l_search_min_availability pa_project_assignments.search_min_availability%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;

Line 62: l_search_min_candidate_score pa_project_assignments.search_min_candidate_score%TYPE;

58: l_search_min_availability pa_project_assignments.search_min_availability%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);

Line 79: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;

75: l_last_struct_version_id NUMBER;
76: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
77: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
78:
79: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
80: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;
81: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
82: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
83: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;

Line 80: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;

76: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
77: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
78:
79: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
80: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;
81: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
82: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
83: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
84:

Line 81: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;

77: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
78:
79: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
80: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;
81: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
82: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
83: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
84:
85: l_fcst_tp_amount_type_tmp pa_project_assignments.fcst_tp_amount_type%TYPE;

Line 82: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;

78:
79: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
80: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;
81: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
82: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
83: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
84:
85: l_fcst_tp_amount_type_tmp pa_project_assignments.fcst_tp_amount_type%TYPE;
86: l_fcst_job_group_id_tmp pa_project_assignments.fcst_job_group_id%TYPE;

Line 83: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;

79: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
80: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;
81: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
82: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
83: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
84:
85: l_fcst_tp_amount_type_tmp pa_project_assignments.fcst_tp_amount_type%TYPE;
86: l_fcst_job_group_id_tmp pa_project_assignments.fcst_job_group_id%TYPE;
87: l_exp_org_id_tmp pa_project_assignments.expenditure_org_id%TYPE;

Line 85: l_fcst_tp_amount_type_tmp pa_project_assignments.fcst_tp_amount_type%TYPE;

81: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
82: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
83: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
84:
85: l_fcst_tp_amount_type_tmp pa_project_assignments.fcst_tp_amount_type%TYPE;
86: l_fcst_job_group_id_tmp pa_project_assignments.fcst_job_group_id%TYPE;
87: l_exp_org_id_tmp pa_project_assignments.expenditure_org_id%TYPE;
88: l_expenditure_type_class_tmp pa_project_assignments.expenditure_type_class%TYPE;
89: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;

Line 86: l_fcst_job_group_id_tmp pa_project_assignments.fcst_job_group_id%TYPE;

82: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
83: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
84:
85: l_fcst_tp_amount_type_tmp pa_project_assignments.fcst_tp_amount_type%TYPE;
86: l_fcst_job_group_id_tmp pa_project_assignments.fcst_job_group_id%TYPE;
87: l_exp_org_id_tmp pa_project_assignments.expenditure_org_id%TYPE;
88: l_expenditure_type_class_tmp pa_project_assignments.expenditure_type_class%TYPE;
89: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;
90:

Line 87: l_exp_org_id_tmp pa_project_assignments.expenditure_org_id%TYPE;

83: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
84:
85: l_fcst_tp_amount_type_tmp pa_project_assignments.fcst_tp_amount_type%TYPE;
86: l_fcst_job_group_id_tmp pa_project_assignments.fcst_job_group_id%TYPE;
87: l_exp_org_id_tmp pa_project_assignments.expenditure_org_id%TYPE;
88: l_expenditure_type_class_tmp pa_project_assignments.expenditure_type_class%TYPE;
89: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;
90:
91: CURSOR get_project_info IS

Line 88: l_expenditure_type_class_tmp pa_project_assignments.expenditure_type_class%TYPE;

84:
85: l_fcst_tp_amount_type_tmp pa_project_assignments.fcst_tp_amount_type%TYPE;
86: l_fcst_job_group_id_tmp pa_project_assignments.fcst_job_group_id%TYPE;
87: l_exp_org_id_tmp pa_project_assignments.expenditure_org_id%TYPE;
88: l_expenditure_type_class_tmp pa_project_assignments.expenditure_type_class%TYPE;
89: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;
90:
91: CURSOR get_project_info IS
92: SELECT calendar_id, competence_match_wt, availability_match_wt, job_level_match_wt, search_min_availability, search_org_hier_id, search_starting_org_id, search_country_code, min_cand_score_reqd_for_nom, adv_action_set_id, start_adv_action_set_flag,

Line 89: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;

85: l_fcst_tp_amount_type_tmp pa_project_assignments.fcst_tp_amount_type%TYPE;
86: l_fcst_job_group_id_tmp pa_project_assignments.fcst_job_group_id%TYPE;
87: l_exp_org_id_tmp pa_project_assignments.expenditure_org_id%TYPE;
88: l_expenditure_type_class_tmp pa_project_assignments.expenditure_type_class%TYPE;
89: l_enable_auto_cand_nom_flag pa_project_assignments.enable_auto_cand_nom_flag%TYPE;
90:
91: CURSOR get_project_info IS
92: SELECT calendar_id, competence_match_wt, availability_match_wt, job_level_match_wt, search_min_availability, search_org_hier_id, search_starting_org_id, search_country_code, min_cand_score_reqd_for_nom, adv_action_set_id, start_adv_action_set_flag,
93: enable_automated_search -- Added for bug 4306049

Line 708: ,x_msg => 'Inserting record into pa_project_assignments.'

704:
705: --Log Message
706: IF (P_DEBUG_MODE = 'Y') THEN
707: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_OPEN_ASSIGNMENT_PVT.Create_Open_Assignment.insert_row'
708: ,x_msg => 'Inserting record into pa_project_assignments.'
709: ,x_log_level => li_message_level);
710: END IF;
711:
712: --dbms_output.put_line('calling insert_row');

Line 713: PA_PROJECT_ASSIGNMENTS_PKG.Insert_Row

709: ,x_log_level => li_message_level);
710: END IF;
711:
712: --dbms_output.put_line('calling insert_row');
713: PA_PROJECT_ASSIGNMENTS_PKG.Insert_Row
714: ( p_assignment_name => l_assignment_rec.assignment_name
715: ,p_assignment_type => l_assignment_rec.assignment_type
716: ,p_multiple_status_flag => l_assignment_rec.multiple_status_flag
717: ,p_status_code => l_assignment_rec.status_code

Line 938: this is to populate the TP columns in pa_project_assignments table */

934: ,x_log_level => li_message_level);
935: END IF;
936:
937: /* Bug 3051110 - Added code to call PA_ASSIGNMENTS_PVT.Calc_Init_Transfer_Price if the l_return status is success,
938: this is to populate the TP columns in pa_project_assignments table */
939:
940: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
941:
942: IF p_debug_mode = 'Y' THEN

Line 1146: l_old_status_code pa_project_assignments.status_code%TYPE;

1142: )
1143: IS
1144:
1145: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
1146: l_old_status_code pa_project_assignments.status_code%TYPE;
1147: l_old_start_date pa_project_assignments.start_date%TYPE;
1148: l_old_end_date pa_project_assignments.end_date%TYPE;
1149: l_return_status VARCHAR2(1);
1150: l_msg_count NUMBER;

Line 1147: l_old_start_date pa_project_assignments.start_date%TYPE;

1143: IS
1144:
1145: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
1146: l_old_status_code pa_project_assignments.status_code%TYPE;
1147: l_old_start_date pa_project_assignments.start_date%TYPE;
1148: l_old_end_date pa_project_assignments.end_date%TYPE;
1149: l_return_status VARCHAR2(1);
1150: l_msg_count NUMBER;
1151: l_error_message_code fnd_new_messages.message_name%TYPE;

Line 1148: l_old_end_date pa_project_assignments.end_date%TYPE;

1144:
1145: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
1146: l_old_status_code pa_project_assignments.status_code%TYPE;
1147: l_old_start_date pa_project_assignments.start_date%TYPE;
1148: l_old_end_date pa_project_assignments.end_date%TYPE;
1149: l_return_status VARCHAR2(1);
1150: l_msg_count NUMBER;
1151: l_error_message_code fnd_new_messages.message_name%TYPE;
1152: l_msg_data FND_NEW_MESSAGES.message_text%TYPE;

Line 1167: l_cur_resource_id pa_project_assignments.resource_id%TYPE;

1163: l_last_struct_version_id NUMBER;
1164: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1165: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1166:
1167: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1168: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1169: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1170: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1171: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;

Line 1168: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;

1164: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1165: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1166:
1167: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1168: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1169: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1170: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1171: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1172: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;

Line 1169: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;

1165: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1166:
1167: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1168: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1169: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1170: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1171: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1172: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1173: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;

Line 1170: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;

1166:
1167: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1168: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1169: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1170: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1171: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1172: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1173: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1174: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;

Line 1171: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;

1167: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1168: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1169: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1170: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1171: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1172: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1173: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1174: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1175: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;

Line 1172: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;

1168: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1169: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1170: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1171: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1172: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1173: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1174: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1175: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1176:

Line 1173: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;

1169: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1170: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1171: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1172: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1173: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1174: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1175: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1176:
1177: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;

Line 1175: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;

1171: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1172: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1173: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1174: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1175: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1176:
1177: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1178: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1179: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;

Line 1220: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;

1216: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1217: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1218: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1219:
1220: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1221: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;
1222: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1223: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1224: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;

Line 1221: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;

1217: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1218: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1219:
1220: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1221: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;
1222: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1223: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1224: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1225:

Line 1222: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;

1218: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1219:
1220: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1221: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;
1222: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1223: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1224: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1225:
1226: CURSOR assignment_status_code_csr IS

Line 1223: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;

1219:
1220: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1221: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;
1222: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1223: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1224: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1225:
1226: CURSOR assignment_status_code_csr IS
1227: SELECT status_code, start_date, end_date

Line 1224: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;

1220: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1221: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;
1222: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1223: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1224: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1225:
1226: CURSOR assignment_status_code_csr IS
1227: SELECT status_code, start_date, end_date
1228: FROM pa_project_assignments

Line 1228: FROM pa_project_assignments

1224: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1225:
1226: CURSOR assignment_status_code_csr IS
1227: SELECT status_code, start_date, end_date
1228: FROM pa_project_assignments
1229: WHERE assignment_id = p_assignment_rec.assignment_id;
1230:
1231: CURSOR get_unlinked_res_asgmts IS
1232: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id

Line 1314: FROM pa_project_assignments

1310: expenditure_type,
1311: project_role_id, assignment_name,
1312: resource_list_member_id,
1313: project_role_id
1314: FROM pa_project_assignments
1315: WHERE assignment_id = l_assignment_rec.assignment_id;
1316:
1317: BEGIN
1318: -- Initialize the Error Stack

Line 1796: --dbms_output.put_line('calling PA_PROJECT_ASSIGNMENTS_PKG.Update_Row');

1792: ,x_msg => 'Update Assignment Record in the table'
1793: ,x_log_level => li_message_level);
1794: END IF;
1795:
1796: --dbms_output.put_line('calling PA_PROJECT_ASSIGNMENTS_PKG.Update_Row');
1797:
1798:
1799: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row
1800: ( p_assignment_row_id => l_assignment_rec.assignment_row_id

Line 1799: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row

1795:
1796: --dbms_output.put_line('calling PA_PROJECT_ASSIGNMENTS_PKG.Update_Row');
1797:
1798:
1799: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row
1800: ( p_assignment_row_id => l_assignment_rec.assignment_row_id
1801: ,p_assignment_id => l_assignment_rec.assignment_id
1802: ,p_record_version_number => l_assignment_rec.record_version_number
1803: ,p_assignment_name => l_assignment_rec.assignment_name

Line 1903: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM

1899:
1900:
1901: PROCEDURE Delete_Open_Assignment
1902: ( p_assignment_row_id IN ROWID
1903: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
1904: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1905: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM
1906: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1907: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 2082: PA_PROJECT_ASSIGNMENTS_PKG.Delete_Row

2078: END IF;
2079:
2080:
2081: -- Delete the master record
2082: PA_PROJECT_ASSIGNMENTS_PKG.Delete_Row
2083: ( p_assignment_row_id => p_assignment_row_id
2084: ,p_assignment_id => p_assignment_id
2085: ,p_record_version_number => p_record_version_number
2086: ,x_return_status => x_return_status);