[Home] [Help]
PACKAGE: APPS.PJM_PROJECT_PARAM_PUB
Source
1 PACKAGE PJM_PROJECT_PARAM_PUB AUTHID CURRENT_USER AS
2 /* $Header: PJMPPJPS.pls 115.0 2002/12/10 00:23:38 alaw noship $ */
3
4 TYPE ParamRecType IS RECORD
5 ( Project_ID pjm_project_parameters.project_id%type
6 , Organization_ID pjm_project_parameters.organization_id%type
7 , Cost_Group_ID pjm_project_parameters.costing_group_id%type
8 , WIP_Acct_Class_Code pjm_project_parameters.wip_acct_class_code%type
9 , EAM_Acct_Class_Code pjm_project_parameters.wip_acct_class_code%type
10 , IPV_Expenditure_Type pjm_project_parameters.ipv_expenditure_type%type
11 , ERV_Expenditure_Type pjm_project_parameters.erv_expenditure_type%type
12 , Freight_Expenditure_Type pjm_project_parameters.freight_expenditure_type%type
13 , Tax_Expenditure_Type pjm_project_parameters.tax_expenditure_type%type
14 , Misc_Expenditure_Type pjm_project_parameters.misc_expenditure_type%type
15 , PPV_Expenditure_Type pjm_project_parameters.ppv_expenditure_type%type
16 , Dir_Item_Expenditure_Type pjm_project_parameters.dir_item_expenditure_type%type
17 , Start_Date_Active pjm_project_parameters.start_date_active%type
18 , End_Date_Active pjm_project_parameters.end_date_active%type
19 , Attr_Category pjm_project_parameters.attribute_category%type
20 , Attr1 pjm_project_parameters.attribute1%type
21 , Attr2 pjm_project_parameters.attribute2%type
22 , Attr3 pjm_project_parameters.attribute3%type
23 , Attr4 pjm_project_parameters.attribute4%type
24 , Attr5 pjm_project_parameters.attribute5%type
25 , Attr6 pjm_project_parameters.attribute6%type
26 , Attr7 pjm_project_parameters.attribute7%type
27 , Attr8 pjm_project_parameters.attribute8%type
28 , Attr9 pjm_project_parameters.attribute9%type
29 , Attr10 pjm_project_parameters.attribute10%type
30 , Attr11 pjm_project_parameters.attribute11%type
31 , Attr12 pjm_project_parameters.attribute12%type
32 , Attr13 pjm_project_parameters.attribute13%type
33 , Attr14 pjm_project_parameters.attribute14%type
34 , Attr15 pjm_project_parameters.attribute15%type
35 );
36
37 TYPE ParamTblType IS TABLE OF ParamRecType
38 INDEX BY BINARY_INTEGER;
39
40
41 --
42 -- Functions and Procedures
43 --
44 PROCEDURE Create_Project_Parameter
45 ( P_api_version IN NUMBER
46 , P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE
47 , P_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
48 , X_return_status OUT NOCOPY VARCHAR2
49 , X_msg_count OUT NOCOPY NUMBER
50 , X_msg_data OUT NOCOPY VARCHAR2
51 , P_param_data IN ParamRecType
52 );
53
54
55 PROCEDURE Create_Project_Parameter
56 ( P_api_version IN NUMBER
57 , P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE
58 , P_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
59 , X_return_status OUT NOCOPY VARCHAR2
60 , X_msg_count OUT NOCOPY NUMBER
61 , X_msg_data OUT NOCOPY VARCHAR2
62 , P_param_data IN ParamTblType
63 );
64
65
66 PROCEDURE update_planning_group
67 ( P_api_version IN NUMBER
68 , P_init_msg_list IN VARCHAR2
69 , P_commit IN VARCHAR2
70 , X_return_status OUT NOCOPY VARCHAR2
71 , X_msg_count OUT NOCOPY NUMBER
72 , X_msg_data OUT NOCOPY VARCHAR2
73 , P_project_id IN NUMBER
74 , P_planning_group IN VARCHAR2
75 );
76
77 END PJM_PROJECT_PARAM_PUB;