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 1989: update pa_project_assignments set no_of_active_candidates=0

1985: ,x_return_status => x_return_status
1986: ,x_msg_count => x_msg_count
1987: ,x_msg_data => x_msg_data);
1988:
1989: update pa_project_assignments set no_of_active_candidates=0
1990: where assignment_id = l_source_assignment_id;
1991: --end of anuragag changes for bug 8763672
1992:
1993: END IF; -- end of checking source assignment id

Line 2163: FROM pa_project_assignments

2159:
2160: -- Added for Bug# 8296021
2161: CURSOR get_wf_progress_flag IS
2162: SELECT nvl(mass_wf_in_progress_flag,'N')
2163: FROM pa_project_assignments
2164: WHERE assignment_id = p_assignment_id;
2165:
2166: CURSOR get_user_id_mflow IS
2167: SELECT fu.user_id

Line 2267: l_assignment_status_code pa_project_assignments.status_code%TYPE;

2263: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
2264: x_msg_data OUT NOCOPY Varchar2 ) --File.Sql.39 bug 4440895
2265:
2266: IS
2267: l_assignment_status_code pa_project_assignments.status_code%TYPE;
2268: l_msg_index_out NUMBER;
2269: l_start_date DATE;
2270: l_end_date DATE;
2271: l_return_status VARCHAR2(1);

Line 2278: FROM pa_project_assignments asgn,

2274: l_person_id NUMBER;
2275:
2276: CURSOR get_start_end_date IS
2277: SELECT asgn.start_date, asgn.end_date, asgn.project_id, res.person_id
2278: FROM pa_project_assignments asgn,
2279: pa_resources_denorm res
2280: WHERE assignment_id = p_assignment_id
2281: AND res.resource_id = asgn.resource_id
2282: AND rownum=1;

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

2432: (p_mode IN VARCHAR2
2433: ,p_action IN VARCHAR2
2434: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2435: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2436: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2438: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2439: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2440: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

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

2433: ,p_action IN VARCHAR2
2434: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2435: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2436: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2438: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2439: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2440: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2441: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

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

2434: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2435: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2436: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2438: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2439: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2440: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2441: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2442: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM

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

2435: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2436: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2438: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2439: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2440: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2441: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2442: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2443: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM

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

2436: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2438: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2439: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2440: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2441: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2442: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2443: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2444: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

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

2437: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2438: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2439: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2440: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2441: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2442: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2443: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2444: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2445: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

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

2438: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2439: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2440: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2441: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2442: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2443: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2444: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2445: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2446: ,p_append_description_flag IN VARCHAR2 := 'N'

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

2441: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2442: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2443: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2444: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2445: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2446: ,p_append_description_flag IN VARCHAR2 := 'N'
2447: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2448: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2449: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

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

2443: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2444: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2445: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2446: ,p_append_description_flag IN VARCHAR2 := 'N'
2447: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2448: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2449: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2450: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2451: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

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

2444: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2445: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2446: ,p_append_description_flag IN VARCHAR2 := 'N'
2447: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2448: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2449: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2450: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2451: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2452: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

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

2445: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2446: ,p_append_description_flag IN VARCHAR2 := 'N'
2447: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2448: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2449: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2450: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2451: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2452: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2453: ,p_append_information_flag IN VARCHAR2 := 'N'

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

2446: ,p_append_description_flag IN VARCHAR2 := 'N'
2447: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2448: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2449: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2450: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2451: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2452: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2453: ,p_append_information_flag IN VARCHAR2 := 'N'
2454: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM

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

2447: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2448: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2449: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2450: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2451: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2452: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2453: ,p_append_information_flag IN VARCHAR2 := 'N'
2454: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2455: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

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

2448: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2449: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2450: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2451: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2452: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2453: ,p_append_information_flag IN VARCHAR2 := 'N'
2454: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2455: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2456: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR

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

2450: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2451: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2452: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2453: ,p_append_information_flag IN VARCHAR2 := 'N'
2454: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2455: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2456: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2457: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2458: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM

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

2451: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2452: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2453: ,p_append_information_flag IN VARCHAR2 := 'N'
2454: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2455: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2456: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2457: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2458: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2459: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

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

2452: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2453: ,p_append_information_flag IN VARCHAR2 := 'N'
2454: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2455: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2456: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2457: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2458: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2459: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2460: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

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

2453: ,p_append_information_flag IN VARCHAR2 := 'N'
2454: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2455: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2456: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2457: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2458: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2459: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2460: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2461: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

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

2454: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2455: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2456: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2457: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2458: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2459: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2460: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2461: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2462: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

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

2467: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2468: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2469: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2470: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2471: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2472: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2473: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM

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

2468: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2469: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2470: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2471: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2472: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2473: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM

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

2469: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2470: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2471: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2472: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2473: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM

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

2470: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2471: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2472: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2473: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM

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

2471: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2472: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2473: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

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

2472: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2473: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR

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

2473: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM

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

2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2482: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM

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

2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2482: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2483: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

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

2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2482: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2483: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2484: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

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

2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2482: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2483: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2484: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2485: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR

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

2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2482: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2483: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2484: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2485: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2486: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

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

2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2482: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2483: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2484: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2485: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2486: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2487: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

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

2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2482: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2483: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2484: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2485: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2486: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2487: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2488: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR

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

2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2482: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2483: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2484: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2485: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2486: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2487: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2488: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2489: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

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

2483: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2484: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2485: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2486: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2487: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2488: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2489: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2490: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2491: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

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

2485: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2486: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2487: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2488: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2489: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2490: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2491: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2492: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2493: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

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

2487: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2488: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2489: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2490: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2491: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2492: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2493: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2494: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2495: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

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

2488: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2489: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2490: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2491: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2492: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2493: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2494: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2495: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2496: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

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

2489: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2490: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2491: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2492: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2493: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2494: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2495: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2496: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2497: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

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

2811: --The IN parameters are assignments table which are submitted for
2812: --approval along with 2 approvers tables
2813: ---------------------------------------------------------------------------
2814: PROCEDURE mass_assignment_approval
2815: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2816: ,p_mode IN VARCHAR2
2817: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2818: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2819: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

Line 2859: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;

2855: l_routing_order NUMBER;
2856: l_change_id NUMBER;
2857: l_record_version_number NUMBER;
2858: p_record_version_number NUMBER;
2859: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
2860: l_project_super_user_submitter VARCHAR2(1);
2861: l_display_name VARCHAR2(360); /* Modified length from 200 to 360 for bug 3148857 */
2862: l_approver_name VARCHAR2(320); /* Modified length from 200 to 320 for bug 3148857 */
2863:

Line 2866: FROM pa_project_assignments

2862: l_approver_name VARCHAR2(320); /* Modified length from 200 to 320 for bug 3148857 */
2863:
2864: CURSOR resource_id (p_assignment_id NUMBER) IS
2865: SELECT resource_id
2866: FROM pa_project_assignments
2867: WHERE assignment_id = p_assignment_id;
2868:
2869: l_resource_id NUMBER;
2870:

Line 2873: FROM pa_project_assignments

2869: l_resource_id NUMBER;
2870:
2871: CURSOR get_rec_num ( p_assignment_id IN NUMBER )IS
2872: SELECT record_version_number
2873: FROM pa_project_assignments
2874: WHERE assignment_id = p_assignment_id;
2875:
2876: CURSOR l_stus_csr IS
2877: SELECT ps.enable_wf_flag

Line 2895: pa_project_assignments asgn

2891:
2892: CURSOR distinct_approvers IS
2893: SELECT distinct user_name
2894: FROM pa_wf_ntf_performers ntf,
2895: pa_project_assignments asgn
2896: WHERE ntf.group_id = l_group_id
2897: AND ntf.object_id1 = asgn.assignment_id
2898: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted
2899: AND ntf.routing_order = 1;

Line 2937: l_asgn_approval_status pa_project_assignments.apprvl_status_code%TYPE;

2933: FROM fnd_user
2934: WHERE user_id = p_submitter_user_id;
2935: l_submitter_rec get_submitter_details%ROWTYPE;
2936:
2937: l_asgn_approval_status pa_project_assignments.apprvl_status_code%TYPE;
2938:
2939: PROCESS_ASSIGNMENT_EXCEPTION EXCEPTION;
2940: NO_WORKFLOW_EXCEPTION EXCEPTION;
2941: INVALID_STATUS EXCEPTION;

Line 3265: FROM pa_project_assignments

3261: ----------------------------------------------------------
3262: BEGIN
3263: SELECT apprvl_status_code
3264: INTO l_asgn_approval_status
3265: FROM pa_project_assignments
3266: WHERE assignment_id = l_assignment_id_tbl(i);
3267: EXCEPTION
3268: WHEN NO_DATA_FOUND THEN
3269: l_asgn_approval_status := null;

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

3484: l_routing_order := l_routing_order + 1;
3485:
3486: END LOOP;--end k loop
3487:
3488: --Set pending approval flag for assignment record in pa_project_assignments
3489: PA_ASGMT_WFSTD.Maintain_wf_pending_flag
3490: (p_assignment_id => l_assignment_id_tbl(i),
3491: p_mode => 'PENDING_APPROVAL') ;
3492:

Line 3520: --Setting pending approval flag in pa_project_assignments

3516: p_context3 => l_resource_id,
3517: p_commit => FND_API.G_FALSE,
3518: x_return_status => l_return_status);
3519:
3520: --Setting pending approval flag in pa_project_assignments
3521: PA_ASGMT_WFSTD.Maintain_wf_pending_flag
3522: (p_assignment_id => l_assignment_id_tbl(i),
3523: p_mode => 'APPROVAL_PROCESS_COMPLETED') ;
3524:

Line 3528: UPDATE pa_project_assignments

3524:
3525: ---------------------------
3526: --Set the mass wf flag
3527: ---------------------------
3528: UPDATE pa_project_assignments
3529: SET mass_wf_in_progress_flag = 'N'
3530: WHERE assignment_id = l_assignment_id_tbl(i);
3531:
3532: l_assignment_id_tbl(i) := NULL;

Line 3604: pa_project_assignments asgn

3600:
3601: SELECT count(*)
3602: INTO l_num_apr_asgns
3603: FROM pa_wf_ntf_performers ntf,
3604: pa_project_assignments asgn
3605: WHERE ntf.group_id = l_group_id
3606: AND ntf.routing_order = 1
3607: AND ntf.object_id1 = asgn.assignment_id
3608: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved ;

Line 3622: pa_project_assignments asgn

3618:
3619: SELECT count(*)
3620: INTO l_num_rej_asgns
3621: FROM pa_wf_ntf_performers ntf,
3622: pa_project_assignments asgn
3623: WHERE ntf.group_id = l_group_id
3624: AND ntf.routing_order = 1
3625: AND ntf.object_id1 = asgn.assignment_id
3626: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_rejected ;

Line 3670: pa_project_assignments asgn

3666: --which have been approved
3667: SELECT ntf.object_id1
3668: BULK COLLECT INTO l_appr_asgmt_id_tbl
3669: FROM pa_wf_ntf_performers ntf,
3670: pa_project_assignments asgn
3671: WHERE ntf.group_id = l_group_id
3672: AND ntf.routing_order = 1
3673: AND ntf.object_id1 = asgn.assignment_id
3674: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved ;

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

3816: --Workflow Itemtype: PARMAAP
3817: --Workflow process : 'PA_MASS_PROCESS_APRVL_RESULT'
3818: ---------------------------------------------------------
3819: PROCEDURE mass_process_approval_result
3820: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
3821: ,p_mode IN VARCHAR2
3822: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
3823: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
3824: ,p_group_id IN NUMBER

Line 4197: FROM pa_project_assignments

4193:
4194: --Get the assignment start date
4195: SELECT start_date
4196: INTO l_assignment_start_date
4197: FROM pa_project_assignments
4198: WHERE assignment_id = p_assignment_id_tbl(i);
4199:
4200: IF p_approver1_id_tbl.EXISTS(i) THEN
4201: IF p_approver1_id_tbl(i) <> -999 THEN

Line 4315: --Setting pending approval flag in pa_project_assignments

4311: --Populate x_success_assignment_id_tbl
4312: -------------------------------------------
4313: IF FND_MSG_PUB.Count_Msg > 0 THEN
4314:
4315: --Setting pending approval flag in pa_project_assignments
4316: PA_ASGMT_WFSTD.Maintain_wf_pending_flag
4317: (p_assignment_id => p_assignment_id_tbl(i),
4318: p_mode => 'APPROVAL_PROCESS_COMPLETED') ;
4319:

Line 4323: UPDATE pa_project_assignments

4319:
4320: ---------------------------
4321: --Set the mass wf flag
4322: ---------------------------
4323: UPDATE pa_project_assignments
4324: SET mass_wf_in_progress_flag = 'N'
4325: WHERE assignment_id = p_assignment_id_tbl(i);
4326:
4327: x_assignment_id_tbl (i) := null;

Line 4336: FROM pa_project_assignments

4332: IF FND_MSG_PUB.Count_Msg > 0 THEN
4333:
4334: SELECT resource_id
4335: INTO l_resource_id
4336: FROM pa_project_assignments
4337: WHERE assignment_id = p_assignment_id_tbl(i);
4338:
4339: log_message('Value of submitter user id:' || p_submitter_user_id);
4340: