eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ACC_GEN_WF_PKG dependencies on HR_ORGANIZATION_UNITS

Line 24: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

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,
27: x_class_code OUT NOCOPY pa_class_codes.class_code%TYPE,
28: x_direct_flag OUT NOCOPY pa_project_types_all.direct_flag%TYPE,

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

27: x_class_code OUT NOCOPY pa_class_codes.class_code%TYPE,
28: x_direct_flag OUT NOCOPY pa_project_types_all.direct_flag%TYPE,
29: x_expenditure_category OUT
30: NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
31: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
32: x_project_number OUT NOCOPY pa_projects_all.segment1%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,

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

29: x_expenditure_category OUT
30: NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
31: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
32: x_project_number OUT NOCOPY pa_projects_all.segment1%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,

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

30: NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
31: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
32: x_project_number OUT NOCOPY pa_projects_all.segment1%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,

Line 39: x_task_organization_name OUT NOCOPY hr_organization_units.name%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,
42: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,
43: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,

Line 40: x_task_organization_id OUT NOCOPY hr_organization_units.organization_id %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,
42: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,
43: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
44: x_vendor_employee_id OUT NOCOPY per_people_f.person_id%TYPE,

Line 183: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

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,
186: p_calling_module IN VARCHAR2,
187: p_employee_id IN per_people_f.person_id%TYPE,

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

190: p_expense_cc IN ap_expense_report_headers_all.flex_concatenated%TYPE,
191: x_class_code OUT NOCOPY pa_class_codes.class_code%TYPE,
192: x_direct_flag OUT NOCOPY pa_project_types_all.direct_flag%TYPE,
193: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
194: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
195: x_project_number OUT NOCOPY pa_projects_all.segment1%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,

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

192: x_direct_flag OUT NOCOPY pa_project_types_all.direct_flag%TYPE,
193: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
194: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
195: x_project_number OUT NOCOPY pa_projects_all.segment1%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,

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

193: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
194: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
195: x_project_number OUT NOCOPY pa_projects_all.segment1%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,

Line 202: x_task_organization_name OUT NOCOPY hr_organization_units.name%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,
205: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,
206: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,

Line 203: x_task_organization_id OUT NOCOPY hr_organization_units.organization_id%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,
205: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,
206: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
207: x_employee_number OUT NOCOPY per_people_f.employee_number%TYPE,

Line 354: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

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,
358: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,

Line 359: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%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,
358: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
359: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
360: x_project_number OUT NOCOPY pa_projects_all.segment1%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,

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

357: x_direct_flag OUT NOCOPY pa_project_types_all.direct_flag%TYPE,
358: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
359: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
360: x_project_number OUT NOCOPY pa_projects_all.segment1%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,

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

358: x_expenditure_category OUT NOCOPY pa_expenditure_categories.expenditure_category%TYPE,
359: x_expenditure_org_name OUT NOCOPY hr_organization_units.name%TYPE,
360: x_project_number OUT NOCOPY pa_projects_all.segment1%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,

Line 367: x_task_organization_name OUT NOCOPY hr_organization_units.name%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,
370: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,
371: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE)

Line 368: x_task_organization_id OUT NOCOPY hr_organization_units.organization_id %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,
370: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,
371: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE)
372: AS

Line 403: HR_Organization_Units ORG,

399: x_project_type,
400: x_public_sector_flag
401: -- l_cbs_enabled /* Added for bug 16220146 */ commented for bug 16613999
402: FROM
403: HR_Organization_Units ORG,
404: PA_Project_Types_all PTYPE,
405: PA_Projects_all PROJ
406: WHERE
407: PROJ.project_id = p_project_id

Line 467: FROM hr_organization_units ORG

463: IF p_expenditure_organization_id IS NOT NULL
464: THEN
465: SELECT ORG.name EXP_ORG_NAME
466: INTO x_expenditure_org_name
467: FROM hr_organization_units ORG
468: WHERE ORG.organization_id = p_expenditure_organization_id;
469: END IF;
470:
471: --------------------------------------------------------

Line 496: HR_Organization_Units ORG,

492: x_task_service_type,
493: x_top_task_id,
494: x_top_task_number
495: FROM
496: HR_Organization_Units ORG,
497: PA_Tasks TOP_TASK,
498: PA_Tasks TASK
499: WHERE
500: TASK.task_id = p_task_id

Line 521: HR_Organization_Units ORG,

517: x_task_service_type,
518: x_top_task_id,
519: x_top_task_number
520: FROM
521: HR_Organization_Units ORG,
522: PA_Tasks TOP_TASK,
523: PA_Tasks TASK,
524: pa_alternate_tasks alt
525: WHERE alt.alt_task_id = p_task_id

Line 560: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

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,
564: p_direct_flag IN pa_project_types_all.direct_flag%TYPE,

Line 566: p_expenditure_org_name IN hr_organization_units.name%TYPE,

562: p_billable_flag IN pa_tasks.billable_flag%TYPE,
563: p_class_code IN pa_class_codes.class_code%TYPE,
564: p_direct_flag IN pa_project_types_all.direct_flag%TYPE,
565: p_expenditure_category IN pa_expenditure_categories.expenditure_category%TYPE,
566: p_expenditure_org_name IN hr_organization_units.name%TYPE,
567: p_project_number IN pa_projects_all.segment1%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,

Line 568: p_project_organization_name IN hr_organization_units.name%TYPE,

564: p_direct_flag IN pa_project_types_all.direct_flag%TYPE,
565: p_expenditure_category IN pa_expenditure_categories.expenditure_category%TYPE,
566: p_expenditure_org_name IN hr_organization_units.name%TYPE,
567: p_project_number IN pa_projects_all.segment1%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,

Line 569: p_project_organization_id IN hr_organization_units.organization_id %TYPE,

565: p_expenditure_category IN pa_expenditure_categories.expenditure_category%TYPE,
566: p_expenditure_org_name IN hr_organization_units.name%TYPE,
567: p_project_number IN pa_projects_all.segment1%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,

Line 574: p_task_organization_name IN hr_organization_units.name%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,
577: p_top_task_id IN pa_tasks.task_id%TYPE,
578: p_top_task_number IN pa_tasks.task_number%TYPE) AS

Line 575: p_task_organization_id IN hr_organization_units.organization_id %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,
577: p_top_task_id IN pa_tasks.task_id%TYPE,
578: p_top_task_number IN pa_tasks.task_number%TYPE) AS
579:

Line 748: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

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,
751: p_billable_flag IN pa_tasks.billable_flag%TYPE,
752: p_chart_of_accounts_id IN NUMBER,

Line 814: l_expenditure_organization_id hr_organization_units.organization_id%TYPE;

810: l_employee_ccid gl_code_combinations.code_combination_id%TYPE;
811: l_class_code pa_class_codes.class_code%TYPE;
812: l_direct_flag pa_project_types_all.direct_flag%TYPE;
813: l_expenditure_category pa_expenditure_categories.expenditure_category%TYPE;
814: l_expenditure_organization_id hr_organization_units.organization_id%TYPE;
815: l_expenditure_org_name hr_organization_units.name%TYPE;
816: l_project_number pa_projects_all.segment1%TYPE;
817: l_project_organization_name hr_organization_units.name%TYPE;
818: l_project_organization_id hr_organization_units.organization_id %TYPE;

Line 815: l_expenditure_org_name hr_organization_units.name%TYPE;

811: l_class_code pa_class_codes.class_code%TYPE;
812: l_direct_flag pa_project_types_all.direct_flag%TYPE;
813: l_expenditure_category pa_expenditure_categories.expenditure_category%TYPE;
814: l_expenditure_organization_id hr_organization_units.organization_id%TYPE;
815: l_expenditure_org_name hr_organization_units.name%TYPE;
816: l_project_number pa_projects_all.segment1%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;

Line 817: l_project_organization_name hr_organization_units.name%TYPE;

813: l_expenditure_category pa_expenditure_categories.expenditure_category%TYPE;
814: l_expenditure_organization_id hr_organization_units.organization_id%TYPE;
815: l_expenditure_org_name hr_organization_units.name%TYPE;
816: l_project_number pa_projects_all.segment1%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;

Line 818: l_project_organization_id hr_organization_units.organization_id %TYPE;

814: l_expenditure_organization_id hr_organization_units.organization_id%TYPE;
815: l_expenditure_org_name hr_organization_units.name%TYPE;
816: l_project_number pa_projects_all.segment1%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;

Line 823: l_task_organization_name hr_organization_units.name%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;
826: l_top_task_id pa_tasks.task_id%TYPE;
827: l_top_task_number pa_tasks.task_number%TYPE;

Line 824: l_task_organization_id hr_organization_units.organization_id %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;
826: l_top_task_id pa_tasks.task_id%TYPE;
827: l_top_task_number pa_tasks.task_number%TYPE;
828: l_employee_number per_people_f.employee_number%TYPE;

Line 831: l_org_id hr_organization_units.organization_id %TYPE; -- Workflow Enhancement

827: l_top_task_number pa_tasks.task_number%TYPE;
828: l_employee_number per_people_f.employee_number%TYPE;
829: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;
830: l_error_message VARCHAR2(1000) := '';
831: l_org_id hr_organization_units.organization_id %TYPE; -- Workflow Enhancement
832:
833: l_code_combination BOOLEAN;
834: l_person_type VARCHAR2(10);
835:

Line 1545: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

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,
1548: p_billable_flag IN pa_tasks.billable_flag%TYPE,
1549: p_chart_of_accounts_id IN NUMBER,

Line 1610: l_expenditure_org_name hr_organization_units.name%TYPE;

1606: l_return_ccid gl_code_combinations.code_combination_id%TYPE;
1607: l_class_code pa_class_codes.class_code%TYPE;
1608: l_direct_flag pa_project_types_all.direct_flag%TYPE;
1609: l_expenditure_category pa_expenditure_categories.expenditure_category%TYPE;
1610: l_expenditure_org_name hr_organization_units.name%TYPE;
1611: l_project_number pa_projects_all.segment1%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;

Line 1612: l_project_organization_name hr_organization_units.name%TYPE;

1608: l_direct_flag pa_project_types_all.direct_flag%TYPE;
1609: l_expenditure_category pa_expenditure_categories.expenditure_category%TYPE;
1610: l_expenditure_org_name hr_organization_units.name%TYPE;
1611: l_project_number pa_projects_all.segment1%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;

Line 1613: l_project_organization_id hr_organization_units.organization_id %TYPE;

1609: l_expenditure_category pa_expenditure_categories.expenditure_category%TYPE;
1610: l_expenditure_org_name hr_organization_units.name%TYPE;
1611: l_project_number pa_projects_all.segment1%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;

Line 1618: l_task_organization_name hr_organization_units.name%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;
1621: l_top_task_id pa_tasks.task_id%TYPE;
1622: l_top_task_number pa_tasks.task_number%TYPE;

Line 1619: l_task_organization_id hr_organization_units.organization_id %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;
1621: l_top_task_id pa_tasks.task_id%TYPE;
1622: l_top_task_number pa_tasks.task_number%TYPE;
1623: l_vendor_employee_id per_people_f.person_id%TYPE;

Line 1628: l_org_id hr_organization_units.organization_id %TYPE; -- Workflow Enhancement

1624: l_vendor_employee_number per_people_f.employee_number%TYPE;
1625: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;
1626: l_error_message VARCHAR2(1000) :='';
1627: l_accounting_date DATE;
1628: l_org_id hr_organization_units.organization_id %TYPE; -- Workflow Enhancement
1629:
1630: l_code_combination BOOLEAN;
1631:
1632: -- Start: Added for bug 16613999

Line 2334: l_expenditure_organization_id hr_organization_units.organization_id%TYPE;

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;
2337: l_chart_of_accounts_id NUMBER;
2338: l_fb_error_msg VARCHAR2(2000);