APPS.ZX_ACCOUNT_TAX_RATES_PKG dependencies on DBMS_SQL

Line 97: org_cursor := dbms_sql.open_cursor;

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 ',

Line 98: dbms_sql.parse(org_cursor,

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);

Line 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);

Line 103: dbms_sql.define_column(org_cursor, 1, x_org_name, 240);

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

Line 104: dbms_sql.bind_variable(org_cursor, ':org_id', x_org_id);

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;

Line 106: row_count := dbms_sql.execute_and_fetch(org_cursor);

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:

Line 111: dbms_sql.column_value(org_cursor, 1, x_org_name);

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:

Line 112: dbms_sql.close_cursor(org_cursor);

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(