APPS.XLE_ASSOC_VALIDATIONS_PVT dependencies on DBMS_SQL

Line 137: l_cursor := DBMS_SQL.OPEN_CURSOR;

133: IF (l_OBJECT_type_rec.where_clause IS NOT NULL) THEN
134: l_select_statement := l_select_statement || ' AND ' || l_OBJECT_type_rec.where_clause;
135: END IF;
136:
137: l_cursor := DBMS_SQL.OPEN_CURSOR;
138:
139: DBMS_SQL.PARSE(l_cursor, l_select_statement, DBMS_SQL.V7);
140: DBMS_SQL.BIND_VARIABLE (l_cursor, ':pk_id', p_object_id);
141:

Line 139: DBMS_SQL.PARSE(l_cursor, l_select_statement, DBMS_SQL.V7);

135: END IF;
136:
137: l_cursor := DBMS_SQL.OPEN_CURSOR;
138:
139: DBMS_SQL.PARSE(l_cursor, l_select_statement, DBMS_SQL.V7);
140: DBMS_SQL.BIND_VARIABLE (l_cursor, ':pk_id', p_object_id);
141:
142: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
143:

Line 140: DBMS_SQL.BIND_VARIABLE (l_cursor, ':pk_id', p_object_id);

136:
137: l_cursor := DBMS_SQL.OPEN_CURSOR;
138:
139: DBMS_SQL.PARSE(l_cursor, l_select_statement, DBMS_SQL.V7);
140: DBMS_SQL.BIND_VARIABLE (l_cursor, ':pk_id', p_object_id);
141:
142: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
143:
144: IF DBMS_SQL.FETCH_ROWS(l_cursor) = 0 THEN

Line 142: l_dummy := DBMS_SQL.EXECUTE(l_cursor);

138:
139: DBMS_SQL.PARSE(l_cursor, l_select_statement, DBMS_SQL.V7);
140: DBMS_SQL.BIND_VARIABLE (l_cursor, ':pk_id', p_object_id);
141:
142: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
143:
144: IF DBMS_SQL.FETCH_ROWS(l_cursor) = 0 THEN
145: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_PARAM');
146: FND_MESSAGE.SET_TOKEN ('PARAM', p_param2_name);

Line 144: IF DBMS_SQL.FETCH_ROWS(l_cursor) = 0 THEN

140: DBMS_SQL.BIND_VARIABLE (l_cursor, ':pk_id', p_object_id);
141:
142: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
143:
144: IF DBMS_SQL.FETCH_ROWS(l_cursor) = 0 THEN
145: FND_MESSAGE.SET_NAME ('XLE', 'XLE_ASSOC_INVALID_PARAM');
146: FND_MESSAGE.SET_TOKEN ('PARAM', p_param2_name);
147: FND_MSG_PUB.ADD;
148: RAISE FND_API.G_EXC_ERROR;

Line 150: DBMS_SQL.CLOSE_CURSOR (l_cursor);

146: FND_MESSAGE.SET_TOKEN ('PARAM', p_param2_name);
147: FND_MSG_PUB.ADD;
148: RAISE FND_API.G_EXC_ERROR;
149: END IF;
150: DBMS_SQL.CLOSE_CURSOR (l_cursor);
151: x_OBJECT_type_id := l_OBJECT_type_rec.OBJECT_TYPE_ID;
152:
153: EXCEPTION
154: WHEN OTHERS THEN