eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEU_DIAGNOSTICS_PVT dependencies on DBMS_SQL

Line 3319: l_cursor_name := dbms_sql.open_cursor;

3315: -- Execute the sql_stmt to get the count
3316: --
3317:
3318: BEGIN
3319: l_cursor_name := dbms_sql.open_cursor;
3320: DBMS_SQL.PARSE(l_cursor_name,l_sql_stmt , dbms_sql.native);
3321:
3322: If (l_rtnode_bind_var_flag = 'T')
3323: then

Line 3320: DBMS_SQL.PARSE(l_cursor_name,l_sql_stmt , dbms_sql.native);

3316: --
3317:
3318: BEGIN
3319: l_cursor_name := dbms_sql.open_cursor;
3320: DBMS_SQL.PARSE(l_cursor_name,l_sql_stmt , dbms_sql.native);
3321:
3322: If (l_rtnode_bind_var_flag = 'T')
3323: then
3324:

Line 3340: DBMS_SQL.BIND_VARIABLE (

3336: end if;
3337:
3338: if (l_resource_id_flag = 'T')
3339: then
3340: DBMS_SQL.BIND_VARIABLE (
3341: l_cursor_name,
3342: ':resource_id',
3343: p_resource_id );
3344: end if;

Line 3357: DBMS_SQL.BIND_VARIABLE (

3353: -- Ignore bind Var :resource_id here.
3354: If (b.bind_var_name <> ':resource_id')
3355: then
3356:
3357: DBMS_SQL.BIND_VARIABLE (
3358: l_cursor_name,
3359: b.bind_var_name,
3360: b.bind_var_value );
3361: end if;

Line 3371: DBMS_SQL.BIND_VARIABLE (

3367: else
3368:
3369: if (l_enum_bind_var_flag = 'T')
3370: then
3371: DBMS_SQL.BIND_VARIABLE (
3372: l_cursor_name,
3373: ':resource_id',
3374: p_resource_id );
3375: end if;

Line 3379: --DBMS_SQL.BIND_VARIABLE(l_cursor_name, ':resource_id', 3807);

3375: end if;
3376:
3377: end if;
3378:
3379: --DBMS_SQL.BIND_VARIABLE(l_cursor_name, ':resource_id', 3807);
3380: DBMS_SQL.DEFINE_COLUMN(l_cursor_name, 1, l_count);
3381: l_rows_processed := dbms_sql.execute(l_cursor_name);
3382:
3383: IF (DBMS_SQL.FETCH_ROWS(l_cursor_name) > 0)

Line 3380: DBMS_SQL.DEFINE_COLUMN(l_cursor_name, 1, l_count);

3376:
3377: end if;
3378:
3379: --DBMS_SQL.BIND_VARIABLE(l_cursor_name, ':resource_id', 3807);
3380: DBMS_SQL.DEFINE_COLUMN(l_cursor_name, 1, l_count);
3381: l_rows_processed := dbms_sql.execute(l_cursor_name);
3382:
3383: IF (DBMS_SQL.FETCH_ROWS(l_cursor_name) > 0)
3384: THEN

Line 3381: l_rows_processed := dbms_sql.execute(l_cursor_name);

3377: end if;
3378:
3379: --DBMS_SQL.BIND_VARIABLE(l_cursor_name, ':resource_id', 3807);
3380: DBMS_SQL.DEFINE_COLUMN(l_cursor_name, 1, l_count);
3381: l_rows_processed := dbms_sql.execute(l_cursor_name);
3382:
3383: IF (DBMS_SQL.FETCH_ROWS(l_cursor_name) > 0)
3384: THEN
3385: -- get column values of the row

Line 3383: IF (DBMS_SQL.FETCH_ROWS(l_cursor_name) > 0)

3379: --DBMS_SQL.BIND_VARIABLE(l_cursor_name, ':resource_id', 3807);
3380: DBMS_SQL.DEFINE_COLUMN(l_cursor_name, 1, l_count);
3381: l_rows_processed := dbms_sql.execute(l_cursor_name);
3382:
3383: IF (DBMS_SQL.FETCH_ROWS(l_cursor_name) > 0)
3384: THEN
3385: -- get column values of the row
3386: DBMS_SQL.COLUMN_VALUE(l_cursor_name, 1, l_count);
3387: END IF;

Line 3386: DBMS_SQL.COLUMN_VALUE(l_cursor_name, 1, l_count);

3382:
3383: IF (DBMS_SQL.FETCH_ROWS(l_cursor_name) > 0)
3384: THEN
3385: -- get column values of the row
3386: DBMS_SQL.COLUMN_VALUE(l_cursor_name, 1, l_count);
3387: END IF;
3388:
3389: DBMS_SQL.close_cursor(l_cursor_name);
3390:

Line 3389: DBMS_SQL.close_cursor(l_cursor_name);

3385: -- get column values of the row
3386: DBMS_SQL.COLUMN_VALUE(l_cursor_name, 1, l_count);
3387: END IF;
3388:
3389: DBMS_SQL.close_cursor(l_cursor_name);
3390:
3391: EXCEPTION
3392:
3393: WHEN OTHERS THEN

Line 3394: DBMS_SQL.CLOSE_CURSOR(l_cursor_name);

3390:
3391: EXCEPTION
3392:
3393: WHEN OTHERS THEN
3394: DBMS_SQL.CLOSE_CURSOR(l_cursor_name);
3395:
3396: END;
3397:
3398: END IF;

Line 3701: v_cursor := DBMS_SQL.OPEN_CURSOR;

3697: -- show log message IEU_UWQ_DEFTASKMAN_LAUNCH
3698: -- 3.1.1 successfully, show success message
3699: -- 3.1.2 failed, show error message IEU_UWQ_FUNCTION_NOT_ALLOWED
3700: -- 3.2 not 'TASK' object_code, show error message IEU_UWQ_ALL_NO_SOURCE_DOC
3701: v_cursor := DBMS_SQL.OPEN_CURSOR;
3702: DBMS_SQL.parse(v_cursor,
3703: 'SELECT unique object_function, name , APPLICATION_NAME
3704: FROM jtf_objects_vl
3705: WHERE lower(object_code) = lower(:action_code)',

Line 3702: DBMS_SQL.parse(v_cursor,

3698: -- 3.1.1 successfully, show success message
3699: -- 3.1.2 failed, show error message IEU_UWQ_FUNCTION_NOT_ALLOWED
3700: -- 3.2 not 'TASK' object_code, show error message IEU_UWQ_ALL_NO_SOURCE_DOC
3701: v_cursor := DBMS_SQL.OPEN_CURSOR;
3702: DBMS_SQL.parse(v_cursor,
3703: 'SELECT unique object_function, name , APPLICATION_NAME
3704: FROM jtf_objects_vl
3705: WHERE lower(object_code) = lower(:action_code)',
3706: DBMS_SQL.V7);

Line 3706: DBMS_SQL.V7);

3702: DBMS_SQL.parse(v_cursor,
3703: 'SELECT unique object_function, name , APPLICATION_NAME
3704: FROM jtf_objects_vl
3705: WHERE lower(object_code) = lower(:action_code)',
3706: DBMS_SQL.V7);
3707:
3708: DBMS_SQL.BIND_VARIABLE(v_cursor, 'action_code', p_object_code);
3709: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_object_function,60);
3710: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_name,30);

Line 3708: DBMS_SQL.BIND_VARIABLE(v_cursor, 'action_code', p_object_code);

3704: FROM jtf_objects_vl
3705: WHERE lower(object_code) = lower(:action_code)',
3706: DBMS_SQL.V7);
3707:
3708: DBMS_SQL.BIND_VARIABLE(v_cursor, 'action_code', p_object_code);
3709: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_object_function,60);
3710: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_name,30);
3711: DBMS_SQL.DEFINE_COLUMN(v_cursor, 3, l_application_name,30);
3712:

Line 3709: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_object_function,60);

3705: WHERE lower(object_code) = lower(:action_code)',
3706: DBMS_SQL.V7);
3707:
3708: DBMS_SQL.BIND_VARIABLE(v_cursor, 'action_code', p_object_code);
3709: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_object_function,60);
3710: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_name,30);
3711: DBMS_SQL.DEFINE_COLUMN(v_cursor, 3, l_application_name,30);
3712:
3713: v_numrows := DBMS_SQL.EXECUTE(v_cursor);

Line 3710: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_name,30);

3706: DBMS_SQL.V7);
3707:
3708: DBMS_SQL.BIND_VARIABLE(v_cursor, 'action_code', p_object_code);
3709: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_object_function,60);
3710: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_name,30);
3711: DBMS_SQL.DEFINE_COLUMN(v_cursor, 3, l_application_name,30);
3712:
3713: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
3714: --v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);

Line 3711: DBMS_SQL.DEFINE_COLUMN(v_cursor, 3, l_application_name,30);

3707:
3708: DBMS_SQL.BIND_VARIABLE(v_cursor, 'action_code', p_object_code);
3709: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_object_function,60);
3710: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_name,30);
3711: DBMS_SQL.DEFINE_COLUMN(v_cursor, 3, l_application_name,30);
3712:
3713: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
3714: --v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
3715:

Line 3713: v_numrows := DBMS_SQL.EXECUTE(v_cursor);

3709: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_object_function,60);
3710: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_name,30);
3711: DBMS_SQL.DEFINE_COLUMN(v_cursor, 3, l_application_name,30);
3712:
3713: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
3714: --v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
3715:
3716: LOOP
3717: if DBMS_SQL.FETCH_ROWS(v_cursor) = 0 then

Line 3714: --v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);

3710: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_name,30);
3711: DBMS_SQL.DEFINE_COLUMN(v_cursor, 3, l_application_name,30);
3712:
3713: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
3714: --v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
3715:
3716: LOOP
3717: if DBMS_SQL.FETCH_ROWS(v_cursor) = 0 then
3718: --DBMS_OUTPUT.Put_Line('end of rows');

Line 3717: if DBMS_SQL.FETCH_ROWS(v_cursor) = 0 then

3713: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
3714: --v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
3715:
3716: LOOP
3717: if DBMS_SQL.FETCH_ROWS(v_cursor) = 0 then
3718: --DBMS_OUTPUT.Put_Line('end of rows');
3719: exit;
3720: end if;
3721:

Line 3722: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_object_function);

3718: --DBMS_OUTPUT.Put_Line('end of rows');
3719: exit;
3720: end if;
3721:
3722: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_object_function);
3723: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_name);
3724: DBMS_SQL.COLUMN_VALUE(v_cursor, 3, l_application_name);
3725:
3726: IF (l_object_function IS null) THEN

Line 3723: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_name);

3719: exit;
3720: end if;
3721:
3722: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_object_function);
3723: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_name);
3724: DBMS_SQL.COLUMN_VALUE(v_cursor, 3, l_application_name);
3725:
3726: IF (l_object_function IS null) THEN
3727: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_LAU_LOG_NULL_OBJ_F');

Line 3724: DBMS_SQL.COLUMN_VALUE(v_cursor, 3, l_application_name);

3720: end if;
3721:
3722: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_object_function);
3723: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_name);
3724: DBMS_SQL.COLUMN_VALUE(v_cursor, 3, l_application_name);
3725:
3726: IF (l_object_function IS null) THEN
3727: FND_MESSAGE.set_name('IEU', 'IEU_DIAG_LAU_LOG_NULL_OBJ_F');
3728: x_log.extend;

Line 3778: DBMS_SQL.CLOSE_CURSOR(v_cursor);

3774: END if; -- object_code = 'TASK'
3775: END IF; -- if FND_FUNCTION.TEST
3776: END if; -- if object function is null
3777: end LOOP; -- select object function from view
3778: DBMS_SQL.CLOSE_CURSOR(v_cursor);
3779:
3780: --DBMS_OUTPUT.Put_Line('v_numrows is '|| v_numrows);
3781: --DBMS_OUTPUT.Put_Line('l_action_code is '|| l_action_code);
3782:

Line 3943: v_cursor3 := DBMS_SQL.OPEN_CURSOR;

3939:
3940: if (x_return_status = 'S') then -- object code and resp are valid
3941: -- check if the given inputs is
3942: -- registered in ieu_uwq_nonmedia_action
3943: v_cursor3 := DBMS_SQL.OPEN_CURSOR;
3944: DBMS_SQL.parse(v_cursor3,
3945: 'SELECT count(action_object_code)
3946: FROM ieu_uwq_nonmedia_actions
3947: WHERE lower(action_object_code) = lower(:action_code)

Line 3944: DBMS_SQL.parse(v_cursor3,

3940: if (x_return_status = 'S') then -- object code and resp are valid
3941: -- check if the given inputs is
3942: -- registered in ieu_uwq_nonmedia_action
3943: v_cursor3 := DBMS_SQL.OPEN_CURSOR;
3944: DBMS_SQL.parse(v_cursor3,
3945: 'SELECT count(action_object_code)
3946: FROM ieu_uwq_nonmedia_actions
3947: WHERE lower(action_object_code) = lower(:action_code)
3948: AND lower(source_for_task_flag) = lower(:flag)

Line 3950: DBMS_SQL.V7);

3946: FROM ieu_uwq_nonmedia_actions
3947: WHERE lower(action_object_code) = lower(:action_code)
3948: AND lower(source_for_task_flag) = lower(:flag)
3949: AND nvl(responsibility_id, -1) IN (-1, :resp) ',
3950: DBMS_SQL.V7);
3951:
3952: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'action_code', p_object_code);
3953: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'flag', p_task_source);
3954: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'resp', l_responsibility_id);

Line 3952: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'action_code', p_object_code);

3948: AND lower(source_for_task_flag) = lower(:flag)
3949: AND nvl(responsibility_id, -1) IN (-1, :resp) ',
3950: DBMS_SQL.V7);
3951:
3952: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'action_code', p_object_code);
3953: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'flag', p_task_source);
3954: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'resp', l_responsibility_id);
3955: DBMS_SQL.DEFINE_COLUMN(v_cursor3, 1, l_count);
3956: v_numrows := DBMS_SQL.EXECUTE_AND_FETCH(v_cursor3);

Line 3953: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'flag', p_task_source);

3949: AND nvl(responsibility_id, -1) IN (-1, :resp) ',
3950: DBMS_SQL.V7);
3951:
3952: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'action_code', p_object_code);
3953: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'flag', p_task_source);
3954: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'resp', l_responsibility_id);
3955: DBMS_SQL.DEFINE_COLUMN(v_cursor3, 1, l_count);
3956: v_numrows := DBMS_SQL.EXECUTE_AND_FETCH(v_cursor3);
3957: DBMS_SQL.COLUMN_VALUE(v_cursor3, 1, l_count);

Line 3954: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'resp', l_responsibility_id);

3950: DBMS_SQL.V7);
3951:
3952: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'action_code', p_object_code);
3953: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'flag', p_task_source);
3954: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'resp', l_responsibility_id);
3955: DBMS_SQL.DEFINE_COLUMN(v_cursor3, 1, l_count);
3956: v_numrows := DBMS_SQL.EXECUTE_AND_FETCH(v_cursor3);
3957: DBMS_SQL.COLUMN_VALUE(v_cursor3, 1, l_count);
3958: DBMS_SQL.CLOSE_CURSOR(v_cursor3);

Line 3955: DBMS_SQL.DEFINE_COLUMN(v_cursor3, 1, l_count);

3951:
3952: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'action_code', p_object_code);
3953: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'flag', p_task_source);
3954: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'resp', l_responsibility_id);
3955: DBMS_SQL.DEFINE_COLUMN(v_cursor3, 1, l_count);
3956: v_numrows := DBMS_SQL.EXECUTE_AND_FETCH(v_cursor3);
3957: DBMS_SQL.COLUMN_VALUE(v_cursor3, 1, l_count);
3958: DBMS_SQL.CLOSE_CURSOR(v_cursor3);
3959: -- DBMS_OUTPUT.Put_Line('count(action_object_code) in ieu_uwq_nonmedia_actions is ' || l_count);

Line 3956: v_numrows := DBMS_SQL.EXECUTE_AND_FETCH(v_cursor3);

3952: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'action_code', p_object_code);
3953: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'flag', p_task_source);
3954: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'resp', l_responsibility_id);
3955: DBMS_SQL.DEFINE_COLUMN(v_cursor3, 1, l_count);
3956: v_numrows := DBMS_SQL.EXECUTE_AND_FETCH(v_cursor3);
3957: DBMS_SQL.COLUMN_VALUE(v_cursor3, 1, l_count);
3958: DBMS_SQL.CLOSE_CURSOR(v_cursor3);
3959: -- DBMS_OUTPUT.Put_Line('count(action_object_code) in ieu_uwq_nonmedia_actions is ' || l_count);
3960: EXECUTE immediate ' select NAME , application_name'||

Line 3957: DBMS_SQL.COLUMN_VALUE(v_cursor3, 1, l_count);

3953: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'flag', p_task_source);
3954: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'resp', l_responsibility_id);
3955: DBMS_SQL.DEFINE_COLUMN(v_cursor3, 1, l_count);
3956: v_numrows := DBMS_SQL.EXECUTE_AND_FETCH(v_cursor3);
3957: DBMS_SQL.COLUMN_VALUE(v_cursor3, 1, l_count);
3958: DBMS_SQL.CLOSE_CURSOR(v_cursor3);
3959: -- DBMS_OUTPUT.Put_Line('count(action_object_code) in ieu_uwq_nonmedia_actions is ' || l_count);
3960: EXECUTE immediate ' select NAME , application_name'||
3961: ' from jtf_objects_vl '||

Line 3958: DBMS_SQL.CLOSE_CURSOR(v_cursor3);

3954: DBMS_SQL.BIND_VARIABLE(v_cursor3, 'resp', l_responsibility_id);
3955: DBMS_SQL.DEFINE_COLUMN(v_cursor3, 1, l_count);
3956: v_numrows := DBMS_SQL.EXECUTE_AND_FETCH(v_cursor3);
3957: DBMS_SQL.COLUMN_VALUE(v_cursor3, 1, l_count);
3958: DBMS_SQL.CLOSE_CURSOR(v_cursor3);
3959: -- DBMS_OUTPUT.Put_Line('count(action_object_code) in ieu_uwq_nonmedia_actions is ' || l_count);
3960: EXECUTE immediate ' select NAME , application_name'||
3961: ' from jtf_objects_vl '||
3962: ' where lower(OBJECT_CODE) = lower(:1) '