PACKAGE: APPS.PJM_SEIBAN_PUB

Source

1 PACKAGE PJM_SEIBAN_PUB AUTHID CURRENT_USER AS
2 /* $Header: PJMPSBNS.pls 115.5 2002/12/07 10:50:49 alaw noship $ */
3 
4 --
5 -- Record and Table Types
6 --
7 TYPE DescFlexRecType IS RECORD
8 ( Category   pjm_seiban_numbers.attribute_category%type
9 , Attr1      pjm_seiban_numbers.attribute1%type
10 , Attr2      pjm_seiban_numbers.attribute2%type
11 , Attr3      pjm_seiban_numbers.attribute3%type
12 , Attr4      pjm_seiban_numbers.attribute4%type
13 , Attr5      pjm_seiban_numbers.attribute5%type
14 , Attr6      pjm_seiban_numbers.attribute6%type
15 , Attr7      pjm_seiban_numbers.attribute7%type
16 , Attr8      pjm_seiban_numbers.attribute8%type
17 , Attr9      pjm_seiban_numbers.attribute9%type
18 , Attr10     pjm_seiban_numbers.attribute10%type
19 , Attr11     pjm_seiban_numbers.attribute11%type
20 , Attr12     pjm_seiban_numbers.attribute12%type
21 , Attr13     pjm_seiban_numbers.attribute13%type
22 , Attr14     pjm_seiban_numbers.attribute14%type
23 , Attr15     pjm_seiban_numbers.attribute15%type
24 );
25 
26 TYPE OrgRecType IS RECORD
27 ( Organization_ID      pjm_project_parameters.organization_id%type
28 , Cost_Group_ID        pjm_project_parameters.costing_group_id%type
29 , WIP_Acct_Class_Code  pjm_project_parameters.wip_acct_class_code%type
30 , Start_Date_Active    pjm_project_parameters.start_date_active%type
31 , End_Date_Active      pjm_project_parameters.end_date_active%type
32 , Attr_Category        pjm_project_parameters.attribute_category%type
33 , Attr1                pjm_project_parameters.attribute1%type
34 , Attr2                pjm_project_parameters.attribute2%type
35 , Attr3                pjm_project_parameters.attribute3%type
36 , Attr4                pjm_project_parameters.attribute4%type
37 , Attr5                pjm_project_parameters.attribute5%type
38 , Attr6                pjm_project_parameters.attribute6%type
39 , Attr7                pjm_project_parameters.attribute7%type
40 , Attr8                pjm_project_parameters.attribute8%type
41 , Attr9                pjm_project_parameters.attribute9%type
42 , Attr10               pjm_project_parameters.attribute10%type
43 , Attr11               pjm_project_parameters.attribute11%type
44 , Attr12               pjm_project_parameters.attribute12%type
45 , Attr13               pjm_project_parameters.attribute13%type
46 , Attr14               pjm_project_parameters.attribute14%type
47 , Attr15               pjm_project_parameters.attribute15%type
48 );
49 
50 TYPE OrgTblType IS TABLE OF OrgRecType
51   INDEX BY BINARY_INTEGER;
52 
53 
54 --
55 -- Functions and Procedures
56 --
57 PROCEDURE Create_Seiban
58 ( P_api_version             IN            NUMBER
59 , P_init_msg_list           IN            VARCHAR2 DEFAULT FND_API.G_TRUE
60 , P_commit                  IN            VARCHAR2 DEFAULT FND_API.G_FALSE
61 , X_return_status           OUT NOCOPY    VARCHAR2
62 , X_msg_count               OUT NOCOPY    NUMBER
63 , X_msg_data                OUT NOCOPY    VARCHAR2
64 , P_seiban_number           IN            VARCHAR2
65 , P_seiban_name             IN            VARCHAR2
66 , P_operating_unit          IN            NUMBER   DEFAULT NULL
67 , P_planning_group          IN            VARCHAR2 DEFAULT NULL
68 , P_DFF                     IN            DescFlexRecType
69 , P_org_list                IN            OrgTblType
70 , X_project_id              OUT NOCOPY    NUMBER
71 );
72 
73 END PJM_SEIBAN_PUB;