APPS.IEC_SQL_LOGGER_PVT dependencies on IEO_LNA_RECORDS

Line 15: select IEO_LNA_RECORDS_S1.nextval into G_SEQ_NUM from dual;

11:
12: if( G_SEQ_NUM IS NULL OR G_SEQ_NUM = G_FETCH_SEQ_NUM )
13: then
14: -- dbms_output.put_line('get_next_record_id: After fetch id is <'|| G_SEQ_NUM || '>' );
15: select IEO_LNA_RECORDS_S1.nextval into G_SEQ_NUM from dual;
16: G_FETCH_SEQ_NUM := G_SEQ_NUM + 2000;
17: end if;
18:
19: G_SEQ_NUM := G_SEQ_NUM + 1;

Line 188: l_record_id IEO_LNA_RECORDS.RECORD_ID%TYPE;

184: IS
185:
186: PRAGMA AUTONOMOUS_TRANSACTION;
187: l_log NUMBER(1);
188: l_record_id IEO_LNA_RECORDS.RECORD_ID%TYPE;
189: l_date1 DATE;
190: l_date2 DATE;
191:
192: l_last_updated_by NUMBER;

Line 224: insert into ieo_lna_records ( record_id,

220: l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);
221: l_created_by := NVL(FND_GLOBAL.user_id,-1);
222: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
223:
224: insert into ieo_lna_records ( record_id,
225: created_by,
226: creation_date,
227: last_updated_by,
228: last_update_date,

Line 303: from ieo_lna_records

299: return;
300: end if;
301:
302: select 1 into l_log
303: from ieo_lna_records
304: where record_id = P_RECORD_ID;
305:
306: -- Create a savepoint and then commit till this point.
307: SAVEPOINT log_description;

Line 378: from ieo_lna_records

374: then
375: return;
376: end if;
377: select 1 into l_log
378: from ieo_lna_records
379: where record_id = P_RECORD_ID;
380:
381: -- Create a savepoint and then commit till this point.
382: SAVEPOINT log_description_II;

Line 456: from ieo_lna_records

452: return;
453: end if;
454:
455: select 1 into l_log
456: from ieo_lna_records
457: where record_id = P_RECORD_ID;
458:
459: -- Create a savepoint and then commit till this point.
460: SAVEPOINT desc_params;

Line 541: from ieo_lna_records

537: return;
538: end if;
539:
540: select 1 into l_log
541: from ieo_lna_records
542: where record_id = P_RECORD_ID;
543:
544: -- Create a savepoint and then commit till this point.
545: SAVEPOINT desc_params_II;