1 PACKAGE BODY PA_CLIENT_EXTN_BURDEN_RESOURCE AS
2 /* $Header: PAXBRGCB.pls 120.1 2005/08/23 19:18:40 spunathi noship $ */
3
4 FUNCTION CLIENT_GROUPING
5 ( p_job_id IN PA_EXPENDITURE_ITEMS_ALL.job_id%type DEFAULT NULL,
6 p_non_labor_resource IN PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type DEFAULT NULL,
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
16 v_grouping_method varchar2(2000) default null;
17
18 BEGIN
19
20 IF NVL(FND_PROFILE.value('PA_RPT_BTC_SRC_RESRC'), 'N') = 'Y' THEN
21
22 null;
23
24 /*
25 ** CLIENT CUSTOMIZATIONS BEGINS HERE .
26 ** modify the value of v_grouping_method with the additional grouping criteria
27 */
28
29 END IF;
30
31 RETURN v_grouping_method;
32
33 EXCEPTION
34
35 WHEN OTHERS THEN
36 RAISE;
37
38 END CLIENT_GROUPING;
39
40 PROCEDURE CLIENT_COLUMN_VALUES
41 ( p_job_id IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.job_id%type,
42 p_non_labor_resource IN OUT NOCOPY PA_EXPENDITURE_ITEMS_ALL.non_labor_resource%type,
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
52 IS
53
54 BEGIN
55
56 null;
57
58 /* This client extension filters out the column values needs to be
59 populated in pa_expenditure_items table, when a new expenditure item is created by the
60 Burden Summarization process based on the additional summarization grouping.
61 These column values, which have been included in the grouping criteria in the function
62 CLIENT_GROUPING, should be commented out from the below code.
63 */
64 p_job_id := null;
65 p_non_labor_resource := null;
66 p_non_labor_resource_orgn_id := null;
67 p_incurred_by_person_id := null;
68 p_inventory_item_id := null;
69 p_vendor_id := null;
70 p_bom_equipment_resource_id := null;
71 p_bom_labor_resource_id := null;
72
73 EXCEPTION
74 WHEN OTHERS THEN
75 RAISE;
76 END CLIENT_COLUMN_VALUES;
77
78 END PA_CLIENT_EXTN_BURDEN_RESOURCE;