APPS.ASG_PUB_SEQUENCE_PKG dependencies on DBMS_SQL

Line 96: v_id := DBMS_SQL.OPEN_CURSOR;

92: ' where MOD(' || x_primary_key || ',' || v_max_users ||
93: ') = '|| x_client_number;
94:
95:
96: v_id := DBMS_SQL.OPEN_CURSOR;
97: DBMS_SQL.PARSE(v_id, v_statement, DBMS_SQL.native);
98: DBMS_SQL.DEFINE_COLUMN(v_id, 1, v_start);
99: dummy_num := DBMS_SQL.EXECUTE(v_id);
100: if DBMS_SQL.FETCH_ROWS(v_id) = 0 then

Line 97: DBMS_SQL.PARSE(v_id, v_statement, DBMS_SQL.native);

93: ') = '|| x_client_number;
94:
95:
96: v_id := DBMS_SQL.OPEN_CURSOR;
97: DBMS_SQL.PARSE(v_id, v_statement, DBMS_SQL.native);
98: DBMS_SQL.DEFINE_COLUMN(v_id, 1, v_start);
99: dummy_num := DBMS_SQL.EXECUTE(v_id);
100: if DBMS_SQL.FETCH_ROWS(v_id) = 0 then
101: return -1;

Line 98: DBMS_SQL.DEFINE_COLUMN(v_id, 1, v_start);

94:
95:
96: v_id := DBMS_SQL.OPEN_CURSOR;
97: DBMS_SQL.PARSE(v_id, v_statement, DBMS_SQL.native);
98: DBMS_SQL.DEFINE_COLUMN(v_id, 1, v_start);
99: dummy_num := DBMS_SQL.EXECUTE(v_id);
100: if DBMS_SQL.FETCH_ROWS(v_id) = 0 then
101: return -1;
102: END if;

Line 99: dummy_num := DBMS_SQL.EXECUTE(v_id);

95:
96: v_id := DBMS_SQL.OPEN_CURSOR;
97: DBMS_SQL.PARSE(v_id, v_statement, DBMS_SQL.native);
98: DBMS_SQL.DEFINE_COLUMN(v_id, 1, v_start);
99: dummy_num := DBMS_SQL.EXECUTE(v_id);
100: if DBMS_SQL.FETCH_ROWS(v_id) = 0 then
101: return -1;
102: END if;
103: DBMS_SQL.COLUMN_VALUE(v_id, 1, v_start);

Line 100: if DBMS_SQL.FETCH_ROWS(v_id) = 0 then

96: v_id := DBMS_SQL.OPEN_CURSOR;
97: DBMS_SQL.PARSE(v_id, v_statement, DBMS_SQL.native);
98: DBMS_SQL.DEFINE_COLUMN(v_id, 1, v_start);
99: dummy_num := DBMS_SQL.EXECUTE(v_id);
100: if DBMS_SQL.FETCH_ROWS(v_id) = 0 then
101: return -1;
102: END if;
103: DBMS_SQL.COLUMN_VALUE(v_id, 1, v_start);
104: DBMS_SQL.CLOSE_CURSOR(v_id);

Line 103: DBMS_SQL.COLUMN_VALUE(v_id, 1, v_start);

99: dummy_num := DBMS_SQL.EXECUTE(v_id);
100: if DBMS_SQL.FETCH_ROWS(v_id) = 0 then
101: return -1;
102: END if;
103: DBMS_SQL.COLUMN_VALUE(v_id, 1, v_start);
104: DBMS_SQL.CLOSE_CURSOR(v_id);
105:
106: if(v_start > v_start_mobile) then
107: v_minValue := v_start;

Line 104: DBMS_SQL.CLOSE_CURSOR(v_id);

100: if DBMS_SQL.FETCH_ROWS(v_id) = 0 then
101: return -1;
102: END if;
103: DBMS_SQL.COLUMN_VALUE(v_id, 1, v_start);
104: DBMS_SQL.CLOSE_CURSOR(v_id);
105:
106: if(v_start > v_start_mobile) then
107: v_minValue := v_start;
108: else