DBA Data[Home] [Help]

APPS.IEC_SQL_LOGGER_PVT dependencies on FND_GLOBAL

Line 62: l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);

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.

Line 63: l_created_by := NVL(FND_GLOBAL.user_id,-1);

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:

Line 64: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);

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

Line 220: l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);

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,

Line 221: l_created_by := NVL(FND_GLOBAL.user_id,-1);

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,

Line 222: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);

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,

Line 316: l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);

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' );

Line 317: l_created_by := NVL(FND_GLOBAL.user_id,-1);

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,

Line 318: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);

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,

Line 469: l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);

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,

Line 470: l_created_by := NVL(FND_GLOBAL.user_id,-1);

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,

Line 471: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);

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,