APPS.PQH_RNG_BUS dependencies on PQH_ATTRIBUTES

Line 551: from pqh_attributes a

547: l_dummy varchar2(1);
548: --
549: cursor c1 is
550: select null
551: from pqh_attributes a
552: where a.attribute_id = p_attribute_id;
553: --
554: Begin
555: --

Line 568: -- check if attribute_id value exists in pqh_attributes table

564: <> nvl(pqh_rng_shd.g_old_rec.attribute_id,hr_api.g_number)
565: or not l_api_updating)
566: and p_attribute_id is not null then
567: --
568: -- check if attribute_id value exists in pqh_attributes table
569: --
570: open c1;
571: --
572: fetch c1 into l_dummy;

Line 577: -- raise error as FK does not relate to PK in pqh_attributes

573: if c1%notfound then
574: --
575: close c1;
576: --
577: -- raise error as FK does not relate to PK in pqh_attributes
578: -- table.
579: --
580: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_FK1');
581: --

Line 636: l_col_type pqh_attributes.column_type%type;

632: p_from_date in date,
633: p_to_date in date,
634: p_object_version_number in number) is
635: --
636: l_col_type pqh_attributes.column_type%type;
637: l_attribute_name pqh_attributes.attribute_name%type;
638: l_dummy_name pqh_attributes.attribute_name%type;
639: l_list_identifier pqh_txn_category_attributes.list_identifying_flag%type;
640: l_member_identifier pqh_txn_category_attributes.member_identifying_flag%type;

Line 637: l_attribute_name pqh_attributes.attribute_name%type;

633: p_to_date in date,
634: p_object_version_number in number) is
635: --
636: l_col_type pqh_attributes.column_type%type;
637: l_attribute_name pqh_attributes.attribute_name%type;
638: l_dummy_name pqh_attributes.attribute_name%type;
639: l_list_identifier pqh_txn_category_attributes.list_identifying_flag%type;
640: l_member_identifier pqh_txn_category_attributes.member_identifying_flag%type;
641: l_tcat_id pqh_txn_category_attributes.transaction_category_id%type;

Line 638: l_dummy_name pqh_attributes.attribute_name%type;

634: p_object_version_number in number) is
635: --
636: l_col_type pqh_attributes.column_type%type;
637: l_attribute_name pqh_attributes.attribute_name%type;
638: l_dummy_name pqh_attributes.attribute_name%type;
639: l_list_identifier pqh_txn_category_attributes.list_identifying_flag%type;
640: l_member_identifier pqh_txn_category_attributes.member_identifying_flag%type;
641: l_tcat_id pqh_txn_category_attributes.transaction_category_id%type;
642: r_tcat_id pqh_routing_categories.transaction_category_id%type;

Line 659: from pqh_txn_category_attributes tca,pqh_attributes att

655: select att.attribute_name,nvl(att.column_type,hr_api.g_varchar2),
656: tca.transaction_category_id,
657: nvl(tca.list_identifying_flag,hr_api.g_varchar2),
658: nvl(tca.member_identifying_flag,hr_api.g_varchar2)
659: from pqh_txn_category_attributes tca,pqh_attributes att
660: where att.attribute_id = p_attribute_id
661: AND tca.attribute_id = att.attribute_id
662: AND tca.transaction_category_id = p_transaction_category_id;
663: --