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.WIP_WS_SKILL_CHECK_PVT dependencies on DBMS_SQL

Line 332: l_cursor := dbms_sql.open_cursor;

328: ' where organization_id = :1 '||
329: ' and wip_entity_id = :2 '||
330: l_add_where_clause;
331:
332: l_cursor := dbms_sql.open_cursor;
333: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
334: dbms_sql.define_column(l_cursor, 1, l_op_seq_num);
335: dbms_sql.define_column(l_cursor, 2, l_check_skill);
336: dbms_sql.bind_variable(l_cursor, ':1', p_organization_id);

Line 333: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);

329: ' and wip_entity_id = :2 '||
330: l_add_where_clause;
331:
332: l_cursor := dbms_sql.open_cursor;
333: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
334: dbms_sql.define_column(l_cursor, 1, l_op_seq_num);
335: dbms_sql.define_column(l_cursor, 2, l_check_skill);
336: dbms_sql.bind_variable(l_cursor, ':1', p_organization_id);
337: dbms_sql.bind_variable(l_cursor, ':2', p_wip_entity_id);

Line 334: dbms_sql.define_column(l_cursor, 1, l_op_seq_num);

330: l_add_where_clause;
331:
332: l_cursor := dbms_sql.open_cursor;
333: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
334: dbms_sql.define_column(l_cursor, 1, l_op_seq_num);
335: dbms_sql.define_column(l_cursor, 2, l_check_skill);
336: dbms_sql.bind_variable(l_cursor, ':1', p_organization_id);
337: dbms_sql.bind_variable(l_cursor, ':2', p_wip_entity_id);
338: dbms_sql.bind_variable(l_cursor, ':3', l_from_op);

Line 335: dbms_sql.define_column(l_cursor, 2, l_check_skill);

331:
332: l_cursor := dbms_sql.open_cursor;
333: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
334: dbms_sql.define_column(l_cursor, 1, l_op_seq_num);
335: dbms_sql.define_column(l_cursor, 2, l_check_skill);
336: dbms_sql.bind_variable(l_cursor, ':1', p_organization_id);
337: dbms_sql.bind_variable(l_cursor, ':2', p_wip_entity_id);
338: dbms_sql.bind_variable(l_cursor, ':3', l_from_op);
339: dbms_sql.bind_variable(l_cursor, ':4', l_to_op);

Line 336: dbms_sql.bind_variable(l_cursor, ':1', p_organization_id);

332: l_cursor := dbms_sql.open_cursor;
333: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
334: dbms_sql.define_column(l_cursor, 1, l_op_seq_num);
335: dbms_sql.define_column(l_cursor, 2, l_check_skill);
336: dbms_sql.bind_variable(l_cursor, ':1', p_organization_id);
337: dbms_sql.bind_variable(l_cursor, ':2', p_wip_entity_id);
338: dbms_sql.bind_variable(l_cursor, ':3', l_from_op);
339: dbms_sql.bind_variable(l_cursor, ':4', l_to_op);
340: l_sql_exec := dbms_sql.execute(l_cursor);

Line 337: dbms_sql.bind_variable(l_cursor, ':2', p_wip_entity_id);

333: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
334: dbms_sql.define_column(l_cursor, 1, l_op_seq_num);
335: dbms_sql.define_column(l_cursor, 2, l_check_skill);
336: dbms_sql.bind_variable(l_cursor, ':1', p_organization_id);
337: dbms_sql.bind_variable(l_cursor, ':2', p_wip_entity_id);
338: dbms_sql.bind_variable(l_cursor, ':3', l_from_op);
339: dbms_sql.bind_variable(l_cursor, ':4', l_to_op);
340: l_sql_exec := dbms_sql.execute(l_cursor);
341:

Line 338: dbms_sql.bind_variable(l_cursor, ':3', l_from_op);

334: dbms_sql.define_column(l_cursor, 1, l_op_seq_num);
335: dbms_sql.define_column(l_cursor, 2, l_check_skill);
336: dbms_sql.bind_variable(l_cursor, ':1', p_organization_id);
337: dbms_sql.bind_variable(l_cursor, ':2', p_wip_entity_id);
338: dbms_sql.bind_variable(l_cursor, ':3', l_from_op);
339: dbms_sql.bind_variable(l_cursor, ':4', l_to_op);
340: l_sql_exec := dbms_sql.execute(l_cursor);
341:
342: loop

Line 339: dbms_sql.bind_variable(l_cursor, ':4', l_to_op);

335: dbms_sql.define_column(l_cursor, 2, l_check_skill);
336: dbms_sql.bind_variable(l_cursor, ':1', p_organization_id);
337: dbms_sql.bind_variable(l_cursor, ':2', p_wip_entity_id);
338: dbms_sql.bind_variable(l_cursor, ':3', l_from_op);
339: dbms_sql.bind_variable(l_cursor, ':4', l_to_op);
340: l_sql_exec := dbms_sql.execute(l_cursor);
341:
342: loop
343: exit when dbms_sql.fetch_rows(l_cursor) = 0 OR l_validate_skill <> G_SKILL_VALIDATION_SUCCESS;

Line 340: l_sql_exec := dbms_sql.execute(l_cursor);

336: dbms_sql.bind_variable(l_cursor, ':1', p_organization_id);
337: dbms_sql.bind_variable(l_cursor, ':2', p_wip_entity_id);
338: dbms_sql.bind_variable(l_cursor, ':3', l_from_op);
339: dbms_sql.bind_variable(l_cursor, ':4', l_to_op);
340: l_sql_exec := dbms_sql.execute(l_cursor);
341:
342: loop
343: exit when dbms_sql.fetch_rows(l_cursor) = 0 OR l_validate_skill <> G_SKILL_VALIDATION_SUCCESS;
344: dbms_sql.column_value(l_cursor, 1, l_op_seq_num);

Line 343: exit when dbms_sql.fetch_rows(l_cursor) = 0 OR l_validate_skill <> G_SKILL_VALIDATION_SUCCESS;

339: dbms_sql.bind_variable(l_cursor, ':4', l_to_op);
340: l_sql_exec := dbms_sql.execute(l_cursor);
341:
342: loop
343: exit when dbms_sql.fetch_rows(l_cursor) = 0 OR l_validate_skill <> G_SKILL_VALIDATION_SUCCESS;
344: dbms_sql.column_value(l_cursor, 1, l_op_seq_num);
345: dbms_sql.column_value(l_cursor, 2, l_check_skill);
346: if l_check_skill=G_SKILL_CHECK_ENABLED then
347: l_validate_skill := validate_skill_for_move_ops(p_wip_entity_id => p_wip_entity_id,

Line 344: dbms_sql.column_value(l_cursor, 1, l_op_seq_num);

340: l_sql_exec := dbms_sql.execute(l_cursor);
341:
342: loop
343: exit when dbms_sql.fetch_rows(l_cursor) = 0 OR l_validate_skill <> G_SKILL_VALIDATION_SUCCESS;
344: dbms_sql.column_value(l_cursor, 1, l_op_seq_num);
345: dbms_sql.column_value(l_cursor, 2, l_check_skill);
346: if l_check_skill=G_SKILL_CHECK_ENABLED then
347: l_validate_skill := validate_skill_for_move_ops(p_wip_entity_id => p_wip_entity_id,
348: p_organization_id => p_organization_id,

Line 345: dbms_sql.column_value(l_cursor, 2, l_check_skill);

341:
342: loop
343: exit when dbms_sql.fetch_rows(l_cursor) = 0 OR l_validate_skill <> G_SKILL_VALIDATION_SUCCESS;
344: dbms_sql.column_value(l_cursor, 1, l_op_seq_num);
345: dbms_sql.column_value(l_cursor, 2, l_check_skill);
346: if l_check_skill=G_SKILL_CHECK_ENABLED then
347: l_validate_skill := validate_skill_for_move_ops(p_wip_entity_id => p_wip_entity_id,
348: p_organization_id => p_organization_id,
349: p_operation => l_op_seq_num,

Line 354: dbms_sql.close_cursor(l_cursor);

350: p_emp_id => p_emp_id);
351: end if;
352:
353: end loop;
354: dbms_sql.close_cursor(l_cursor);
355: end if;
356: if l_validate_skill <> G_SKILL_VALIDATION_SUCCESS then
357: if p_wip_entity_id is not null and p_emp_id is not null then
358: set_message_context(p_wip_entity_id,p_emp_id);