[Home] [Help]
180: --
181: l_proc varchar2(72) := g_package||'chk_routing_category_id';
182: l_api_updating boolean;
183: l_dummy varchar2(1);
184: l_tcat pqh_routing_categories.transaction_category_id%type;
185: l_freeze_status_cd pqh_transaction_categories.freeze_status_cd%type;
186: --
187: cursor c1 is
188: -- select null
186: --
187: cursor c1 is
188: -- select null
189: select transaction_category_id
190: from pqh_routing_categories a
191: where a.routing_category_id = p_routing_category_id;
192: --
193: cursor c2 is
194: select nvl(freeze_status_cd,hr_api.g_varchar2)
206: and nvl(p_routing_category_id,hr_api.g_number)
207: <> nvl(pqh_rng_shd.g_old_rec.routing_category_id,hr_api.g_number)
208: or not l_api_updating) then
209: --
210: -- check if routing_category_id value exists in pqh_routing_categories table
211: --
212: open c1;
213: --
214: -- fetch c1 into l_dummy;
216: if c1%notfound then
217: --
218: close c1;
219: --
220: -- raise error as FK does not relate to PK in pqh_routing_categories
221: -- table.
222: --
223: pqh_rng_shd.constraint_error('PQH_ATTRIBUTE_RANGES_FK3');
224: --
357: p_assignment_id in number,
358: p_routing_category_id in number,
359: p_object_version_number in number) is
360: --
361: l_rlist_id1 pqh_routing_categories.routing_list_id%type;
362: l_rlist_id2 pqh_routing_list_members.routing_list_id%type;
363: l_enable_flag pqh_routing_list_members.enable_flag%type;
364: l_position_structure_id pqh_routing_categories.position_structure_id%type;
365: --
360: --
361: l_rlist_id1 pqh_routing_categories.routing_list_id%type;
362: l_rlist_id2 pqh_routing_list_members.routing_list_id%type;
363: l_enable_flag pqh_routing_list_members.enable_flag%type;
364: l_position_structure_id pqh_routing_categories.position_structure_id%type;
365: --
366: Cursor csr_list_id is
367: select nvl(routing_list_id,hr_api.g_number),
368: nvl(position_structure_id,hr_api.g_number)
365: --
366: Cursor csr_list_id is
367: select nvl(routing_list_id,hr_api.g_number),
368: nvl(position_structure_id,hr_api.g_number)
369: from pqh_routing_categories a
370: where a.routing_category_id = p_routing_category_id;
371: --
372: Cursor csr_routing_list_member is
373: Select nvl(routing_list_id,hr_api.g_number),nvl(enable_flag,'N')
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;
643: l_attribute_found boolean := FALSE;
644: --
645: l_proc varchar2(72) := g_package||'chk_if_valid_identifiers';
646: l_api_updating boolean;
647: l_dummy varchar2(1);
648: --
649: cursor c1 is
650: select transaction_category_id
651: from pqh_routing_categories a
652: where a.routing_category_id = p_routing_category_id;
653:
654: cursor c2 (p_transaction_category_id in number) is
655: select att.attribute_name,nvl(att.column_type,hr_api.g_varchar2),
912: --
913: --
914: Cursor csr_list_id is
915: select nvl(routing_list_id,hr_api.g_number)
916: from pqh_routing_categories a
917: where a.routing_category_id = p_routing_category_id;
918: --
919: l_routing_list_id pqh_routing_categories.routing_list_id%type;
920: l_error_code number(10) := NULL;
915: select nvl(routing_list_id,hr_api.g_number)
916: from pqh_routing_categories a
917: where a.routing_category_id = p_routing_category_id;
918: --
919: l_routing_list_id pqh_routing_categories.routing_list_id%type;
920: l_error_code number(10) := NULL;
921: --
922: l_proc varchar2(72) := g_package||'chk_enable_flag';
923: l_api_updating boolean;