DBA Data[Home] [Help]

APPS.PA_ACC_GEN_WF_PKG dependencies on PA_TASKS

Line 66: p_task_id IN pa_tasks.task_id%TYPE,

62: ----------------------------------------------------------------------------------
63:
64: PROCEDURE wf_acc_derive_params (
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,

Line 81: x_task_number OUT NOCOPY pa_tasks.task_number%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,
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,

Line 84: x_task_service_type OUT NOCOPY pa_tasks.service_type_code%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,
88: x_vendor_employee_number OUT NOCOPY per_people_f.employee_number%TYPE,

Line 85: x_top_task_id OUT NOCOPY pa_tasks.task_id%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,
88: x_vendor_employee_number OUT NOCOPY per_people_f.employee_number%TYPE,
89: x_vendor_type OUT NOCOPY po_vendors.vendor_type_lookup_code%TYPE);

Line 86: x_top_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,
88: x_vendor_employee_number OUT NOCOPY per_people_f.employee_number%TYPE,
89: x_vendor_type OUT NOCOPY po_vendors.vendor_type_lookup_code%TYPE);
90:

Line 150: p_task_id IN pa_tasks.task_id%TYPE,

146: --
147:
148: PROCEDURE wf_acc_derive_er_params (
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,

Line 170: x_task_number OUT NOCOPY pa_tasks.task_number%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,
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,

Line 173: x_task_service_type OUT NOCOPY pa_tasks.service_type_code%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,
177: x_vendor_type OUT NOCOPY po_vendors.vendor_type_lookup_code%TYPE,

Line 174: x_top_task_id OUT NOCOPY pa_tasks.task_id%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,
177: x_vendor_type OUT NOCOPY po_vendors.vendor_type_lookup_code%TYPE,
178: x_person_type OUT NOCOPY VARCHAR2 );

Line 175: x_top_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,
177: x_vendor_type OUT NOCOPY po_vendors.vendor_type_lookup_code%TYPE,
178: x_person_type OUT NOCOPY VARCHAR2 );
179:

Line 233: p_task_id IN pa_tasks.task_id%TYPE,

229: --
230:
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,

Line 247: x_task_number OUT NOCOPY pa_tasks.task_number%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,
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,

Line 250: x_task_service_type OUT NOCOPY pa_tasks.service_type_code%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:
254:

Line 251: x_top_task_id OUT NOCOPY pa_tasks.task_id%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:
254:
255: --------------------------------------------------------------------------------

Line 252: x_top_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:
254:
255: --------------------------------------------------------------------------------
256: --

Line 301: p_task_id IN pa_tasks.task_id%TYPE,

297: PROCEDURE Set_Pa_Item_Attr(
298: p_itemtype IN VARCHAR2,
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,

Line 305: p_billable_flag IN pa_tasks.billable_flag%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,
308: p_expenditure_category IN pa_expenditure_categories.expenditure_category%TYPE,
309: p_expenditure_org_name IN hr_organization_units.name%TYPE,

Line 316: p_task_number IN pa_tasks.task_number%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,
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,

Line 319: p_task_service_type IN pa_tasks.service_type_code%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:
323:

Line 320: p_top_task_id IN pa_tasks.task_id%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:
323:
324: ----------------------------------------------------------------------------------

Line 321: p_top_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:
323:
324: ----------------------------------------------------------------------------------
325: -- Start of comments

Line 370: p_task_id IN pa_tasks.task_id%TYPE,

366:
367: FUNCTION ap_inv_generate_account
368: (
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,

Line 375: p_billable_flag IN pa_tasks.billable_flag%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,
378: p_attribute1 IN ap_invoices_all.attribute1%TYPE,
379: p_attribute2 IN ap_invoices_all.attribute2%TYPE,

Line 479: p_task_id IN pa_tasks.task_id%TYPE,

475:
476: FUNCTION ap_er_generate_account
477: (
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,

Line 484: p_billable_flag IN pa_tasks.billable_flag%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,
487: p_employee_id IN per_people_f.person_id%TYPE,
488: p_employee_ccid IN gl_code_combinations.code_combination_id%TYPE,