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 705: ,x_msg => 'Inserting record into pa_project_assignments.'

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

Line 710: PA_PROJECT_ASSIGNMENTS_PKG.Insert_Row

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

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

928: ,x_log_level => li_message_level);
929: END IF;
930:
931: /* Bug 3051110 - Added code to call PA_ASSIGNMENTS_PVT.Calc_Init_Transfer_Price if the l_return status is success,
932: this is to populate the TP columns in pa_project_assignments table */
933:
934: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
935:
936: IF p_debug_mode = 'Y' THEN

Line 1140: l_old_status_code pa_project_assignments.status_code%TYPE;

1136: )
1137: IS
1138:
1139: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
1140: l_old_status_code pa_project_assignments.status_code%TYPE;
1141: l_old_start_date pa_project_assignments.start_date%TYPE;
1142: l_old_end_date pa_project_assignments.end_date%TYPE;
1143: l_return_status VARCHAR2(1);
1144: l_msg_count NUMBER;

Line 1141: l_old_start_date pa_project_assignments.start_date%TYPE;

1137: IS
1138:
1139: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
1140: l_old_status_code pa_project_assignments.status_code%TYPE;
1141: l_old_start_date pa_project_assignments.start_date%TYPE;
1142: l_old_end_date pa_project_assignments.end_date%TYPE;
1143: l_return_status VARCHAR2(1);
1144: l_msg_count NUMBER;
1145: l_error_message_code fnd_new_messages.message_name%TYPE;

Line 1142: l_old_end_date pa_project_assignments.end_date%TYPE;

1138:
1139: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
1140: l_old_status_code pa_project_assignments.status_code%TYPE;
1141: l_old_start_date pa_project_assignments.start_date%TYPE;
1142: l_old_end_date pa_project_assignments.end_date%TYPE;
1143: l_return_status VARCHAR2(1);
1144: l_msg_count NUMBER;
1145: l_error_message_code fnd_new_messages.message_name%TYPE;
1146: l_msg_data FND_NEW_MESSAGES.message_text%TYPE;

Line 1161: l_cur_resource_id pa_project_assignments.resource_id%TYPE;

1157: l_last_struct_version_id NUMBER;
1158: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1159: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1160:
1161: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1162: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1163: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1164: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1165: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;

Line 1162: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;

1158: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1159: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1160:
1161: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1162: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1163: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1164: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1165: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1166: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;

Line 1163: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;

1159: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1160:
1161: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1162: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1163: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1164: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1165: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1166: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1167: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;

Line 1164: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;

1160:
1161: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1162: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1163: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1164: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1165: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1166: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1167: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1168: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;

Line 1165: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;

1161: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1162: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1163: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1164: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1165: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1166: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1167: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1168: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1169: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;

Line 1166: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;

1162: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1163: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1164: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1165: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1166: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1167: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1168: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1169: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1170:

Line 1167: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;

1163: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;
1164: l_cur_expenditure_type pa_project_assignments.expenditure_type%TYPE;
1165: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1166: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1167: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1168: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1169: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1170:
1171: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;

Line 1169: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;

1165: l_cur_project_role_id pa_project_assignments.project_role_id%TYPE;
1166: l_cur_assignment_name pa_project_assignments.assignment_name%TYPE;
1167: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1168: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1169: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1170:
1171: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1172: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1173: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;

Line 1214: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;

1210: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1211: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1212: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1213:
1214: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1215: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;
1216: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1217: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1218: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;

Line 1215: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;

1211: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1212: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1213:
1214: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1215: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;
1216: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1217: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1218: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1219:

Line 1216: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;

1212: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1213:
1214: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1215: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;
1216: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1217: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1218: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1219:
1220: CURSOR assignment_status_code_csr IS

Line 1217: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;

1213:
1214: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1215: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;
1216: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1217: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1218: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1219:
1220: CURSOR assignment_status_code_csr IS
1221: SELECT status_code, start_date, end_date

Line 1218: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;

1214: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1215: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;
1216: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1217: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1218: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1219:
1220: CURSOR assignment_status_code_csr IS
1221: SELECT status_code, start_date, end_date
1222: FROM pa_project_assignments

Line 1222: FROM pa_project_assignments

1218: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1219:
1220: CURSOR assignment_status_code_csr IS
1221: SELECT status_code, start_date, end_date
1222: FROM pa_project_assignments
1223: WHERE assignment_id = p_assignment_rec.assignment_id;
1224:
1225: CURSOR get_unlinked_res_asgmts IS
1226: SELECT resource_assignment_id, wbs_element_version_id, budget_version_id, project_structure_version_id

Line 1308: FROM pa_project_assignments

1304: expenditure_type,
1305: project_role_id, assignment_name,
1306: resource_list_member_id,
1307: project_role_id
1308: FROM pa_project_assignments
1309: WHERE assignment_id = l_assignment_rec.assignment_id;
1310:
1311: BEGIN
1312: -- Initialize the Error Stack

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

1786: ,x_msg => 'Update Assignment Record in the table'
1787: ,x_log_level => li_message_level);
1788: END IF;
1789:
1790: --dbms_output.put_line('calling PA_PROJECT_ASSIGNMENTS_PKG.Update_Row');
1791:
1792:
1793: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row
1794: ( p_assignment_row_id => l_assignment_rec.assignment_row_id

Line 1793: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row

1789:
1790: --dbms_output.put_line('calling PA_PROJECT_ASSIGNMENTS_PKG.Update_Row');
1791:
1792:
1793: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row
1794: ( p_assignment_row_id => l_assignment_rec.assignment_row_id
1795: ,p_assignment_id => l_assignment_rec.assignment_id
1796: ,p_record_version_number => l_assignment_rec.record_version_number
1797: ,p_assignment_name => l_assignment_rec.assignment_name

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

1893:
1894:
1895: PROCEDURE Delete_Open_Assignment
1896: ( p_assignment_row_id IN ROWID
1897: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
1898: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1899: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_NUM
1900: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1901: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 2076: PA_PROJECT_ASSIGNMENTS_PKG.Delete_Row

2072: END IF;
2073:
2074:
2075: -- Delete the master record
2076: PA_PROJECT_ASSIGNMENTS_PKG.Delete_Row
2077: ( p_assignment_row_id => p_assignment_row_id
2078: ,p_assignment_id => p_assignment_id
2079: ,p_record_version_number => p_record_version_number
2080: ,x_return_status => x_return_status);