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 5308: bind_node_id DBMS_SQL.NUMBER_TABLE;

5304: v_stack_start PLS_INTEGER;
5305: v_stack_end PLS_INTEGER;
5306: v_value_exists PLS_INTEGER := 0;
5307:
5308: bind_node_id DBMS_SQL.NUMBER_TABLE;
5309: bind_node_id_ex DBMS_SQL.NUMBER_TABLE;
5310: bind_node_type DBMS_SQL.NUMBER_TABLE;
5311: bind_node_value DBMS_SQL.VARCHAR2_TABLE;
5312: bind_node_obj DBMS_SQL.VARCHAR2_TABLE;

Line 5309: bind_node_id_ex DBMS_SQL.NUMBER_TABLE;

5305: v_stack_end PLS_INTEGER;
5306: v_value_exists PLS_INTEGER := 0;
5307:
5308: bind_node_id DBMS_SQL.NUMBER_TABLE;
5309: bind_node_id_ex DBMS_SQL.NUMBER_TABLE;
5310: bind_node_type DBMS_SQL.NUMBER_TABLE;
5311: bind_node_value DBMS_SQL.VARCHAR2_TABLE;
5312: bind_node_obj DBMS_SQL.VARCHAR2_TABLE;
5313:

Line 5310: bind_node_type DBMS_SQL.NUMBER_TABLE;

5306: v_value_exists PLS_INTEGER := 0;
5307:
5308: bind_node_id DBMS_SQL.NUMBER_TABLE;
5309: bind_node_id_ex DBMS_SQL.NUMBER_TABLE;
5310: bind_node_type DBMS_SQL.NUMBER_TABLE;
5311: bind_node_value DBMS_SQL.VARCHAR2_TABLE;
5312: bind_node_obj DBMS_SQL.VARCHAR2_TABLE;
5313:
5314: TYPE bind_value_table IS TABLE OF DBMS_SQL.VARCHAR2_TABLE INDEX BY BINARY_INTEGER;

Line 5311: bind_node_value DBMS_SQL.VARCHAR2_TABLE;

5307:
5308: bind_node_id DBMS_SQL.NUMBER_TABLE;
5309: bind_node_id_ex DBMS_SQL.NUMBER_TABLE;
5310: bind_node_type DBMS_SQL.NUMBER_TABLE;
5311: bind_node_value DBMS_SQL.VARCHAR2_TABLE;
5312: bind_node_obj DBMS_SQL.VARCHAR2_TABLE;
5313:
5314: TYPE bind_value_table IS TABLE OF DBMS_SQL.VARCHAR2_TABLE INDEX BY BINARY_INTEGER;
5315: bind_values bind_value_table;

Line 5312: bind_node_obj DBMS_SQL.VARCHAR2_TABLE;

5308: bind_node_id DBMS_SQL.NUMBER_TABLE;
5309: bind_node_id_ex DBMS_SQL.NUMBER_TABLE;
5310: bind_node_type DBMS_SQL.NUMBER_TABLE;
5311: bind_node_value DBMS_SQL.VARCHAR2_TABLE;
5312: bind_node_obj DBMS_SQL.VARCHAR2_TABLE;
5313:
5314: TYPE bind_value_table IS TABLE OF DBMS_SQL.VARCHAR2_TABLE INDEX BY BINARY_INTEGER;
5315: bind_values bind_value_table;
5316: arg_table_name temp_table_hash_type;

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

5310: bind_node_type DBMS_SQL.NUMBER_TABLE;
5311: bind_node_value DBMS_SQL.VARCHAR2_TABLE;
5312: bind_node_obj DBMS_SQL.VARCHAR2_TABLE;
5313:
5314: TYPE bind_value_table IS TABLE OF DBMS_SQL.VARCHAR2_TABLE INDEX BY BINARY_INTEGER;
5315: bind_values bind_value_table;
5316: arg_table_name temp_table_hash_type;
5317: hash_propval_key VARCHAR2(4000);
5318: ---------------------------------------------------------------------------------------

Line 5771: v_cursor := DBMS_SQL.OPEN_CURSOR;

5767: END LOOP;
5768:
5769: nDebug := 7004106;
5770:
5771: v_cursor := DBMS_SQL.OPEN_CURSOR;
5772: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);
5773:
5774: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_type);
5775: DBMS_SQL.BIND_ARRAY(v_cursor, ':y2', bind_node_id);

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

5768:
5769: nDebug := 7004106;
5770:
5771: v_cursor := DBMS_SQL.OPEN_CURSOR;
5772: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);
5773:
5774: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_type);
5775: DBMS_SQL.BIND_ARRAY(v_cursor, ':y2', bind_node_id);
5776: DBMS_SQL.BIND_ARRAY(v_cursor, ':y3', bind_node_value);

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

5770:
5771: v_cursor := DBMS_SQL.OPEN_CURSOR;
5772: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);
5773:
5774: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_type);
5775: DBMS_SQL.BIND_ARRAY(v_cursor, ':y2', bind_node_id);
5776: DBMS_SQL.BIND_ARRAY(v_cursor, ':y3', bind_node_value);
5777: DBMS_SQL.BIND_ARRAY(v_cursor, ':y4', bind_node_obj);
5778: DBMS_SQL.BIND_ARRAY(v_cursor, ':y5', bind_node_id_ex);

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

5771: v_cursor := DBMS_SQL.OPEN_CURSOR;
5772: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);
5773:
5774: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_type);
5775: DBMS_SQL.BIND_ARRAY(v_cursor, ':y2', bind_node_id);
5776: DBMS_SQL.BIND_ARRAY(v_cursor, ':y3', bind_node_value);
5777: DBMS_SQL.BIND_ARRAY(v_cursor, ':y4', bind_node_obj);
5778: DBMS_SQL.BIND_ARRAY(v_cursor, ':y5', bind_node_id_ex);
5779:

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

5772: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);
5773:
5774: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_type);
5775: DBMS_SQL.BIND_ARRAY(v_cursor, ':y2', bind_node_id);
5776: DBMS_SQL.BIND_ARRAY(v_cursor, ':y3', bind_node_value);
5777: DBMS_SQL.BIND_ARRAY(v_cursor, ':y4', bind_node_obj);
5778: DBMS_SQL.BIND_ARRAY(v_cursor, ':y5', bind_node_id_ex);
5779:
5780: FOR ii IN 1..v_property_id.COUNT LOOP

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

5773:
5774: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_type);
5775: DBMS_SQL.BIND_ARRAY(v_cursor, ':y2', bind_node_id);
5776: DBMS_SQL.BIND_ARRAY(v_cursor, ':y3', bind_node_value);
5777: DBMS_SQL.BIND_ARRAY(v_cursor, ':y4', bind_node_obj);
5778: DBMS_SQL.BIND_ARRAY(v_cursor, ':y5', bind_node_id_ex);
5779:
5780: FOR ii IN 1..v_property_id.COUNT LOOP
5781: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));

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

5774: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_type);
5775: DBMS_SQL.BIND_ARRAY(v_cursor, ':y2', bind_node_id);
5776: DBMS_SQL.BIND_ARRAY(v_cursor, ':y3', bind_node_value);
5777: DBMS_SQL.BIND_ARRAY(v_cursor, ':y4', bind_node_obj);
5778: DBMS_SQL.BIND_ARRAY(v_cursor, ':y5', bind_node_id_ex);
5779:
5780: FOR ii IN 1..v_property_id.COUNT LOOP
5781: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));
5782: END LOOP;

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

5777: DBMS_SQL.BIND_ARRAY(v_cursor, ':y4', bind_node_obj);
5778: DBMS_SQL.BIND_ARRAY(v_cursor, ':y5', bind_node_id_ex);
5779:
5780: FOR ii IN 1..v_property_id.COUNT LOOP
5781: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));
5782: END LOOP;
5783:
5784: localNumber := DBMS_SQL.EXECUTE(v_cursor);
5785: DBMS_SQL.CLOSE_CURSOR(v_cursor);

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

5780: FOR ii IN 1..v_property_id.COUNT LOOP
5781: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));
5782: END LOOP;
5783:
5784: localNumber := DBMS_SQL.EXECUTE(v_cursor);
5785: DBMS_SQL.CLOSE_CURSOR(v_cursor);
5786:
5787: nDebug := 7004107;
5788:

Line 5785: DBMS_SQL.CLOSE_CURSOR(v_cursor);

5781: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));
5782: END LOOP;
5783:
5784: localNumber := DBMS_SQL.EXECUTE(v_cursor);
5785: DBMS_SQL.CLOSE_CURSOR(v_cursor);
5786:
5787: nDebug := 7004107;
5788:
5789: EXECUTE IMMEDIATE 'ANALYZE TABLE ' || tableName || ' COMPUTE STATISTICS';

Line 5808: v_cursor := DBMS_SQL.OPEN_CURSOR;

5804:
5805: SQLWhere := ' WHERE ' || EXAMINE_WHERE_CLAUSE(v_ChildrenIndex(v_tExprId(whereIndex)));
5806: END IF;
5807:
5808: v_cursor := DBMS_SQL.OPEN_CURSOR;
5809: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
5810:
5811: FOR i IN 1..bindValue.COUNT LOOP
5812: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));

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

5805: SQLWhere := ' WHERE ' || EXAMINE_WHERE_CLAUSE(v_ChildrenIndex(v_tExprId(whereIndex)));
5806: END IF;
5807:
5808: v_cursor := DBMS_SQL.OPEN_CURSOR;
5809: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
5810:
5811: FOR i IN 1..bindValue.COUNT LOOP
5812: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));
5813: END LOOP;

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

5808: v_cursor := DBMS_SQL.OPEN_CURSOR;
5809: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
5810:
5811: FOR i IN 1..bindValue.COUNT LOOP
5812: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));
5813: END LOOP;
5814:
5815: FOR i IN 1..iteratorIndex.COUNT LOOP
5816:

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

5813: END LOOP;
5814:
5815: FOR i IN 1..iteratorIndex.COUNT LOOP
5816:
5817: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 1, localNumber);
5818: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 2, localNumber);
5819: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 3, localString, 2000);
5820: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 4, localString, 2000);
5821: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 5, localNumber);

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

5814:
5815: FOR i IN 1..iteratorIndex.COUNT LOOP
5816:
5817: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 1, localNumber);
5818: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 2, localNumber);
5819: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 3, localString, 2000);
5820: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 4, localString, 2000);
5821: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 5, localNumber);
5822: END LOOP;

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

5815: FOR i IN 1..iteratorIndex.COUNT LOOP
5816:
5817: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 1, localNumber);
5818: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 2, localNumber);
5819: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 3, localString, 2000);
5820: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 4, localString, 2000);
5821: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 5, localNumber);
5822: END LOOP;
5823:

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

5816:
5817: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 1, localNumber);
5818: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 2, localNumber);
5819: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 3, localString, 2000);
5820: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 4, localString, 2000);
5821: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 5, localNumber);
5822: END LOOP;
5823:
5824: nDebug := 7004109;

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

5817: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 1, localNumber);
5818: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 2, localNumber);
5819: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 3, localString, 2000);
5820: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 4, localString, 2000);
5821: DBMS_SQL.DEFINE_COLUMN(v_cursor, 5 * (i - 1) + 5, localNumber);
5822: END LOOP;
5823:
5824: nDebug := 7004109;
5825:

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

5822: END LOOP;
5823:
5824: nDebug := 7004109;
5825:
5826: localNumber := DBMS_SQL.EXECUTE(v_cursor);
5827:
5828: --For every returned row, store the values in the parameter scope, from where GENERATE_EXPRESSION
5829: --will be retrieving it when generating an argument.
5830:

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

5832:
5833: parameterName(v_stack_start + i - 1) := v_tExprArgumentName(iteratorIndex(i));
5834: END LOOP;
5835:
5836: WHILE(DBMS_SQL.FETCH_ROWS(v_cursor) > 0)LOOP
5837:
5838: FOR i IN 1..iteratorIndex.COUNT LOOP
5839:
5840: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 1, parameterScope(v_stack_start + i - 1).node_type);

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

5836: WHILE(DBMS_SQL.FETCH_ROWS(v_cursor) > 0)LOOP
5837:
5838: FOR i IN 1..iteratorIndex.COUNT LOOP
5839:
5840: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 1, parameterScope(v_stack_start + i - 1).node_type);
5841: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 2, parameterScope(v_stack_start + i - 1).node_id);
5842: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 3, parameterScope(v_stack_start + i - 1).node_value);
5843: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 4, parameterScope(v_stack_start + i - 1).node_obj);
5844: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 5, parameterScope(v_stack_start + i - 1).node_id_ex);

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

5837:
5838: FOR i IN 1..iteratorIndex.COUNT LOOP
5839:
5840: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 1, parameterScope(v_stack_start + i - 1).node_type);
5841: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 2, parameterScope(v_stack_start + i - 1).node_id);
5842: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 3, parameterScope(v_stack_start + i - 1).node_value);
5843: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 4, parameterScope(v_stack_start + i - 1).node_obj);
5844: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 5, parameterScope(v_stack_start + i - 1).node_id_ex);
5845: END LOOP;

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

5838: FOR i IN 1..iteratorIndex.COUNT LOOP
5839:
5840: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 1, parameterScope(v_stack_start + i - 1).node_type);
5841: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 2, parameterScope(v_stack_start + i - 1).node_id);
5842: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 3, parameterScope(v_stack_start + i - 1).node_value);
5843: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 4, parameterScope(v_stack_start + i - 1).node_obj);
5844: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 5, parameterScope(v_stack_start + i - 1).node_id_ex);
5845: END LOOP;
5846:

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

5839:
5840: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 1, parameterScope(v_stack_start + i - 1).node_type);
5841: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 2, parameterScope(v_stack_start + i - 1).node_id);
5842: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 3, parameterScope(v_stack_start + i - 1).node_value);
5843: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 4, parameterScope(v_stack_start + i - 1).node_obj);
5844: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 5, parameterScope(v_stack_start + i - 1).node_id_ex);
5845: END LOOP;
5846:
5847: IF(expressionIndex <> 0 AND v_ChildrenIndex.EXISTS(v_tExprId(expressionIndex)))THEN

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

5840: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 1, parameterScope(v_stack_start + i - 1).node_type);
5841: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 2, parameterScope(v_stack_start + i - 1).node_id);
5842: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 3, parameterScope(v_stack_start + i - 1).node_value);
5843: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 4, parameterScope(v_stack_start + i - 1).node_obj);
5844: DBMS_SQL.COLUMN_VALUE(v_cursor, 5 * (i - 1) + 5, parameterScope(v_stack_start + i - 1).node_id_ex);
5845: END LOOP;
5846:
5847: IF(expressionIndex <> 0 AND v_ChildrenIndex.EXISTS(v_tExprId(expressionIndex)))THEN
5848:

Line 5908: DBMS_SQL.CLOSE_CURSOR(v_cursor);

5904: parameterName.DELETE(v_stack_start, v_stack_end);
5905:
5906: nDebug := 7004110;
5907:
5908: DBMS_SQL.CLOSE_CURSOR(v_cursor);
5909:
5910: IF(v_tExprParentId(j) IS NOT NULL AND v_return.COUNT = 0)THEN
5911:
5912: --The FORALL or COLLECT did not yield any rows while it is not the root operator.

Line 5966: v_tOptionId DBMS_SQL.NUMBER_TABLE;

5962: localNumber NUMBER;
5963: localString VARCHAR2(4000);
5964: bindValue tStringArray;
5965: typeCheck NUMBER;
5966: v_tOptionId DBMS_SQL.NUMBER_TABLE;
5967: v_tFeatureId tExplNodeId;
5968: v_BackIndex tIntegerArray;
5969: v_tExplId tExplNodeId;
5970: rowThreshold PLS_INTEGER := 0;

Line 5984: bind_node_id DBMS_SQL.NUMBER_TABLE;

5980: v_ItemLines tStringArray;
5981: ExcludesRequired PLS_INTEGER;
5982: v_flag tIntegerArray;
5983:
5984: bind_node_id DBMS_SQL.NUMBER_TABLE;
5985:
5986: TYPE bind_value_table IS TABLE OF DBMS_SQL.VARCHAR2_TABLE INDEX BY BINARY_INTEGER;
5987: bind_values bind_value_table;
5988: arg_table_name temp_table_hash_type;

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

5982: v_flag tIntegerArray;
5983:
5984: bind_node_id DBMS_SQL.NUMBER_TABLE;
5985:
5986: TYPE bind_value_table IS TABLE OF DBMS_SQL.VARCHAR2_TABLE INDEX BY BINARY_INTEGER;
5987: bind_values bind_value_table;
5988: arg_table_name temp_table_hash_type;
5989:
5990: h_OptionExplId table_of_tNumberArray_idx_vc2;-- jonatara:bug7041718

Line 6217: v_cursor := DBMS_SQL.OPEN_CURSOR;

6213: END;
6214: ---------------------------------------------------------------------------------------
6215: PROCEDURE GENERATE_STANDARD_PBC IS
6216: BEGIN
6217: v_cursor := DBMS_SQL.OPEN_CURSOR;
6218: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
6219:
6220: FOR i IN 1..bindValue.COUNT LOOP
6221: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));

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

6214: ---------------------------------------------------------------------------------------
6215: PROCEDURE GENERATE_STANDARD_PBC IS
6216: BEGIN
6217: v_cursor := DBMS_SQL.OPEN_CURSOR;
6218: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
6219:
6220: FOR i IN 1..bindValue.COUNT LOOP
6221: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));
6222: END LOOP;

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

6217: v_cursor := DBMS_SQL.OPEN_CURSOR;
6218: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
6219:
6220: FOR i IN 1..bindValue.COUNT LOOP
6221: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));
6222: END LOOP;
6223:
6224: nDebug := 7005109;
6225:

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

6222: END LOOP;
6223:
6224: nDebug := 7005109;
6225:
6226: localNumber := DBMS_SQL.EXECUTE(v_cursor);
6227:
6228: LOOP
6229:
6230: FOR i IN 1..iteratorIndex.COUNT LOOP

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

6227:
6228: LOOP
6229:
6230: FOR i IN 1..iteratorIndex.COUNT LOOP
6231: DBMS_SQL.DEFINE_ARRAY(v_cursor, i, v_tOptionId, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6232: END LOOP;
6233:
6234: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);
6235:

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

6230: FOR i IN 1..iteratorIndex.COUNT LOOP
6231: DBMS_SQL.DEFINE_ARRAY(v_cursor, i, v_tOptionId, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6232: END LOOP;
6233:
6234: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);
6235:
6236: FOR i IN 1..v_tFeatureId.COUNT LOOP
6237:
6238: DBMS_SQL.COLUMN_VALUE(v_cursor, i, v_tOptionId);

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

6234: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);
6235:
6236: FOR i IN 1..v_tFeatureId.COUNT LOOP
6237:
6238: DBMS_SQL.COLUMN_VALUE(v_cursor, i, v_tOptionId);
6239:
6240: FOR n IN 1..localNumber LOOP
6241:
6242: GET_ITEM_INDEX(v_tOptionId(n), i);

Line 6253: EXIT WHEN localNumber <> DBMS_SQL_MAX_BUFFER_SIZE;

6249: v_RowLines(rowThreshold + n) := ' ' || TO_CHAR(itemIndex - 1);
6250: END IF;
6251: END LOOP;
6252: END LOOP;
6253: EXIT WHEN localNumber <> DBMS_SQL_MAX_BUFFER_SIZE;
6254: rowThreshold := rowThreshold + DBMS_SQL_MAX_BUFFER_SIZE;
6255: END LOOP;
6256:
6257: nDebug := 7005110;

Line 6254: rowThreshold := rowThreshold + DBMS_SQL_MAX_BUFFER_SIZE;

6250: END IF;
6251: END LOOP;
6252: END LOOP;
6253: EXIT WHEN localNumber <> DBMS_SQL_MAX_BUFFER_SIZE;
6254: rowThreshold := rowThreshold + DBMS_SQL_MAX_BUFFER_SIZE;
6255: END LOOP;
6256:
6257: nDebug := 7005110;
6258:

Line 6259: DBMS_SQL.CLOSE_CURSOR(v_cursor);

6255: END LOOP;
6256:
6257: nDebug := 7005110;
6258:
6259: DBMS_SQL.CLOSE_CURSOR(v_cursor);
6260:
6261: --If there's no valid combinations, report the rule and ignore it.
6262:
6263: IF(v_RowLines.COUNT = 0)THEN

Line 6392: v_option_a DBMS_SQL.NUMBER_TABLE;

6388: a_min PLS_INTEGER;
6389: b_min PLS_INTEGER;
6390: a_object_name VARCHAR2(4000);
6391: b_object_name VARCHAR2(4000);
6392: v_option_a DBMS_SQL.NUMBER_TABLE;
6393: v_option_b DBMS_SQL.NUMBER_TABLE;
6394: current_option NUMBER;
6395: v_bitpos_a tIntegerArray_idx_vc2; --jonatara:bug7041718
6396: v_bitpos_b tIntegerArray_idx_vc2;

Line 6393: v_option_b DBMS_SQL.NUMBER_TABLE;

6389: b_min PLS_INTEGER;
6390: a_object_name VARCHAR2(4000);
6391: b_object_name VARCHAR2(4000);
6392: v_option_a DBMS_SQL.NUMBER_TABLE;
6393: v_option_b DBMS_SQL.NUMBER_TABLE;
6394: current_option NUMBER;
6395: v_bitpos_a tIntegerArray_idx_vc2; --jonatara:bug7041718
6396: v_bitpos_b tIntegerArray_idx_vc2;
6397: v_bitinv_a tIntegerArray;

Line 6469: v_cursor := DBMS_SQL.OPEN_CURSOR;

6465: END;
6466: ---------------------------------------------------------------------------------------
6467: BEGIN
6468: nDebug := 8000000;
6469: v_cursor := DBMS_SQL.OPEN_CURSOR;
6470: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
6471:
6472: FOR i IN 1..bindValue.COUNT LOOP
6473: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));

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

6466: ---------------------------------------------------------------------------------------
6467: BEGIN
6468: nDebug := 8000000;
6469: v_cursor := DBMS_SQL.OPEN_CURSOR;
6470: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
6471:
6472: FOR i IN 1..bindValue.COUNT LOOP
6473: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));
6474: END LOOP;

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

6469: v_cursor := DBMS_SQL.OPEN_CURSOR;
6470: DBMS_SQL.PARSE(v_cursor, SQLSelect || SQLFrom || SQLWhere, DBMS_SQL.NATIVE);
6471:
6472: FOR i IN 1..bindValue.COUNT LOOP
6473: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));
6474: END LOOP;
6475:
6476: localNumber := DBMS_SQL.EXECUTE(v_cursor);
6477: nDebug := 8000001;

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

6472: FOR i IN 1..bindValue.COUNT LOOP
6473: DBMS_SQL.BIND_VARIABLE(v_cursor, ':x' || TO_CHAR(i), bindValue(i));
6474: END LOOP;
6475:
6476: localNumber := DBMS_SQL.EXECUTE(v_cursor);
6477: nDebug := 8000001;
6478: LOOP
6479:
6480: DBMS_SQL.DEFINE_ARRAY(v_cursor, 1, v_option_a, DBMS_SQL_MAX_BUFFER_SIZE, 1);

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

6476: localNumber := DBMS_SQL.EXECUTE(v_cursor);
6477: nDebug := 8000001;
6478: LOOP
6479:
6480: DBMS_SQL.DEFINE_ARRAY(v_cursor, 1, v_option_a, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6481: DBMS_SQL.DEFINE_ARRAY(v_cursor, 2, v_option_b, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6482:
6483: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);
6484:

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

6477: nDebug := 8000001;
6478: LOOP
6479:
6480: DBMS_SQL.DEFINE_ARRAY(v_cursor, 1, v_option_a, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6481: DBMS_SQL.DEFINE_ARRAY(v_cursor, 2, v_option_b, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6482:
6483: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);
6484:
6485: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, v_option_a);

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

6479:
6480: DBMS_SQL.DEFINE_ARRAY(v_cursor, 1, v_option_a, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6481: DBMS_SQL.DEFINE_ARRAY(v_cursor, 2, v_option_b, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6482:
6483: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);
6484:
6485: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, v_option_a);
6486: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, v_option_b);
6487: nDebug := 8000002;

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

6481: DBMS_SQL.DEFINE_ARRAY(v_cursor, 2, v_option_b, DBMS_SQL_MAX_BUFFER_SIZE, 1);
6482:
6483: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);
6484:
6485: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, v_option_a);
6486: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, v_option_b);
6487: nDebug := 8000002;
6488: FOR i IN 1..localNumber LOOP
6489: v_options.EXTEND();

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

6482:
6483: localNumber := DBMS_SQL.FETCH_ROWS(v_cursor);
6484:
6485: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, v_option_a);
6486: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, v_option_b);
6487: nDebug := 8000002;
6488: FOR i IN 1..localNumber LOOP
6489: v_options.EXTEND();
6490: v_options(rowThreshold + i) := SYSTEM.cz_lce_compat_rec_type(v_option_a(i), v_option_b(i));

Line 6511: EXIT WHEN localNumber <> DBMS_SQL_MAX_BUFFER_SIZE;

6507:
6508: v_option_a.DELETE;
6509: v_option_b.DELETE;
6510:
6511: EXIT WHEN localNumber <> DBMS_SQL_MAX_BUFFER_SIZE;
6512: rowThreshold := rowThreshold + DBMS_SQL_MAX_BUFFER_SIZE;
6513: END LOOP;
6514: nDebug := 8000005;
6515: DBMS_SQL.CLOSE_CURSOR(v_cursor);

Line 6512: rowThreshold := rowThreshold + DBMS_SQL_MAX_BUFFER_SIZE;

6508: v_option_a.DELETE;
6509: v_option_b.DELETE;
6510:
6511: EXIT WHEN localNumber <> DBMS_SQL_MAX_BUFFER_SIZE;
6512: rowThreshold := rowThreshold + DBMS_SQL_MAX_BUFFER_SIZE;
6513: END LOOP;
6514: nDebug := 8000005;
6515: DBMS_SQL.CLOSE_CURSOR(v_cursor);
6516:

Line 6515: DBMS_SQL.CLOSE_CURSOR(v_cursor);

6511: EXIT WHEN localNumber <> DBMS_SQL_MAX_BUFFER_SIZE;
6512: rowThreshold := rowThreshold + DBMS_SQL_MAX_BUFFER_SIZE;
6513: END LOOP;
6514: nDebug := 8000005;
6515: DBMS_SQL.CLOSE_CURSOR(v_cursor);
6516:
6517: --If there's no valid combinations, report the rule and ignore it.
6518:
6519: IF(v_options.COUNT = 0)THEN

Line 7013: v_cursor := DBMS_SQL.OPEN_CURSOR;

7009: END LOOP;
7010:
7011: nDebug := 7005107;
7012:
7013: v_cursor := DBMS_SQL.OPEN_CURSOR;
7014: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);
7015:
7016: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_id);
7017:

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

7010:
7011: nDebug := 7005107;
7012:
7013: v_cursor := DBMS_SQL.OPEN_CURSOR;
7014: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);
7015:
7016: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_id);
7017:
7018: FOR ii IN 1..v_property_id.COUNT LOOP

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

7012:
7013: v_cursor := DBMS_SQL.OPEN_CURSOR;
7014: DBMS_SQL.PARSE(v_cursor, SQLInsert || SQLValues, DBMS_SQL.NATIVE);
7015:
7016: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_id);
7017:
7018: FOR ii IN 1..v_property_id.COUNT LOOP
7019: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));
7020: END LOOP;

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

7015:
7016: DBMS_SQL.BIND_ARRAY(v_cursor, ':y1', bind_node_id);
7017:
7018: FOR ii IN 1..v_property_id.COUNT LOOP
7019: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));
7020: END LOOP;
7021:
7022: localNumber := DBMS_SQL.EXECUTE(v_cursor);
7023: DBMS_SQL.CLOSE_CURSOR(v_cursor);

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

7018: FOR ii IN 1..v_property_id.COUNT LOOP
7019: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));
7020: END LOOP;
7021:
7022: localNumber := DBMS_SQL.EXECUTE(v_cursor);
7023: DBMS_SQL.CLOSE_CURSOR(v_cursor);
7024:
7025: EXECUTE IMMEDIATE 'ANALYZE TABLE ' || tableName || ' COMPUTE STATISTICS';
7026:

Line 7023: DBMS_SQL.CLOSE_CURSOR(v_cursor);

7019: DBMS_SQL.BIND_ARRAY(v_cursor, ':x' || TO_CHAR(ii), bind_values(ii));
7020: END LOOP;
7021:
7022: localNumber := DBMS_SQL.EXECUTE(v_cursor);
7023: DBMS_SQL.CLOSE_CURSOR(v_cursor);
7024:
7025: EXECUTE IMMEDIATE 'ANALYZE TABLE ' || tableName || ' COMPUTE STATISTICS';
7026:
7027: --The table is created and populated, add its name to the hash for re-use if it is eligible.