APPS.HXC_TIME_ATTRIBUTES_API dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 333: -- select hxc_time_attribute_usages_s.nextval from dual; -- refer Bug#3062133

329: ,p_object_version_number in out nocopy number
330: ) is
331:
332: --cursor c_attribute_usage_sequence is
333: -- select hxc_time_attribute_usages_s.nextval from dual; -- refer Bug#3062133
334:
335: cursor c_bld_blk_info_type_id(p_bld_blk_info_type varchar2) is
336: select bld_blk_info_type_id
337: from hxc_bld_blk_info_types

Line 520: -- insert row into hxc_time_attribute_usages to associate attributes

516: ,p_time_attribute_id => l_time_attribute_id
517: ,p_object_version_number => l_object_version_number
518: );
519:
520: -- insert row into hxc_time_attribute_usages to associate attributes
521: -- with a building block
522: if g_debug then
523: hr_utility.set_location('gaz: '|| l_proc, 90);
524: end if;

Line 538: insert into hxc_time_attribute_usages

534: if ((p_time_building_block_id IS NULL) OR (l_time_attribute_id is NULL)) then
535: raise e_usage_data_missing;
536: end if;
537:
538: insert into hxc_time_attribute_usages
539: (time_attribute_usage_id
540: ,time_attribute_id
541: ,time_building_block_id
542: ,time_building_block_ovn

Line 550: (hxc_time_attribute_usages_s.nextval -- refer Bug#3062133

546: ,last_updated_by
547: ,last_update_date
548: ,last_update_login
549: ) values
550: (hxc_time_attribute_usages_s.nextval -- refer Bug#3062133
551: ,l_time_attribute_id
552: ,p_time_building_block_id
553: ,p_tbb_ovn
554: ,l_data_set_id

Line 625: --select hxc_time_attribute_usages_s.nextval from dual;

621: ,p_object_version_number in out nocopy number
622: ) is
623:
624: --cursor c_attribute_usage_sequence is -- refer Bug#3062133
625: --select hxc_time_attribute_usages_s.nextval from dual;
626:
627: cursor c_get_data_set(p_tbb_id number,p_tbb_ovn number)
628: is
629: select data_set_id from hxc_time_building_blocks

Line 635: l_time_attribute_usage_id hxc_time_attribute_usages.time_attribute_usage_id%type;

631: and object_version_number = p_tbb_ovn;
632:
633: l_time_attribute_id hxc_time_attributes.time_attribute_id%type;
634: l_object_version_number hxc_time_attributes.object_version_number%type;
635: l_time_attribute_usage_id hxc_time_attribute_usages.time_attribute_usage_id%type;
636:
637: l_data_set_id hxc_time_attributes.data_set_id%type;
638: e_usage_data_missing exception;
639: Begin

Line 687: -- insert row into hxc_time_attribute_usages to associate attributes

683: ,p_time_attribute_id => l_time_attribute_id
684: ,p_object_version_number => l_object_version_number
685: );
686:
687: -- insert row into hxc_time_attribute_usages to associate attributes
688: -- with a building block
689:
690: --open c_attribute_usage_sequence; -- refer Bug#3062133
691: --fetch c_attribute_usage_sequence into l_time_attribute_usage_id;

Line 698: insert into hxc_time_attribute_usages

694: if ((p_time_building_block_id IS NULL) OR (l_time_attribute_id is NULL)) then
695: raise e_usage_data_missing;
696: end if;
697:
698: insert into hxc_time_attribute_usages
699: (time_attribute_usage_id
700: ,time_attribute_id
701: ,time_building_block_id
702: ,time_building_block_ovn

Line 710: (hxc_time_attribute_usages_s.nextval -- refer Bug#3062133

706: ,last_updated_by
707: ,last_update_date
708: ,last_update_login
709: ) values
710: (hxc_time_attribute_usages_s.nextval -- refer Bug#3062133
711: ,l_time_attribute_id
712: ,p_time_building_block_id
713: ,p_tbb_ovn
714: ,l_data_set_id