1 PACKAGE PA_CLIENT_EXTN_BURDEN_RESOURCE AS
2 /* $Header: PAXBRGCS.pls 120.2 2006/06/27 18:44:41 rahariha noship $ */
3 /*#
4 * This extension is used to customize the summary criteria for creating the summary burden transactions.
5 * @rep:scope public
6 * @rep:product PA
7 * @rep:lifecycle active
8 * @rep:displayname Summary Burden Grouping Customization
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY PA_PROJECT
11 * @rep:category BUSINESS_ENTITY PA_LABOR_COST
12 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
13 */
14
15 /*#
16 * Use this procedure to create Summary Burden transactions in such a way that, the summary burden transactions
17 * and its source raw transactions are mapped to the same Planning Resource in order to report them correctly in the
18 * context of a Resource Breakdown Structure.
19 * @param p_job_id This contains a value if the resource is of JOB type. It contains job identifier of the source transaction.
20 * @param p_non_labor_resource This contains a value if the resource is of NON_LABOR_RESOURCE type. This holds the non labor
21 * resource name of the source transaction.
22 * @param p_non_labor_resource_orgn_id Identifier of the organization of the resource of the source transaction.
23 * @param p_wip_resource_id Identifier of the resource for work in progress of the source transaction.
24 * @param p_incurred_by_person_id Identifier of the person who incurred the source transaction.
25 * @param p_inventory_item_id This contains a value if the resource is of ITEM type. It contains the resource identifier of
26 * the source transaction.
27 * @param p_vendor_id The vendor identifier of the source transaction.
28 * @param p_bom_equipment_resource_id Identifier for BOM equipment resource of the osurce transaction.
29 * @param p_bom_labor_resource_id This contains a value if the resource is of BOM_LABOR type.It holds the selected resource
30 * identifier of the source transaction.
31 * @rep:scope public
32 * @rep:lifecycle active
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,
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 ;
47
48
49 /*#
50 * Use this procedure in conjunction with the above Summary Burden Grouping - Resource. NULL out those parameters
51 * that were not used for additional grouping in Summary Burden Grouping - Resource.
52 * @param p_job_id This contains a value if the resource is of JOB type. It contains job identifier of the source transaction.
53 * @param p_non_labor_resource This contains a value if the resource is of NON_LABOR_RESOURCE type. This holds the non labor
54 * resource name of the source transaction.
55 * @param p_non_labor_resource_orgn_id Identifier of the organization of the resource of the source transaction.
56 * @param p_wip_resource_id Identifier of the resource for work in progress of the source transaction.
57 * @param p_incurred_by_person_id Identifier of the person who incurred the source transaction.
58 * @param p_inventory_item_id This contains a value if the resource is of ITEM type. It contains the resource identifier of
59 * the source transaction.
60 * @param p_vendor_id The vendor identifier of the source transaction.
61 * @param p_bom_equipment_resource_id Identifier for BOM equipment resource of the osurce transaction.
62 * @param p_bom_labor_resource_id This contains a value if the resource is of BOM_LABOR type.It holds the selected resource
63 * identifier of the source transaction.
64 * @rep:scope public
65 * @rep:lifecycle active
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,
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 );
80
81 END PA_CLIENT_EXTN_BURDEN_RESOURCE;