[Home] [Help]
PACKAGE: APPS.CN_SRP_PLAN_ASSIGNS_PKG
Source
1 PACKAGE CN_SRP_PLAN_ASSIGNS_PKG AUTHID CURRENT_USER as
2 -- $Header: cnsrplas.pls 115.6 2002/11/21 21:08:13 hlchen ship $
3 --
4 -- Package Name
5 -- CN_SRP_PLAN_ASSIGNS_PKG
6 -- Purpose
7 -- Table Handler for CN_SRP_PLAN_ASSIGNS
8 -- FORM CNSRMT
9 -- BLOCK SRP_PLAN_ASSIGNS
10 --
11 -- History
12 -- 06-Jun-99 Angela Chung Created
13
14 -- -------------------------------------------------------------------------+
15 -- Procedure Name
16 -- INSERT_ROW
17 -- Purpose
18 --
19 -- History
20 --
21 -- -------------------------------------------------------------------------+
22 PROCEDURE INSERT_ROW
23 (X_SRP_PLAN_ASSIGN_ID IN OUT NOCOPY NUMBER,
24 X_SRP_ROLE_ID IN NUMBER,
25 X_ROLE_PLAN_ID IN NUMBER,
26 X_SALESREP_ID IN NUMBER,
27 X_ROLE_ID IN NUMBER,
28 X_COMP_PLAN_ID IN NUMBER,
29 X_START_DATE IN DATE,
30 X_END_DATE IN DATE,
31 X_ATTRIBUTE_CATEGORY IN VARCHAR2 := NULL,
32 X_ATTRIBUTE1 IN VARCHAR2 := NULL,
33 X_ATTRIBUTE2 IN VARCHAR2 := NULL,
34 X_ATTRIBUTE3 IN VARCHAR2 := NULL,
35 X_ATTRIBUTE4 IN VARCHAR2 := NULL,
36 X_ATTRIBUTE5 IN VARCHAR2 := NULL,
37 X_ATTRIBUTE6 IN VARCHAR2 := NULL,
38 X_ATTRIBUTE7 IN VARCHAR2 := NULL,
39 X_ATTRIBUTE8 IN VARCHAR2 := NULL,
40 X_ATTRIBUTE9 IN VARCHAR2 := NULL,
41 X_ATTRIBUTE10 IN VARCHAR2 := NULL,
42 X_ATTRIBUTE11 IN VARCHAR2 := NULL,
43 X_ATTRIBUTE12 IN VARCHAR2 := NULL,
44 X_ATTRIBUTE13 IN VARCHAR2 := NULL,
45 X_ATTRIBUTE14 IN VARCHAR2 := NULL,
46 X_ATTRIBUTE15 IN VARCHAR2 := NULL,
47 X_CREATED_BY IN NUMBER,
48 X_CREATION_DATE IN DATE,
49 X_LAST_UPDATE_DATE IN DATE,
50 X_LAST_UPDATED_BY IN NUMBER,
51 X_LAST_UPDATE_LOGIN IN NUMBER
52 );
53
54 -- -------------------------------------------------------------------------+
55 -- Procedure Name
56 -- LOCK_ROW
57 -- Purpose
58 --
59 -- History
60 --
61 -- -------------------------------------------------------------------------+
62 PROCEDURE LOCK_ROW
63 (X_SRP_PLAN_ASSIGN_ID IN NUMBER,
64 X_SRP_ROLE_ID IN NUMBER,
65 X_ROLE_PLAN_ID IN NUMBER,
66 X_SALESREP_ID IN NUMBER,
67 X_ROLE_ID IN NUMBER,
68 X_COMP_PLAN_ID IN NUMBER,
69 X_START_DATE IN DATE,
70 X_END_DATE IN DATE,
71 X_ATTRIBUTE_CATEGORY IN VARCHAR2 := NULL,
72 X_ATTRIBUTE1 IN VARCHAR2 := NULL,
73 X_ATTRIBUTE2 IN VARCHAR2 := NULL,
74 X_ATTRIBUTE3 IN VARCHAR2 := NULL,
75 X_ATTRIBUTE4 IN VARCHAR2 := NULL,
76 X_ATTRIBUTE5 IN VARCHAR2 := NULL,
77 X_ATTRIBUTE6 IN VARCHAR2 := NULL,
78 X_ATTRIBUTE7 IN VARCHAR2 := NULL,
79 X_ATTRIBUTE8 IN VARCHAR2 := NULL,
80 X_ATTRIBUTE9 IN VARCHAR2 := NULL,
81 X_ATTRIBUTE10 IN VARCHAR2 := NULL,
82 X_ATTRIBUTE11 IN VARCHAR2 := NULL,
83 X_ATTRIBUTE12 IN VARCHAR2 := NULL,
84 X_ATTRIBUTE13 IN VARCHAR2 := NULL,
85 X_ATTRIBUTE14 IN VARCHAR2 := NULL,
86 X_ATTRIBUTE15 IN VARCHAR2 := NULL
87 );
88
89 -- -------------------------------------------------------------------------+
90 -- Procedure Name
91 -- UPDATE_ROW
92 -- Purpose
93 --
94 -- History
95 --
96 -- -------------------------------------------------------------------------+
97 PROCEDURE UPDATE_ROW
98 (X_SRP_PLAN_ASSIGN_ID IN NUMBER,
99 X_SRP_ROLE_ID IN NUMBER := fnd_api.g_miss_num,
100 X_ROLE_PLAN_ID IN NUMBER := fnd_api.g_miss_num,
101 X_SALESREP_ID IN NUMBER := fnd_api.g_miss_num,
102 X_ROLE_ID IN NUMBER := fnd_api.g_miss_num,
103 X_COMP_PLAN_ID IN NUMBER := fnd_api.g_miss_num,
104 X_START_DATE IN DATE := fnd_api.g_miss_date,
105 X_END_DATE IN DATE := fnd_api.g_miss_date,
106 X_ATTRIBUTE_CATEGORY IN VARCHAR2 := fnd_api.g_miss_char,
107 X_ATTRIBUTE1 IN VARCHAR2 := fnd_api.g_miss_char,
108 X_ATTRIBUTE2 IN VARCHAR2 := fnd_api.g_miss_char,
109 X_ATTRIBUTE3 IN VARCHAR2 := fnd_api.g_miss_char,
110 X_ATTRIBUTE4 IN VARCHAR2 := fnd_api.g_miss_char,
111 X_ATTRIBUTE5 IN VARCHAR2 := fnd_api.g_miss_char,
112 X_ATTRIBUTE6 IN VARCHAR2 := fnd_api.g_miss_char,
113 X_ATTRIBUTE7 IN VARCHAR2 := fnd_api.g_miss_char,
114 X_ATTRIBUTE8 IN VARCHAR2 := fnd_api.g_miss_char,
115 X_ATTRIBUTE9 IN VARCHAR2 := fnd_api.g_miss_char,
116 X_ATTRIBUTE10 IN VARCHAR2 := fnd_api.g_miss_char,
117 X_ATTRIBUTE11 IN VARCHAR2 := fnd_api.g_miss_char,
118 X_ATTRIBUTE12 IN VARCHAR2 := fnd_api.g_miss_char,
119 X_ATTRIBUTE13 IN VARCHAR2 := fnd_api.g_miss_char,
120 X_ATTRIBUTE14 IN VARCHAR2 := fnd_api.g_miss_char,
121 X_ATTRIBUTE15 IN VARCHAR2 := fnd_api.g_miss_char,
122 X_LAST_UPDATE_DATE IN DATE,
123 X_LAST_UPDATED_BY IN NUMBER,
124 X_LAST_UPDATE_LOGIN IN NUMBER
125 );
126
127 -- -------------------------------------------------------------------------+
128 -- Procedure Name
129 -- DELETE_ROW
130 -- Purpose
131 --
132 -- History
133 --
134 -- -------------------------------------------------------------------------+
135 PROCEDURE DELETE_ROW (X_SRP_PLAN_ASSIGN_ID IN NUMBER);
136
137 END CN_SRP_PLAN_ASSIGNS_PKG;