APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_TC_AP_LINKS

Line 1199: FROM hxc_tc_ap_links

1195: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE
1196: )
1197: IS
1198: SELECT timecard_id
1199: FROM hxc_tc_ap_links
1200: WHERE application_period_id = p_app_id;
1201:
1202: CURSOR c_ap_details(
1203: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE

Line 1345: --populate hxc_tc_ap_links

1341: ,Null
1342: ,l_current_period.data_set_id
1343: );
1344:
1345: --populate hxc_tc_ap_links
1346: OPEN c_timecards(
1347: p_app_id => l_period_id
1348: );
1349:

Line 1356: hxc_tc_ap_links_pkg.insert_summary_row(

1352:
1353: EXIT WHEN c_timecards%NOTFOUND;
1354: -- 115.76 Not changed this one, since this procedure
1355: -- no longer seems to be called.
1356: hxc_tc_ap_links_pkg.insert_summary_row(
1357: l_timecard_id
1358: ,l_new_appl_bb_id);
1359:
1360: --Bug 5554020.

Line 1905: FROM hxc_tc_ap_links

1901: ,p_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE
1902: )
1903: IS
1904: SELECT 'Y'
1905: FROM hxc_tc_ap_links
1906: WHERE timecard_id = p_timecard_id
1907: AND application_period_id = p_app_period_id;
1908:
1909: cursor c_previous_actioner(

Line 2038: --from hxc_tc_ap_links and hxc_ap_detail_links

2034:
2035: ELSE
2036: --should also end date them from hxc_time_building_blocks
2037: --remove them from hxc_app_period_summary
2038: --from hxc_tc_ap_links and hxc_ap_detail_links
2039: hxc_app_period_summary_api.app_period_delete(l_app_id_temp);
2040:
2041: END IF;
2042:

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

2182: IF l_approval_status <> 'SUBMITTED' THEN
2183: --
2184: -- 115.76 Change. Ensure this link is created using the normal
2185: -- interface, not this one which is internal.
2186: -- hxc_tc_ap_links_pkg.insert_summary_row(p_timecard_id, l_app_id);
2187: hxc_tc_ap_links_pkg.create_app_period_links(l_app_id);
2188: --
2189: -- 115.91 Change: At this point we also ensure the timecard
2190: -- status is reevaluated so that if a period is not sent due

Line 2187: hxc_tc_ap_links_pkg.create_app_period_links(l_app_id);

2183: --
2184: -- 115.76 Change. Ensure this link is created using the normal
2185: -- interface, not this one which is internal.
2186: -- hxc_tc_ap_links_pkg.insert_summary_row(p_timecard_id, l_app_id);
2187: hxc_tc_ap_links_pkg.create_app_period_links(l_app_id);
2188: --
2189: -- 115.91 Change: At this point we also ensure the timecard
2190: -- status is reevaluated so that if a period is not sent due
2191: -- to other changes in the timecard, the timecard has the

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

2392: g_trace := l_proc || '130';
2393:
2394:
2395: if g_debug then
2396: hr_utility.trace('Populating hxc_tc_ap_links');
2397: end if;
2398: --populate hxc_tc_ap_links
2399:
2400: OPEN c_tc_ap_link(p_timecard_id, l_app_id);

Line 2398: --populate hxc_tc_ap_links

2394:
2395: if g_debug then
2396: hr_utility.trace('Populating hxc_tc_ap_links');
2397: end if;
2398: --populate hxc_tc_ap_links
2399:
2400: OPEN c_tc_ap_link(p_timecard_id, l_app_id);
2401: FETCH c_tc_ap_link INTO l_tc_ap_link_exists;
2402: CLOSE c_tc_ap_link;

Line 2414: hxc_tc_ap_links_pkg.insert_summary_row(

2410: -- 115.76 Change. It is ok to leave this call, since
2411: -- the link is explicitly checked not to exist in the
2412: -- first place.
2413: --
2414: hxc_tc_ap_links_pkg.insert_summary_row(
2415: p_timecard_id => p_timecard_id
2416: ,p_application_period_id => l_app_id
2417: );
2418: --

Line 3216: from hxc_tc_ap_links tcl

3212: AND aps.category_sequence < p_category_sequence)
3213: )
3214: AND exists
3215: (select 'Y'
3216: from hxc_tc_ap_links tcl
3217: where tcl.application_period_id = aps.application_period_id
3218: );
3219:
3220: l_days number := p_period_end_date - p_period_start_date + 1;

Line 3406: from hxc_app_period_summary aps, hxc_tc_ap_links tcl

3402: aps.recipient_sequence,
3403: aps.time_category_id,
3404: aps.category_sequence,
3405: aps.approval_item_key
3406: from hxc_app_period_summary aps, hxc_tc_ap_links tcl
3407: where aps.resource_id = p_resource_id
3408: and aps.approval_status = 'SUBMITTED'
3409: and aps.notification_status = 'NOT_NOTIFIED'
3410: and aps.application_period_id = tcl.application_period_id