APPS.EGO_ITEM_COMPARE_PKG dependencies on DBMS_SQL

Line 383: l_dyn_cur INTEGER := DBMS_SQL.OPEN_CURSOR;

379: ,p_organization_id IN VARCHAR2
380: ,p_attr_name IN VARCHAR2
381: ) RETURN VARCHAR2 IS
382:
383: l_dyn_cur INTEGER := DBMS_SQL.OPEN_CURSOR;
384:
385: --Assumption: All the 'Main' attributes to be displayed are not more than
386: --1000 chars. Long Description is of 4000 char length, but actual value
387: --populated is lesser length than that.

Line 411: DBMS_SQL.CLOSE_CURSOR(l_dyn_cur);

407: IF (p_inventory_item_id = '-1' OR p_organization_id = '-1') THEN
408:
409: l_item_attr_val := 'NULL';
410: --For BUG 3321433
411: DBMS_SQL.CLOSE_CURSOR(l_dyn_cur);
412:
413: ELSE
414:
415: l_db_column := Substr(p_attr_name, Instr(p_attr_name,'.')+1);

Line 429: DBMS_SQL.PARSE(l_dyn_cur, l_dyn_sql, DBMS_SQL.NATIVE);

425: l_dyn_sql := l_dyn_sql || ' AND ORGANIZATION_ID = :ORGANIZATION_ID ';
426:
427: --log_debug('l_dyn_sql - '||l_dyn_sql);
428:
429: DBMS_SQL.PARSE(l_dyn_cur, l_dyn_sql, DBMS_SQL.NATIVE);
430:
431: DBMS_SQL.DEFINE_COLUMN (l_dyn_cur, 1, l_item_attr_val, 1000);
432:
433: DBMS_SQL.BIND_VARIABLE(l_dyn_cur,':INVENTORY_ITEM_ID', p_inventory_item_id);

Line 431: DBMS_SQL.DEFINE_COLUMN (l_dyn_cur, 1, l_item_attr_val, 1000);

427: --log_debug('l_dyn_sql - '||l_dyn_sql);
428:
429: DBMS_SQL.PARSE(l_dyn_cur, l_dyn_sql, DBMS_SQL.NATIVE);
430:
431: DBMS_SQL.DEFINE_COLUMN (l_dyn_cur, 1, l_item_attr_val, 1000);
432:
433: DBMS_SQL.BIND_VARIABLE(l_dyn_cur,':INVENTORY_ITEM_ID', p_inventory_item_id);
434: DBMS_SQL.BIND_VARIABLE(l_dyn_cur,':ORGANIZATION_ID', p_organization_id);
435:

Line 433: DBMS_SQL.BIND_VARIABLE(l_dyn_cur,':INVENTORY_ITEM_ID', p_inventory_item_id);

429: DBMS_SQL.PARSE(l_dyn_cur, l_dyn_sql, DBMS_SQL.NATIVE);
430:
431: DBMS_SQL.DEFINE_COLUMN (l_dyn_cur, 1, l_item_attr_val, 1000);
432:
433: DBMS_SQL.BIND_VARIABLE(l_dyn_cur,':INVENTORY_ITEM_ID', p_inventory_item_id);
434: DBMS_SQL.BIND_VARIABLE(l_dyn_cur,':ORGANIZATION_ID', p_organization_id);
435:
436: l_exec_val := DBMS_SQL.EXECUTE_AND_FETCH(l_dyn_cur);
437:

Line 434: DBMS_SQL.BIND_VARIABLE(l_dyn_cur,':ORGANIZATION_ID', p_organization_id);

430:
431: DBMS_SQL.DEFINE_COLUMN (l_dyn_cur, 1, l_item_attr_val, 1000);
432:
433: DBMS_SQL.BIND_VARIABLE(l_dyn_cur,':INVENTORY_ITEM_ID', p_inventory_item_id);
434: DBMS_SQL.BIND_VARIABLE(l_dyn_cur,':ORGANIZATION_ID', p_organization_id);
435:
436: l_exec_val := DBMS_SQL.EXECUTE_AND_FETCH(l_dyn_cur);
437:
438: DBMS_SQL.COLUMN_VALUE(l_dyn_cur, 1, l_item_attr_val);

Line 436: l_exec_val := DBMS_SQL.EXECUTE_AND_FETCH(l_dyn_cur);

432:
433: DBMS_SQL.BIND_VARIABLE(l_dyn_cur,':INVENTORY_ITEM_ID', p_inventory_item_id);
434: DBMS_SQL.BIND_VARIABLE(l_dyn_cur,':ORGANIZATION_ID', p_organization_id);
435:
436: l_exec_val := DBMS_SQL.EXECUTE_AND_FETCH(l_dyn_cur);
437:
438: DBMS_SQL.COLUMN_VALUE(l_dyn_cur, 1, l_item_attr_val);
439:
440: DBMS_SQL.CLOSE_CURSOR(l_dyn_cur);

Line 438: DBMS_SQL.COLUMN_VALUE(l_dyn_cur, 1, l_item_attr_val);

434: DBMS_SQL.BIND_VARIABLE(l_dyn_cur,':ORGANIZATION_ID', p_organization_id);
435:
436: l_exec_val := DBMS_SQL.EXECUTE_AND_FETCH(l_dyn_cur);
437:
438: DBMS_SQL.COLUMN_VALUE(l_dyn_cur, 1, l_item_attr_val);
439:
440: DBMS_SQL.CLOSE_CURSOR(l_dyn_cur);
441: --log_debug('OK '||l_exec_val);
442: --log_debug('l_item_attr_val : '||l_item_attr_val);

Line 440: DBMS_SQL.CLOSE_CURSOR(l_dyn_cur);

436: l_exec_val := DBMS_SQL.EXECUTE_AND_FETCH(l_dyn_cur);
437:
438: DBMS_SQL.COLUMN_VALUE(l_dyn_cur, 1, l_item_attr_val);
439:
440: DBMS_SQL.CLOSE_CURSOR(l_dyn_cur);
441: --log_debug('OK '||l_exec_val);
442: --log_debug('l_item_attr_val : '||l_item_attr_val);
443:
444: --For specific columns, code to meaning translations are needed.

Line 489: DBMS_SQL.CLOSE_CURSOR(l_dyn_cur);

485:
486: RETURN l_item_attr_val;
487: --For Bug 3321433
488: EXCEPTION when others then
489: DBMS_SQL.CLOSE_CURSOR(l_dyn_cur);
490: RETURN l_item_attr_val;
491: END Get_Item_Attr_Val;
492:
493: --------------------------------------------------------------------------