APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on FND_API

Line 31: ( person_id NUMBER := FND_API.G_MISS_NUM

27:
28: --Record for the PL/SQL table to store approvers
29: TYPE Asgmt_Approvers_Rec_Type
30: IS RECORD
31: ( person_id NUMBER := FND_API.G_MISS_NUM
32: ,orders NUMBER := FND_API.G_MISS_NUM
33: ,approver_person_type VARCHAR2(100) := FND_API.G_MISS_CHAR
34: );
35:

Line 32: ,orders NUMBER := FND_API.G_MISS_NUM

28: --Record for the PL/SQL table to store approvers
29: TYPE Asgmt_Approvers_Rec_Type
30: IS RECORD
31: ( person_id NUMBER := FND_API.G_MISS_NUM
32: ,orders NUMBER := FND_API.G_MISS_NUM
33: ,approver_person_type VARCHAR2(100) := FND_API.G_MISS_CHAR
34: );
35:
36:

Line 33: ,approver_person_type VARCHAR2(100) := FND_API.G_MISS_CHAR

29: TYPE Asgmt_Approvers_Rec_Type
30: IS RECORD
31: ( person_id NUMBER := FND_API.G_MISS_NUM
32: ,orders NUMBER := FND_API.G_MISS_NUM
33: ,approver_person_type VARCHAR2(100) := FND_API.G_MISS_CHAR
34: );
35:
36:
37: --Global PL/SQL table used to store approvers

Line 56: ,p_note_to_approver IN VARCHAR2 := FND_API.G_MISS_CHAR

52: PROCEDURE Start_Assignment_Approvals
53: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
54: ,p_new_assignment_flag IN VARCHAR2
55: ,p_action_code IN VARCHAR2
56: ,p_note_to_approver IN VARCHAR2 := FND_API.G_MISS_CHAR
57: ,p_record_version_number IN NUMBER
58: ,p_apr_person_id IN NUMBER DEFAULT NULL
59: ,p_apr_person_name IN VARCHAR2 DEFAULT NULL
60: ,p_apr_person_type IN VARCHAR2 DEFAULT NULL

Line 67: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

63: ,p_check_overcommitment_flag IN VARCHAR2 := 'N'
64: ,p_conflict_group_id IN NUMBER DEFAULT NULL
65: ,p_resolve_con_action_code IN VARCHAR2 DEFAULT NULL
66: ,p_api_version IN NUMBER := 1.0
67: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
68: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
69: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
70: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
71: ,x_overcommitment_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 68: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

64: ,p_conflict_group_id IN NUMBER DEFAULT NULL
65: ,p_resolve_con_action_code IN VARCHAR2 DEFAULT NULL
66: ,p_api_version IN NUMBER := 1.0
67: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
68: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
69: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
70: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
71: ,x_overcommitment_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72: ,x_conflict_group_id OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 69: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

65: ,p_resolve_con_action_code IN VARCHAR2 DEFAULT NULL
66: ,p_api_version IN NUMBER := 1.0
67: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
68: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
69: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
70: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
71: ,x_overcommitment_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72: ,x_conflict_group_id OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
73: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 70: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

66: ,p_api_version IN NUMBER := 1.0
67: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
68: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
69: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
70: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
71: ,x_overcommitment_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72: ,x_conflict_group_id OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
73: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
74: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 89: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

85: --
86: PROCEDURE Revert_To_Last_Approved
87: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
88: ,p_api_version IN NUMBER := 1.0
89: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
90: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
91: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
92: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
93: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 90: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

86: PROCEDURE Revert_To_Last_Approved
87: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
88: ,p_api_version IN NUMBER := 1.0
89: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
90: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
91: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
92: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
93: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
94: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 91: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

87: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
88: ,p_api_version IN NUMBER := 1.0
89: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
90: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
91: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
92: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
93: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
94: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
95: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 92: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

88: ,p_api_version IN NUMBER := 1.0
89: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
90: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
91: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
92: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
93: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
94: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
95: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96: );

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

104: --
105: PROCEDURE Populate_Changed_Items_Table
106: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
107: ,p_populate_mode IN VARCHAR2 := 'SAVED'
108: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
109: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
110: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
111: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
112: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

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

105: PROCEDURE Populate_Changed_Items_Table
106: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
107: ,p_populate_mode IN VARCHAR2 := 'SAVED'
108: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
109: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
110: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
111: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
112: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
113: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

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

106: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
107: ,p_populate_mode IN VARCHAR2 := 'SAVED'
108: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
109: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
110: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
111: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
112: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
113: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
114: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

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

107: ,p_populate_mode IN VARCHAR2 := 'SAVED'
108: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
109: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
110: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
111: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
112: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
113: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
114: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
115: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR

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

108: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
109: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
110: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
111: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
112: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
113: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
114: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
115: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
116: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM

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

109: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
110: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
111: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
112: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
113: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
114: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
115: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
116: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
117: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

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

110: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
111: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
112: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
113: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
114: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
115: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
116: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
117: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
118: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

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

111: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
112: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
113: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
114: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
115: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
116: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
117: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
118: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
119: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR

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

112: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
113: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
114: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
115: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
116: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
117: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
118: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
119: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
120: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM

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

113: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
114: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
115: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
116: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
117: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
118: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
119: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
120: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
121: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

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

114: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
115: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
116: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
117: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
118: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
119: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
120: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
121: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
122: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR

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

115: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
116: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
117: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
118: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
119: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
120: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
121: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
122: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
123: ,p_exception_type_code IN VARCHAR2 := NULL

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

116: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
117: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
118: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
119: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
120: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
121: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
122: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
123: ,p_exception_type_code IN VARCHAR2 := NULL
124: ,p_start_date IN DATE := NULL

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

117: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
118: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
119: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
120: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
121: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
122: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
123: ,p_exception_type_code IN VARCHAR2 := NULL
124: ,p_start_date IN DATE := NULL
125: ,p_end_date IN DATE := NULL

Line 122: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR

118: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
119: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
120: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
121: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
122: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
123: ,p_exception_type_code IN VARCHAR2 := NULL
124: ,p_start_date IN DATE := NULL
125: ,p_end_date IN DATE := NULL
126: ,p_requirement_status_code IN VARCHAR2 := NULL

Line 148: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

144: ,p_duration_shift_type_code IN VARCHAR2 := NULL
145: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
146: ,p_number_of_shift IN NUMBER := NULL
147: ,p_api_version IN NUMBER := 1.0
148: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
149: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
150: ,x_new_assignment_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
151: ,x_approval_required_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
152: ,x_record_version_number OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 149: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

145: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
146: ,p_number_of_shift IN NUMBER := NULL
147: ,p_api_version IN NUMBER := 1.0
148: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
149: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
150: ,x_new_assignment_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
151: ,x_approval_required_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
152: ,x_record_version_number OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
153: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 170: p_assignment_status_code IN Varchar2 := FND_API.G_MISS_CHAR,

166: p_assignment_id IN Number ,
167: p_assignment_type IN Varchar2 ,
168: p_start_date IN date ,
169: p_end_date IN date ,
170: p_assignment_status_code IN Varchar2 := FND_API.G_MISS_CHAR,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: x_return_status OUT NOCOPY Varchar2 , --File.Sql.39 bug 4440895
174: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

Line 171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

167: p_assignment_type IN Varchar2 ,
168: p_start_date IN date ,
169: p_end_date IN date ,
170: p_assignment_status_code IN Varchar2 := FND_API.G_MISS_CHAR,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: x_return_status OUT NOCOPY Varchar2 , --File.Sql.39 bug 4440895
174: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
175: x_msg_data OUT NOCOPY Varchar2 ); --File.Sql.39 bug 4440895

Line 172: p_commit IN VARCHAR2 := FND_API.G_FALSE,

168: p_start_date IN date ,
169: p_end_date IN date ,
170: p_assignment_status_code IN Varchar2 := FND_API.G_MISS_CHAR,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: x_return_status OUT NOCOPY Varchar2 , --File.Sql.39 bug 4440895
174: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
175: x_msg_data OUT NOCOPY Varchar2 ); --File.Sql.39 bug 4440895
176:

Line 200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

196: p_assignment_id IN Number ,
197: p_assignment_type IN Varchar2 ,
198: p_start_date IN date ,
199: p_end_date IN date ,
200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: x_return_status OUT NOCOPY Varchar2 , --File.Sql.39 bug 4440895
203: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
204: x_msg_data OUT NOCOPY Varchar2 ); --File.Sql.39 bug 4440895

Line 201: p_commit IN VARCHAR2 := FND_API.G_FALSE,

197: p_assignment_type IN Varchar2 ,
198: p_start_date IN date ,
199: p_end_date IN date ,
200: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
202: x_return_status OUT NOCOPY Varchar2 , --File.Sql.39 bug 4440895
203: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
204: x_msg_data OUT NOCOPY Varchar2 ); --File.Sql.39 bug 4440895
205:

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

210: (p_mode IN VARCHAR2
211: ,p_action IN VARCHAR2
212: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
213: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
214: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
215: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
216: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
217: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
218: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

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

211: ,p_action IN VARCHAR2
212: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
213: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
214: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
215: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
216: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
217: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
218: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
219: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

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

212: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
213: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
214: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
215: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
216: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
217: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
218: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
219: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
220: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM

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

213: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
214: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
215: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
216: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
217: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
218: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
219: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
220: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
221: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM

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

214: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
215: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
216: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
217: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
218: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
219: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
220: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
221: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
222: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

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

215: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
216: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
217: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
218: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
219: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
220: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
221: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
222: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
223: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

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

216: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
217: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
218: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
219: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
220: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
221: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
222: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
223: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
224: ,p_append_description_flag IN VARCHAR2 := 'N'

Line 221: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM

217: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
218: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
219: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
220: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
221: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
222: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
223: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
224: ,p_append_description_flag IN VARCHAR2 := 'N'
225: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE

Line 222: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

218: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
219: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
220: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
221: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
222: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
223: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
224: ,p_append_description_flag IN VARCHAR2 := 'N'
225: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
226: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

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

219: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
220: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
221: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
222: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
223: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
224: ,p_append_description_flag IN VARCHAR2 := 'N'
225: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
226: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
227: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

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

221: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
222: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
223: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
224: ,p_append_description_flag IN VARCHAR2 := 'N'
225: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
226: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
227: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
228: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
229: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

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

222: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
223: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
224: ,p_append_description_flag IN VARCHAR2 := 'N'
225: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
226: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
227: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
228: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
229: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
230: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

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

223: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
224: ,p_append_description_flag IN VARCHAR2 := 'N'
225: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
226: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
227: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
228: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
229: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
230: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
231: ,p_append_information_flag IN VARCHAR2 := 'N'

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

224: ,p_append_description_flag IN VARCHAR2 := 'N'
225: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
226: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
227: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
228: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
229: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
230: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
231: ,p_append_information_flag IN VARCHAR2 := 'N'
232: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM

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

225: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
226: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
227: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
228: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
229: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
230: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
231: ,p_append_information_flag IN VARCHAR2 := 'N'
232: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
233: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

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

226: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
227: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
228: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
229: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
230: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
231: ,p_append_information_flag IN VARCHAR2 := 'N'
232: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
233: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
234: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR

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

228: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
229: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
230: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
231: ,p_append_information_flag IN VARCHAR2 := 'N'
232: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
233: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
234: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
235: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
236: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM

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

229: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
230: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
231: ,p_append_information_flag IN VARCHAR2 := 'N'
232: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
233: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
234: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
235: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
236: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
237: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

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

230: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
231: ,p_append_information_flag IN VARCHAR2 := 'N'
232: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
233: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
234: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
235: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
236: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
237: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
238: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

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

231: ,p_append_information_flag IN VARCHAR2 := 'N'
232: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
233: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
234: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
235: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
236: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
237: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
238: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
239: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

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

232: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
233: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
234: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
235: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
236: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
237: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
238: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
239: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
240: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

Line 237: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

233: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
234: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
235: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
236: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
237: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
238: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
239: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
240: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
241: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

Line 238: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

234: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
235: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
236: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
237: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
238: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
239: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
240: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
241: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
242: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

Line 239: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

235: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
236: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
237: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
238: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
239: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
240: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
241: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
242: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
243: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

Line 240: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

236: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
237: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
238: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
239: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
240: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
241: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
242: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
243: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
244: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

Line 241: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

237: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
238: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
239: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
240: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
241: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
242: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
243: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
244: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
245: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

Line 242: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

238: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
239: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
240: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
241: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
242: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
243: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
244: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
245: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
246: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

Line 243: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

239: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
240: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
241: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
242: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
243: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
244: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
245: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
246: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
247: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

Line 244: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

240: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
241: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
242: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
243: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
244: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
245: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
246: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
247: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
248: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 245: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

241: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
242: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
243: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
244: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
245: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
246: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
247: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
248: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
249: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR

Line 246: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

242: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
243: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
244: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
245: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
246: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
247: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
248: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
249: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
250: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM

Line 247: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

243: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
244: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
245: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
246: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
247: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
248: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
249: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
250: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
251: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR

Line 248: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

244: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
245: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
246: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
247: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
248: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
249: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
250: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
251: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
252: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

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

245: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
246: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
247: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
248: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
249: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
250: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
251: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
252: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
253: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM

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

246: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
247: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
248: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
249: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
250: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
251: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
252: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
253: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
254: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM

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

247: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
248: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
249: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
250: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
251: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
252: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
253: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
254: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
255: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM

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

248: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
249: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
250: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
251: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
252: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
253: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
254: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
255: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
256: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM

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

249: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
250: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
251: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
252: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
253: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
254: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
255: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
256: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
257: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

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

250: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
251: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
252: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
253: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
254: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
255: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
256: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
257: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
258: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR

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

251: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
252: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
253: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
254: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
255: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
256: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
257: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
258: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
259: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM

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

252: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
253: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
254: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
255: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
256: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
257: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
258: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
259: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
260: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM

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

253: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
254: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
255: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
256: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
257: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
258: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
259: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
260: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
261: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

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

254: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
255: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
256: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
257: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
258: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
259: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
260: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
261: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
262: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

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

255: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
256: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
257: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
258: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
259: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
260: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
261: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
262: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
263: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR

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

256: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
257: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
258: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
259: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
260: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
261: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
262: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
263: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
264: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

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

257: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
258: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
259: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
260: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
261: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
262: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
263: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
264: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
265: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

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

258: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
259: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
260: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
261: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
262: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
263: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
264: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
265: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
266: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR

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

259: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
260: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
261: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
262: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
263: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
264: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
265: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
266: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
267: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

Line 264: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

260: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
261: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
262: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
263: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
264: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
265: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
266: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
267: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
268: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR

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

261: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
262: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
263: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
264: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
265: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
266: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
267: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
268: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
269: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

Line 266: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR

262: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
263: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
264: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
265: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
266: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
267: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
268: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
269: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
270: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR

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

263: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
264: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
265: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
266: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
267: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
268: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
269: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
270: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
271: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

Line 268: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR

264: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
265: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
266: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
267: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
268: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
269: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
270: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
271: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
272: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR

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

265: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
266: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
267: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
268: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
269: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
270: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
271: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
272: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
273: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

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

266: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
267: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
268: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
269: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
270: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
271: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
272: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
273: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
274: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

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

267: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
268: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
269: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
270: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
271: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
272: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
273: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
274: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
275: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 272: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR

268: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
269: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
270: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
271: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
272: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
273: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
274: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
275: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
276: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 273: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

269: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
270: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
271: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
272: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
273: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
274: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
275: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
276: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
277: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 274: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

270: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
271: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
272: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
273: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
274: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
275: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
276: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
277: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
278: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE

Line 275: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

271: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
272: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
273: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
274: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
275: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
276: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
277: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
278: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
279: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE

Line 276: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

272: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
273: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
274: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
275: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
276: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
277: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
278: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
279: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
280: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 277: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

273: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
274: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
275: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
276: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
277: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
278: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
279: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
280: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
281: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 278: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE

274: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
275: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
276: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
277: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
278: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
279: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
280: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
281: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
282: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

Line 279: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE

275: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
276: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
277: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
278: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
279: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
280: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
281: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
282: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
283: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

Line 280: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR

276: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
277: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
278: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
279: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
280: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
281: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
282: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
283: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
284: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 281: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR

277: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
278: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
279: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
280: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
281: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
282: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
283: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
284: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
285: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 292: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

288: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
289: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
290: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
291: ,p_non_working_day_flag IN VARCHAR2 := 'N'
292: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
293: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
294: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
295: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
296: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 293: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM

289: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
290: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
291: ,p_non_working_day_flag IN VARCHAR2 := 'N'
292: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
293: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
294: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
295: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
296: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
297: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM

Line 294: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM

290: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
291: ,p_non_working_day_flag IN VARCHAR2 := 'N'
292: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
293: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
294: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
295: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
296: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
297: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
298: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 295: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

291: ,p_non_working_day_flag IN VARCHAR2 := 'N'
292: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
293: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
294: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
295: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
296: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
297: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
298: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
299: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 296: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR

292: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
293: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
294: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
295: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
296: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
297: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
298: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
299: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
300: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM

Line 297: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM

293: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
294: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
295: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
296: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
297: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
298: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
299: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
300: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
301: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

Line 298: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

294: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
295: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
296: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
297: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
298: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
299: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
300: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
301: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
302: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

Line 299: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR

295: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
296: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
297: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
298: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
299: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
300: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
301: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
302: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
303: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

Line 300: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM

296: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
297: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
298: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
299: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
300: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
301: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
302: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
303: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
304: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

Line 306: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR

302: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
303: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
304: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
305: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
306: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
307: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
308: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
309: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
310: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

Line 312: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR

308: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
309: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
310: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
311: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl
312: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
313: ,p_api_version IN NUMBER := 1.0
314: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
316: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 314: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

310: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
311: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl
312: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
313: ,p_api_version IN NUMBER := 1.0
314: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
316: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
317: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
318: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 315: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

311: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl
312: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
313: ,p_api_version IN NUMBER := 1.0
314: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
316: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
317: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
318: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
319: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 316: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

312: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
313: ,p_api_version IN NUMBER := 1.0
314: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
316: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
317: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
318: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
319: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
320: );

Line 317: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

313: ,p_api_version IN NUMBER := 1.0
314: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
316: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
317: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
318: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
319: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
320: );
321:

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

319: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
320: );
321:
322: PROCEDURE mass_assignment_approval
323: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
324: ,p_mode IN VARCHAR2
325: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
326: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
327: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

Line 331: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM

327: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
328: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
329: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
330: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
331: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
332: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
333: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
334: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
335: ,p_api_version IN NUMBER := 1.0

Line 332: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR

328: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
329: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
330: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
331: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
332: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
333: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
334: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
335: ,p_api_version IN NUMBER := 1.0
336: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 333: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM

329: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
330: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
331: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
332: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
333: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
334: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
335: ,p_api_version IN NUMBER := 1.0
336: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
337: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

Line 334: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR

330: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
331: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
332: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
333: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
334: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
335: ,p_api_version IN NUMBER := 1.0
336: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
337: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
338: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 336: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

332: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
333: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
334: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
335: ,p_api_version IN NUMBER := 1.0
336: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
337: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
338: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
339: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
340: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 337: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

333: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
334: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
335: ,p_api_version IN NUMBER := 1.0
336: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
337: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
338: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
339: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
340: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
341: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 338: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

334: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
335: ,p_api_version IN NUMBER := 1.0
336: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
337: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
338: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
339: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
340: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
341: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
342: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 339: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

335: ,p_api_version IN NUMBER := 1.0
336: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
337: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
338: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
339: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
340: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
341: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
342: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
343: );

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

342: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
343: );
344:
345: PROCEDURE mass_process_approval_result
346: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
347: ,p_mode IN VARCHAR2
348: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
349: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
350: ,p_group_id IN NUMBER

Line 356: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM

352: ,p_routing_order IN NUMBER
353: ,p_item_key IN NUMBER
354: ,p_notification_id IN NUMBER
355: ,p_submitter_user_name IN VARCHAR2
356: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
357: ,p_api_version IN NUMBER := 1.0
358: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
359: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
360: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 358: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

354: ,p_notification_id IN NUMBER
355: ,p_submitter_user_name IN VARCHAR2
356: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
357: ,p_api_version IN NUMBER := 1.0
358: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
359: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
360: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
361: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
362: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 359: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

355: ,p_submitter_user_name IN VARCHAR2
356: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
357: ,p_api_version IN NUMBER := 1.0
358: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
359: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
360: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
361: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
362: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
363: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 360: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

356: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
357: ,p_api_version IN NUMBER := 1.0
358: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
359: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
360: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
361: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
362: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
363: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
364: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 361: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

357: ,p_api_version IN NUMBER := 1.0
358: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
359: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
360: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
361: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
362: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
363: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
364: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
365: );