58:
59: X_SOURCE_ID := 0;
60:
61: BEGIN
62: l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);
63: l_created_by := NVL(FND_GLOBAL.user_id,-1);
64: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
65:
66: -- Check if a record already exists for this source.
59: X_SOURCE_ID := 0;
60:
61: BEGIN
62: l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);
63: l_created_by := NVL(FND_GLOBAL.user_id,-1);
64: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
65:
66: -- Check if a record already exists for this source.
67:
60:
61: BEGIN
62: l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);
63: l_created_by := NVL(FND_GLOBAL.user_id,-1);
64: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
65:
66: -- Check if a record already exists for this source.
67:
68: Select SOURCE_ID, LOG_LEVEL into l_source_id, l_log_level
216:
217: l_date1 := sysdate;
218: l_date2 := l_date1;
219:
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,
217: l_date1 := sysdate;
218: l_date2 := l_date1;
219:
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,
218: l_date2 := l_date1;
219:
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,
312: then
313: l_date1 := sysdate;
314: l_date2 := l_date1;
315:
316: l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);
317: l_created_by := NVL(FND_GLOBAL.user_id,-1);
318: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
319:
320: -- dbms_output.put_line('log_description: Adding the description' );
313: l_date1 := sysdate;
314: l_date2 := l_date1;
315:
316: l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);
317: l_created_by := NVL(FND_GLOBAL.user_id,-1);
318: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
319:
320: -- dbms_output.put_line('log_description: Adding the description' );
321: insert into ieo_lna_descriptions ( record_id,
314: l_date2 := l_date1;
315:
316: l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);
317: l_created_by := NVL(FND_GLOBAL.user_id,-1);
318: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
319:
320: -- dbms_output.put_line('log_description: Adding the description' );
321: insert into ieo_lna_descriptions ( record_id,
322: desc_pos,
465: then
466: l_date1 := sysdate;
467: l_date2 := l_date1;
468:
469: l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);
470: l_created_by := NVL(FND_GLOBAL.user_id,-1);
471: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
472:
473: insert into ieo_lna_parameters ( record_id,
466: l_date1 := sysdate;
467: l_date2 := l_date1;
468:
469: l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);
470: l_created_by := NVL(FND_GLOBAL.user_id,-1);
471: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
472:
473: insert into ieo_lna_parameters ( record_id,
474: desc_pos,
467: l_date2 := l_date1;
468:
469: l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);
470: l_created_by := NVL(FND_GLOBAL.user_id,-1);
471: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
472:
473: insert into ieo_lna_parameters ( record_id,
474: desc_pos,
475: param_pos,