110: p_project_id IN pa_projects_all.project_id%TYPE,
111: p_task_id IN pa_tasks.task_id%TYPE,
112: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
113: p_expenditure_type_class IN pa_system_linkages.function%TYPE,
114: p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
115: p_quantity IN pa_expenditure_items_all.quantity%TYPE,
116: p_expenditure_comment IN Varchar2,
117: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,
118: p_attribute1 IN pa_expenditure_items_all.attribute1%TYPE,
111: p_task_id IN pa_tasks.task_id%TYPE,
112: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
113: p_expenditure_type_class IN pa_system_linkages.function%TYPE,
114: p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
115: p_quantity IN pa_expenditure_items_all.quantity%TYPE,
116: p_expenditure_comment IN Varchar2,
117: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,
118: p_attribute1 IN pa_expenditure_items_all.attribute1%TYPE,
119: p_attribute2 IN pa_expenditure_items_all.attribute2%TYPE,
113: p_expenditure_type_class IN pa_system_linkages.function%TYPE,
114: p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
115: p_quantity IN pa_expenditure_items_all.quantity%TYPE,
116: p_expenditure_comment IN Varchar2,
117: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,
118: p_attribute1 IN pa_expenditure_items_all.attribute1%TYPE,
119: p_attribute2 IN pa_expenditure_items_all.attribute2%TYPE,
120: p_attribute3 IN pa_expenditure_items_all.attribute3%TYPE,
121: p_attribute4 IN pa_expenditure_items_all.attribute4%TYPE,
114: p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
115: p_quantity IN pa_expenditure_items_all.quantity%TYPE,
116: p_expenditure_comment IN Varchar2,
117: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,
118: p_attribute1 IN pa_expenditure_items_all.attribute1%TYPE,
119: p_attribute2 IN pa_expenditure_items_all.attribute2%TYPE,
120: p_attribute3 IN pa_expenditure_items_all.attribute3%TYPE,
121: p_attribute4 IN pa_expenditure_items_all.attribute4%TYPE,
122: p_attribute5 IN pa_expenditure_items_all.attribute5%TYPE,
115: p_quantity IN pa_expenditure_items_all.quantity%TYPE,
116: p_expenditure_comment IN Varchar2,
117: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,
118: p_attribute1 IN pa_expenditure_items_all.attribute1%TYPE,
119: p_attribute2 IN pa_expenditure_items_all.attribute2%TYPE,
120: p_attribute3 IN pa_expenditure_items_all.attribute3%TYPE,
121: p_attribute4 IN pa_expenditure_items_all.attribute4%TYPE,
122: p_attribute5 IN pa_expenditure_items_all.attribute5%TYPE,
123: p_attribute6 IN pa_expenditure_items_all.attribute6%TYPE,
116: p_expenditure_comment IN Varchar2,
117: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,
118: p_attribute1 IN pa_expenditure_items_all.attribute1%TYPE,
119: p_attribute2 IN pa_expenditure_items_all.attribute2%TYPE,
120: p_attribute3 IN pa_expenditure_items_all.attribute3%TYPE,
121: p_attribute4 IN pa_expenditure_items_all.attribute4%TYPE,
122: p_attribute5 IN pa_expenditure_items_all.attribute5%TYPE,
123: p_attribute6 IN pa_expenditure_items_all.attribute6%TYPE,
124: p_attribute7 IN pa_expenditure_items_all.attribute7%TYPE,
117: p_attribute_category IN pa_expenditure_items_all.attribute_category%TYPE,
118: p_attribute1 IN pa_expenditure_items_all.attribute1%TYPE,
119: p_attribute2 IN pa_expenditure_items_all.attribute2%TYPE,
120: p_attribute3 IN pa_expenditure_items_all.attribute3%TYPE,
121: p_attribute4 IN pa_expenditure_items_all.attribute4%TYPE,
122: p_attribute5 IN pa_expenditure_items_all.attribute5%TYPE,
123: p_attribute6 IN pa_expenditure_items_all.attribute6%TYPE,
124: p_attribute7 IN pa_expenditure_items_all.attribute7%TYPE,
125: p_attribute8 IN pa_expenditure_items_all.attribute8%TYPE,
118: p_attribute1 IN pa_expenditure_items_all.attribute1%TYPE,
119: p_attribute2 IN pa_expenditure_items_all.attribute2%TYPE,
120: p_attribute3 IN pa_expenditure_items_all.attribute3%TYPE,
121: p_attribute4 IN pa_expenditure_items_all.attribute4%TYPE,
122: p_attribute5 IN pa_expenditure_items_all.attribute5%TYPE,
123: p_attribute6 IN pa_expenditure_items_all.attribute6%TYPE,
124: p_attribute7 IN pa_expenditure_items_all.attribute7%TYPE,
125: p_attribute8 IN pa_expenditure_items_all.attribute8%TYPE,
126: p_attribute9 IN pa_expenditure_items_all.attribute9%TYPE,
119: p_attribute2 IN pa_expenditure_items_all.attribute2%TYPE,
120: p_attribute3 IN pa_expenditure_items_all.attribute3%TYPE,
121: p_attribute4 IN pa_expenditure_items_all.attribute4%TYPE,
122: p_attribute5 IN pa_expenditure_items_all.attribute5%TYPE,
123: p_attribute6 IN pa_expenditure_items_all.attribute6%TYPE,
124: p_attribute7 IN pa_expenditure_items_all.attribute7%TYPE,
125: p_attribute8 IN pa_expenditure_items_all.attribute8%TYPE,
126: p_attribute9 IN pa_expenditure_items_all.attribute9%TYPE,
127: p_attribute10 IN pa_expenditure_items_all.attribute10%TYPE,
120: p_attribute3 IN pa_expenditure_items_all.attribute3%TYPE,
121: p_attribute4 IN pa_expenditure_items_all.attribute4%TYPE,
122: p_attribute5 IN pa_expenditure_items_all.attribute5%TYPE,
123: p_attribute6 IN pa_expenditure_items_all.attribute6%TYPE,
124: p_attribute7 IN pa_expenditure_items_all.attribute7%TYPE,
125: p_attribute8 IN pa_expenditure_items_all.attribute8%TYPE,
126: p_attribute9 IN pa_expenditure_items_all.attribute9%TYPE,
127: p_attribute10 IN pa_expenditure_items_all.attribute10%TYPE,
128: p_match_status IN Varchar2,
121: p_attribute4 IN pa_expenditure_items_all.attribute4%TYPE,
122: p_attribute5 IN pa_expenditure_items_all.attribute5%TYPE,
123: p_attribute6 IN pa_expenditure_items_all.attribute6%TYPE,
124: p_attribute7 IN pa_expenditure_items_all.attribute7%TYPE,
125: p_attribute8 IN pa_expenditure_items_all.attribute8%TYPE,
126: p_attribute9 IN pa_expenditure_items_all.attribute9%TYPE,
127: p_attribute10 IN pa_expenditure_items_all.attribute10%TYPE,
128: p_match_status IN Varchar2,
129: x_match_status OUT NOCOPY varchar2)
122: p_attribute5 IN pa_expenditure_items_all.attribute5%TYPE,
123: p_attribute6 IN pa_expenditure_items_all.attribute6%TYPE,
124: p_attribute7 IN pa_expenditure_items_all.attribute7%TYPE,
125: p_attribute8 IN pa_expenditure_items_all.attribute8%TYPE,
126: p_attribute9 IN pa_expenditure_items_all.attribute9%TYPE,
127: p_attribute10 IN pa_expenditure_items_all.attribute10%TYPE,
128: p_match_status IN Varchar2,
129: x_match_status OUT NOCOPY varchar2)
130: IS
123: p_attribute6 IN pa_expenditure_items_all.attribute6%TYPE,
124: p_attribute7 IN pa_expenditure_items_all.attribute7%TYPE,
125: p_attribute8 IN pa_expenditure_items_all.attribute8%TYPE,
126: p_attribute9 IN pa_expenditure_items_all.attribute9%TYPE,
127: p_attribute10 IN pa_expenditure_items_all.attribute10%TYPE,
128: p_match_status IN Varchar2,
129: x_match_status OUT NOCOPY varchar2)
130: IS
131:
223: -- Task_Number Pa_Tasks.Task_Number%TYPE,
224: -- Task_Id Pa_Tasks.Task_Id%TYPE,
225: -- Expenditure_Type Pa_Expenditure_Types.Expenditure_Type%TYPE,
226: -- System_Linkage_Function Pa_System_Linkages.Function%TYPE,
227: -- Quantity Pa_Expenditure_Items_All.quantity%TYPE,
228: -- Incurred_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,
229: -- Override_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
230: -- Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
231: -- Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
226: -- System_Linkage_Function Pa_System_Linkages.Function%TYPE,
227: -- Quantity Pa_Expenditure_Items_All.quantity%TYPE,
228: -- Incurred_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,
229: -- Override_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
230: -- Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
231: -- Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
232: -- Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE,
233: -- Attribute1 Pa_Expenditure_Items_All.Attribute1%TYPE,
234: -- Attribute2 Pa_Expenditure_Items_All.Attribute1%TYPE,
228: -- Incurred_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,
229: -- Override_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
230: -- Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
231: -- Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
232: -- Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE,
233: -- Attribute1 Pa_Expenditure_Items_All.Attribute1%TYPE,
234: -- Attribute2 Pa_Expenditure_Items_All.Attribute1%TYPE,
235: -- Attribute3 Pa_Expenditure_Items_All.Attribute1%TYPE,
236: -- Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,
229: -- Override_Approver_Person_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE,
230: -- Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
231: -- Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
232: -- Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE,
233: -- Attribute1 Pa_Expenditure_Items_All.Attribute1%TYPE,
234: -- Attribute2 Pa_Expenditure_Items_All.Attribute1%TYPE,
235: -- Attribute3 Pa_Expenditure_Items_All.Attribute1%TYPE,
236: -- Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,
237: -- Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,
230: -- Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
231: -- Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
232: -- Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE,
233: -- Attribute1 Pa_Expenditure_Items_All.Attribute1%TYPE,
234: -- Attribute2 Pa_Expenditure_Items_All.Attribute1%TYPE,
235: -- Attribute3 Pa_Expenditure_Items_All.Attribute1%TYPE,
236: -- Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,
237: -- Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,
238: -- Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,
231: -- Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
232: -- Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE,
233: -- Attribute1 Pa_Expenditure_Items_All.Attribute1%TYPE,
234: -- Attribute2 Pa_Expenditure_Items_All.Attribute1%TYPE,
235: -- Attribute3 Pa_Expenditure_Items_All.Attribute1%TYPE,
236: -- Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,
237: -- Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,
238: -- Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,
239: -- Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,
232: -- Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%TYPE,
233: -- Attribute1 Pa_Expenditure_Items_All.Attribute1%TYPE,
234: -- Attribute2 Pa_Expenditure_Items_All.Attribute1%TYPE,
235: -- Attribute3 Pa_Expenditure_Items_All.Attribute1%TYPE,
236: -- Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,
237: -- Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,
238: -- Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,
239: -- Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,
240: -- Attribute8 Pa_Expenditure_Items_All.Attribute1%TYPE,
233: -- Attribute1 Pa_Expenditure_Items_All.Attribute1%TYPE,
234: -- Attribute2 Pa_Expenditure_Items_All.Attribute1%TYPE,
235: -- Attribute3 Pa_Expenditure_Items_All.Attribute1%TYPE,
236: -- Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,
237: -- Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,
238: -- Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,
239: -- Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,
240: -- Attribute8 Pa_Expenditure_Items_All.Attribute1%TYPE,
241: -- Attribute9 Pa_Expenditure_Items_All.Attribute1%TYPE,
234: -- Attribute2 Pa_Expenditure_Items_All.Attribute1%TYPE,
235: -- Attribute3 Pa_Expenditure_Items_All.Attribute1%TYPE,
236: -- Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,
237: -- Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,
238: -- Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,
239: -- Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,
240: -- Attribute8 Pa_Expenditure_Items_All.Attribute1%TYPE,
241: -- Attribute9 Pa_Expenditure_Items_All.Attribute1%TYPE,
242: -- Attribute10 Pa_Expenditure_Items_All.Attribute1%TYPE,
235: -- Attribute3 Pa_Expenditure_Items_All.Attribute1%TYPE,
236: -- Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,
237: -- Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,
238: -- Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,
239: -- Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,
240: -- Attribute8 Pa_Expenditure_Items_All.Attribute1%TYPE,
241: -- Attribute9 Pa_Expenditure_Items_All.Attribute1%TYPE,
242: -- Attribute10 Pa_Expenditure_Items_All.Attribute1%TYPE,
243: -- Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,
236: -- Attribute4 Pa_Expenditure_Items_All.Attribute1%TYPE,
237: -- Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,
238: -- Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,
239: -- Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,
240: -- Attribute8 Pa_Expenditure_Items_All.Attribute1%TYPE,
241: -- Attribute9 Pa_Expenditure_Items_All.Attribute1%TYPE,
242: -- Attribute10 Pa_Expenditure_Items_All.Attribute1%TYPE,
243: -- Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,
244: -- Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
237: -- Attribute5 Pa_Expenditure_Items_All.Attribute1%TYPE,
238: -- Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,
239: -- Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,
240: -- Attribute8 Pa_Expenditure_Items_All.Attribute1%TYPE,
241: -- Attribute9 Pa_Expenditure_Items_All.Attribute1%TYPE,
242: -- Attribute10 Pa_Expenditure_Items_All.Attribute1%TYPE,
243: -- Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,
244: -- Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
245: -- Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE)
238: -- Attribute6 Pa_Expenditure_Items_All.Attribute1%TYPE,
239: -- Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,
240: -- Attribute8 Pa_Expenditure_Items_All.Attribute1%TYPE,
241: -- Attribute9 Pa_Expenditure_Items_All.Attribute1%TYPE,
242: -- Attribute10 Pa_Expenditure_Items_All.Attribute1%TYPE,
243: -- Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,
244: -- Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
245: -- Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE)
246: --
239: -- Attribute7 Pa_Expenditure_Items_All.Attribute1%TYPE,
240: -- Attribute8 Pa_Expenditure_Items_All.Attribute1%TYPE,
241: -- Attribute9 Pa_Expenditure_Items_All.Attribute1%TYPE,
242: -- Attribute10 Pa_Expenditure_Items_All.Attribute1%TYPE,
243: -- Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,
244: -- Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
245: -- Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE)
246: --
247: -- The following pl/sql table columns will always be NULL: