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

Line 5319: bind_node_id DBMS_SQL.NUMBER_TABLE;

5315: v_stack_start PLS_INTEGER;
5316: v_stack_end PLS_INTEGER;
5317: v_value_exists PLS_INTEGER := 0;
5318:
5319: bind_node_id DBMS_SQL.NUMBER_TABLE;
5320: bind_node_id_ex DBMS_SQL.NUMBER_TABLE;
5321: bind_node_type DBMS_SQL.NUMBER_TABLE;
5322: bind_node_value DBMS_SQL.VARCHAR2_TABLE;
5323: bind_node_obj DBMS_SQL.VARCHAR2_TABLE;

Line 5320: bind_node_id_ex DBMS_SQL.NUMBER_TABLE;

5316: v_stack_end PLS_INTEGER;
5317: v_value_exists PLS_INTEGER := 0;
5318:
5319: bind_node_id DBMS_SQL.NUMBER_TABLE;
5320: bind_node_id_ex DBMS_SQL.NUMBER_TABLE;
5321: bind_node_type DBMS_SQL.NUMBER_TABLE;
5322: bind_node_value DBMS_SQL.VARCHAR2_TABLE;
5323: bind_node_obj DBMS_SQL.VARCHAR2_TABLE;
5324:

Line 5321: bind_node_type DBMS_SQL.NUMBER_TABLE;

5317: v_value_exists PLS_INTEGER := 0;
5318:
5319: bind_node_id DBMS_SQL.NUMBER_TABLE;
5320: bind_node_id_ex DBMS_SQL.NUMBER_TABLE;
5321: bind_node_type DBMS_SQL.NUMBER_TABLE;
5322: bind_node_value DBMS_SQL.VARCHAR2_TABLE;
5323: bind_node_obj DBMS_SQL.VARCHAR2_TABLE;
5324:
5325: TYPE bind_value_table IS TABLE OF DBMS_SQL.VARCHAR2_TABLE INDEX BY BINARY_INTEGER;

Line 5322: bind_node_value DBMS_SQL.VARCHAR2_TABLE;

5318:
5319: bind_node_id DBMS_SQL.NUMBER_TABLE;
5320: bind_node_id_ex DBMS_SQL.NUMBER_TABLE;
5321: bind_node_type DBMS_SQL.NUMBER_TABLE;
5322: bind_node_value DBMS_SQL.VARCHAR2_TABLE;
5323: bind_node_obj DBMS_SQL.VARCHAR2_TABLE;
5324:
5325: TYPE bind_value_table IS TABLE OF DBMS_SQL.VARCHAR2_TABLE INDEX BY BINARY_INTEGER;
5326: bind_values bind_value_table;

Line 5323: bind_node_obj DBMS_SQL.VARCHAR2_TABLE;

5319: bind_node_id DBMS_SQL.NUMBER_TABLE;
5320: bind_node_id_ex DBMS_SQL.NUMBER_TABLE;
5321: bind_node_type DBMS_SQL.NUMBER_TABLE;
5322: bind_node_value DBMS_SQL.VARCHAR2_TABLE;
5323: bind_node_obj DBMS_SQL.VARCHAR2_TABLE;
5324:
5325: TYPE bind_value_table IS TABLE OF DBMS_SQL.VARCHAR2_TABLE INDEX BY BINARY_INTEGER;
5326: bind_values bind_value_table;
5327: arg_table_name temp_table_hash_type;

Line 5325: TYPE bind_value_table IS TABLE OF DBMS_SQL.VARCHAR2_TABLE INDEX BY BINARY_INTEGER;

5321: bind_node_type DBMS_SQL.NUMBER_TABLE;
5322: bind_node_value DBMS_SQL.VARCHAR2_TABLE;
5323: bind_node_obj DBMS_SQL.VARCHAR2_TABLE;
5324:
5325: TYPE bind_value_table IS TABLE OF DBMS_SQL.VARCHAR2_TABLE INDEX BY BINARY_INTEGER;
5326: bind_values bind_value_table;
5327: arg_table_name temp_table_hash_type;
5328: hash_propval_key VARCHAR2(4000);
5329: ---------------------------------------------------------------------------------------

Line 5784: v_cursor := DBMS_SQL.OPEN_CURSOR;

5780: END LOOP;
5781:
5782: nDebug := 7004106;
5783:
5784: v_cursor := DBMS_SQL.OPEN_CURSOR;
5785: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);
5786:
5787: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_type);
5788: DBMS_SQL.BIND_ARRAY(v_cursor, ':y2', bind_node_id);

Line 5785: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);

5781:
5782: nDebug := 7004106;
5783:
5784: v_cursor := DBMS_SQL.OPEN_CURSOR;
5785: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);
5786:
5787: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_type);
5788: DBMS_SQL.BIND_ARRAY(v_cursor, ':y2', bind_node_id);
5789: DBMS_SQL.BIND_ARRAY(v_cursor, ':y3', bind_node_value);

Line 5787: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_type);

5783:
5784: v_cursor := DBMS_SQL.OPEN_CURSOR;
5785: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);
5786:
5787: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_type);
5788: DBMS_SQL.BIND_ARRAY(v_cursor, ':y2', bind_node_id);
5789: DBMS_SQL.BIND_ARRAY(v_cursor, ':y3', bind_node_value);
5790: DBMS_SQL.BIND_ARRAY(v_cursor, ':y4', bind_node_obj);
5791: DBMS_SQL.BIND_ARRAY(v_cursor, ':y5', bind_node_id_ex);

Line 5788: DBMS_SQL.BIND_ARRAY(v_cursor, ':y2', bind_node_id);

5784: v_cursor := DBMS_SQL.OPEN_CURSOR;
5785: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);
5786:
5787: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_type);
5788: DBMS_SQL.BIND_ARRAY(v_cursor, ':y2', bind_node_id);
5789: DBMS_SQL.BIND_ARRAY(v_cursor, ':y3', bind_node_value);
5790: DBMS_SQL.BIND_ARRAY(v_cursor, ':y4', bind_node_obj);
5791: DBMS_SQL.BIND_ARRAY(v_cursor, ':y5', bind_node_id_ex);
5792:

Line 5789: DBMS_SQL.BIND_ARRAY(v_cursor, ':y3', bind_node_value);

5785: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);
5786:
5787: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_type);
5788: DBMS_SQL.BIND_ARRAY(v_cursor, ':y2', bind_node_id);
5789: DBMS_SQL.BIND_ARRAY(v_cursor, ':y3', bind_node_value);
5790: DBMS_SQL.BIND_ARRAY(v_cursor, ':y4', bind_node_obj);
5791: DBMS_SQL.BIND_ARRAY(v_cursor, ':y5', bind_node_id_ex);
5792:
5793: FOR ii IN 1..v_property_id.COUNT LOOP

Line 5790: DBMS_SQL.BIND_ARRAY(v_cursor, ':y4', bind_node_obj);

5786:
5787: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_type);
5788: DBMS_SQL.BIND_ARRAY(v_cursor, ':y2', bind_node_id);
5789: DBMS_SQL.BIND_ARRAY(v_cursor, ':y3', bind_node_value);
5790: DBMS_SQL.BIND_ARRAY(v_cursor, ':y4', bind_node_obj);
5791: DBMS_SQL.BIND_ARRAY(v_cursor, ':y5', bind_node_id_ex);
5792:
5793: FOR ii IN 1..v_property_id.COUNT LOOP
5794: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));

Line 5791: DBMS_SQL.BIND_ARRAY(v_cursor, ':y5', bind_node_id_ex);

5787: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_type);
5788: DBMS_SQL.BIND_ARRAY(v_cursor, ':y2', bind_node_id);
5789: DBMS_SQL.BIND_ARRAY(v_cursor, ':y3', bind_node_value);
5790: DBMS_SQL.BIND_ARRAY(v_cursor, ':y4', bind_node_obj);
5791: DBMS_SQL.BIND_ARRAY(v_cursor, ':y5', bind_node_id_ex);
5792:
5793: FOR ii IN 1..v_property_id.COUNT LOOP
5794: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));
5795: END LOOP;

Line 5794: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));

5790: DBMS_SQL.BIND_ARRAY(v_cursor, ':y4', bind_node_obj);
5791: DBMS_SQL.BIND_ARRAY(v_cursor, ':y5', bind_node_id_ex);
5792:
5793: FOR ii IN 1..v_property_id.COUNT LOOP
5794: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));
5795: END LOOP;
5796:
5797: localNumber := DBMS_SQL.EXECUTE(v_cursor);
5798: DBMS_SQL.CLOSE_CURSOR(v_cursor);

Line 5797: localNumber := DBMS_SQL.EXECUTE(v_cursor);

5793: FOR ii IN 1..v_property_id.COUNT LOOP
5794: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));
5795: END LOOP;
5796:
5797: localNumber := DBMS_SQL.EXECUTE(v_cursor);
5798: DBMS_SQL.CLOSE_CURSOR(v_cursor);
5799:
5800: nDebug := 7004107;
5801:

Line 5798: DBMS_SQL.CLOSE_CURSOR(v_cursor);

5794: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));
5795: END LOOP;
5796:
5797: localNumber := DBMS_SQL.EXECUTE(v_cursor);
5798: DBMS_SQL.CLOSE_CURSOR(v_cursor);
5799:
5800: nDebug := 7004107;
5801:
5802: EXECUTE IMMEDIATE 'ANALYZE TABLE ' || tableName || ' COMPUTE STATISTICS';

Line 5821: v_cursor := DBMS_SQL.OPEN_CURSOR;

5817:
5818: SQLWhere := ' WHERE ' || EXAMINE_WHERE_CLAUSE(v_ChildrenIndex(v_tExprId(whereIndex)));
5819: END IF;
5820:
5821: v_cursor := DBMS_SQL.OPEN_CURSOR;
5822: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
5823:
5824: FOR i IN 1..bindValue.COUNT LOOP
5825: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));

Line 5822: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);

5818: SQLWhere := ' WHERE ' || EXAMINE_WHERE_CLAUSE(v_ChildrenIndex(v_tExprId(whereIndex)));
5819: END IF;
5820:
5821: v_cursor := DBMS_SQL.OPEN_CURSOR;
5822: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
5823:
5824: FOR i IN 1..bindValue.COUNT LOOP
5825: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));
5826: END LOOP;

Line 5825: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));

5821: v_cursor := DBMS_SQL.OPEN_CURSOR;
5822: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
5823:
5824: FOR i IN 1..bindValue.COUNT LOOP
5825: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));
5826: END LOOP;
5827:
5828: FOR i IN 1..iteratorIndex.COUNT LOOP
5829:

Line 5830: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 1, localNumber);

5826: END LOOP;
5827:
5828: FOR i IN 1..iteratorIndex.COUNT LOOP
5829:
5830: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 1, localNumber);
5831: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 2, localNumber);
5832: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 3, localString, 2000);
5833: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 4, localString, 2000);
5834: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 5, localNumber);

Line 5831: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 2, localNumber);

5827:
5828: FOR i IN 1..iteratorIndex.COUNT LOOP
5829:
5830: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 1, localNumber);
5831: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 2, localNumber);
5832: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 3, localString, 2000);
5833: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 4, localString, 2000);
5834: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 5, localNumber);
5835: END LOOP;

Line 5832: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 3, localString, 2000);

5828: FOR i IN 1..iteratorIndex.COUNT LOOP
5829:
5830: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 1, localNumber);
5831: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 2, localNumber);
5832: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 3, localString, 2000);
5833: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 4, localString, 2000);
5834: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 5, localNumber);
5835: END LOOP;
5836:

Line 5833: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 4, localString, 2000);

5829:
5830: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 1, localNumber);
5831: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 2, localNumber);
5832: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 3, localString, 2000);
5833: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 4, localString, 2000);
5834: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 5, localNumber);
5835: END LOOP;
5836:
5837: nDebug := 7004109;

Line 5834: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 5, localNumber);

5830: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 1, localNumber);
5831: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 2, localNumber);
5832: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 3, localString, 2000);
5833: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 4, localString, 2000);
5834: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 5, localNumber);
5835: END LOOP;
5836:
5837: nDebug := 7004109;
5838:

Line 5839: localNumber := DBMS_SQL.EXECUTE(v_cursor);

5835: END LOOP;
5836:
5837: nDebug := 7004109;
5838:
5839: localNumber := DBMS_SQL.EXECUTE(v_cursor);
5840:
5841: --For every returned row, store the values in the parameter scope, from where GENERATE_EXPRESSION
5842: --will be retrieving it when generating an argument.
5843:

Line 5849: WHILE(DBMS_SQL.FETCH_ROWS(v_cursor) > 0)LOOP

5845:
5846: parameterName(v_stack_start + i - 1) := v_tExprArgumentName(iteratorIndex(i));
5847: END LOOP;
5848:
5849: WHILE(DBMS_SQL.FETCH_ROWS(v_cursor) > 0)LOOP
5850:
5851: FOR i IN 1..iteratorIndex.COUNT LOOP
5852:
5853: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 1, parameterScope(v_stack_start + i - 1).node_type);

Line 5853: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 1, parameterScope(v_stack_start + i - 1).node_type);

5849: WHILE(DBMS_SQL.FETCH_ROWS(v_cursor) > 0)LOOP
5850:
5851: FOR i IN 1..iteratorIndex.COUNT LOOP
5852:
5853: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 1, parameterScope(v_stack_start + i - 1).node_type);
5854: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 2, parameterScope(v_stack_start + i - 1).node_id);
5855: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 3, parameterScope(v_stack_start + i - 1).node_value);
5856: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 4, parameterScope(v_stack_start + i - 1).node_obj);
5857: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 5, parameterScope(v_stack_start + i - 1).node_id_ex);

Line 5854: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 2, parameterScope(v_stack_start + i - 1).node_id);

5850:
5851: FOR i IN 1..iteratorIndex.COUNT LOOP
5852:
5853: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 1, parameterScope(v_stack_start + i - 1).node_type);
5854: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 2, parameterScope(v_stack_start + i - 1).node_id);
5855: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 3, parameterScope(v_stack_start + i - 1).node_value);
5856: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 4, parameterScope(v_stack_start + i - 1).node_obj);
5857: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 5, parameterScope(v_stack_start + i - 1).node_id_ex);
5858: END LOOP;

Line 5855: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 3, parameterScope(v_stack_start + i - 1).node_value);

5851: FOR i IN 1..iteratorIndex.COUNT LOOP
5852:
5853: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 1, parameterScope(v_stack_start + i - 1).node_type);
5854: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 2, parameterScope(v_stack_start + i - 1).node_id);
5855: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 3, parameterScope(v_stack_start + i - 1).node_value);
5856: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 4, parameterScope(v_stack_start + i - 1).node_obj);
5857: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 5, parameterScope(v_stack_start + i - 1).node_id_ex);
5858: END LOOP;
5859:

Line 5856: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 4, parameterScope(v_stack_start + i - 1).node_obj);

5852:
5853: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 1, parameterScope(v_stack_start + i - 1).node_type);
5854: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 2, parameterScope(v_stack_start + i - 1).node_id);
5855: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 3, parameterScope(v_stack_start + i - 1).node_value);
5856: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 4, parameterScope(v_stack_start + i - 1).node_obj);
5857: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 5, parameterScope(v_stack_start + i - 1).node_id_ex);
5858: END LOOP;
5859:
5860: IF(expressionIndex <> 0 AND v_ChildrenIndex.EXISTS(v_tExprId(expressionIndex)))THEN

Line 5857: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 5, parameterScope(v_stack_start + i - 1).node_id_ex);

5853: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 1, parameterScope(v_stack_start + i - 1).node_type);
5854: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 2, parameterScope(v_stack_start + i - 1).node_id);
5855: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 3, parameterScope(v_stack_start + i - 1).node_value);
5856: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 4, parameterScope(v_stack_start + i - 1).node_obj);
5857: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 5, parameterScope(v_stack_start + i - 1).node_id_ex);
5858: END LOOP;
5859:
5860: IF(expressionIndex <> 0 AND v_ChildrenIndex.EXISTS(v_tExprId(expressionIndex)))THEN
5861:

Line 5921: DBMS_SQL.CLOSE_CURSOR(v_cursor);

5917: parameterName.DELETE(v_stack_start, v_stack_end);
5918:
5919: nDebug := 7004110;
5920:
5921: DBMS_SQL.CLOSE_CURSOR(v_cursor);
5922:
5923: IF(v_tExprParentId(j) IS NOT NULL AND v_return.COUNT = 0)THEN
5924:
5925: --The FORALL or COLLECT did not yield any rows while it is not the root operator.

Line 5979: v_tOptionId DBMS_SQL.NUMBER_TABLE;

5975: localNumber NUMBER;
5976: localString VARCHAR2(4000);
5977: bindValue tStringArray;
5978: typeCheck NUMBER;
5979: v_tOptionId DBMS_SQL.NUMBER_TABLE;
5980: v_tFeatureId tExplNodeId;
5981: v_BackIndex tIntegerArray;
5982: v_tExplId tExplNodeId;
5983: rowThreshold PLS_INTEGER := 0;

Line 5997: bind_node_id DBMS_SQL.NUMBER_TABLE;

5993: v_ItemLines tStringArray;
5994: ExcludesRequired PLS_INTEGER;
5995: v_flag tIntegerArray;
5996:
5997: bind_node_id DBMS_SQL.NUMBER_TABLE;
5998:
5999: TYPE bind_value_table IS TABLE OF DBMS_SQL.VARCHAR2_TABLE INDEX BY BINARY_INTEGER;
6000: bind_values bind_value_table;
6001: arg_table_name temp_table_hash_type;

Line 5999: TYPE bind_value_table IS TABLE OF DBMS_SQL.VARCHAR2_TABLE INDEX BY BINARY_INTEGER;

5995: v_flag tIntegerArray;
5996:
5997: bind_node_id DBMS_SQL.NUMBER_TABLE;
5998:
5999: TYPE bind_value_table IS TABLE OF DBMS_SQL.VARCHAR2_TABLE INDEX BY BINARY_INTEGER;
6000: bind_values bind_value_table;
6001: arg_table_name temp_table_hash_type;
6002:
6003: h_OptionExplId table_of_tNumberArray_idx_vc2;-- jonatara:bug7041718

Line 6230: v_cursor := DBMS_SQL.OPEN_CURSOR;

6226: END;
6227: ---------------------------------------------------------------------------------------
6228: PROCEDURE GENERATE_STANDARD_PBC IS
6229: BEGIN
6230: v_cursor := DBMS_SQL.OPEN_CURSOR;
6231: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
6232:
6233: FOR i IN 1..bindValue.COUNT LOOP
6234: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));

Line 6231: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);

6227: ---------------------------------------------------------------------------------------
6228: PROCEDURE GENERATE_STANDARD_PBC IS
6229: BEGIN
6230: v_cursor := DBMS_SQL.OPEN_CURSOR;
6231: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
6232:
6233: FOR i IN 1..bindValue.COUNT LOOP
6234: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));
6235: END LOOP;

Line 6234: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));

6230: v_cursor := DBMS_SQL.OPEN_CURSOR;
6231: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
6232:
6233: FOR i IN 1..bindValue.COUNT LOOP
6234: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));
6235: END LOOP;
6236:
6237: nDebug := 7005109;
6238:

Line 6239: localNumber := DBMS_SQL.EXECUTE(v_cursor);

6235: END LOOP;
6236:
6237: nDebug := 7005109;
6238:
6239: localNumber := DBMS_SQL.EXECUTE(v_cursor);
6240:
6241: LOOP
6242:
6243: FOR i IN 1..iteratorIndex.COUNT LOOP

Line 6244: DBMS_SQL.DEFINE_ARRAY(v_cursor, i, v_tOptionId, DBMS_SQL_MAX_BUFFER_SIZE, 1);

6240:
6241: LOOP
6242:
6243: FOR i IN 1..iteratorIndex.COUNT LOOP
6244: DBMS_SQL.DEFINE_ARRAY(v_cursor, i, v_tOptionId, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6245: END LOOP;
6246:
6247: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);
6248:

Line 6247: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);

6243: FOR i IN 1..iteratorIndex.COUNT LOOP
6244: DBMS_SQL.DEFINE_ARRAY(v_cursor, i, v_tOptionId, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6245: END LOOP;
6246:
6247: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);
6248:
6249: FOR i IN 1..v_tFeatureId.COUNT LOOP
6250:
6251: DBMS_SQL.COLUMN_VALUE(v_cursor, i, v_tOptionId);

Line 6251: DBMS_SQL.COLUMN_VALUE(v_cursor, i, v_tOptionId);

6247: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);
6248:
6249: FOR i IN 1..v_tFeatureId.COUNT LOOP
6250:
6251: DBMS_SQL.COLUMN_VALUE(v_cursor, i, v_tOptionId);
6252:
6253: FOR n IN 1..localNumber LOOP
6254:
6255: GET_ITEM_INDEX(v_tOptionId(n), i);

Line 6266: EXIT WHEN localNumber <> DBMS_SQL_MAX_BUFFER_SIZE;

6262: v_RowLines(rowThreshold + n) := ' ' || TO_CHAR(itemIndex - 1);
6263: END IF;
6264: END LOOP;
6265: END LOOP;
6266: EXIT WHEN localNumber <> DBMS_SQL_MAX_BUFFER_SIZE;
6267: rowThreshold := rowThreshold + DBMS_SQL_MAX_BUFFER_SIZE;
6268: END LOOP;
6269:
6270: nDebug := 7005110;

Line 6267: rowThreshold := rowThreshold + DBMS_SQL_MAX_BUFFER_SIZE;

6263: END IF;
6264: END LOOP;
6265: END LOOP;
6266: EXIT WHEN localNumber <> DBMS_SQL_MAX_BUFFER_SIZE;
6267: rowThreshold := rowThreshold + DBMS_SQL_MAX_BUFFER_SIZE;
6268: END LOOP;
6269:
6270: nDebug := 7005110;
6271:

Line 6272: DBMS_SQL.CLOSE_CURSOR(v_cursor);

6268: END LOOP;
6269:
6270: nDebug := 7005110;
6271:
6272: DBMS_SQL.CLOSE_CURSOR(v_cursor);
6273:
6274: --If there's no valid combinations, report the rule and ignore it.
6275:
6276: IF(v_RowLines.COUNT = 0)THEN

Line 6405: v_option_a DBMS_SQL.NUMBER_TABLE;

6401: a_min PLS_INTEGER;
6402: b_min PLS_INTEGER;
6403: a_object_name VARCHAR2(4000);
6404: b_object_name VARCHAR2(4000);
6405: v_option_a DBMS_SQL.NUMBER_TABLE;
6406: v_option_b DBMS_SQL.NUMBER_TABLE;
6407: current_option NUMBER;
6408: v_bitpos_a tIntegerArray_idx_vc2; --jonatara:bug7041718
6409: v_bitpos_b tIntegerArray_idx_vc2;

Line 6406: v_option_b DBMS_SQL.NUMBER_TABLE;

6402: b_min PLS_INTEGER;
6403: a_object_name VARCHAR2(4000);
6404: b_object_name VARCHAR2(4000);
6405: v_option_a DBMS_SQL.NUMBER_TABLE;
6406: v_option_b DBMS_SQL.NUMBER_TABLE;
6407: current_option NUMBER;
6408: v_bitpos_a tIntegerArray_idx_vc2; --jonatara:bug7041718
6409: v_bitpos_b tIntegerArray_idx_vc2;
6410: v_bitinv_a tIntegerArray;

Line 6482: v_cursor := DBMS_SQL.OPEN_CURSOR;

6478: END;
6479: ---------------------------------------------------------------------------------------
6480: BEGIN
6481: nDebug := 8000000;
6482: v_cursor := DBMS_SQL.OPEN_CURSOR;
6483: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
6484:
6485: FOR i IN 1..bindValue.COUNT LOOP
6486: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));

Line 6483: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);

6479: ---------------------------------------------------------------------------------------
6480: BEGIN
6481: nDebug := 8000000;
6482: v_cursor := DBMS_SQL.OPEN_CURSOR;
6483: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
6484:
6485: FOR i IN 1..bindValue.COUNT LOOP
6486: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));
6487: END LOOP;

Line 6486: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));

6482: v_cursor := DBMS_SQL.OPEN_CURSOR;
6483: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
6484:
6485: FOR i IN 1..bindValue.COUNT LOOP
6486: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));
6487: END LOOP;
6488:
6489: localNumber := DBMS_SQL.EXECUTE(v_cursor);
6490: nDebug := 8000001;

Line 6489: localNumber := DBMS_SQL.EXECUTE(v_cursor);

6485: FOR i IN 1..bindValue.COUNT LOOP
6486: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));
6487: END LOOP;
6488:
6489: localNumber := DBMS_SQL.EXECUTE(v_cursor);
6490: nDebug := 8000001;
6491: LOOP
6492:
6493: DBMS_SQL.DEFINE_ARRAY(v_cursor, 1, v_option_a, DBMS_SQL_MAX_BUFFER_SIZE, 1);

Line 6493: DBMS_SQL.DEFINE_ARRAY(v_cursor, 1, v_option_a, DBMS_SQL_MAX_BUFFER_SIZE, 1);

6489: localNumber := DBMS_SQL.EXECUTE(v_cursor);
6490: nDebug := 8000001;
6491: LOOP
6492:
6493: DBMS_SQL.DEFINE_ARRAY(v_cursor, 1, v_option_a, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6494: DBMS_SQL.DEFINE_ARRAY(v_cursor, 2, v_option_b, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6495:
6496: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);
6497:

Line 6494: DBMS_SQL.DEFINE_ARRAY(v_cursor, 2, v_option_b, DBMS_SQL_MAX_BUFFER_SIZE, 1);

6490: nDebug := 8000001;
6491: LOOP
6492:
6493: DBMS_SQL.DEFINE_ARRAY(v_cursor, 1, v_option_a, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6494: DBMS_SQL.DEFINE_ARRAY(v_cursor, 2, v_option_b, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6495:
6496: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);
6497:
6498: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, v_option_a);

Line 6496: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);

6492:
6493: DBMS_SQL.DEFINE_ARRAY(v_cursor, 1, v_option_a, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6494: DBMS_SQL.DEFINE_ARRAY(v_cursor, 2, v_option_b, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6495:
6496: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);
6497:
6498: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, v_option_a);
6499: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, v_option_b);
6500: nDebug := 8000002;

Line 6498: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, v_option_a);

6494: DBMS_SQL.DEFINE_ARRAY(v_cursor, 2, v_option_b, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6495:
6496: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);
6497:
6498: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, v_option_a);
6499: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, v_option_b);
6500: nDebug := 8000002;
6501: FOR i IN 1..localNumber LOOP
6502: v_options.EXTEND();

Line 6499: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, v_option_b);

6495:
6496: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);
6497:
6498: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, v_option_a);
6499: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, v_option_b);
6500: nDebug := 8000002;
6501: FOR i IN 1..localNumber LOOP
6502: v_options.EXTEND();
6503: v_options(rowThreshold + i) := SYSTEM.cz_lce_compat_rec_type(v_option_a(i), v_option_b(i));

Line 6524: EXIT WHEN localNumber <> DBMS_SQL_MAX_BUFFER_SIZE;

6520:
6521: v_option_a.DELETE;
6522: v_option_b.DELETE;
6523:
6524: EXIT WHEN localNumber <> DBMS_SQL_MAX_BUFFER_SIZE;
6525: rowThreshold := rowThreshold + DBMS_SQL_MAX_BUFFER_SIZE;
6526: END LOOP;
6527: nDebug := 8000005;
6528: DBMS_SQL.CLOSE_CURSOR(v_cursor);

Line 6525: rowThreshold := rowThreshold + DBMS_SQL_MAX_BUFFER_SIZE;

6521: v_option_a.DELETE;
6522: v_option_b.DELETE;
6523:
6524: EXIT WHEN localNumber <> DBMS_SQL_MAX_BUFFER_SIZE;
6525: rowThreshold := rowThreshold + DBMS_SQL_MAX_BUFFER_SIZE;
6526: END LOOP;
6527: nDebug := 8000005;
6528: DBMS_SQL.CLOSE_CURSOR(v_cursor);
6529:

Line 6528: DBMS_SQL.CLOSE_CURSOR(v_cursor);

6524: EXIT WHEN localNumber <> DBMS_SQL_MAX_BUFFER_SIZE;
6525: rowThreshold := rowThreshold + DBMS_SQL_MAX_BUFFER_SIZE;
6526: END LOOP;
6527: nDebug := 8000005;
6528: DBMS_SQL.CLOSE_CURSOR(v_cursor);
6529:
6530: --If there's no valid combinations, report the rule and ignore it.
6531:
6532: IF(v_options.COUNT = 0)THEN

Line 7028: v_cursor := DBMS_SQL.OPEN_CURSOR;

7024: END LOOP;
7025:
7026: nDebug := 7005107;
7027:
7028: v_cursor := DBMS_SQL.OPEN_CURSOR;
7029: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);
7030:
7031: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_id);
7032:

Line 7029: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);

7025:
7026: nDebug := 7005107;
7027:
7028: v_cursor := DBMS_SQL.OPEN_CURSOR;
7029: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);
7030:
7031: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_id);
7032:
7033: FOR ii IN 1..v_property_id.COUNT LOOP

Line 7031: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_id);

7027:
7028: v_cursor := DBMS_SQL.OPEN_CURSOR;
7029: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);
7030:
7031: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_id);
7032:
7033: FOR ii IN 1..v_property_id.COUNT LOOP
7034: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));
7035: END LOOP;

Line 7034: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));

7030:
7031: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_id);
7032:
7033: FOR ii IN 1..v_property_id.COUNT LOOP
7034: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));
7035: END LOOP;
7036:
7037: localNumber := DBMS_SQL.EXECUTE(v_cursor);
7038: DBMS_SQL.CLOSE_CURSOR(v_cursor);

Line 7037: localNumber := DBMS_SQL.EXECUTE(v_cursor);

7033: FOR ii IN 1..v_property_id.COUNT LOOP
7034: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));
7035: END LOOP;
7036:
7037: localNumber := DBMS_SQL.EXECUTE(v_cursor);
7038: DBMS_SQL.CLOSE_CURSOR(v_cursor);
7039:
7040: EXECUTE IMMEDIATE 'ANALYZE TABLE ' || tableName || ' COMPUTE STATISTICS';
7041:

Line 7038: DBMS_SQL.CLOSE_CURSOR(v_cursor);

7034: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));
7035: END LOOP;
7036:
7037: localNumber := DBMS_SQL.EXECUTE(v_cursor);
7038: DBMS_SQL.CLOSE_CURSOR(v_cursor);
7039:
7040: EXECUTE IMMEDIATE 'ANALYZE TABLE ' || tableName || ' COMPUTE STATISTICS';
7041:
7042: --The table is created and populated, add its name to the hash for re-use if it is eligible.