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 PA_TASKS

Line 21: p_task_id IN pa_tasks.task_id%TYPE,

17: ----------------------------------------------------------------------
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

Line 38: x_task_number OUT NOCOPY pa_tasks.task_number%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,
42: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,

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

Line 42: x_top_task_id OUT NOCOPY pa_tasks.task_id%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,
45: x_vendor_employee_number OUT NOCOPY per_people_f.employee_number%TYPE,
46: x_vendor_type OUT NOCOPY po_vendors.vendor_type_lookup_code%TYPE)

Line 43: x_top_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,
45: x_vendor_employee_number OUT NOCOPY per_people_f.employee_number%TYPE,
46: x_vendor_type OUT NOCOPY po_vendors.vendor_type_lookup_code%TYPE)
47: AS

Line 180: p_task_id IN pa_tasks.task_id%TYPE,

176: ----------------------------------------------------------------------
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

Line 201: x_task_number OUT NOCOPY pa_tasks.task_number%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,
205: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,

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

Line 205: x_top_task_id OUT NOCOPY pa_tasks.task_id%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,
208: x_vendor_type OUT NOCOPY po_vendors.vendor_type_lookup_code%TYPE,
209: x_person_type OUT NOCOPY VARCHAR2 )

Line 206: x_top_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,
208: x_vendor_type OUT NOCOPY po_vendors.vendor_type_lookup_code%TYPE,
209: x_person_type OUT NOCOPY VARCHAR2 )
210: AS

Line 352: p_task_id IN pa_tasks.task_id%TYPE,

348:
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,

Line 366: x_task_number OUT NOCOPY pa_tasks.task_number%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,
370: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,

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

Line 370: x_top_task_id OUT NOCOPY pa_tasks.task_id%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
373:
374: -- l_cbs_enabled varchar2(1); /* Added for bug 16220146 */ commented for bug 16613999

Line 371: x_top_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
373:
374: -- l_cbs_enabled varchar2(1); /* Added for bug 16220146 */ commented for bug 16613999
375:

Line 497: PA_Tasks TOP_TASK,

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
501: AND ORG.organization_id = TASK.carrying_out_organization_id

Line 498: PA_Tasks TASK

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
501: AND ORG.organization_id = TASK.carrying_out_organization_id
502: AND TASK.Top_Task_ID = TOP_TASK.Task_ID;

Line 522: PA_Tasks TOP_TASK,

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
526: AND TASK.task_id = alt.proj_element_id

Line 523: PA_Tasks TASK,

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
526: AND TASK.task_id = alt.proj_element_id
527: AND ORG.organization_id = TASK.carrying_out_organization_id

Line 558: p_task_id IN pa_tasks.task_id%TYPE,

554: (
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,

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

Line 573: p_task_number IN pa_tasks.task_number%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,
577: p_top_task_id IN pa_tasks.task_id%TYPE,

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

Line 577: p_top_task_id IN pa_tasks.task_id%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:
580:
581:

Line 578: p_top_task_number IN pa_tasks.task_number%TYPE) AS

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:
580:
581:
582: BEGIN

Line 745: p_task_id IN pa_tasks.task_id%TYPE,

741:
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

Line 751: p_billable_flag IN pa_tasks.billable_flag%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,
753: p_calling_module IN VARCHAR2,
754: p_employee_id IN per_people_f.person_id%TYPE,
755: p_employee_ccid IN gl_code_combinations.code_combination_id%TYPE,

Line 822: l_task_number pa_tasks.task_number%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;
826: l_top_task_id pa_tasks.task_id%TYPE;

Line 825: l_task_service_type pa_tasks.service_type_code%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;
829: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;

Line 826: l_top_task_id pa_tasks.task_id%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;
829: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;
830: l_error_message VARCHAR2(1000) := '';

Line 827: l_top_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;
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

Line 844: l_task_id pa_tasks.task_id%TYPE;

840:
841: l_input_ccid gl_code_combinations.code_combination_id%TYPE; /* Bug 5378579 */
842:
843: -- Start: Added for bug 16613999
844: l_task_id pa_tasks.task_id%TYPE;
845: l_task_count NUMBER := 0;
846: -- End: Added for bug 16613999
847:
848: BEGIN

Line 860: from pa_tasks

856: g_error_message := '';
857:
858: -- Start: Added for bug 16613999
859: select count(*) into l_task_count
860: from pa_tasks
861: where project_id = p_project_id
862: and task_id = p_task_id;
863:
864: IF l_task_count <> 0 THEN

Line 1542: p_task_id IN pa_tasks.task_id%TYPE,

1538:
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

Line 1548: p_billable_flag IN pa_tasks.billable_flag%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,
1550: p_attribute_category IN ap_invoices_all.attribute_category%TYPE,
1551: p_attribute1 IN ap_invoices_all.attribute1%TYPE,
1552: p_attribute2 IN ap_invoices_all.attribute2%TYPE,

Line 1617: l_task_number pa_tasks.task_number%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;
1621: l_top_task_id pa_tasks.task_id%TYPE;

Line 1620: l_task_service_type pa_tasks.service_type_code%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;
1624: l_vendor_employee_number per_people_f.employee_number%TYPE;

Line 1621: l_top_task_id pa_tasks.task_id%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;
1624: l_vendor_employee_number per_people_f.employee_number%TYPE;
1625: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;

Line 1622: l_top_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;
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) :='';

Line 1633: l_task_id pa_tasks.task_id%TYPE;

1629:
1630: l_code_combination BOOLEAN;
1631:
1632: -- Start: Added for bug 16613999
1633: l_task_id pa_tasks.task_id%TYPE;
1634: l_task_count NUMBER := 0;
1635: -- End: Added for bug 16613999
1636:
1637: /* R12 Changes Start */

Line 1654: from pa_tasks

1650: g_error_message := '';
1651:
1652: -- Start: Added for bug 16613999
1653: select count(*) into l_task_count
1654: from pa_tasks
1655: where project_id = p_project_id
1656: and task_id = p_task_id;
1657:
1658: IF l_task_count <> 0 THEN

Line 2331: l_task_id pa_tasks.task_id%TYPE;

2327: x_result OUT NOCOPY VARCHAR2)
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;

Line 2336: l_billable_flag pa_tasks.billable_flag%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);
2339: l_fb_flex_seg VARCHAR2(500);
2340: l_build_account_result BOOLEAN;

Line 2861: l_billable_flag pa_tasks.billable_flag%TYPE;

2857:
2858: l_public_sector_flag
2859: pa_projects_all.public_sector_flag%TYPE;
2860:
2861: l_billable_flag pa_tasks.billable_flag%TYPE;
2862:
2863: l_ft_code pa_function_transactions_all.function_transaction_code%TYPE;
2864:
2865: l_ptype_ft_code pa_function_transactions_all.function_transaction_code%TYPE;