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_PROJECT_TYPES_ALL

Line 28: x_direct_flag OUT NOCOPY pa_project_types_all.direct_flag%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,
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,

Line 35: x_project_type OUT NOCOPY pa_project_types_all.project_type%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,
39: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,

Line 192: x_direct_flag OUT NOCOPY pa_project_types_all.direct_flag%TYPE,

188: p_employee_ccid IN OUT NOCOPY gl_code_combinations.code_combination_id%TYPE,
189: p_expense_type IN ap_expense_report_lines_all.web_parameter_id%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,

Line 198: x_project_type OUT NOCOPY pa_project_types_all.project_type%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,
202: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,

Line 357: x_direct_flag OUT NOCOPY pa_project_types_all.direct_flag%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,
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,

Line 363: x_project_type OUT NOCOPY pa_project_types_all.project_type%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,
367: x_task_organization_name OUT NOCOPY hr_organization_units.name%TYPE,

Line 400: PA_Project_Types_all PTYPE,

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
404: AND ORG.organization_id = PROJ.carrying_out_organization_id

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

Line 535: p_project_type IN pa_project_types_all.project_type%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,
539: p_task_organization_name IN hr_organization_units.name%TYPE,

Line 777: l_direct_flag pa_project_types_all.direct_flag%TYPE;

773: l_concat_descrs VARCHAR2(500);
774: l_return_ccid gl_code_combinations.code_combination_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;

Line 784: l_project_type pa_project_types_all.project_type%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;
788: l_task_organization_name hr_organization_units.name%TYPE;

Line 1541: l_direct_flag pa_project_types_all.direct_flag%TYPE;

1537: /* Adding parameter l_input_ccid for bug 2348764 */
1538: l_input_ccid gl_code_combinations.code_combination_id%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;

Line 1547: l_project_type pa_project_types_all.project_type%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;
1551: l_task_organization_name hr_organization_units.name%TYPE;

Line 2757: pa_project_types_all.project_type_class_code%TYPE;

2753: l_project_id
2754: pa_projects_all.project_id%TYPE;
2755:
2756: l_ptype_class_code
2757: pa_project_types_all.project_type_class_code%TYPE;
2758:
2759: l_public_sector_flag
2760: pa_projects_all.public_sector_flag%TYPE;
2761:

Line 2803: from pa_project_types_all a,

2799: aname => 'PROJECT_ID' );
2800:
2801: select a.project_type_class_code
2802: into l_ptype_class_code
2803: from pa_project_types_all a,
2804: pa_projects_all b
2805: where a.project_type = b.project_type
2806: and nvl(a.org_id,-99) = nvl(b.org_id, -99)
2807: and b.project_id = l_project_id;