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_ASSIGNMENT_APPROVAL_PUB dependencies on PA_PROJECT_ASSIGNMENTS

Line 29: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

25: -- or the Cancel button on team list.
26: -- p_action_code allowed: 'APPROVE', 'SUBMIT', 'REJECT', 'CANCEL'
27: --
28: PROCEDURE Start_Assignment_Approvals
29: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
30: ,p_new_assignment_flag IN VARCHAR2
31: ,p_action_code IN VARCHAR2
32: ,p_note_to_approver IN VARCHAR2 := FND_API.G_MISS_CHAR
33: ,p_record_version_number IN NUMBER

Line 55: l_assignment_type pa_project_assignments.assignment_type%TYPE;

51: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
52: ) IS
53:
54: l_approver_rec PA_ASSIGNMENT_APPROVAL_PUB.Asgmt_Approvers_Rec_Type;
55: l_assignment_type pa_project_assignments.assignment_type%TYPE;
56: l_project_id pa_project_assignments.project_id%TYPE;
57: l_project_status_name pa_project_statuses.project_status_name%TYPE;
58: l_success_status_code pa_project_statuses.project_status_code%TYPE;
59: l_failure_status_code pa_project_statuses.project_status_code%TYPE;

Line 56: l_project_id pa_project_assignments.project_id%TYPE;

52: ) IS
53:
54: l_approver_rec PA_ASSIGNMENT_APPROVAL_PUB.Asgmt_Approvers_Rec_Type;
55: l_assignment_type pa_project_assignments.assignment_type%TYPE;
56: l_project_id pa_project_assignments.project_id%TYPE;
57: l_project_status_name pa_project_statuses.project_status_name%TYPE;
58: l_success_status_code pa_project_statuses.project_status_code%TYPE;
59: l_failure_status_code pa_project_statuses.project_status_code%TYPE;
60: l_start_date pa_project_assignments.start_date%TYPE;

Line 60: l_start_date pa_project_assignments.start_date%TYPE;

56: l_project_id pa_project_assignments.project_id%TYPE;
57: l_project_status_name pa_project_statuses.project_status_name%TYPE;
58: l_success_status_code pa_project_statuses.project_status_code%TYPE;
59: l_failure_status_code pa_project_statuses.project_status_code%TYPE;
60: l_start_date pa_project_assignments.start_date%TYPE;
61: l_pending_approval_flag pa_project_assignments.pending_approval_flag%TYPE;
62: l_project_manager_person_id NUMBER ;
63: l_project_manager_name VARCHAR2(200);
64: l_project_party_id NUMBER ;

Line 61: l_pending_approval_flag pa_project_assignments.pending_approval_flag%TYPE;

57: l_project_status_name pa_project_statuses.project_status_name%TYPE;
58: l_success_status_code pa_project_statuses.project_status_code%TYPE;
59: l_failure_status_code pa_project_statuses.project_status_code%TYPE;
60: l_start_date pa_project_assignments.start_date%TYPE;
61: l_pending_approval_flag pa_project_assignments.pending_approval_flag%TYPE;
62: l_project_manager_person_id NUMBER ;
63: l_project_manager_name VARCHAR2(200);
64: l_project_party_id NUMBER ;
65: l_project_role_id NUMBER ;

Line 77: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;

73: l_approver2_person_type VARCHAR2(100);
74: l_change_id NUMBER;
75: l_record_version_number NUMBER;
76: l_return_status VARCHAR2(1);
77: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
78: l_next_status_code pa_project_assignments.apprvl_status_code%TYPE;
79: l_schedule_status_code pa_project_assignments.status_code%TYPE;
80: l_msg_count NUMBER;
81: l_msg_data VARCHAR2(2000);

Line 78: l_next_status_code pa_project_assignments.apprvl_status_code%TYPE;

74: l_change_id NUMBER;
75: l_record_version_number NUMBER;
76: l_return_status VARCHAR2(1);
77: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
78: l_next_status_code pa_project_assignments.apprvl_status_code%TYPE;
79: l_schedule_status_code pa_project_assignments.status_code%TYPE;
80: l_msg_count NUMBER;
81: l_msg_data VARCHAR2(2000);
82: l_msg_index_out NUMBER;

Line 79: l_schedule_status_code pa_project_assignments.status_code%TYPE;

75: l_record_version_number NUMBER;
76: l_return_status VARCHAR2(1);
77: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
78: l_next_status_code pa_project_assignments.apprvl_status_code%TYPE;
79: l_schedule_status_code pa_project_assignments.status_code%TYPE;
80: l_msg_count NUMBER;
81: l_msg_data VARCHAR2(2000);
82: l_msg_index_out NUMBER;
83: l_wf_type VARCHAR2(80) := NULL;

Line 100: FROM pa_project_assignments ppa,

96:
97: CURSOR get_asgmt_info IS
98: SELECT ppa.assignment_type, ppa.project_id, ppa.start_date, ppa.status_code,
99: pps.project_status_name, ppa.pending_approval_flag
100: FROM pa_project_assignments ppa,
101: pa_project_statuses pps,
102: pa_projects_all pal
103: WHERE ppa.assignment_id = p_assignment_id
104: AND ppa.project_id = pal.project_id

Line 117: TYPE status_codes IS TABLE OF pa_project_assignments.status_code%TYPE;

113: SELECT employee_id
114: FROM fnd_user
115: WHERE user_id = l_submitter_user_id;
116:
117: TYPE status_codes IS TABLE OF pa_project_assignments.status_code%TYPE;
118: l_status_codes status_codes;
119:
120:
121: BEGIN

Line 653: --API used to revert the current record in pa_project_assignments table to the last approved record in history table.

649:
650:
651:
652: --
653: --API used to revert the current record in pa_project_assignments table to the last approved record in history table.
654: --
655: PROCEDURE Revert_To_Last_Approved
656: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
657: ,p_api_version IN NUMBER := 1.0

Line 656: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

652: --
653: --API used to revert the current record in pa_project_assignments table to the last approved record in history table.
654: --
655: PROCEDURE Revert_To_Last_Approved
656: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
657: ,p_api_version IN NUMBER := 1.0
658: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
659: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
660: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 673: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;

669: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
670: l_change_id NUMBER;
671: l_record_version_number NUMBER;
672: l_return_status VARCHAR2(1);
673: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
674: l_next_status_code pa_project_assignments.apprvl_status_code%TYPE;
675: l_msg_count NUMBER;
676: l_msg_data VARCHAR2(2000);
677: l_msg_index_out NUMBER;

Line 674: l_next_status_code pa_project_assignments.apprvl_status_code%TYPE;

670: l_change_id NUMBER;
671: l_record_version_number NUMBER;
672: l_return_status VARCHAR2(1);
673: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
674: l_next_status_code pa_project_assignments.apprvl_status_code%TYPE;
675: l_msg_count NUMBER;
676: l_msg_data VARCHAR2(2000);
677: l_msg_index_out NUMBER;
678: l_project_subteam_party_id NUMBER;

Line 683: FROM pa_project_assignments

679: l_project_subteam_id NUMBER;
680:
681: CURSOR get_apprvl_stus_and_record_num IS
682: SELECT apprvl_status_code, record_version_number
683: FROM pa_project_assignments
684: WHERE assignment_id = p_assignment_id;
685:
686: BEGIN
687:

Line 942: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row

938: ,x_msg => 'Update current record with history record details.'
939: ,x_log_level => 5);
940: END IF;
941:
942: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row
943: (p_assignment_id => l_assignment_rec.assignment_id
944: ,p_record_version_number => l_record_version_number
945: ,p_assignment_name => l_assignment_rec.assignment_name
946: ,p_assignment_type => l_assignment_rec.assignment_type

Line 1051: ,p_object_type => 'PA_PROJECT_ASSIGNMENTS'

1047: PA_PROJECT_SUBTEAM_PARTIES_PVT.Update_SPT_Assgn
1048: ( p_validate_only => p_validate_only
1049: ,p_get_subteam_party_id_flag => 'Y'
1050: ,p_project_subteam_id => l_project_subteam_id
1051: ,p_object_type => 'PA_PROJECT_ASSIGNMENTS'
1052: ,p_object_id => p_assignment_id
1053: ,x_project_subteam_party_id => l_project_subteam_party_id
1054: ,x_return_status => l_return_status
1055: ,x_record_version_number => l_record_version_number

Line 1119: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE

1115: -- the last approved record, and stores those changed fields and their old and new values in the table.
1116: -- Currently, this api is called by Single/Mass Submit for Approval
1117: --
1118: PROCEDURE Populate_Changed_Items_Table
1119: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
1120: ,p_populate_mode IN VARCHAR2 := 'SAVED'
1121: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1122: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1123: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

Line 1121: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR

1117: --
1118: PROCEDURE Populate_Changed_Items_Table
1119: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
1120: ,p_populate_mode IN VARCHAR2 := 'SAVED'
1121: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1122: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1123: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

Line 1122: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

1118: PROCEDURE Populate_Changed_Items_Table
1119: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
1120: ,p_populate_mode IN VARCHAR2 := 'SAVED'
1121: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1122: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1123: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

Line 1123: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

1119: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
1120: ,p_populate_mode IN VARCHAR2 := 'SAVED'
1121: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1122: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1123: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

Line 1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

1120: ,p_populate_mode IN VARCHAR2 := 'SAVED'
1121: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1122: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1123: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR

Line 1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

1121: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1122: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1123: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM

Line 1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

1122: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1123: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

Line 1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

1123: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

Line 1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR

1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1132: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR

Line 1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM

1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1132: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1133: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM

Line 1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1132: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1133: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
1134: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

Line 1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1132: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1133: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
1134: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
1135: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR

Line 1132: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR

1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1132: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1133: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
1134: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
1135: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
1136: ,p_exception_type_code IN VARCHAR2 := NULL

Line 1133: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM

1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1132: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1133: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
1134: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
1135: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
1136: ,p_exception_type_code IN VARCHAR2 := NULL
1137: ,p_start_date IN DATE := NULL

Line 1134: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1132: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1133: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
1134: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
1135: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
1136: ,p_exception_type_code IN VARCHAR2 := NULL
1137: ,p_start_date IN DATE := NULL
1138: ,p_end_date IN DATE := NULL

Line 1196: FROM pa_project_assignments

1192: l_updated_asmt_rec pa_assignments_pub.assignment_rec_type;
1193:
1194: CURSOR get_rec_ver_num IS
1195: SELECT record_version_number
1196: FROM pa_project_assignments
1197: WHERE assignment_id = p_assignment_id;
1198:
1199: CURSOR get_locations (new_location_id NUMBER, old_location_id NUMBER) IS
1200: SELECT location_id, city, region, country_code

Line 1212: WHERE object_type = 'PA_PROJECT_ASSIGNMENTS'

1208:
1209: CURSOR get_project_subteam_id IS
1210: SELECT project_subteam_id
1211: FROM pa_project_subteam_parties
1212: WHERE object_type = 'PA_PROJECT_ASSIGNMENTS'
1213: AND object_id = p_assignment_id
1214: AND primary_subteam_flag = 'Y';
1215:
1216: CURSOR get_his_project_subteam_id IS

Line 1606: l_assignment_number pa_project_assignments.assignment_number%TYPE;

1602: x_msg_data OUT NOCOPY Varchar2 ) --File.Sql.39 bug 4440895
1603: IS
1604: l_msg_index_out NUMBER;
1605: l_assignment_row_id ROWID;
1606: l_assignment_number pa_project_assignments.assignment_number%TYPE;
1607: l_project_id pa_project_assignments.project_id%TYPE;
1608: l_calendar_id pa_project_assignments.calendar_id%TYPE;
1609: l_asgn_end_date pa_project_assignments.end_date%TYPE;
1610: l_asgn_start_date pa_project_assignments.start_date%TYPE;

Line 1607: l_project_id pa_project_assignments.project_id%TYPE;

1603: IS
1604: l_msg_index_out NUMBER;
1605: l_assignment_row_id ROWID;
1606: l_assignment_number pa_project_assignments.assignment_number%TYPE;
1607: l_project_id pa_project_assignments.project_id%TYPE;
1608: l_calendar_id pa_project_assignments.calendar_id%TYPE;
1609: l_asgn_end_date pa_project_assignments.end_date%TYPE;
1610: l_asgn_start_date pa_project_assignments.start_date%TYPE;
1611: l_source_assignment_id pa_project_assignments.source_assignment_id%TYPE;

Line 1608: l_calendar_id pa_project_assignments.calendar_id%TYPE;

1604: l_msg_index_out NUMBER;
1605: l_assignment_row_id ROWID;
1606: l_assignment_number pa_project_assignments.assignment_number%TYPE;
1607: l_project_id pa_project_assignments.project_id%TYPE;
1608: l_calendar_id pa_project_assignments.calendar_id%TYPE;
1609: l_asgn_end_date pa_project_assignments.end_date%TYPE;
1610: l_asgn_start_date pa_project_assignments.start_date%TYPE;
1611: l_source_assignment_id pa_project_assignments.source_assignment_id%TYPE;
1612: l_record_version_number pa_project_assignments.record_version_number%TYPE;

Line 1609: l_asgn_end_date pa_project_assignments.end_date%TYPE;

1605: l_assignment_row_id ROWID;
1606: l_assignment_number pa_project_assignments.assignment_number%TYPE;
1607: l_project_id pa_project_assignments.project_id%TYPE;
1608: l_calendar_id pa_project_assignments.calendar_id%TYPE;
1609: l_asgn_end_date pa_project_assignments.end_date%TYPE;
1610: l_asgn_start_date pa_project_assignments.start_date%TYPE;
1611: l_source_assignment_id pa_project_assignments.source_assignment_id%TYPE;
1612: l_record_version_number pa_project_assignments.record_version_number%TYPE;
1613: l_asgn_status_canceled_flag VARCHAR2(1);

Line 1610: l_asgn_start_date pa_project_assignments.start_date%TYPE;

1606: l_assignment_number pa_project_assignments.assignment_number%TYPE;
1607: l_project_id pa_project_assignments.project_id%TYPE;
1608: l_calendar_id pa_project_assignments.calendar_id%TYPE;
1609: l_asgn_end_date pa_project_assignments.end_date%TYPE;
1610: l_asgn_start_date pa_project_assignments.start_date%TYPE;
1611: l_source_assignment_id pa_project_assignments.source_assignment_id%TYPE;
1612: l_record_version_number pa_project_assignments.record_version_number%TYPE;
1613: l_asgn_status_canceled_flag VARCHAR2(1);
1614: l_req_status_canceled_flag VARCHAR2(1);

Line 1611: l_source_assignment_id pa_project_assignments.source_assignment_id%TYPE;

1607: l_project_id pa_project_assignments.project_id%TYPE;
1608: l_calendar_id pa_project_assignments.calendar_id%TYPE;
1609: l_asgn_end_date pa_project_assignments.end_date%TYPE;
1610: l_asgn_start_date pa_project_assignments.start_date%TYPE;
1611: l_source_assignment_id pa_project_assignments.source_assignment_id%TYPE;
1612: l_record_version_number pa_project_assignments.record_version_number%TYPE;
1613: l_asgn_status_canceled_flag VARCHAR2(1);
1614: l_req_status_canceled_flag VARCHAR2(1);
1615: l_full_cancel_flag VARCHAR2(1);

Line 1612: l_record_version_number pa_project_assignments.record_version_number%TYPE;

1608: l_calendar_id pa_project_assignments.calendar_id%TYPE;
1609: l_asgn_end_date pa_project_assignments.end_date%TYPE;
1610: l_asgn_start_date pa_project_assignments.start_date%TYPE;
1611: l_source_assignment_id pa_project_assignments.source_assignment_id%TYPE;
1612: l_record_version_number pa_project_assignments.record_version_number%TYPE;
1613: l_asgn_status_canceled_flag VARCHAR2(1);
1614: l_req_status_canceled_flag VARCHAR2(1);
1615: l_full_cancel_flag VARCHAR2(1);
1616: l_start_req_status_code pa_project_statuses.project_status_code%TYPE;

Line 1622: l_assignment_type pa_project_assignments.assignment_type%TYPE;

1618: l_change_id NUMBER;
1619: l_apprvl_status_code pa_project_statuses.project_status_code%TYPE;
1620: l_save_to_hist VARCHAR2(1);
1621: l_new_assignment_id NUMBER;
1622: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1623: l_req_start_date pa_project_assignments.start_date%TYPE;
1624: l_project_party_id pa_project_assignments.project_party_id%TYPE;
1625: l_error_message_code fnd_new_messages.message_name%TYPE;
1626: l_resource_id pa_project_assignments.resource_id%TYPE;

Line 1623: l_req_start_date pa_project_assignments.start_date%TYPE;

1619: l_apprvl_status_code pa_project_statuses.project_status_code%TYPE;
1620: l_save_to_hist VARCHAR2(1);
1621: l_new_assignment_id NUMBER;
1622: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1623: l_req_start_date pa_project_assignments.start_date%TYPE;
1624: l_project_party_id pa_project_assignments.project_party_id%TYPE;
1625: l_error_message_code fnd_new_messages.message_name%TYPE;
1626: l_resource_id pa_project_assignments.resource_id%TYPE;
1627: l_conflict_group_id NUMBER;

Line 1624: l_project_party_id pa_project_assignments.project_party_id%TYPE;

1620: l_save_to_hist VARCHAR2(1);
1621: l_new_assignment_id NUMBER;
1622: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1623: l_req_start_date pa_project_assignments.start_date%TYPE;
1624: l_project_party_id pa_project_assignments.project_party_id%TYPE;
1625: l_error_message_code fnd_new_messages.message_name%TYPE;
1626: l_resource_id pa_project_assignments.resource_id%TYPE;
1627: l_conflict_group_id NUMBER;
1628: l_overcommitment_flag VARCHAR2(1);

Line 1626: l_resource_id pa_project_assignments.resource_id%TYPE;

1622: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1623: l_req_start_date pa_project_assignments.start_date%TYPE;
1624: l_project_party_id pa_project_assignments.project_party_id%TYPE;
1625: l_error_message_code fnd_new_messages.message_name%TYPE;
1626: l_resource_id pa_project_assignments.resource_id%TYPE;
1627: l_conflict_group_id NUMBER;
1628: l_overcommitment_flag VARCHAR2(1);
1629: l_action_set_id NUMBER;
1630: l_return_status VARCHAR2(1);

Line 1641: FROM pa_project_assignments

1637:
1638:
1639: CURSOR check_record_version IS
1640: SELECT ROWID, project_id, calendar_id, start_date, end_date, source_assignment_id, project_party_id, resource_id
1641: FROM pa_project_assignments
1642: WHERE assignment_id = p_assignment_id
1643: AND record_version_number = p_record_version_number;
1644:
1645: CURSOR get_requirement_info IS

Line 1647: FROM pa_project_assignments

1643: AND record_version_number = p_record_version_number;
1644:
1645: CURSOR get_requirement_info IS
1646: SELECT assignment_type, start_date
1647: FROM pa_project_assignments
1648: WHERE assignment_id = l_source_assignment_id;
1649:
1650: CURSOR get_record_version IS
1651: SELECT record_version_number

Line 1652: FROM pa_project_assignments

1648: WHERE assignment_id = l_source_assignment_id;
1649:
1650: CURSOR get_record_version IS
1651: SELECT record_version_number
1652: FROM pa_project_assignments
1653: WHERE assignment_id = p_assignment_id;
1654:
1655: -- get advertisement action set details
1656: CURSOR get_action_set IS

Line 1672: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage

1668: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
1669: FROM PA_RESOURCE_ASSIGNMENTS ra
1670: ,PA_BUDGET_VERSIONS bv
1671: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1672: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage
1673: WHERE ra.project_id = bv.project_id
1674: AND bv.project_id = evs.project_id
1675: AND ra.budget_version_id = bv.budget_version_id
1676: AND bv.project_structure_version_id = evs.element_version_id

Line 1688: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage

1684: FROM PA_RESOURCE_ASSIGNMENTS ra
1685: ,PA_BUDGET_VERSIONS bv
1686: ,PA_PROJ_ELEM_VER_STRUCTURE evs
1687: ,PA_PROJ_WORKPLAN_ATTR pwa
1688: -- ,PA_PROJECT_ASSIGNMENTS pa -- 5110598 Removed PA_PROJECT_ASSIGNMENTS table usage
1689: WHERE pwa.wp_enable_Version_flag = 'N'
1690: AND pwa.project_id = ra.project_id
1691: AND pwa.proj_element_id = evs.proj_element_id
1692: AND ra.project_id = bv.project_id

Line 1707: pa_project_assignments pa

1703: CURSOR get_res_mand_attributes IS
1704: SELECT rf.ROLE_ENABLED_FLAG
1705: FROM pa_res_formats_b rf,
1706: pa_resource_list_members rlm,
1707: pa_project_assignments pa
1708: WHERE pa.assignment_id = p_assignment_id
1709: AND pa.resource_list_member_id IS NOT NULL
1710: AND rlm.resource_list_member_id = pa.resource_list_member_id
1711: AND rlm.res_format_id = rf.res_format_id;

Line 1958: UPDATE pa_project_assignments

1954:
1955: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1956:
1957: --Need to keep the link from the new requirement to the canceled assignment
1958: UPDATE pa_project_assignments
1959: SET source_assignment_id = p_assignment_id
1960: WHERE assignment_id = l_new_assignment_id;
1961:
1962: --Copy the Candidate List from the old requirement to the new requirement

Line 2211: l_assignment_status_code pa_project_assignments.status_code%TYPE;

2207: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
2208: x_msg_data OUT NOCOPY Varchar2 ) --File.Sql.39 bug 4440895
2209:
2210: IS
2211: l_assignment_status_code pa_project_assignments.status_code%TYPE;
2212: l_msg_index_out NUMBER;
2213: l_start_date DATE;
2214: l_end_date DATE;
2215: l_return_status VARCHAR2(1);

Line 2222: FROM pa_project_assignments asgn,

2218: l_person_id NUMBER;
2219:
2220: CURSOR get_start_end_date IS
2221: SELECT asgn.start_date, asgn.end_date, asgn.project_id, res.person_id
2222: FROM pa_project_assignments asgn,
2223: pa_resources_denorm res
2224: WHERE assignment_id = p_assignment_id
2225: AND res.resource_id = asgn.resource_id
2226: AND rownum=1;

Line 2375: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR

2371: (p_mode IN VARCHAR2
2372: ,p_action IN VARCHAR2
2373: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2374: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2375: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2376: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

Line 2376: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR

2372: ,p_action IN VARCHAR2
2373: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2374: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2375: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2376: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

Line 2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR

2373: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2374: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2375: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2376: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2381: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM

Line 2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR

2374: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2375: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2376: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2381: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2382: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM

Line 2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

2375: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2376: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2381: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2382: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2383: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

Line 2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

2376: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2381: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2382: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2383: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2384: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

Line 2381: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM

2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2381: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2382: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2383: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2384: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2385: ,p_append_description_flag IN VARCHAR2 := 'N'

Line 2384: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2381: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2382: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2383: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2384: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2385: ,p_append_description_flag IN VARCHAR2 := 'N'
2386: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2388: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

Line 2386: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE

2382: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2383: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2384: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2385: ,p_append_description_flag IN VARCHAR2 := 'N'
2386: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2388: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2389: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

Line 2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

2383: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2384: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2385: ,p_append_description_flag IN VARCHAR2 := 'N'
2386: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2388: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2389: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

Line 2388: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

2384: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2385: ,p_append_description_flag IN VARCHAR2 := 'N'
2386: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2388: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2389: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2392: ,p_append_information_flag IN VARCHAR2 := 'N'

Line 2389: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM

2385: ,p_append_description_flag IN VARCHAR2 := 'N'
2386: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2388: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2389: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2392: ,p_append_information_flag IN VARCHAR2 := 'N'
2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM

Line 2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

2386: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2388: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2389: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2392: ,p_append_information_flag IN VARCHAR2 := 'N'
2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

Line 2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2388: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2389: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2392: ,p_append_information_flag IN VARCHAR2 := 'N'
2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR

Line 2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM

2389: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2392: ,p_append_information_flag IN VARCHAR2 := 'N'
2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM

Line 2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2392: ,p_append_information_flag IN VARCHAR2 := 'N'
2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

Line 2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR

2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2392: ,p_append_information_flag IN VARCHAR2 := 'N'
2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2399: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

Line 2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM

2392: ,p_append_information_flag IN VARCHAR2 := 'N'
2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2399: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2400: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

Line 2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM

2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2399: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2400: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2401: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

Line 2410: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR

2406: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2407: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2408: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2409: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2410: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2411: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM

Line 2411: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM

2407: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2408: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2409: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2410: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2411: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM

Line 2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR

2408: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2409: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2410: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2411: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM

Line 2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

2409: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2410: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2411: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM

Line 2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM

2410: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2411: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

Line 2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM

2411: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR

Line 2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM

2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM

2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR

2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

Line 2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM

2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR

Line 2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM

2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2425: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

Line 2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2425: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2426: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

Line 2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2425: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2426: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2427: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR

Line 2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR

2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2425: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2426: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2427: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2428: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

Line 2426: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2425: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2426: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2427: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2428: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2429: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2430: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

Line 2428: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2425: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2426: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2427: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2428: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2429: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2430: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2431: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2432: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

Line 2430: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

2426: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2427: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2428: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2429: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2430: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2431: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2432: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2433: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2434: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

Line 2431: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR

2427: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2428: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2429: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2430: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2431: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2432: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2433: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2434: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2435: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

Line 2432: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

2428: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2429: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2430: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2431: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2432: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2433: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2434: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2435: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2436: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 2754: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

2750: --The IN parameters are assignments table which are submitted for
2751: --approval along with 2 approvers tables
2752: ---------------------------------------------------------------------------
2753: PROCEDURE mass_assignment_approval
2754: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2755: ,p_mode IN VARCHAR2
2756: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2757: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2758: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

Line 2798: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;

2794: l_routing_order NUMBER;
2795: l_change_id NUMBER;
2796: l_record_version_number NUMBER;
2797: p_record_version_number NUMBER;
2798: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
2799: l_project_super_user_submitter VARCHAR2(1);
2800: l_display_name VARCHAR2(360); /* Modified length from 200 to 360 for bug 3148857 */
2801: l_approver_name VARCHAR2(320); /* Modified length from 200 to 320 for bug 3148857 */
2802:

Line 2805: FROM pa_project_assignments

2801: l_approver_name VARCHAR2(320); /* Modified length from 200 to 320 for bug 3148857 */
2802:
2803: CURSOR resource_id (p_assignment_id NUMBER) IS
2804: SELECT resource_id
2805: FROM pa_project_assignments
2806: WHERE assignment_id = p_assignment_id;
2807:
2808: l_resource_id NUMBER;
2809:

Line 2812: FROM pa_project_assignments

2808: l_resource_id NUMBER;
2809:
2810: CURSOR get_rec_num ( p_assignment_id IN NUMBER )IS
2811: SELECT record_version_number
2812: FROM pa_project_assignments
2813: WHERE assignment_id = p_assignment_id;
2814:
2815: CURSOR l_stus_csr IS
2816: SELECT ps.enable_wf_flag

Line 2834: pa_project_assignments asgn

2830:
2831: CURSOR distinct_approvers IS
2832: SELECT distinct user_name
2833: FROM pa_wf_ntf_performers ntf,
2834: pa_project_assignments asgn
2835: WHERE ntf.group_id = l_group_id
2836: AND ntf.object_id1 = asgn.assignment_id
2837: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted
2838: AND ntf.routing_order = 1;

Line 2876: l_asgn_approval_status pa_project_assignments.apprvl_status_code%TYPE;

2872: FROM fnd_user
2873: WHERE user_id = p_submitter_user_id;
2874: l_submitter_rec get_submitter_details%ROWTYPE;
2875:
2876: l_asgn_approval_status pa_project_assignments.apprvl_status_code%TYPE;
2877:
2878: PROCESS_ASSIGNMENT_EXCEPTION EXCEPTION;
2879: NO_WORKFLOW_EXCEPTION EXCEPTION;
2880: INVALID_STATUS EXCEPTION;

Line 3204: FROM pa_project_assignments

3200: ----------------------------------------------------------
3201: BEGIN
3202: SELECT apprvl_status_code
3203: INTO l_asgn_approval_status
3204: FROM pa_project_assignments
3205: WHERE assignment_id = l_assignment_id_tbl(i);
3206: EXCEPTION
3207: WHEN NO_DATA_FOUND THEN
3208: l_asgn_approval_status := null;

Line 3423: --Set pending approval flag for assignment record in pa_project_assignments

3419: l_routing_order := l_routing_order + 1;
3420:
3421: END LOOP;--end k loop
3422:
3423: --Set pending approval flag for assignment record in pa_project_assignments
3424: PA_ASGMT_WFSTD.Maintain_wf_pending_flag
3425: (p_assignment_id => l_assignment_id_tbl(i),
3426: p_mode => 'PENDING_APPROVAL') ;
3427:

Line 3455: --Setting pending approval flag in pa_project_assignments

3451: p_context3 => l_resource_id,
3452: p_commit => FND_API.G_FALSE,
3453: x_return_status => l_return_status);
3454:
3455: --Setting pending approval flag in pa_project_assignments
3456: PA_ASGMT_WFSTD.Maintain_wf_pending_flag
3457: (p_assignment_id => l_assignment_id_tbl(i),
3458: p_mode => 'APPROVAL_PROCESS_COMPLETED') ;
3459:

Line 3463: UPDATE pa_project_assignments

3459:
3460: ---------------------------
3461: --Set the mass wf flag
3462: ---------------------------
3463: UPDATE pa_project_assignments
3464: SET mass_wf_in_progress_flag = 'N'
3465: WHERE assignment_id = l_assignment_id_tbl(i);
3466:
3467: l_assignment_id_tbl(i) := NULL;

Line 3539: pa_project_assignments asgn

3535:
3536: SELECT count(*)
3537: INTO l_num_apr_asgns
3538: FROM pa_wf_ntf_performers ntf,
3539: pa_project_assignments asgn
3540: WHERE ntf.group_id = l_group_id
3541: AND ntf.routing_order = 1
3542: AND ntf.object_id1 = asgn.assignment_id
3543: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved ;

Line 3557: pa_project_assignments asgn

3553:
3554: SELECT count(*)
3555: INTO l_num_rej_asgns
3556: FROM pa_wf_ntf_performers ntf,
3557: pa_project_assignments asgn
3558: WHERE ntf.group_id = l_group_id
3559: AND ntf.routing_order = 1
3560: AND ntf.object_id1 = asgn.assignment_id
3561: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_rejected ;

Line 3605: pa_project_assignments asgn

3601: --which have been approved
3602: SELECT ntf.object_id1
3603: BULK COLLECT INTO l_appr_asgmt_id_tbl
3604: FROM pa_wf_ntf_performers ntf,
3605: pa_project_assignments asgn
3606: WHERE ntf.group_id = l_group_id
3607: AND ntf.routing_order = 1
3608: AND ntf.object_id1 = asgn.assignment_id
3609: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved ;

Line 3755: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

3751: --Workflow Itemtype: PARMAAP
3752: --Workflow process : 'PA_MASS_PROCESS_APRVL_RESULT'
3753: ---------------------------------------------------------
3754: PROCEDURE mass_process_approval_result
3755: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
3756: ,p_mode IN VARCHAR2
3757: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
3758: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
3759: ,p_group_id IN NUMBER

Line 4132: FROM pa_project_assignments

4128:
4129: --Get the assignment start date
4130: SELECT start_date
4131: INTO l_assignment_start_date
4132: FROM pa_project_assignments
4133: WHERE assignment_id = p_assignment_id_tbl(i);
4134:
4135: IF p_approver1_id_tbl.EXISTS(i) THEN
4136: IF p_approver1_id_tbl(i) <> -999 THEN

Line 4250: --Setting pending approval flag in pa_project_assignments

4246: --Populate x_success_assignment_id_tbl
4247: -------------------------------------------
4248: IF FND_MSG_PUB.Count_Msg > 0 THEN
4249:
4250: --Setting pending approval flag in pa_project_assignments
4251: PA_ASGMT_WFSTD.Maintain_wf_pending_flag
4252: (p_assignment_id => p_assignment_id_tbl(i),
4253: p_mode => 'APPROVAL_PROCESS_COMPLETED') ;
4254:

Line 4258: UPDATE pa_project_assignments

4254:
4255: ---------------------------
4256: --Set the mass wf flag
4257: ---------------------------
4258: UPDATE pa_project_assignments
4259: SET mass_wf_in_progress_flag = 'N'
4260: WHERE assignment_id = p_assignment_id_tbl(i);
4261:
4262: x_assignment_id_tbl (i) := null;

Line 4271: FROM pa_project_assignments

4267: IF FND_MSG_PUB.Count_Msg > 0 THEN
4268:
4269: SELECT resource_id
4270: INTO l_resource_id
4271: FROM pa_project_assignments
4272: WHERE assignment_id = p_assignment_id_tbl(i);
4273:
4274: log_message('Value of submitter user id:' || p_submitter_user_id);
4275: