eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PA_CLIENT_EXTN_BURDEN_RESOURCE

Source


1 PACKAGE PA_CLIENT_EXTN_BURDEN_RESOURCE AUTHID CURRENT_USER 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;