93: org_cursor NUMBER;
94: row_count NUMBER;
95: BEGIN
96:
97: org_cursor := dbms_sql.open_cursor;
98: dbms_sql.parse(org_cursor,
99: 'SELECT name ' ||
100: 'FROM hr_operating_units ' ||
101: 'WHERE organization_id = :org_id ',
94: row_count NUMBER;
95: BEGIN
96:
97: org_cursor := dbms_sql.open_cursor;
98: dbms_sql.parse(org_cursor,
99: 'SELECT name ' ||
100: 'FROM hr_operating_units ' ||
101: 'WHERE organization_id = :org_id ',
102: dbms_sql.v7);
98: dbms_sql.parse(org_cursor,
99: 'SELECT name ' ||
100: 'FROM hr_operating_units ' ||
101: 'WHERE organization_id = :org_id ',
102: dbms_sql.v7);
103: dbms_sql.define_column(org_cursor, 1, x_org_name, 240);
104: dbms_sql.bind_variable(org_cursor, ':org_id', x_org_id);
105:
106: row_count := dbms_sql.execute_and_fetch(org_cursor);
99: 'SELECT name ' ||
100: 'FROM hr_operating_units ' ||
101: 'WHERE organization_id = :org_id ',
102: dbms_sql.v7);
103: dbms_sql.define_column(org_cursor, 1, x_org_name, 240);
104: dbms_sql.bind_variable(org_cursor, ':org_id', x_org_id);
105:
106: row_count := dbms_sql.execute_and_fetch(org_cursor);
107: IF (row_count = 0) THEN
100: 'FROM hr_operating_units ' ||
101: 'WHERE organization_id = :org_id ',
102: dbms_sql.v7);
103: dbms_sql.define_column(org_cursor, 1, x_org_name, 240);
104: dbms_sql.bind_variable(org_cursor, ':org_id', x_org_id);
105:
106: row_count := dbms_sql.execute_and_fetch(org_cursor);
107: IF (row_count = 0) THEN
108: RAISE NO_DATA_FOUND;
102: dbms_sql.v7);
103: dbms_sql.define_column(org_cursor, 1, x_org_name, 240);
104: dbms_sql.bind_variable(org_cursor, ':org_id', x_org_id);
105:
106: row_count := dbms_sql.execute_and_fetch(org_cursor);
107: IF (row_count = 0) THEN
108: RAISE NO_DATA_FOUND;
109: END IF;
110:
107: IF (row_count = 0) THEN
108: RAISE NO_DATA_FOUND;
109: END IF;
110:
111: dbms_sql.column_value(org_cursor, 1, x_org_name);
112: dbms_sql.close_cursor(org_cursor);
113: END org_name;
114:
115:
108: RAISE NO_DATA_FOUND;
109: END IF;
110:
111: dbms_sql.column_value(org_cursor, 1, x_org_name);
112: dbms_sql.close_cursor(org_cursor);
113: END org_name;
114:
115:
116: PROCEDURE insert_row(