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_PROJECTS_ALL

Line 20: p_project_id IN pa_projects_all.project_id%TYPE,

16: -- Definition of procedure in package specifications
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,

Line 32: x_project_number OUT NOCOPY pa_projects_all.segment1%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,
36: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,

Line 36: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%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,
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,

Line 179: p_project_id IN pa_projects_all.project_id%TYPE,

175: -- Definition of procedure in package specifications
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,

Line 195: x_project_number OUT NOCOPY pa_projects_all.segment1%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,
199: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,

Line 199: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%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,
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,

Line 351: p_project_id IN pa_projects_all.project_id%TYPE,

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

Line 360: x_project_number OUT NOCOPY pa_projects_all.segment1%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,
364: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%TYPE,

Line 364: x_public_sector_flag OUT NOCOPY pa_projects_all.public_sector_flag%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,
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,

Line 405: PA_Projects_all PROJ

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
408: AND ORG.organization_id = PROJ.carrying_out_organization_id
409: AND nvl(PTYPE.org_id,-99) = nvl(PROJ.org_id,-99)

Line 557: p_project_id IN pa_projects_all.project_id%TYPE,

553: PROCEDURE Set_Pa_Item_Attr
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 */

Line 567: p_project_number IN pa_projects_all.segment1%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,
571: p_public_sector_flag IN pa_projects_all.public_sector_flag%TYPE,

Line 571: p_public_sector_flag IN pa_projects_all.public_sector_flag%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,
574: p_task_organization_name IN hr_organization_units.name%TYPE,
575: p_task_organization_id IN hr_organization_units.organization_id %TYPE,

Line 744: p_project_id IN pa_projects_all.project_id%TYPE,

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

Line 816: l_project_number pa_projects_all.segment1%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;
820: l_public_sector_flag pa_projects_all.public_sector_flag%TYPE;

Line 820: l_public_sector_flag pa_projects_all.public_sector_flag%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;
823: l_task_organization_name hr_organization_units.name%TYPE;
824: l_task_organization_id hr_organization_units.organization_id %TYPE;

Line 1541: p_project_id IN pa_projects_all.project_id%TYPE,

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

Line 1611: l_project_number pa_projects_all.segment1%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;
1615: l_public_sector_flag pa_projects_all.public_sector_flag%TYPE;

Line 1615: l_public_sector_flag pa_projects_all.public_sector_flag%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;
1618: l_task_organization_name hr_organization_units.name%TYPE;
1619: l_task_organization_id hr_organization_units.organization_id %TYPE;

Line 2330: l_project_id pa_projects_all.project_id%TYPE;

2326: p_funcmode IN VARCHAR2,
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;

Line 2853: pa_projects_all.project_id%TYPE;

2849:
2850: ft_rec c_ft_code%ROWTYPE;
2851:
2852: l_project_id
2853: pa_projects_all.project_id%TYPE;
2854:
2855: l_ptype_class_code
2856: pa_project_types_all.project_type_class_code%TYPE;
2857:

Line 2859: pa_projects_all.public_sector_flag%TYPE;

2855: l_ptype_class_code
2856: pa_project_types_all.project_type_class_code%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;

Line 2903: pa_projects_all b

2899:
2900: select a.project_type_class_code
2901: into l_ptype_class_code
2902: from pa_project_types_all a,
2903: pa_projects_all b
2904: where a.project_type = b.project_type
2905: and nvl(a.org_id,-99) = nvl(b.org_id, -99)
2906: and b.project_id = l_project_id;
2907: