DBA Data[Home] [Help]

APPS.PA_ACC_GEN_WF_PKG dependencies on PA_EXPENDITURE_TYPES

Line 22: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,

18:
19: PROCEDURE wf_acc_derive_params (
20: p_project_id IN pa_projects_all.project_id%TYPE,
21: p_task_id IN pa_tasks.task_id%TYPE,
22: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
23: p_vendor_id IN po_vendors.vendor_id%type,
24: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
25: p_expenditure_item_date IN
26: pa_expenditure_items_all.expenditure_item_date%TYPE,

Line 37: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,

33: x_project_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
34: x_project_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
35: x_project_type OUT NOCOPY pa_project_types_all.project_type%TYPE,
36: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,
37: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,
38: x_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
39: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
40: x_task_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
41: x_task_service_type OUT NOCOPY pa_tasks.service_type_code%TYPE,

Line 181: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,

177:
178: PROCEDURE wf_acc_derive_er_params (
179: p_project_id IN pa_projects_all.project_id%TYPE,
180: p_task_id IN pa_tasks.task_id%TYPE,
181: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
182: p_vendor_id IN po_vendors.vendor_id%type,
183: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
184: p_expenditure_item_date IN
185: pa_expenditure_items_all.expenditure_item_date%TYPE,

Line 200: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,

196: x_project_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
197: x_project_organization_id OUT NOCOPY hr_organization_units.organization_id%TYPE,
198: x_project_type OUT NOCOPY pa_project_types_all.project_type%TYPE,
199: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,
200: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,
201: x_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
202: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
203: x_task_organization_id OUT NOCOPY hr_organization_units.organization_id%TYPE,
204: x_task_service_type OUT NOCOPY pa_tasks.service_type_code%TYPE,

Line 353: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,

349:
350: PROCEDURE wf_acc_derive_pa_params (
351: p_project_id IN pa_projects_all.project_id%TYPE,
352: p_task_id IN pa_tasks.task_id%TYPE,
353: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
354: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
355: p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
356: x_class_code OUT NOCOPY pa_class_codes.class_code%TYPE,
357: x_direct_flag OUT NOCOPY pa_project_types_all.direct_flag%TYPE,

Line 365: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,

361: x_project_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
362: x_project_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
363: x_project_type OUT NOCOPY pa_project_types_all.project_type%TYPE,
364: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,
365: x_revenue_category OUT NOCOPY pa_expenditure_types.revenue_category_code%TYPE,
366: x_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
367: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,
368: x_task_organization_id OUT NOCOPY hr_organization_units.organization_id %TYPE,
369: x_task_service_type OUT NOCOPY pa_tasks.service_type_code%TYPE,

Line 427: PA_Expenditure_Types ETYPE

423: INTO
424: x_expenditure_category,
425: x_revenue_category
426: FROM
427: PA_Expenditure_Types ETYPE
428: WHERE
429: ETYPE.expenditure_type = p_expenditure_type;
430: END IF;
431:

Line 559: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,

555: p_itemtype IN VARCHAR2,
556: p_itemkey IN VARCHAR2,
557: p_project_id IN pa_projects_all.project_id%TYPE,
558: p_task_id IN pa_tasks.task_id%TYPE,
559: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
560: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
561: p_expenditure_item_date IN DATE, /* Added For Bug 1629411 */
562: p_billable_flag IN pa_tasks.billable_flag%TYPE,
563: p_class_code IN pa_class_codes.class_code%TYPE,

Line 572: p_revenue_category IN pa_expenditure_types.revenue_category_code%TYPE,

568: p_project_organization_name IN hr_organization_units.name%TYPE,
569: p_project_organization_id IN hr_organization_units.organization_id %TYPE,
570: p_project_type IN pa_project_types_all.project_type%TYPE,
571: p_public_sector_flag IN pa_projects_all.public_sector_flag%TYPE,
572: p_revenue_category IN pa_expenditure_types.revenue_category_code%TYPE,
573: p_task_number IN pa_tasks.task_number%TYPE,
574: p_task_organization_name IN hr_organization_units.name%TYPE,
575: p_task_organization_id IN hr_organization_units.organization_id %TYPE,
576: p_task_service_type IN pa_tasks.service_type_code%TYPE,

Line 746: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,

742: FUNCTION ap_er_generate_account
743: (
744: p_project_id IN pa_projects_all.project_id%TYPE,
745: p_task_id IN pa_tasks.task_id%TYPE,
746: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
747: p_vendor_id IN po_vendors.vendor_id%type,
748: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
749: p_expenditure_item_date IN
750: pa_expenditure_items_all.expenditure_item_date%TYPE,

Line 821: l_revenue_category pa_expenditure_types.revenue_category_code%TYPE;

817: l_project_organization_name hr_organization_units.name%TYPE;
818: l_project_organization_id hr_organization_units.organization_id %TYPE;
819: l_project_type pa_project_types_all.project_type%TYPE;
820: l_public_sector_flag pa_projects_all.public_sector_flag%TYPE;
821: l_revenue_category pa_expenditure_types.revenue_category_code%TYPE;
822: l_task_number pa_tasks.task_number%TYPE;
823: l_task_organization_name hr_organization_units.name%TYPE;
824: l_task_organization_id hr_organization_units.organization_id %TYPE;
825: l_task_service_type pa_tasks.service_type_code%TYPE;

Line 1543: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,

1539: FUNCTION ap_inv_generate_account
1540: (
1541: p_project_id IN pa_projects_all.project_id%TYPE,
1542: p_task_id IN pa_tasks.task_id%TYPE,
1543: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
1544: p_vendor_id IN po_vendors.vendor_id%type,
1545: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
1546: p_expenditure_item_date IN
1547: pa_expenditure_items_all.expenditure_item_date%TYPE,

Line 1616: l_revenue_category pa_expenditure_types.revenue_category_code%TYPE;

1612: l_project_organization_name hr_organization_units.name%TYPE;
1613: l_project_organization_id hr_organization_units.organization_id %TYPE;
1614: l_project_type pa_project_types_all.project_type%TYPE;
1615: l_public_sector_flag pa_projects_all.public_sector_flag%TYPE;
1616: l_revenue_category pa_expenditure_types.revenue_category_code%TYPE;
1617: l_task_number pa_tasks.task_number%TYPE;
1618: l_task_organization_name hr_organization_units.name%TYPE;
1619: l_task_organization_id hr_organization_units.organization_id %TYPE;
1620: l_task_service_type pa_tasks.service_type_code%TYPE;

Line 2332: l_expenditure_type pa_expenditure_types.expenditure_type%TYPE;

2328: AS
2329:
2330: l_project_id pa_projects_all.project_id%TYPE;
2331: l_task_id pa_tasks.task_id%TYPE;
2332: l_expenditure_type pa_expenditure_types.expenditure_type%TYPE;
2333: l_vendor_id po_vendors.vendor_id%type;
2334: l_expenditure_organization_id hr_organization_units.organization_id%TYPE;
2335: l_expenditure_item_date pa_expenditure_items_all.expenditure_item_date%TYPE;
2336: l_billable_flag pa_tasks.billable_flag%TYPE;