33: * @rep:displayname Summary Burden Grouping - Resource
34: * @rep:compatibility S
35: */
36: FUNCTION CLIENT_GROUPING
37: ( p_job_id IN PA_EXPENDITURE_ITEMS_ALL.job_id%type DEFAULT NULL,
38: p_non_labor_resource IN PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type DEFAULT NULL,
39: p_non_labor_resource_orgn_id IN PA_EXPENDITURE_ITEMS_ALL.organization_id%type DEFAULT NULL,
40: p_wip_resource_id IN PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type DEFAULT NULL,
41: p_incurred_by_person_id IN PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL,
34: * @rep:compatibility S
35: */
36: FUNCTION CLIENT_GROUPING
37: ( p_job_id IN PA_EXPENDITURE_ITEMS_ALL.job_id%type DEFAULT NULL,
38: p_non_labor_resource IN PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type DEFAULT NULL,
39: p_non_labor_resource_orgn_id IN PA_EXPENDITURE_ITEMS_ALL.organization_id%type DEFAULT NULL,
40: p_wip_resource_id IN PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type DEFAULT NULL,
41: p_incurred_by_person_id IN PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL,
42: p_inventory_item_id IN PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type DEFAULT NULL,
35: */
36: FUNCTION CLIENT_GROUPING
37: ( p_job_id IN PA_EXPENDITURE_ITEMS_ALL.job_id%type DEFAULT NULL,
38: p_non_labor_resource IN PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type DEFAULT NULL,
39: p_non_labor_resource_orgn_id IN PA_EXPENDITURE_ITEMS_ALL.organization_id%type DEFAULT NULL,
40: p_wip_resource_id IN PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type DEFAULT NULL,
41: p_incurred_by_person_id IN PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL,
42: p_inventory_item_id IN PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type DEFAULT NULL,
43: p_vendor_id IN PA_COMMITMENT_TXNS.vendor_id%type DEFAULT NULL,
36: FUNCTION CLIENT_GROUPING
37: ( p_job_id IN PA_EXPENDITURE_ITEMS_ALL.job_id%type DEFAULT NULL,
38: p_non_labor_resource IN PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type DEFAULT NULL,
39: p_non_labor_resource_orgn_id IN PA_EXPENDITURE_ITEMS_ALL.organization_id%type DEFAULT NULL,
40: p_wip_resource_id IN PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type DEFAULT NULL,
41: p_incurred_by_person_id IN PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL,
42: p_inventory_item_id IN PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type DEFAULT NULL,
43: p_vendor_id IN PA_COMMITMENT_TXNS.vendor_id%type DEFAULT NULL,
44: p_bom_equipment_resource_id IN PA_COMMITMENT_TXNS.bom_equipment_resource_id%type DEFAULT NULL,
38: p_non_labor_resource IN PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type DEFAULT NULL,
39: p_non_labor_resource_orgn_id IN PA_EXPENDITURE_ITEMS_ALL.organization_id%type DEFAULT NULL,
40: p_wip_resource_id IN PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type DEFAULT NULL,
41: p_incurred_by_person_id IN PA_EXPENDITURES_ALL.incurred_by_person_id%type DEFAULT NULL,
42: p_inventory_item_id IN PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type DEFAULT NULL,
43: p_vendor_id IN PA_COMMITMENT_TXNS.vendor_id%type DEFAULT NULL,
44: p_bom_equipment_resource_id IN PA_COMMITMENT_TXNS.bom_equipment_resource_id%type DEFAULT NULL,
45: p_bom_labor_resource_id IN PA_COMMITMENT_TXNS.bom_labor_resource_id%type DEFAULT NULL
46: ) RETURN varchar2 ;
66: * @rep:displayname Client Column Values - Resource
67: * @rep:compatibility S
68: */
69: PROCEDURE CLIENT_COLUMN_VALUES
70: ( p_job_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.job_id%type,
71: p_non_labor_resource IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type,
72: p_non_labor_resource_orgn_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.organization_id%type,
73: p_wip_resource_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type,
74: p_incurred_by_person_id IN OUT NOCOPY PA_EXPENDITURES_ALL.incurred_by_person_id%type,
67: * @rep:compatibility S
68: */
69: PROCEDURE CLIENT_COLUMN_VALUES
70: ( p_job_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.job_id%type,
71: p_non_labor_resource IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type,
72: p_non_labor_resource_orgn_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.organization_id%type,
73: p_wip_resource_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type,
74: p_incurred_by_person_id IN OUT NOCOPY PA_EXPENDITURES_ALL.incurred_by_person_id%type,
75: p_inventory_item_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type,
68: */
69: PROCEDURE CLIENT_COLUMN_VALUES
70: ( p_job_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.job_id%type,
71: p_non_labor_resource IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type,
72: p_non_labor_resource_orgn_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.organization_id%type,
73: p_wip_resource_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type,
74: p_incurred_by_person_id IN OUT NOCOPY PA_EXPENDITURES_ALL.incurred_by_person_id%type,
75: p_inventory_item_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type,
76: p_vendor_id IN OUT NOCOPY PA_COMMITMENT_TXNS.vendor_id%type,
69: PROCEDURE CLIENT_COLUMN_VALUES
70: ( p_job_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.job_id%type,
71: p_non_labor_resource IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type,
72: p_non_labor_resource_orgn_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.organization_id%type,
73: p_wip_resource_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type,
74: p_incurred_by_person_id IN OUT NOCOPY PA_EXPENDITURES_ALL.incurred_by_person_id%type,
75: p_inventory_item_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type,
76: p_vendor_id IN OUT NOCOPY PA_COMMITMENT_TXNS.vendor_id%type,
77: p_bom_equipment_resource_id IN OUT NOCOPY PA_COMMITMENT_TXNS.bom_equipment_resource_id%type,
71: p_non_labor_resource IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type,
72: p_non_labor_resource_orgn_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.organization_id%type,
73: p_wip_resource_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.wip_resource_id%type,
74: p_incurred_by_person_id IN OUT NOCOPY PA_EXPENDITURES_ALL.incurred_by_person_id%type,
75: p_inventory_item_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.inventory_item_id%type,
76: p_vendor_id IN OUT NOCOPY PA_COMMITMENT_TXNS.vendor_id%type,
77: p_bom_equipment_resource_id IN OUT NOCOPY PA_COMMITMENT_TXNS.bom_equipment_resource_id%type,
78: p_bom_labor_resource_id IN OUT NOCOPY PA_COMMITMENT_TXNS.bom_labor_resource_id%type
79: );