[Home] [Help]
18: x_last_update_login IN NUMBER,
19: x_tax_event_class_name IN VARCHAR2
20: ) is
21:
22: CURSOR C IS SELECT rowid FROM zx_event_classes_b
23: WHERE tax_event_class_code = x_tax_event_class_code;
24:
25: clsinfo c%rowtype;
26: BEGIN
32:
33: IF (g_level_procedure >= g_current_runtime_level ) THEN
34: FND_LOG.STRING(g_level_procedure,
35: 'ZX_EVENT_CLASSES_PKG.Insert_Row',
36: 'Insert into ZX_EVENT_CLASSES_B (+)');
37: END IF;
38:
39: INSERT INTO zx_event_classes_b (
40: tax_event_class_code ,
35: 'ZX_EVENT_CLASSES_PKG.Insert_Row',
36: 'Insert into ZX_EVENT_CLASSES_B (+)');
37: END IF;
38:
39: INSERT INTO zx_event_classes_b (
40: tax_event_class_code ,
41: normal_sign_flag ,
42: asc_intrcmp_tx_evnt_cls_code,
43: creation_date ,
95:
96: IF (g_level_procedure >= g_current_runtime_level ) THEN
97: FND_LOG.STRING(g_level_procedure,
98: 'ZX_EVENT_CLASSES_PKG.Insert_Row',
99: 'Insert into ZX_EVENT_CLASSES_B (-)');
100: END IF;
101: END insert_row;
102:
103:
185:
186: BEGIN
187: SELECT decode (LAST_UPDATED_BY,1,1,0), LAST_UPDATE_DATE
188: INTO db_luby, db_ludate
189: FROM zx_event_classes_b
190: WHERE tax_event_class_code = x_tax_event_class_code;
191:
192: -- Record should be updated only if :
193: -- a. file owner is CUSTOM and db owner is SEED
193: -- a. file owner is CUSTOM and db owner is SEED
194: -- b. owners are the same, and file_date > db_date
195: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
196: db_ludate, x_custom_mode)) THEN
197: UPDATE zx_event_classes_b
198: SET normal_sign_flag = x_normal_sign_flag ,
199: asc_intrcmp_tx_evnt_cls_code = x_intrcmp_tx_cls_code,
200: last_update_date = f_ludate,
201: last_updated_by = f_luby,
228: BEGIN
229: DELETE FROM zx_event_classes_tl T
230: WHERE NOT EXISTS
231: (SELECT null
232: FROM ZX_EVENT_CLASSES_B B
233: WHERE B.tax_event_class_code = T.tax_event_class_code
234: );
235:
236: UPDATE ZX_EVENT_CLASSES_TL T SET (