eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_APP_PERIOD_SUMMARY

Line 1046: hxc_app_period_summary haps

1042: cursor get_app_period(p_bb_id in number, p_bb_ovn in number ,p_app_bb_id in number)
1043: is
1044: select adl.application_period_id
1045: from hxc_ap_detail_links adl,
1046: hxc_app_period_summary haps
1047: where adl.time_building_block_id = p_bb_id
1048: and adl.time_building_block_ovn = p_bb_ovn
1049: and adl.application_period_id <> p_app_bb_id
1050: and adl.application_period_id = haps.application_period_id

Line 1283: update hxc_app_period_summary

1279: end if;
1280:
1281: --update hxc_application_period_summary table
1282: l_creation_date := get_creation_date(l_appl_period_bb_id, l_appl_period_bb_ovn);
1283: update hxc_app_period_summary
1284: set application_period_ovn = l_appl_period_bb_ovn
1285: ,approval_status = l_approval_status
1286: ,approver_id = l_approver
1287: ,notification_status = 'FINISHED'

Line 1370: FROM hxc_app_period_summary

1366: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE
1367: )
1368: IS
1369: SELECT *
1370: FROM hxc_app_period_summary
1371: WHERE application_period_id = p_app_id;
1372:
1373: CURSOR c_timecards(
1374: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE

Line 1391: l_current_period hxc_app_period_summary%rowtype;

1387: FROM hxc_ap_detail_links
1388: WHERE application_period_id = p_app_id;
1389:
1390:
1391: l_current_period hxc_app_period_summary%rowtype;
1392: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
1393: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
1394: l_detail_ovn hxc_time_building_blocks.object_version_number%TYPE;
1395: l_new_appl_bb_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;

Line 1484: --populate hxc_app_period_summary with the new row

1480: CLOSE c_current_period;
1481:
1482: g_trace := l_proc || '80';
1483: /*
1484: --populate hxc_app_period_summary with the new row
1485: INSERT INTO hxc_app_period_summary
1486: (APPLICATION_PERIOD_ID
1487: ,APPLICATION_PERIOD_OVN
1488: ,APPROVAL_STATUS

Line 1485: INSERT INTO hxc_app_period_summary

1481:
1482: g_trace := l_proc || '80';
1483: /*
1484: --populate hxc_app_period_summary with the new row
1485: INSERT INTO hxc_app_period_summary
1486: (APPLICATION_PERIOD_ID
1487: ,APPLICATION_PERIOD_OVN
1488: ,APPROVAL_STATUS
1489: ,TIME_RECIPIENT_ID

Line 1503: hxc_app_period_summary_pkg.insert_summary_row

1499: ,APPROVAL_COMP_ID
1500: )
1501: VALUES
1502: */
1503: hxc_app_period_summary_pkg.insert_summary_row
1504: (l_new_appl_bb_id
1505: ,l_new_appl_bb_ovn
1506: ,'SUBMITTED'
1507: ,l_current_period.time_recipient_id

Line 2067: FROM hxc_app_period_summary

2063: ,application_period_ovn
2064: ,approval_status
2065: ,notification_status
2066: ,approval_comp_id
2067: FROM hxc_app_period_summary
2068: WHERE resource_id = p_resource_id
2069: AND start_time = p_start_time
2070: AND stop_time = p_stop_time
2071: AND time_recipient_id = p_time_recipient_id

Line 2089: p_app_period_id in hxc_app_period_summary.application_period_id%type) is

2085: WHERE timecard_id = p_timecard_id
2086: AND application_period_id = p_app_period_id;
2087:
2088: cursor c_previous_actioner(
2089: p_app_period_id in hxc_app_period_summary.application_period_id%type) is
2090: select approver_id
2091: from hxc_app_period_summary
2092: where application_period_id = p_app_period_id;
2093:

Line 2091: from hxc_app_period_summary

2087:
2088: cursor c_previous_actioner(
2089: p_app_period_id in hxc_app_period_summary.application_period_id%type) is
2090: select approver_id
2091: from hxc_app_period_summary
2092: where application_period_id = p_app_period_id;
2093:
2094: CURSOR c_get_detail_blocks(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type)
2095: is

Line 2110: from hxc_app_period_summary

2106:
2107: cursor get_item_key(p_bb_id in number)
2108: is
2109: select approval_item_key
2110: from hxc_app_period_summary
2111: where application_period_id = p_bb_id;
2112:
2113:
2114: l_app_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;

Line 2118: l_app_comp_id hxc_app_period_summary.approval_comp_id%type;

2114: l_app_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
2115: l_app_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;
2116: l_approval_status hxc_time_building_blocks.approval_status%TYPE := NULL;
2117: l_notification_status VARCHAR2(150) := NULL;
2118: l_app_comp_id hxc_app_period_summary.approval_comp_id%type;
2119: l_app_id_temp hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
2120: l_app_ovn_temp hxc_time_building_blocks.object_version_number%TYPE := NULL;
2121: l_app_status_temp hxc_time_building_blocks.approval_status%TYPE := NULL;
2122: l_notif_status_temp VARCHAR2(150) := NULL;

Line 2123: l_app_comp_id_temp hxc_app_period_summary.approval_comp_id%type;

2119: l_app_id_temp hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
2120: l_app_ovn_temp hxc_time_building_blocks.object_version_number%TYPE := NULL;
2121: l_app_status_temp hxc_time_building_blocks.approval_status%TYPE := NULL;
2122: l_notif_status_temp VARCHAR2(150) := NULL;
2123: l_app_comp_id_temp hxc_app_period_summary.approval_comp_id%type;
2124: l_first_app_period BOOLEAN;
2125: l_time_category_id hxc_time_categories.time_category_id%TYPE := NULL;
2126: l_category_sequence hxc_app_period_summary.category_sequence%TYPE := NULL;
2127: l_creation_date DATE;

Line 2126: l_category_sequence hxc_app_period_summary.category_sequence%TYPE := NULL;

2122: l_notif_status_temp VARCHAR2(150) := NULL;
2123: l_app_comp_id_temp hxc_app_period_summary.approval_comp_id%type;
2124: l_first_app_period BOOLEAN;
2125: l_time_category_id hxc_time_categories.time_category_id%TYPE := NULL;
2126: l_category_sequence hxc_app_period_summary.category_sequence%TYPE := NULL;
2127: l_creation_date DATE;
2128: t_attributes hxc_time_attributes_api.timecard;
2129: l_tc_ap_link_exists VARCHAR2(50) := NULL;
2130: l_app_exists BOOLEAN;

Line 2223: --remove them from hxc_app_period_summary

2219: l_first_app_period := FALSE;
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:

Line 2226: hxc_app_period_summary_api.app_period_delete(l_app_id_temp);

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;
2229:
2230: END LOOP;

Line 2287: hxc_app_period_summary_api.app_period_delete(l_app_id);

2283: --otherwise, it means, this app period still has details from
2284: --other timecards, can't delete the app period
2285: IF NOT has_details(l_app_id)
2286: THEN
2287: hxc_app_period_summary_api.app_period_delete(l_app_id);
2288: END IF;
2289: END IF;
2290:
2291: hr_utility.trace('Return(2)');

Line 2640: hr_utility.trace('Populating hxc_app_period_summary');

2636: if g_debug then
2637: hr_utility.trace('Generated the period');
2638: hr_utility.trace('app_id=' || l_app_id);
2639: hr_utility.trace('app_ovn=' || l_app_ovn);
2640: hr_utility.trace('Populating hxc_app_period_summary');
2641: end if;
2642: l_creation_date := get_creation_date(l_app_id, l_app_ovn);
2643:
2644: g_trace := l_proc || '80';

Line 2646: --populate hxc_app_period_summary with the new row

2642: l_creation_date := get_creation_date(l_app_id, l_app_ovn);
2643:
2644: g_trace := l_proc || '80';
2645:
2646: --populate hxc_app_period_summary with the new row
2647: hxc_app_period_summary_api.app_period_create(
2648: p_application_period_id => l_app_id
2649: ,p_application_period_ovn => l_app_ovn
2650: ,p_approval_status => 'SUBMITTED'

Line 2647: hxc_app_period_summary_api.app_period_create(

2643:
2644: g_trace := l_proc || '80';
2645:
2646: --populate hxc_app_period_summary with the new row
2647: hxc_app_period_summary_api.app_period_create(
2648: p_application_period_id => l_app_id
2649: ,p_application_period_ovn => l_app_ovn
2650: ,p_approval_status => 'SUBMITTED'
2651: ,p_time_recipient_id => p_time_recipient_id

Line 2671: UPDATE hxc_app_period_summary

2667: ELSE
2668:
2669: IF l_notification_status <> 'NOT_NOTIFIED' THEN
2670: -- don't create a new application period, but need to change status
2671: UPDATE hxc_app_period_summary
2672: SET notification_status = 'NOT_NOTIFIED'
2673: ,approval_comp_id = p_approval_comp.approval_comp_id
2674: WHERE application_period_id = l_app_id;
2675: elsif(p_approval_comp.approval_comp_id <> l_app_comp_id) then

Line 2678: UPDATE hxc_app_period_summary

2674: WHERE application_period_id = l_app_id;
2675: elsif(p_approval_comp.approval_comp_id <> l_app_comp_id) then
2676: -- do not create a new application period, but ensure the
2677: -- correct approval component id is used.
2678: UPDATE hxc_app_period_summary
2679: SET approval_comp_id = p_approval_comp.approval_comp_id
2680: WHERE application_period_id = l_app_id;
2681: END IF;
2682:

Line 3812: ,p_recipient_sequence IN hxc_app_period_summary.recipient_sequence%TYPE

3808: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
3809: ,p_period_start_date IN hxc_time_building_blocks.start_time%TYPE
3810: ,p_period_end_date IN hxc_time_building_blocks.stop_time%TYPE
3811: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
3812: ,p_recipient_sequence IN hxc_app_period_summary.recipient_sequence%TYPE
3813: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
3814: ,p_category_sequence IN hxc_app_period_summary.category_sequence%TYPE
3815: )
3816: RETURN VARCHAR2

Line 3814: ,p_category_sequence IN hxc_app_period_summary.category_sequence%TYPE

3810: ,p_period_end_date IN hxc_time_building_blocks.stop_time%TYPE
3811: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
3812: ,p_recipient_sequence IN hxc_app_period_summary.recipient_sequence%TYPE
3813: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
3814: ,p_category_sequence IN hxc_app_period_summary.category_sequence%TYPE
3815: )
3816: RETURN VARCHAR2
3817: IS
3818:

Line 3825: ,p_recipient_sequence hxc_app_period_summary.recipient_sequence%TYPE

3821: ,p_resource_id hxc_time_building_blocks.resource_id%TYPE
3822: ,p_period_start_date hxc_time_building_blocks.start_time%TYPE
3823: ,p_period_end_date hxc_time_building_blocks.stop_time%TYPE
3824: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
3825: ,p_recipient_sequence hxc_app_period_summary.recipient_sequence%TYPE
3826: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
3827: ,p_category_sequence hxc_app_period_summary.category_sequence%TYPE
3828: )
3829: IS

Line 3827: ,p_category_sequence hxc_app_period_summary.category_sequence%TYPE

3823: ,p_period_end_date hxc_time_building_blocks.stop_time%TYPE
3824: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
3825: ,p_recipient_sequence hxc_app_period_summary.recipient_sequence%TYPE
3826: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
3827: ,p_category_sequence hxc_app_period_summary.category_sequence%TYPE
3828: )
3829: IS
3830: SELECT aps.approval_status
3831: FROM hxc_app_period_summary aps

Line 3831: FROM hxc_app_period_summary aps

3827: ,p_category_sequence hxc_app_period_summary.category_sequence%TYPE
3828: )
3829: IS
3830: SELECT aps.approval_status
3831: FROM hxc_app_period_summary aps
3832: WHERE aps.resource_id = p_resource_id
3833: AND p_date BETWEEN aps.start_time AND aps.stop_time
3834: AND aps.approval_status <> 'APPROVED'
3835: AND (

Line 4025: p_resource_id in hxc_app_period_summary.resource_id%type

4021: and tc.object_version_number = p_ovn;
4022:
4023:
4024: CURSOR csr_get_appl_periods(
4025: p_resource_id in hxc_app_period_summary.resource_id%type
4026: ,p_timecard_id in hxc_timecard_summary.timecard_id%type
4027: )
4028: IS
4029: select aps.application_period_id,

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

Line 4051: from hxc_app_period_summary

4047: p_period_id number
4048: )
4049: IS
4050: select 'N'
4051: from hxc_app_period_summary
4052: where application_period_id = p_period_id
4053: and approval_status = 'SUBMITTED'
4054: and notification_status = 'NOT_NOTIFIED';
4055:

Line 4318: update hxc_app_period_summary

4314: SELECT hxc_approval_item_key_s.nextval
4315: INTO l_item_key
4316: FROM dual;
4317:
4318: update hxc_app_period_summary
4319: set notification_status = 'NOTIFIED',
4320: approval_item_type = itemtype,
4321: approval_process_name = l_process_name,
4322: approval_item_key = l_item_key

Line 4508: update hxc_app_period_summary

4504: hr_utility.trace('Before Update');
4505: hr_utility.set_location(l_proc, 360);
4506: end if;
4507:
4508: update hxc_app_period_summary
4509: set notification_status = 'NOTIFIED'
4510: where application_period_id = l_appl_period_bb_id
4511: and application_period_ovn = l_appl_period_bb_ovn;
4512:

Line 5002: from hxc_app_period_summary

4998:
4999: cursor c_appr_comp(p_app_bb_id number,p_app_bb_ovn number)
5000: is
5001: select approval_comp_id
5002: from hxc_app_period_summary
5003: where application_period_id = p_app_bb_id
5004: and application_period_ovn = p_app_bb_ovn;
5005:
5006: cursor c_app_comp_pm(p_bb_id number,p_bb_ovn number)