DBA Data[Home] [Help]

APPS.PQH_RLA_BUS dependencies on PQH_ATTRIBUTES

Line 286: select count(*) into cnt from pqh_attributes where attribute_id = to_number(p_rec.attribute_code);

282: att_val number;
283: att_type varchar2(10);
284: cnt number;
285: Begin
286: select count(*) into cnt from pqh_attributes where attribute_id = to_number(p_rec.attribute_code);
287: if cnt = 1 then
288: select column_type into att_type from pqh_attributes where
289: attribute_id = to_number(p_rec.attribute_code);
290: --

Line 288: select column_type into att_type from pqh_attributes where

284: cnt number;
285: Begin
286: select count(*) into cnt from pqh_attributes where attribute_id = to_number(p_rec.attribute_code);
287: if cnt = 1 then
288: select column_type into att_type from pqh_attributes where
289: attribute_id = to_number(p_rec.attribute_code);
290: --
291: -- to_number is able to handle only upto 126 chars. so making this logic to go beyond 126.
292: --