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 399: HR_Organization_Units ORG,

395: x_project_organization_id,
396: x_project_type,
397: x_public_sector_flag
398: FROM
399: HR_Organization_Units ORG,
400: PA_Project_Types_all PTYPE,
401: PA_Projects_all PROJ
402: WHERE
403: PROJ.project_id = p_project_id

Line 463: FROM hr_organization_units ORG

459: IF p_expenditure_organization_id IS NOT NULL
460: THEN
461: SELECT ORG.name EXP_ORG_NAME
462: INTO x_expenditure_org_name
463: FROM hr_organization_units ORG
464: WHERE ORG.organization_id = p_expenditure_organization_id;
465: END IF;
466:
467: --------------------------------------------------------

Line 490: HR_Organization_Units ORG,

486: x_task_service_type,
487: x_top_task_id,
488: x_top_task_number
489: FROM
490: HR_Organization_Units ORG,
491: PA_Tasks TOP_TASK,
492: PA_Tasks TASK
493: WHERE
494: TASK.task_id = p_task_id

Line 525: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

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

Line 531: p_expenditure_org_name IN hr_organization_units.name%TYPE,

527: p_billable_flag IN pa_tasks.billable_flag%TYPE,
528: p_class_code IN pa_class_codes.class_code%TYPE,
529: p_direct_flag IN pa_project_types_all.direct_flag%TYPE,
530: p_expenditure_category IN pa_expenditure_categories.expenditure_category%TYPE,
531: p_expenditure_org_name IN hr_organization_units.name%TYPE,
532: p_project_number IN pa_projects_all.segment1%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,

Line 533: p_project_organization_name IN hr_organization_units.name%TYPE,

529: p_direct_flag IN pa_project_types_all.direct_flag%TYPE,
530: p_expenditure_category IN pa_expenditure_categories.expenditure_category%TYPE,
531: p_expenditure_org_name IN hr_organization_units.name%TYPE,
532: p_project_number IN pa_projects_all.segment1%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,

Line 534: p_project_organization_id IN hr_organization_units.organization_id %TYPE,

530: p_expenditure_category IN pa_expenditure_categories.expenditure_category%TYPE,
531: p_expenditure_org_name IN hr_organization_units.name%TYPE,
532: p_project_number IN pa_projects_all.segment1%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,

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

Line 540: p_task_organization_id IN hr_organization_units.organization_id %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,
542: p_top_task_id IN pa_tasks.task_id%TYPE,
543: p_top_task_number IN pa_tasks.task_number%TYPE) AS
544:

Line 713: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

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

Line 779: l_expenditure_organization_id hr_organization_units.organization_id%TYPE;

775: l_employee_ccid gl_code_combinations.code_combination_id%TYPE;
776: l_class_code pa_class_codes.class_code%TYPE;
777: l_direct_flag pa_project_types_all.direct_flag%TYPE;
778: l_expenditure_category pa_expenditure_categories.expenditure_category%TYPE;
779: l_expenditure_organization_id hr_organization_units.organization_id%TYPE;
780: l_expenditure_org_name hr_organization_units.name%TYPE;
781: l_project_number pa_projects_all.segment1%TYPE;
782: l_project_organization_name hr_organization_units.name%TYPE;
783: l_project_organization_id hr_organization_units.organization_id %TYPE;

Line 780: l_expenditure_org_name hr_organization_units.name%TYPE;

776: l_class_code pa_class_codes.class_code%TYPE;
777: l_direct_flag pa_project_types_all.direct_flag%TYPE;
778: l_expenditure_category pa_expenditure_categories.expenditure_category%TYPE;
779: l_expenditure_organization_id hr_organization_units.organization_id%TYPE;
780: l_expenditure_org_name hr_organization_units.name%TYPE;
781: l_project_number pa_projects_all.segment1%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;

Line 782: l_project_organization_name hr_organization_units.name%TYPE;

778: l_expenditure_category pa_expenditure_categories.expenditure_category%TYPE;
779: l_expenditure_organization_id hr_organization_units.organization_id%TYPE;
780: l_expenditure_org_name hr_organization_units.name%TYPE;
781: l_project_number pa_projects_all.segment1%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;

Line 783: l_project_organization_id hr_organization_units.organization_id %TYPE;

779: l_expenditure_organization_id hr_organization_units.organization_id%TYPE;
780: l_expenditure_org_name hr_organization_units.name%TYPE;
781: l_project_number pa_projects_all.segment1%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;

Line 788: l_task_organization_name hr_organization_units.name%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;
791: l_top_task_id pa_tasks.task_id%TYPE;
792: l_top_task_number pa_tasks.task_number%TYPE;

Line 789: l_task_organization_id hr_organization_units.organization_id %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;
791: l_top_task_id pa_tasks.task_id%TYPE;
792: l_top_task_number pa_tasks.task_number%TYPE;
793: l_employee_number per_people_f.employee_number%TYPE;

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

792: l_top_task_number pa_tasks.task_number%TYPE;
793: l_employee_number per_people_f.employee_number%TYPE;
794: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;
795: l_error_message VARCHAR2(1000) := '';
796: l_org_id hr_organization_units.organization_id %TYPE; -- Workflow Enhancement
797:
798: l_code_combination BOOLEAN;
799: l_person_type VARCHAR2(10);
800:

Line 1478: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,

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

Line 1543: l_expenditure_org_name hr_organization_units.name%TYPE;

1539: l_return_ccid gl_code_combinations.code_combination_id%TYPE;
1540: l_class_code pa_class_codes.class_code%TYPE;
1541: l_direct_flag pa_project_types_all.direct_flag%TYPE;
1542: l_expenditure_category pa_expenditure_categories.expenditure_category%TYPE;
1543: l_expenditure_org_name hr_organization_units.name%TYPE;
1544: l_project_number pa_projects_all.segment1%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;

Line 1545: l_project_organization_name hr_organization_units.name%TYPE;

1541: l_direct_flag pa_project_types_all.direct_flag%TYPE;
1542: l_expenditure_category pa_expenditure_categories.expenditure_category%TYPE;
1543: l_expenditure_org_name hr_organization_units.name%TYPE;
1544: l_project_number pa_projects_all.segment1%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;

Line 1546: l_project_organization_id hr_organization_units.organization_id %TYPE;

1542: l_expenditure_category pa_expenditure_categories.expenditure_category%TYPE;
1543: l_expenditure_org_name hr_organization_units.name%TYPE;
1544: l_project_number pa_projects_all.segment1%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;

Line 1551: l_task_organization_name hr_organization_units.name%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;
1554: l_top_task_id pa_tasks.task_id%TYPE;
1555: l_top_task_number pa_tasks.task_number%TYPE;

Line 1552: l_task_organization_id hr_organization_units.organization_id %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;
1554: l_top_task_id pa_tasks.task_id%TYPE;
1555: l_top_task_number pa_tasks.task_number%TYPE;
1556: l_vendor_employee_id per_people_f.person_id%TYPE;

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

1557: l_vendor_employee_number per_people_f.employee_number%TYPE;
1558: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;
1559: l_error_message VARCHAR2(1000) :='';
1560: l_accounting_date DATE;
1561: l_org_id hr_organization_units.organization_id %TYPE; -- Workflow Enhancement
1562:
1563: l_code_combination BOOLEAN;
1564:
1565: /* R12 Changes Start */

Line 2235: l_expenditure_organization_id hr_organization_units.organization_id%TYPE;

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