DBA Data[Home] [Help]

PACKAGE: APPS.PN_SET_MILESTONES_PKG

Source


1 package PN_SET_MILESTONES_PKG As
2 /* $Header: PNTSTMLS.pls 120.1 2005/08/05 06:25:04 appldev ship $ */
3 
4 procedure INSERT_ROW (
5                        X_ROWID                in out NOCOPY VARCHAR2,
6                        X_MILESTONES_SET_ID    in out NOCOPY NUMBER,
7                        X_SET_ID               in NUMBER,
8                        X_USER_ID              in NUMBER,
9                        X_NOTIFICATION_DATE    in DATE,
10                        X_LEAD_DAYS            in NUMBER,
11                        X_ATTRIBUTE_CATEGORY   in VARCHAR2,
12                        X_ATTRIBUTE1           in VARCHAR2,
13                        X_ATTRIBUTE2           in VARCHAR2,
14                        X_ATTRIBUTE3           in VARCHAR2,
15                        X_ATTRIBUTE4           in VARCHAR2,
16                        X_ATTRIBUTE5           in VARCHAR2,
17                        X_ATTRIBUTE6           in VARCHAR2,
18                        X_ATTRIBUTE7           in VARCHAR2,
19                        X_ATTRIBUTE8           in VARCHAR2,
20                        X_ATTRIBUTE9           in VARCHAR2,
21                        X_ATTRIBUTE10          in VARCHAR2,
22                        X_ATTRIBUTE11          in VARCHAR2,
23                        X_ATTRIBUTE12          in VARCHAR2,
24                        X_ATTRIBUTE13          in VARCHAR2,
25                        X_ATTRIBUTE14          in VARCHAR2,
26                        X_ATTRIBUTE15          in VARCHAR2,
27                        X_MILESTONE_TYPE_CODE  in VARCHAR2,
28                        X_FREQUENCY            in NUMBER,
29                        X_CREATION_DATE        in DATE,
30                        X_CREATED_BY           in NUMBER,
31                        X_LAST_UPDATE_DATE     in DATE,
32                        X_LAST_UPDATED_BY      in NUMBER,
33                        X_LAST_UPDATE_LOGIN    in NUMBER
34                     );
35 
36 procedure LOCK_ROW (
37                        X_MILESTONES_SET_ID    in NUMBER,
38                        X_SET_ID               in NUMBER,
39                        X_USER_ID              in NUMBER,
40                        X_NOTIFICATION_DATE    in DATE,
41                        X_LEAD_DAYS            in NUMBER,
42                        X_ATTRIBUTE_CATEGORY   in VARCHAR2,
43                        X_ATTRIBUTE1           in VARCHAR2,
44                        X_ATTRIBUTE2           in VARCHAR2,
45                        X_ATTRIBUTE3           in VARCHAR2,
46                        X_ATTRIBUTE4           in VARCHAR2,
47                        X_ATTRIBUTE5           in VARCHAR2,
48                        X_ATTRIBUTE6           in VARCHAR2,
49                        X_ATTRIBUTE7           in VARCHAR2,
50                        X_ATTRIBUTE8           in VARCHAR2,
51                        X_ATTRIBUTE9           in VARCHAR2,
52                        X_ATTRIBUTE10          in VARCHAR2,
53                        X_ATTRIBUTE11          in VARCHAR2,
54                        X_ATTRIBUTE12          in VARCHAR2,
55                        X_ATTRIBUTE13          in VARCHAR2,
56                        X_ATTRIBUTE14          in VARCHAR2,
57                        X_ATTRIBUTE15          in VARCHAR2,
58                        X_MILESTONE_TYPE_CODE  in VARCHAR2,
59                        X_FREQUENCY            in NUMBER
60                      );
61 
62 procedure UPDATE_ROW (
63                        X_MILESTONES_SET_ID    in NUMBER,
64                        X_SET_ID               in NUMBER,
65                        X_USER_ID              in NUMBER,
66                        X_NOTIFICATION_DATE    in DATE,
67                        X_LEAD_DAYS            in NUMBER,
68                        X_ATTRIBUTE_CATEGORY   in VARCHAR2,
69                        X_ATTRIBUTE1           in VARCHAR2,
70                        X_ATTRIBUTE2           in VARCHAR2,
71                        X_ATTRIBUTE3           in VARCHAR2,
72                        X_ATTRIBUTE4           in VARCHAR2,
73                        X_ATTRIBUTE5           in VARCHAR2,
74                        X_ATTRIBUTE6           in VARCHAR2,
75                        X_ATTRIBUTE7           in VARCHAR2,
76                        X_ATTRIBUTE8           in VARCHAR2,
77                        X_ATTRIBUTE9           in VARCHAR2,
78                        X_ATTRIBUTE10          in VARCHAR2,
79                        X_ATTRIBUTE11          in VARCHAR2,
80                        X_ATTRIBUTE12          in VARCHAR2,
81                        X_ATTRIBUTE13          in VARCHAR2,
82                        X_ATTRIBUTE14          in VARCHAR2,
83                        X_ATTRIBUTE15          in VARCHAR2,
84                        X_MILESTONE_TYPE_CODE  in VARCHAR2,
85                        X_FREQUENCY            in NUMBER,
86                        X_LAST_UPDATE_DATE     in DATE,
87                        X_LAST_UPDATED_BY      in NUMBER,
88                        X_LAST_UPDATE_LOGIN    in NUMBER
89                      );
90 
91 procedure DELETE_ROW (
92                        X_MILESTONES_SET_ID    in NUMBER
93                      );
94 
95 end PN_SET_MILESTONES_PKG;