APPS.CS_KB_WF_PKG dependencies on DBMS_SQL

Line 1102: steps := DBMS_SQL.OPEN_CURSOR;

1098: SQL1 := SQL1 || ' ,CS_KB_WF_FLOW_DETAILS ';
1099: SQL2 := SQL2 || ' AND CS_KB_WF_FLOW_DETAILS.STEP = CS_LOOKUPS.LOOKUP_CODE AND CS_KB_WF_FLOW_DETAILS.ACTION = :N ';
1100: END IF;
1101: -- open and parse statement
1102: steps := DBMS_SQL.OPEN_CURSOR;
1103: DBMS_SQL.PARSE(steps, SQL1||SQL2||SQL3, DBMS_SQL.V7);
1104: DBMS_SQL.BIND_VARIABLE(steps,':T', 'CS_KB_STATUS');
1105:
1106: IF(p_restriction = 1) THEN

Line 1103: DBMS_SQL.PARSE(steps, SQL1||SQL2||SQL3, DBMS_SQL.V7);

1099: SQL2 := SQL2 || ' AND CS_KB_WF_FLOW_DETAILS.STEP = CS_LOOKUPS.LOOKUP_CODE AND CS_KB_WF_FLOW_DETAILS.ACTION = :N ';
1100: END IF;
1101: -- open and parse statement
1102: steps := DBMS_SQL.OPEN_CURSOR;
1103: DBMS_SQL.PARSE(steps, SQL1||SQL2||SQL3, DBMS_SQL.V7);
1104: DBMS_SQL.BIND_VARIABLE(steps,':T', 'CS_KB_STATUS');
1105:
1106: IF(p_restriction = 1) THEN
1107: DBMS_SQL.BIND_VARIABLE(steps,':N', 'NOT');

Line 1104: DBMS_SQL.BIND_VARIABLE(steps,':T', 'CS_KB_STATUS');

1100: END IF;
1101: -- open and parse statement
1102: steps := DBMS_SQL.OPEN_CURSOR;
1103: DBMS_SQL.PARSE(steps, SQL1||SQL2||SQL3, DBMS_SQL.V7);
1104: DBMS_SQL.BIND_VARIABLE(steps,':T', 'CS_KB_STATUS');
1105:
1106: IF(p_restriction = 1) THEN
1107: DBMS_SQL.BIND_VARIABLE(steps,':N', 'NOT');
1108: END IF;

Line 1107: DBMS_SQL.BIND_VARIABLE(steps,':N', 'NOT');

1103: DBMS_SQL.PARSE(steps, SQL1||SQL2||SQL3, DBMS_SQL.V7);
1104: DBMS_SQL.BIND_VARIABLE(steps,':T', 'CS_KB_STATUS');
1105:
1106: IF(p_restriction = 1) THEN
1107: DBMS_SQL.BIND_VARIABLE(steps,':N', 'NOT');
1108: END IF;
1109:
1110: -- Define output variables
1111: DBMS_SQL.DEFINE_COLUMN(steps, 1, st,100);

Line 1111: DBMS_SQL.DEFINE_COLUMN(steps, 1, st,100);

1107: DBMS_SQL.BIND_VARIABLE(steps,':N', 'NOT');
1108: END IF;
1109:
1110: -- Define output variables
1111: DBMS_SQL.DEFINE_COLUMN(steps, 1, st,100);
1112: DBMS_SQL.DEFINE_COLUMN(steps, 2, na,100);
1113:
1114:
1115: --Execute cursor

Line 1112: DBMS_SQL.DEFINE_COLUMN(steps, 2, na,100);

1108: END IF;
1109:
1110: -- Define output variables
1111: DBMS_SQL.DEFINE_COLUMN(steps, 1, st,100);
1112: DBMS_SQL.DEFINE_COLUMN(steps, 2, na,100);
1113:
1114:
1115: --Execute cursor
1116: cursorReturn := DBMS_SQL.EXECUTE(steps);

Line 1116: cursorReturn := DBMS_SQL.EXECUTE(steps);

1112: DBMS_SQL.DEFINE_COLUMN(steps, 2, na,100);
1113:
1114:
1115: --Execute cursor
1116: cursorReturn := DBMS_SQL.EXECUTE(steps);
1117:
1118:
1119: /******* LOOPING ********************/
1120:

Line 1122: IF DBMS_SQL.FETCH_ROWS(steps) = 0 THEN

1118:
1119: /******* LOOPING ********************/
1120:
1121: LOOP
1122: IF DBMS_SQL.FETCH_ROWS(steps) = 0 THEN
1123: EXIT;
1124: END IF;
1125: -- Loading variables with column values
1126: DBMS_SQL.COLUMN_VALUE(steps, 1, st);

Line 1126: DBMS_SQL.COLUMN_VALUE(steps, 1, st);

1122: IF DBMS_SQL.FETCH_ROWS(steps) = 0 THEN
1123: EXIT;
1124: END IF;
1125: -- Loading variables with column values
1126: DBMS_SQL.COLUMN_VALUE(steps, 1, st);
1127: DBMS_SQL.COLUMN_VALUE(steps, 2, na);
1128:
1129: -- Extending tables one.
1130: t_step.extend;

Line 1127: DBMS_SQL.COLUMN_VALUE(steps, 2, na);

1123: EXIT;
1124: END IF;
1125: -- Loading variables with column values
1126: DBMS_SQL.COLUMN_VALUE(steps, 1, st);
1127: DBMS_SQL.COLUMN_VALUE(steps, 2, na);
1128:
1129: -- Extending tables one.
1130: t_step.extend;
1131: t_step_names.extend;

Line 1140: DBMS_SQL.CLOSE_CURSOR(steps);

1136:
1137: -- Increment counter.
1138: counter := counter + 1;
1139: END LOOP;
1140: DBMS_SQL.CLOSE_CURSOR(steps);
1141:
1142: IF (p_restriction = 1) THEN
1143: t_step.extend;
1144: t_step_names.extend;

Line 1161: DBMS_SQL.CLOSE_CURSOR(steps);

1157: p_step_names := t_step_names;
1158: EXCEPTION
1159: WHEN OTHERS THEN
1160: IF (steps is not null) THEN
1161: DBMS_SQL.CLOSE_CURSOR(steps);
1162: END IF;
1163: RAISE;
1164: END Get_Step_List;
1165: