APPS.OKI_LOAD_OKV_PVT dependencies on OKI_PERF_MEASURES

Line 80: FROM oki_perf_measures okv

76: , p_kpi_code IN VARCHAR2
77: , p_scs_code IN VARCHAR2
78: ) IS
79: SELECT rowid
80: FROM oki_perf_measures okv
81: WHERE okv.period_set_name = p_period_set_name
82: AND okv.period_name = p_period_name
83: AND okv.authoring_org_id = p_authoring_org_id
84: AND okv.kpi_code = p_kpi_code

Line 90: -- Procedure to insert records into the oki_perf_measures table.

86: ;
87: rec_g_okv_csr g_okv_csr%ROWTYPE ;
88:
89: --------------------------------------------------------------------------------
90: -- Procedure to insert records into the oki_perf_measures table.
91:
92: --------------------------------------------------------------------------------
93:
94: PROCEDURE ins_perf_meas

Line 117: SELECT oki_perf_measures_s1.nextval seq

113: l_sequence NUMBER := NULL ;
114:
115: -- Cursor declaration
116: CURSOR l_seq_num IS
117: SELECT oki_perf_measures_s1.nextval seq
118: FROM dual
119: ;
120: rec_l_seq_num l_seq_num%ROWTYPE ;
121:

Line 136: INSERT INTO oki_perf_measures

132:
133: -- initialize return code to success
134: x_retcode := '0' ;
135:
136: INSERT INTO oki_perf_measures
137: ( id
138: , period_set_name
139: , period_name
140: , period_type

Line 176: , value => 'OKI_PERF_MEASURES');

172: fnd_message.set_name( application => 'OKI'
173: , name => 'OKI_TABLE_LOAD_FAILURE');
174:
175: fnd_message.set_token( token => 'TABLE_NAME'
176: , value => 'OKI_PERF_MEASURES');
177:
178: fnd_file.put_line( which => fnd_file.log
179: , buff => fnd_message.get);
180:

Line 196: , value => 'OKI_PERF_MEASURES');

192: fnd_message.set_name( application => 'OKI'
193: , name => 'OKI_TABLE_LOAD_FAILURE');
194:
195: fnd_message.set_token( token => 'TABLE_NAME'
196: , value => 'OKI_PERF_MEASURES');
197:
198: fnd_file.put_line( which => fnd_file.log
199: , buff => fnd_message.get);
200:

Line 207: -- Procedure to update records in the oki_perf_measures table.

203:
204: END ins_perf_meas ;
205:
206: --------------------------------------------------------------------------------
207: -- Procedure to update records in the oki_perf_measures table.
208:
209: --------------------------------------------------------------------------------
210: PROCEDURE upd_perf_meas
211: ( p_kpi_value IN NUMBER

Line 228: UPDATE oki_perf_measures SET

224:
225: -- initialize return code to success
226: x_retcode := '0';
227:
228: UPDATE oki_perf_measures SET
229: kpi_value = p_kpi_value
230: , request_id = oki_load_okv_pvt.g_request_id
231: , program_application_id = oki_load_okv_pvt.g_program_application_id
232: , program_id = oki_load_okv_pvt.g_program_id

Line 1568: l_table_name CONSTANT VARCHAR2(30) := 'OKI_PERF_MEASURES' ;

1564:
1565: -- Constant declaration
1566:
1567: -- Name of the table for which data is being inserted
1568: l_table_name CONSTANT VARCHAR2(30) := 'OKI_PERF_MEASURES' ;
1569:
1570:
1571: -- Local variable declaration
1572: