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 423: PA_Expenditure_Types ETYPE

419: INTO
420: x_expenditure_category,
421: x_revenue_category
422: FROM
423: PA_Expenditure_Types ETYPE
424: WHERE
425: ETYPE.expenditure_type = p_expenditure_type;
426: END IF;
427:

Line 524: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,

520: p_itemtype IN VARCHAR2,
521: p_itemkey IN VARCHAR2,
522: p_project_id IN pa_projects_all.project_id%TYPE,
523: p_task_id IN pa_tasks.task_id%TYPE,
524: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
525: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
526: p_expenditure_item_date IN DATE, /* Added For Bug 1629411 */
527: p_billable_flag IN pa_tasks.billable_flag%TYPE,
528: p_class_code IN pa_class_codes.class_code%TYPE,

Line 537: p_revenue_category IN pa_expenditure_types.revenue_category_code%TYPE,

533: p_project_organization_name IN hr_organization_units.name%TYPE,
534: p_project_organization_id IN hr_organization_units.organization_id %TYPE,
535: p_project_type IN pa_project_types_all.project_type%TYPE,
536: p_public_sector_flag IN pa_projects_all.public_sector_flag%TYPE,
537: p_revenue_category IN pa_expenditure_types.revenue_category_code%TYPE,
538: p_task_number IN pa_tasks.task_number%TYPE,
539: p_task_organization_name IN hr_organization_units.name%TYPE,
540: p_task_organization_id IN hr_organization_units.organization_id %TYPE,
541: p_task_service_type IN pa_tasks.service_type_code%TYPE,

Line 711: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,

707: FUNCTION ap_er_generate_account
708: (
709: p_project_id IN pa_projects_all.project_id%TYPE,
710: p_task_id IN pa_tasks.task_id%TYPE,
711: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
712: p_vendor_id IN po_vendors.vendor_id%type,
713: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
714: p_expenditure_item_date IN
715: pa_expenditure_items_all.expenditure_item_date%TYPE,

Line 786: l_revenue_category pa_expenditure_types.revenue_category_code%TYPE;

782: l_project_organization_name hr_organization_units.name%TYPE;
783: l_project_organization_id hr_organization_units.organization_id %TYPE;
784: l_project_type pa_project_types_all.project_type%TYPE;
785: l_public_sector_flag pa_projects_all.public_sector_flag%TYPE;
786: l_revenue_category pa_expenditure_types.revenue_category_code%TYPE;
787: l_task_number pa_tasks.task_number%TYPE;
788: l_task_organization_name hr_organization_units.name%TYPE;
789: l_task_organization_id hr_organization_units.organization_id %TYPE;
790: l_task_service_type pa_tasks.service_type_code%TYPE;

Line 1476: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,

1472: FUNCTION ap_inv_generate_account
1473: (
1474: p_project_id IN pa_projects_all.project_id%TYPE,
1475: p_task_id IN pa_tasks.task_id%TYPE,
1476: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
1477: p_vendor_id IN po_vendors.vendor_id%type,
1478: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
1479: p_expenditure_item_date IN
1480: pa_expenditure_items_all.expenditure_item_date%TYPE,

Line 1549: l_revenue_category pa_expenditure_types.revenue_category_code%TYPE;

1545: l_project_organization_name hr_organization_units.name%TYPE;
1546: l_project_organization_id hr_organization_units.organization_id %TYPE;
1547: l_project_type pa_project_types_all.project_type%TYPE;
1548: l_public_sector_flag pa_projects_all.public_sector_flag%TYPE;
1549: l_revenue_category pa_expenditure_types.revenue_category_code%TYPE;
1550: l_task_number pa_tasks.task_number%TYPE;
1551: l_task_organization_name hr_organization_units.name%TYPE;
1552: l_task_organization_id hr_organization_units.organization_id %TYPE;
1553: l_task_service_type pa_tasks.service_type_code%TYPE;

Line 2233: l_expenditure_type pa_expenditure_types.expenditure_type%TYPE;

2229: AS
2230:
2231: l_project_id pa_projects_all.project_id%TYPE;
2232: l_task_id pa_tasks.task_id%TYPE;
2233: l_expenditure_type pa_expenditure_types.expenditure_type%TYPE;
2234: l_vendor_id po_vendors.vendor_id%type;
2235: l_expenditure_organization_id hr_organization_units.organization_id%TYPE;
2236: l_expenditure_item_date pa_expenditure_items_all.expenditure_item_date%TYPE;
2237: l_billable_flag pa_tasks.billable_flag%TYPE;