7: p_non_labor_resource_orgn_id IN PA_EXPENDITURE_ITEMS_ALL.organization_id%type DEFAULT NULL,
8: p_wip_resource_id IN PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type DEFAULT NULL,
9: p_incurred_by_person_id IN PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL,
10: p_inventory_item_id IN PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type DEFAULT NULL,
11: p_vendor_id IN PA_COMMITMENT_TXNS.vendor_id%type DEFAULT NULL,
12: p_bom_equipment_resource_id IN PA_COMMITMENT_TXNS.bom_equipment_resource_id%type DEFAULT NULL,
13: p_bom_labor_resource_id IN PA_COMMITMENT_TXNS.bom_labor_resource_id%type DEFAULT NULL
14: ) RETURN varchar2 IS
15:
8: p_wip_resource_id IN PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type DEFAULT NULL,
9: p_incurred_by_person_id IN PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL,
10: p_inventory_item_id IN PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type DEFAULT NULL,
11: p_vendor_id IN PA_COMMITMENT_TXNS.vendor_id%type DEFAULT NULL,
12: p_bom_equipment_resource_id IN PA_COMMITMENT_TXNS.bom_equipment_resource_id%type DEFAULT NULL,
13: p_bom_labor_resource_id IN PA_COMMITMENT_TXNS.bom_labor_resource_id%type DEFAULT NULL
14: ) RETURN varchar2 IS
15:
16: v_grouping_method varchar2(2000) default null;
9: p_incurred_by_person_id IN PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL,
10: p_inventory_item_id IN PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type DEFAULT NULL,
11: p_vendor_id IN PA_COMMITMENT_TXNS.vendor_id%type DEFAULT NULL,
12: p_bom_equipment_resource_id IN PA_COMMITMENT_TXNS.bom_equipment_resource_id%type DEFAULT NULL,
13: p_bom_labor_resource_id IN PA_COMMITMENT_TXNS.bom_labor_resource_id%type DEFAULT NULL
14: ) RETURN varchar2 IS
15:
16: v_grouping_method varchar2(2000) default null;
17:
43: p_non_labor_resource_orgn_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.organization_id%type,
44: p_wip_resource_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type,
45: p_incurred_by_person_id IN OUT NOCOPY PA_EXPENDITURES_ALL.incurred_by_person_id%type,
46: p_inventory_item_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type,
47: p_vendor_id IN OUT NOCOPY PA_COMMITMENT_TXNS.vendor_id%type,
48: p_bom_equipment_resource_id IN OUT NOCOPY PA_COMMITMENT_TXNS.bom_equipment_resource_id%type,
49: p_bom_labor_resource_id IN OUT NOCOPY PA_COMMITMENT_TXNS.bom_labor_resource_id%type
50: )
51:
44: p_wip_resource_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type,
45: p_incurred_by_person_id IN OUT NOCOPY PA_EXPENDITURES_ALL.incurred_by_person_id%type,
46: p_inventory_item_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type,
47: p_vendor_id IN OUT NOCOPY PA_COMMITMENT_TXNS.vendor_id%type,
48: p_bom_equipment_resource_id IN OUT NOCOPY PA_COMMITMENT_TXNS.bom_equipment_resource_id%type,
49: p_bom_labor_resource_id IN OUT NOCOPY PA_COMMITMENT_TXNS.bom_labor_resource_id%type
50: )
51:
52: IS
45: p_incurred_by_person_id IN OUT NOCOPY PA_EXPENDITURES_ALL.incurred_by_person_id%type,
46: p_inventory_item_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type,
47: p_vendor_id IN OUT NOCOPY PA_COMMITMENT_TXNS.vendor_id%type,
48: p_bom_equipment_resource_id IN OUT NOCOPY PA_COMMITMENT_TXNS.bom_equipment_resource_id%type,
49: p_bom_labor_resource_id IN OUT NOCOPY PA_COMMITMENT_TXNS.bom_labor_resource_id%type
50: )
51:
52: IS
53: