DBA Data[Home] [Help]

APPS.PA_TIME_CLIENT_EXTN dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 114: p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,

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,

Line 115: p_quantity IN pa_expenditure_items_all.quantity%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,

Line 117: p_attribute_category IN pa_expenditure_items_all.attribute_category%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,

Line 118: p_attribute1 IN pa_expenditure_items_all.attribute1%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,

Line 119: p_attribute2 IN pa_expenditure_items_all.attribute2%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,

Line 120: p_attribute3 IN pa_expenditure_items_all.attribute3%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,

Line 121: p_attribute4 IN pa_expenditure_items_all.attribute4%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,

Line 122: p_attribute5 IN pa_expenditure_items_all.attribute5%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,

Line 123: p_attribute6 IN pa_expenditure_items_all.attribute6%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,

Line 124: p_attribute7 IN pa_expenditure_items_all.attribute7%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,

Line 125: p_attribute8 IN pa_expenditure_items_all.attribute8%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,
129: x_match_status OUT NOCOPY varchar2)

Line 126: p_attribute9 IN pa_expenditure_items_all.attribute9%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)
130: IS

Line 127: p_attribute10 IN pa_expenditure_items_all.attribute10%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
131:

Line 227: -- Quantity Pa_Expenditure_Items_All.quantity%TYPE,

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,

Line 230: -- Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_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,

Line 232: -- Attribute_Category Pa_Expenditure_Items_All.Attribute_Category%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,

Line 233: -- Attribute1 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,

Line 234: -- Attribute2 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,

Line 235: -- Attribute3 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,

Line 236: -- Attribute4 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,

Line 237: -- Attribute5 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,

Line 238: -- Attribute6 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,

Line 239: -- Attribute7 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,

Line 240: -- Attribute8 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,
244: -- Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,

Line 241: -- Attribute9 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,
245: -- Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE)

Line 242: -- Attribute10 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)
246: --

Line 243: -- Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%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: --
247: -- The following pl/sql table columns will always be NULL: