DBA Data[Home] [Help]

APPS.PA_ACC_GEN_WF_PKG dependencies on HR_ORGANIZATION_UNITS

Line 71: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

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

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

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

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

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

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

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

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

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

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

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

Line 155: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

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

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

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

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

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

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

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

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

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

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

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

Line 237: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

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

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

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

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

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

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

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

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

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

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

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

Line 305: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

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

Line 311: p_expenditure_org_name IN hr_organization_units.name%TYPE,

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

Line 313: p_project_organization_name IN hr_organization_units.name%TYPE,

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

Line 314: p_project_organization_id IN hr_organization_units.organization_id %TYPE,

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

Line 319: p_task_organization_name IN hr_organization_units.name%TYPE,

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

Line 320: p_task_organization_id IN hr_organization_units.organization_id %TYPE,

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

Line 375: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

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

Line 484: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

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