[Home] [Help]
PACKAGE: APPS.CN_CALC_EXT_TABLE_PKG
Source
1 PACKAGE CN_CALC_EXT_TABLE_PKG AUTHID CURRENT_USER AS
2 /* $Header: cntextts.pls 115.5 2002/11/21 21:09:26 hlchen ship $ */
3 --
4 -- Package Name
5 -- CN_CALC_EXT_TABLE_PKG
6 -- Purpose
7 -- Table Handler for CN_CALC_EXT_TABLE
8 --
9 -- History
10 -- 02-feb-01 Kumar Sivasankaran Created
11
12 --==========================================================================
13 -- Procedure Name
14 -- Insert_row
15 -- Purpose
16 -- Main insert procedure
17 --==========================================================================
18
19 PROCEDURE insert_row
20 (x_calc_ext_table_id IN OUT NOCOPY NUMBER
21 ,p_name VARCHAR2 := NULL
22 ,p_description VARCHAR2 := NULL
23 ,p_internal_table_id NUMBER := NULL
24 ,p_external_table_id NUMBER := NULL
25 ,P_USED_FLAG VARCHAR2 := NULL
26 ,P_SCHEMA VARCHAR2 := NULL
27 ,P_EXTERNAL_TABLE_NAME VARCHAR2 := NULL
28 ,P_ALIAS VARCHAR2 := NULL
29 ,p_attribute_category VARCHAR2 := NULL
30 ,p_attribute1 VARCHAR2 := NULL
31 ,p_attribute2 VARCHAR2 := NULL
32 ,p_attribute3 VARCHAR2 := NULL
33 ,p_attribute4 VARCHAR2 := NULL
34 ,p_attribute5 VARCHAR2 := NULL
35 ,p_attribute6 VARCHAR2 := NULL
36 ,p_attribute7 VARCHAR2 := NULL
37 ,p_attribute8 VARCHAR2 := NULL
38 ,p_attribute9 VARCHAR2 := NULL
39 ,p_attribute10 VARCHAR2 := NULL
40 ,p_attribute11 VARCHAR2 := NULL
41 ,p_attribute12 VARCHAR2 := NULL
42 ,p_attribute13 VARCHAR2 := NULL
43 ,p_attribute14 VARCHAR2 := NULL
44 ,p_attribute15 VARCHAR2 := NULL
45 ,p_Created_By NUMBER
46 ,p_Creation_Date DATE
47 ,p_Last_Updated_By NUMBER
48 ,p_Last_Update_Date DATE
49 ,p_Last_Update_Login NUMBER
50 );
51
52 -- /*-------------------------------------------------------------------------*
53 -- Procedure Name
54 -- Lock_row
55 -- Purpose
56 -- Lock db row after form record is changed
57 -- Notes
58 -- *-------------------------------------------------------------------------*/
59
60 PROCEDURE lock_row
61 (p_calc_ext_table_id NUMBER
62 ,p_name VARCHAR2 := NULL
63 ,P_DESCRIPTION VARCHAR2 := NULL
64 ,P_INTERNAL_TABLE_ID NUMBER := NULL
65 ,P_EXTERNAL_TABLE_ID NUMBER := NULL
66 ,P_USED_FLAG VARCHAR2 := NULL
67 ,P_SCHEMA VARCHAR2 := NULL
68 ,P_EXTERNAL_TABLE_NAME VARCHAR2 := NULL
69 ,P_ALIAS VARCHAR2 := NULL
70 ,p_attribute_category VARCHAR2 := NULL
71 ,p_attribute1 VARCHAR2 := NULL
72 ,p_attribute2 VARCHAR2 := NULL
73 ,p_attribute3 VARCHAR2 := NULL
74 ,p_attribute4 VARCHAR2 := NULL
75 ,p_attribute5 VARCHAR2 := NULL
76 ,p_attribute6 VARCHAR2 := NULL
77 ,p_attribute7 VARCHAR2 := NULL
78 ,p_attribute8 VARCHAR2 := NULL
79 ,p_attribute9 VARCHAR2 := NULL
80 ,p_attribute10 VARCHAR2 := NULL
81 ,p_attribute11 VARCHAR2 := NULL
82 ,p_attribute12 VARCHAR2 := NULL
83 ,p_attribute13 VARCHAR2 := NULL
84 ,p_attribute14 VARCHAR2 := NULL
85 ,p_attribute15 VARCHAR2 := NULL
86 );
87
88 -- /*-------------------------------------------------------------------------*
89 -- Procedure Name
90 -- Update Record
91 -- Purpose
92 --
93 -- *-------------------------------------------------------------------------*/
94 PROCEDURE update_row (
95 p_calc_ext_table_id NUMBER := fnd_api.g_miss_num
96 ,p_name VARCHAR2 := fnd_api.g_miss_char
97 ,P_DESCRIPTION VARCHAR2 := fnd_api.g_miss_char
98 ,P_INTERNAL_TABLE_ID NUMBER := fnd_api.g_miss_num
99 ,P_EXTERNAL_TABLE_ID NUMBER := fnd_api.g_miss_num
100 ,P_USED_FLAG VARCHAR2 := fnd_api.g_miss_char
101 ,P_SCHEMA VARCHAR2 := fnd_api.g_miss_char
102 ,P_EXTERNAL_TABLE_NAME VARCHAR2 := fnd_api.g_miss_char
103 ,P_ALIAS VARCHAR2 := fnd_api.g_miss_char
104 ,p_attribute_category VARCHAR2 := fnd_api.g_miss_char
105 ,p_attribute1 VARCHAR2 := fnd_api.g_miss_char
106 ,p_attribute2 VARCHAR2 := fnd_api.g_miss_char
107 ,p_attribute3 VARCHAR2 := fnd_api.g_miss_char
108 ,p_attribute4 VARCHAR2 := fnd_api.g_miss_char
109 ,p_attribute5 VARCHAR2 := fnd_api.g_miss_char
110 ,p_attribute6 VARCHAR2 := fnd_api.g_miss_char
111 ,p_attribute7 VARCHAR2 := fnd_api.g_miss_char
112 ,p_attribute8 VARCHAR2 := fnd_api.g_miss_char
113 ,p_attribute9 VARCHAR2 := fnd_api.g_miss_char
114 ,p_attribute10 VARCHAR2 := fnd_api.g_miss_char
115 ,p_attribute11 VARCHAR2 := fnd_api.g_miss_char
116 ,p_attribute12 VARCHAR2 := fnd_api.g_miss_char
117 ,p_attribute13 VARCHAR2 := fnd_api.g_miss_char
118 ,p_attribute14 VARCHAR2 := fnd_api.g_miss_char
119 ,p_attribute15 VARCHAR2 := fnd_api.g_miss_char
120 ,p_Last_Updated_By NUMBER
121 ,p_Last_Update_Date DATE
122 ,p_Last_Update_Login NUMBER );
123
124 --/*-------------------------------------------------------------------------*
125 -- Procedure Name
126 -- Delete_row
127 -- Purpose
128 --*-------------------------------------------------------------------------*/
129 PROCEDURE Delete_row( p_calc_ext_table_id NUMBER );
130
131 END CN_CALC_EXT_TABLE_PKG;