DBA Data[Home] [Help]

APPS.PA_ACC_GEN_WF_PKG dependencies on PA_TASKS

Line 68: p_task_id IN pa_tasks.task_id%TYPE,

64: ----------------------------------------------------------------------------------
65:
66: PROCEDURE wf_acc_derive_params (
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,

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

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

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

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

Line 152: p_task_id IN pa_tasks.task_id%TYPE,

148: --
149:
150: PROCEDURE wf_acc_derive_er_params (
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,

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

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

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

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

Line 235: p_task_id IN pa_tasks.task_id%TYPE,

231: --
232:
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,

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

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

Line 253: x_top_task_id OUT NOCOPY pa_tasks.task_id%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:
256:
257: --------------------------------------------------------------------------------

Line 254: x_top_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:
256:
257: --------------------------------------------------------------------------------
258: --

Line 303: p_task_id IN pa_tasks.task_id%TYPE,

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

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

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

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

Line 322: p_top_task_id IN pa_tasks.task_id%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:
325:
326: ----------------------------------------------------------------------------------

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

Line 372: p_task_id IN pa_tasks.task_id%TYPE,

368:
369: FUNCTION ap_inv_generate_account
370: (
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,

Line 377: p_billable_flag IN pa_tasks.billable_flag%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,
380: p_attribute1 IN ap_invoices_all.attribute1%TYPE,
381: p_attribute2 IN ap_invoices_all.attribute2%TYPE,

Line 481: p_task_id IN pa_tasks.task_id%TYPE,

477:
478: FUNCTION ap_er_generate_account
479: (
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,

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