DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_AP_DETAIL_LINKS_PKG

Line 849: hxc_ap_detail_links_pkg.insert_summary_row(

845: --we use this flag to find all the category 0 blocks
846: p_detail_blocks(l_block_index).added := 'Y';
847:
848: --insert a line in hxc_detail_summary;
849: hxc_ap_detail_links_pkg.insert_summary_row(
850: p_app_id
851: ,p_detail_blocks(l_block_index).block_id
852: ,p_detail_blocks(l_block_index).block_ovn
853: );

Line 911: hxc_ap_detail_links_pkg.insert_summary_row(

907: p_detail_blocks(l_block_index).added := 'Y';
908:
909:
910: --insert a line in hxc_detail_summary;
911: hxc_ap_detail_links_pkg.insert_summary_row(
912: p_app_id
913: ,p_detail_blocks(l_block_index).block_id
914: ,p_detail_blocks(l_block_index).block_ovn
915: );

Line 1563: hxc_ap_detail_links_pkg.insert_summary_row

1559: time_building_block_ovn)
1560: VALUES
1561: */
1562:
1563: hxc_ap_detail_links_pkg.insert_summary_row
1564: (l_new_appl_bb_id,
1565: l_detail_id,
1566: l_detail_ovn);
1567: END LOOP;

Line 1995: hxc_ap_detail_links_pkg.insert_summary_row(

1991: fetch c_detail_exists into l_dummy;
1992:
1993: if c_detail_exists%notfound then
1994: --insert a line in hxc_detail_summary;
1995: hxc_ap_detail_links_pkg.insert_summary_row(
1996: p_app_id
1997: ,p_removed_blocks(l_block_index).block_id
1998: ,p_removed_blocks(l_block_index).block_ovn
1999: );

Line 2733: hxc_ap_detail_links_pkg.insert_summary_row(l_app_id, l_tab_type_a(i).p_id, l_max_ovn);

2729: open get_max_ovn(l_tab_type_a(i).p_id);
2730: fetch get_max_ovn into l_max_ovn;
2731: close get_max_ovn;
2732:
2733: hxc_ap_detail_links_pkg.insert_summary_row(l_app_id, l_tab_type_a(i).p_id, l_max_ovn);
2734:
2735: END LOOP;
2736: END IF;
2737: END IF;