DBA Data[Home] [Help]

PACKAGE: APPS.CN_PLAN_TEXTS_PKG

Source


1 PACKAGE CN_PLAN_TEXTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: cntspxs.pls 115.3 2002/01/28 20:06:07 pkm ship      $ */
3 
4 PROCEDURE Insert_Row (
5   P_PLAN_TEXT_ID        IN NUMBER,
6   P_ROLE_ID        IN NUMBER,
7   P_SEQUENCE_ID         IN NUMBER,
8   P_QUOTA_CATEGORY_ID   IN NUMBER,
9   P_TEXT_TYPE           IN VARCHAR2,
10   P_TEXT                IN VARCHAR2,
11   P_TEXT2               IN VARCHAR2,
12   P_ATTRIBUTE_CATEGORY  IN VARCHAR2 := NULL,
13   P_ATTRIBUTE1          IN VARCHAR2 := NULL,
14   P_ATTRIBUTE2          IN VARCHAR2 := NULL,
15   P_ATTRIBUTE3          IN VARCHAR2 := NULL,
16   P_ATTRIBUTE4          IN VARCHAR2 := NULL,
17   P_ATTRIBUTE5          IN VARCHAR2 := NULL,
18   P_ATTRIBUTE6          IN VARCHAR2 := NULL,
19   P_ATTRIBUTE7          IN VARCHAR2 := NULL,
20   P_ATTRIBUTE8          IN VARCHAR2 := NULL,
21   P_ATTRIBUTE9          IN VARCHAR2 := NULL,
22   P_ATTRIBUTE10         IN VARCHAR2 := NULL,
23   P_ATTRIBUTE11         IN VARCHAR2 := NULL,
24   P_ATTRIBUTE12         IN VARCHAR2 := NULL,
25   P_ATTRIBUTE13         IN VARCHAR2 := NULL,
26   P_ATTRIBUTE14         IN VARCHAR2 := NULL,
27   P_ATTRIBUTE15         IN VARCHAR2 := NULL,
28   P_CREATION_DATE       IN DATE,
29   P_CREATED_BY          IN NUMBER,
30   P_LAST_UPDATE_DATE    IN DATE,
31   P_LAST_UPDATED_BY     IN NUMBER,
32   P_LAST_UPDATE_LOGIN   IN NUMBER,
33   P_OBJECT_VERSION_NUMBER   IN NUMBER,
34   P_ROLE_MODEL_ID       IN NUMBER
35 );
36 
37 PROCEDURE Update_Row (
38   P_PLAN_TEXT_ID        IN NUMBER,
39   P_ROLE_ID        IN NUMBER,
40   P_SEQUENCE_ID         IN NUMBER,
41   P_QUOTA_CATEGORY_ID   IN NUMBER,
42   P_TEXT_TYPE           IN VARCHAR2,
43   P_TEXT                IN VARCHAR2,
44   P_TEXT2               IN VARCHAR2,
45   P_ATTRIBUTE_CATEGORY  IN VARCHAR2,
46   P_ATTRIBUTE1          IN VARCHAR2,
47   P_ATTRIBUTE2          IN VARCHAR2,
48   P_ATTRIBUTE3          IN VARCHAR2,
49   P_ATTRIBUTE4          IN VARCHAR2,
50   P_ATTRIBUTE5          IN VARCHAR2,
51   P_ATTRIBUTE6          IN VARCHAR2,
52   P_ATTRIBUTE7          IN VARCHAR2,
53   P_ATTRIBUTE8          IN VARCHAR2,
54   P_ATTRIBUTE9          IN VARCHAR2,
55   P_ATTRIBUTE10         IN VARCHAR2,
56   P_ATTRIBUTE11         IN VARCHAR2,
57   P_ATTRIBUTE12         IN VARCHAR2,
58   P_ATTRIBUTE13         IN VARCHAR2,
59   P_ATTRIBUTE14         IN VARCHAR2,
60   P_ATTRIBUTE15         IN VARCHAR2,
61   P_LAST_UPDATE_DATE    IN DATE,
62   P_LAST_UPDATED_BY     IN NUMBER,
63   P_LAST_UPDATE_LOGIN   IN NUMBER,
64   P_OBJECT_VERSION_NUMBER   IN NUMBER,
65   P_ROLE_MODEL_ID       IN NUMBER
66 );
67 
68 PROCEDURE Delete_Row (
69   P_PLAN_TEXT_ID        IN NUMBER
70 );
71 
72 END CN_PLAN_TEXTS_PKG;