DBA Data[Home] [Help]

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 401: PA_Projects_all PROJ

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
405: AND nvl(PTYPE.org_id,-99) = nvl(PROJ.org_id,-99)

Line 522: p_project_id IN pa_projects_all.project_id%TYPE,

518: PROCEDURE Set_Pa_Item_Attr
519: (
520: p_itemtype IN VARCHAR2,
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 */

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

Line 536: p_public_sector_flag IN pa_projects_all.public_sector_flag%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,
540: p_task_organization_id IN hr_organization_units.organization_id %TYPE,

Line 709: p_project_id IN pa_projects_all.project_id%TYPE,

705: ----------------------------------------------------------------------
706:
707: FUNCTION ap_er_generate_account
708: (
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,

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

Line 785: l_public_sector_flag pa_projects_all.public_sector_flag%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;
789: l_task_organization_id hr_organization_units.organization_id %TYPE;

Line 1474: p_project_id IN pa_projects_all.project_id%TYPE,

1470: ----------------------------------------------------------------------
1471:
1472: FUNCTION ap_inv_generate_account
1473: (
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,

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

Line 1548: l_public_sector_flag pa_projects_all.public_sector_flag%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;
1552: l_task_organization_id hr_organization_units.organization_id %TYPE;

Line 2231: l_project_id pa_projects_all.project_id%TYPE;

2227: p_funcmode IN VARCHAR2,
2228: x_result OUT NOCOPY VARCHAR2)
2229: AS
2230:
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;

Line 2754: pa_projects_all.project_id%TYPE;

2750:
2751: ft_rec c_ft_code%ROWTYPE;
2752:
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:

Line 2760: pa_projects_all.public_sector_flag%TYPE;

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:
2762: l_billable_flag pa_tasks.billable_flag%TYPE;
2763:
2764: l_ft_code pa_function_transactions_all.function_transaction_code%TYPE;

Line 2804: pa_projects_all b

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;
2808: