APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_TC_AP_LINKS

Line 1378: FROM hxc_tc_ap_links

1374: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE
1375: )
1376: IS
1377: SELECT timecard_id
1378: FROM hxc_tc_ap_links
1379: WHERE application_period_id = p_app_id;
1380:
1381: CURSOR c_ap_details(
1382: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE

Line 1524: --populate hxc_tc_ap_links

1520: ,Null
1521: ,l_current_period.data_set_id
1522: );
1523:
1524: --populate hxc_tc_ap_links
1525: OPEN c_timecards(
1526: p_app_id => l_period_id
1527: );
1528:

Line 1535: hxc_tc_ap_links_pkg.insert_summary_row(

1531:
1532: EXIT WHEN c_timecards%NOTFOUND;
1533: -- 115.76 Not changed this one, since this procedure
1534: -- no longer seems to be called.
1535: hxc_tc_ap_links_pkg.insert_summary_row(
1536: l_timecard_id
1537: ,l_new_appl_bb_id);
1538:
1539: --Bug 5554020.

Line 2084: FROM hxc_tc_ap_links

2080: ,p_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE
2081: )
2082: IS
2083: SELECT 'Y'
2084: FROM hxc_tc_ap_links
2085: WHERE timecard_id = p_timecard_id
2086: AND application_period_id = p_app_period_id;
2087:
2088: cursor c_previous_actioner(

Line 2224: --from hxc_tc_ap_links and hxc_ap_detail_links

2220:
2221: ELSE
2222: --should also end date them from hxc_time_building_blocks
2223: --remove them from hxc_app_period_summary
2224: --from hxc_tc_ap_links and hxc_ap_detail_links
2225:
2226: hxc_app_period_summary_api.app_period_delete(l_app_id_temp);
2227:
2228: END IF;

Line 2459: -- hxc_tc_ap_links_pkg.insert_summary_row(p_timecard_id, l_app_id);

2455: IF l_approval_status <> 'SUBMITTED' THEN
2456: --
2457: -- 115.76 Change. Ensure this link is created using the normal
2458: -- interface, not this one which is internal.
2459: -- hxc_tc_ap_links_pkg.insert_summary_row(p_timecard_id, l_app_id);
2460: hxc_tc_ap_links_pkg.create_app_period_links(l_app_id);
2461: --
2462: -- 115.91 Change: At this point we also ensure the timecard
2463: -- status is reevaluated so that if a period is not sent due

Line 2460: hxc_tc_ap_links_pkg.create_app_period_links(l_app_id);

2456: --
2457: -- 115.76 Change. Ensure this link is created using the normal
2458: -- interface, not this one which is internal.
2459: -- hxc_tc_ap_links_pkg.insert_summary_row(p_timecard_id, l_app_id);
2460: hxc_tc_ap_links_pkg.create_app_period_links(l_app_id);
2461: --
2462: -- 115.91 Change: At this point we also ensure the timecard
2463: -- status is reevaluated so that if a period is not sent due
2464: -- to other changes in the timecard, the timecard has the

Line 2743: hr_utility.trace('Populating hxc_tc_ap_links');

2739: g_trace := l_proc || '130';
2740:
2741:
2742: if g_debug then
2743: hr_utility.trace('Populating hxc_tc_ap_links');
2744: end if;
2745: --populate hxc_tc_ap_links
2746:
2747: OPEN c_tc_ap_link(p_timecard_id, l_app_id);

Line 2745: --populate hxc_tc_ap_links

2741:
2742: if g_debug then
2743: hr_utility.trace('Populating hxc_tc_ap_links');
2744: end if;
2745: --populate hxc_tc_ap_links
2746:
2747: OPEN c_tc_ap_link(p_timecard_id, l_app_id);
2748: FETCH c_tc_ap_link INTO l_tc_ap_link_exists;
2749: CLOSE c_tc_ap_link;

Line 2761: hxc_tc_ap_links_pkg.insert_summary_row(

2757: -- 115.76 Change. It is ok to leave this call, since
2758: -- the link is explicitly checked not to exist in the
2759: -- first place.
2760: --
2761: hxc_tc_ap_links_pkg.insert_summary_row(
2762: p_timecard_id => p_timecard_id
2763: ,p_application_period_id => l_app_id
2764: );
2765: --

Line 3847: from hxc_tc_ap_links tcl

3843: AND aps.category_sequence < p_category_sequence)
3844: )
3845: AND exists
3846: (select 'Y'
3847: from hxc_tc_ap_links tcl
3848: where tcl.application_period_id = aps.application_period_id
3849: );
3850:
3851: l_days number := p_period_end_date - p_period_start_date + 1;

Line 4038: from hxc_app_period_summary aps, hxc_tc_ap_links tcl

4034: aps.recipient_sequence,
4035: aps.time_category_id,
4036: aps.category_sequence,
4037: aps.approval_item_key
4038: from hxc_app_period_summary aps, hxc_tc_ap_links tcl
4039: where aps.resource_id = p_resource_id
4040: and aps.approval_status = 'SUBMITTED'
4041: and aps.notification_status = 'NOT_NOTIFIED'
4042: and aps.application_period_id = tcl.application_period_id