DBA Data[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;