DBA Data[Home] [Help]

APPS.PA_ACC_GEN_WF_PKG dependencies on HR_ORGANIZATION_UNITS

Line 69: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

65: p_project_id IN pa_projects_all.project_id%TYPE,
66: p_task_id IN pa_tasks.task_id%TYPE,
67: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
68: p_vendor_id IN po_vendors.vendor_id%type,
69: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
70: p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
71: x_class_code OUT NOCOPY pa_class_codes.class_code%TYPE,
72: x_direct_flag OUT NOCOPY pa_project_types_all.direct_flag%TYPE,
73: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,

Line 74: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,

70: p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
71: x_class_code OUT NOCOPY pa_class_codes.class_code%TYPE,
72: x_direct_flag OUT NOCOPY pa_project_types_all.direct_flag%TYPE,
73: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
74: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
75: x_project_number OUT NOCOPY pa_projects_all.segment1%TYPE,
76: x_project_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
77: x_project_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
78: x_project_type OUT NOCOPY pa_project_types_all.project_type%TYPE,

Line 76: x_project_organization_name OUT NOCOPY hr_organization_units.name%TYPE,

72: x_direct_flag OUT NOCOPY pa_project_types_all.direct_flag%TYPE,
73: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
74: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
75: x_project_number OUT NOCOPY pa_projects_all.segment1%TYPE,
76: x_project_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
77: x_project_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
78: x_project_type OUT NOCOPY pa_project_types_all.project_type%TYPE,
79: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,
80: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,

Line 77: x_project_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,

73: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
74: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
75: x_project_number OUT NOCOPY pa_projects_all.segment1%TYPE,
76: x_project_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
77: x_project_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
78: x_project_type OUT NOCOPY pa_project_types_all.project_type%TYPE,
79: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,
80: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,
81: x_task_number OUT NOCOPY pa_tasks.task_number%TYPE,

Line 82: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,

78: x_project_type OUT NOCOPY pa_project_types_all.project_type%TYPE,
79: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,
80: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,
81: x_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
82: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
83: x_task_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
84: x_task_service_type OUT NOCOPY pa_tasks.service_type_code%TYPE,
85: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,
86: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,

Line 83: x_task_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,

79: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,
80: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,
81: x_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
82: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
83: x_task_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
84: x_task_service_type OUT NOCOPY pa_tasks.service_type_code%TYPE,
85: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,
86: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
87: x_vendor_employee_id OUT NOCOPY per_people_f.person_id%TYPE,

Line 153: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

149: p_project_id IN pa_projects_all.project_id%TYPE,
150: p_task_id IN pa_tasks.task_id%TYPE,
151: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
152: p_vendor_id IN po_vendors.vendor_id%type,
153: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
154: p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
155: p_calling_module IN VARCHAR2,
156: p_employee_id IN per_people_f.person_id%TYPE,
157: p_employee_ccid IN OUT NOCOPY gl_code_combinations.code_combination_id%TYPE,

Line 163: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,

159: p_expense_cc IN ap_expense_report_headers_all.flex_concatenated%TYPE,
160: x_class_code OUT NOCOPY pa_class_codes.class_code%TYPE,
161: x_direct_flag OUT NOCOPY pa_project_types_all.direct_flag%TYPE,
162: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
163: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
164: x_project_number OUT NOCOPY pa_projects_all.segment1%TYPE,
165: x_project_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
166: x_project_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
167: x_project_type OUT NOCOPY pa_project_types_all.project_type%TYPE,

Line 165: x_project_organization_name OUT NOCOPY hr_organization_units.name%TYPE,

161: x_direct_flag OUT NOCOPY pa_project_types_all.direct_flag%TYPE,
162: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
163: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
164: x_project_number OUT NOCOPY pa_projects_all.segment1%TYPE,
165: x_project_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
166: x_project_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
167: x_project_type OUT NOCOPY pa_project_types_all.project_type%TYPE,
168: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,
169: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,

Line 166: x_project_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,

162: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
163: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
164: x_project_number OUT NOCOPY pa_projects_all.segment1%TYPE,
165: x_project_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
166: x_project_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
167: x_project_type OUT NOCOPY pa_project_types_all.project_type%TYPE,
168: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,
169: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,
170: x_task_number OUT NOCOPY pa_tasks.task_number%TYPE,

Line 171: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,

167: x_project_type OUT NOCOPY pa_project_types_all.project_type%TYPE,
168: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,
169: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,
170: x_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
171: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
172: x_task_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
173: x_task_service_type OUT NOCOPY pa_tasks.service_type_code%TYPE,
174: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,
175: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,

Line 172: x_task_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,

168: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,
169: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,
170: x_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
171: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
172: x_task_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
173: x_task_service_type OUT NOCOPY pa_tasks.service_type_code%TYPE,
174: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,
175: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
176: x_employee_number OUT NOCOPY per_people_f.employee_number%TYPE,

Line 235: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

231: PROCEDURE wf_acc_derive_pa_params (
232: p_project_id IN pa_projects_all.project_id%TYPE,
233: p_task_id IN pa_tasks.task_id%TYPE,
234: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
235: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
236: p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
237: x_class_code OUT NOCOPY pa_class_codes.class_code%TYPE,
238: x_direct_flag OUT NOCOPY pa_project_types_all.direct_flag%TYPE,
239: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,

Line 240: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,

236: p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
237: x_class_code OUT NOCOPY pa_class_codes.class_code%TYPE,
238: x_direct_flag OUT NOCOPY pa_project_types_all.direct_flag%TYPE,
239: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
240: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
241: x_project_number OUT NOCOPY pa_projects_all.segment1%TYPE,
242: x_project_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
243: x_project_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
244: x_project_type OUT NOCOPY pa_project_types_all.project_type%TYPE,

Line 242: x_project_organization_name OUT NOCOPY hr_organization_units.name%TYPE,

238: x_direct_flag OUT NOCOPY pa_project_types_all.direct_flag%TYPE,
239: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
240: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
241: x_project_number OUT NOCOPY pa_projects_all.segment1%TYPE,
242: x_project_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
243: x_project_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
244: x_project_type OUT NOCOPY pa_project_types_all.project_type%TYPE,
245: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,
246: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,

Line 243: x_project_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,

239: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
240: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
241: x_project_number OUT NOCOPY pa_projects_all.segment1%TYPE,
242: x_project_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
243: x_project_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
244: x_project_type OUT NOCOPY pa_project_types_all.project_type%TYPE,
245: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,
246: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,
247: x_task_number OUT NOCOPY pa_tasks.task_number%TYPE,

Line 248: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,

244: x_project_type OUT NOCOPY pa_project_types_all.project_type%TYPE,
245: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,
246: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,
247: x_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
248: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
249: x_task_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
250: x_task_service_type OUT NOCOPY pa_tasks.service_type_code%TYPE,
251: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,
252: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE);

Line 249: x_task_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,

245: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,
246: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,
247: x_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
248: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
249: x_task_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
250: x_task_service_type OUT NOCOPY pa_tasks.service_type_code%TYPE,
251: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,
252: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE);
253:

Line 303: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

299: p_itemkey IN VARCHAR2,
300: p_project_id IN pa_projects_all.project_id%TYPE,
301: p_task_id IN pa_tasks.task_id%TYPE,
302: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
303: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
304: p_expenditure_item_date IN DATE,
305: p_billable_flag IN pa_tasks.billable_flag%TYPE,
306: p_class_code IN pa_class_codes.class_code%TYPE,
307: p_direct_flag IN pa_project_types_all.direct_flag%TYPE,

Line 309: p_expenditure_org_name IN hr_organization_units.name%TYPE,

305: p_billable_flag IN pa_tasks.billable_flag%TYPE,
306: p_class_code IN pa_class_codes.class_code%TYPE,
307: p_direct_flag IN pa_project_types_all.direct_flag%TYPE,
308: p_expenditure_category IN pa_expenditure_categories.expenditure_category%TYPE,
309: p_expenditure_org_name IN hr_organization_units.name%TYPE,
310: p_project_number IN pa_projects_all.segment1%TYPE,
311: p_project_organization_name IN hr_organization_units.name%TYPE,
312: p_project_organization_id IN hr_organization_units.organization_id %TYPE,
313: p_project_type IN pa_project_types_all.project_type%TYPE,

Line 311: p_project_organization_name IN hr_organization_units.name%TYPE,

307: p_direct_flag IN pa_project_types_all.direct_flag%TYPE,
308: p_expenditure_category IN pa_expenditure_categories.expenditure_category%TYPE,
309: p_expenditure_org_name IN hr_organization_units.name%TYPE,
310: p_project_number IN pa_projects_all.segment1%TYPE,
311: p_project_organization_name IN hr_organization_units.name%TYPE,
312: p_project_organization_id IN hr_organization_units.organization_id %TYPE,
313: p_project_type IN pa_project_types_all.project_type%TYPE,
314: p_public_sector_flag IN pa_projects_all.public_sector_flag%TYPE,
315: p_revenue_category IN pa_expenditure_types.revenue_category_code%TYPE,

Line 312: p_project_organization_id IN hr_organization_units.organization_id %TYPE,

308: p_expenditure_category IN pa_expenditure_categories.expenditure_category%TYPE,
309: p_expenditure_org_name IN hr_organization_units.name%TYPE,
310: p_project_number IN pa_projects_all.segment1%TYPE,
311: p_project_organization_name IN hr_organization_units.name%TYPE,
312: p_project_organization_id IN hr_organization_units.organization_id %TYPE,
313: p_project_type IN pa_project_types_all.project_type%TYPE,
314: p_public_sector_flag IN pa_projects_all.public_sector_flag%TYPE,
315: p_revenue_category IN pa_expenditure_types.revenue_category_code%TYPE,
316: p_task_number IN pa_tasks.task_number%TYPE,

Line 317: p_task_organization_name IN hr_organization_units.name%TYPE,

313: p_project_type IN pa_project_types_all.project_type%TYPE,
314: p_public_sector_flag IN pa_projects_all.public_sector_flag%TYPE,
315: p_revenue_category IN pa_expenditure_types.revenue_category_code%TYPE,
316: p_task_number IN pa_tasks.task_number%TYPE,
317: p_task_organization_name IN hr_organization_units.name%TYPE,
318: p_task_organization_id IN hr_organization_units.organization_id %TYPE,
319: p_task_service_type IN pa_tasks.service_type_code%TYPE,
320: p_top_task_id IN pa_tasks.task_id%TYPE,
321: p_top_task_number IN pa_tasks.task_number%TYPE);

Line 318: p_task_organization_id IN hr_organization_units.organization_id %TYPE,

314: p_public_sector_flag IN pa_projects_all.public_sector_flag%TYPE,
315: p_revenue_category IN pa_expenditure_types.revenue_category_code%TYPE,
316: p_task_number IN pa_tasks.task_number%TYPE,
317: p_task_organization_name IN hr_organization_units.name%TYPE,
318: p_task_organization_id IN hr_organization_units.organization_id %TYPE,
319: p_task_service_type IN pa_tasks.service_type_code%TYPE,
320: p_top_task_id IN pa_tasks.task_id%TYPE,
321: p_top_task_number IN pa_tasks.task_number%TYPE);
322:

Line 373: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

369: p_project_id IN pa_projects_all.project_id%TYPE,
370: p_task_id IN pa_tasks.task_id%TYPE,
371: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
372: p_vendor_id IN po_vendors.vendor_id%type,
373: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
374: p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
375: p_billable_flag IN pa_tasks.billable_flag%TYPE,
376: p_chart_of_accounts_id IN NUMBER,
377: p_attribute_category IN ap_invoices_all.attribute_category%TYPE,

Line 482: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

478: p_project_id IN pa_projects_all.project_id%TYPE,
479: p_task_id IN pa_tasks.task_id%TYPE,
480: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
481: p_vendor_id IN po_vendors.vendor_id%type,
482: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
483: p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
484: p_billable_flag IN pa_tasks.billable_flag%TYPE,
485: p_chart_of_accounts_id IN NUMBER,
486: p_calling_module IN VARCHAR2,