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.

APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_APP_PERIOD_SUMMARY

Line 894: hxc_app_period_summary haps

890: cursor get_app_period(p_bb_id in number, p_bb_ovn in number ,p_app_bb_id in number)
891: is
892: select adl.application_period_id
893: from hxc_ap_detail_links adl,
894: hxc_app_period_summary haps
895: where adl.time_building_block_id = p_bb_id
896: and adl.time_building_block_ovn = p_bb_ovn
897: and adl.application_period_id <> p_app_bb_id
898: and adl.application_period_id = haps.application_period_id

Line 1104: update hxc_app_period_summary

1100: end if;
1101:
1102: --update hxc_application_period_summary table
1103: l_creation_date := get_creation_date(l_appl_period_bb_id, l_appl_period_bb_ovn);
1104: update hxc_app_period_summary
1105: set application_period_ovn = l_appl_period_bb_ovn
1106: ,approval_status = l_approval_status
1107: ,approver_id = l_approver
1108: ,notification_status = 'FINISHED'

Line 1191: FROM hxc_app_period_summary

1187: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE
1188: )
1189: IS
1190: SELECT *
1191: FROM hxc_app_period_summary
1192: WHERE application_period_id = p_app_id;
1193:
1194: CURSOR c_timecards(
1195: p_app_id hxc_time_building_blocks.time_building_block_id%TYPE

Line 1212: l_current_period hxc_app_period_summary%rowtype;

1208: FROM hxc_ap_detail_links
1209: WHERE application_period_id = p_app_id;
1210:
1211:
1212: l_current_period hxc_app_period_summary%rowtype;
1213: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
1214: l_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
1215: l_detail_ovn hxc_time_building_blocks.object_version_number%TYPE;
1216: l_new_appl_bb_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;

Line 1305: --populate hxc_app_period_summary with the new row

1301: CLOSE c_current_period;
1302:
1303: g_trace := l_proc || '80';
1304: /*
1305: --populate hxc_app_period_summary with the new row
1306: INSERT INTO hxc_app_period_summary
1307: (APPLICATION_PERIOD_ID
1308: ,APPLICATION_PERIOD_OVN
1309: ,APPROVAL_STATUS

Line 1306: INSERT INTO hxc_app_period_summary

1302:
1303: g_trace := l_proc || '80';
1304: /*
1305: --populate hxc_app_period_summary with the new row
1306: INSERT INTO hxc_app_period_summary
1307: (APPLICATION_PERIOD_ID
1308: ,APPLICATION_PERIOD_OVN
1309: ,APPROVAL_STATUS
1310: ,TIME_RECIPIENT_ID

Line 1324: hxc_app_period_summary_pkg.insert_summary_row

1320: ,APPROVAL_COMP_ID
1321: )
1322: VALUES
1323: */
1324: hxc_app_period_summary_pkg.insert_summary_row
1325: (l_new_appl_bb_id
1326: ,l_new_appl_bb_ovn
1327: ,'SUBMITTED'
1328: ,l_current_period.time_recipient_id

Line 1888: FROM hxc_app_period_summary

1884: ,application_period_ovn
1885: ,approval_status
1886: ,notification_status
1887: ,approval_comp_id
1888: FROM hxc_app_period_summary
1889: WHERE resource_id = p_resource_id
1890: AND start_time = p_start_time
1891: AND stop_time = p_stop_time
1892: AND time_recipient_id = p_time_recipient_id

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

1906: WHERE timecard_id = p_timecard_id
1907: AND application_period_id = p_app_period_id;
1908:
1909: cursor c_previous_actioner(
1910: p_app_period_id in hxc_app_period_summary.application_period_id%type) is
1911: select approver_id
1912: from hxc_app_period_summary
1913: where application_period_id = p_app_period_id;
1914:

Line 1912: from hxc_app_period_summary

1908:
1909: cursor c_previous_actioner(
1910: p_app_period_id in hxc_app_period_summary.application_period_id%type) is
1911: select approver_id
1912: from hxc_app_period_summary
1913: where application_period_id = p_app_period_id;
1914:
1915: CURSOR c_get_detail_blocks(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type)
1916: is

Line 1931: from hxc_app_period_summary

1927:
1928: cursor get_item_key(p_bb_id in number)
1929: is
1930: select approval_item_key
1931: from hxc_app_period_summary
1932: where application_period_id = p_bb_id;
1933:
1934:
1935: l_app_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;

Line 1939: l_app_comp_id hxc_app_period_summary.approval_comp_id%type;

1935: l_app_id hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1936: l_app_ovn hxc_time_building_blocks.object_version_number%TYPE := NULL;
1937: l_approval_status hxc_time_building_blocks.approval_status%TYPE := NULL;
1938: l_notification_status VARCHAR2(150) := NULL;
1939: l_app_comp_id hxc_app_period_summary.approval_comp_id%type;
1940: l_app_id_temp hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1941: l_app_ovn_temp hxc_time_building_blocks.object_version_number%TYPE := NULL;
1942: l_app_status_temp hxc_time_building_blocks.approval_status%TYPE := NULL;
1943: l_notif_status_temp VARCHAR2(150) := NULL;

Line 1944: l_app_comp_id_temp hxc_app_period_summary.approval_comp_id%type;

1940: l_app_id_temp hxc_time_building_blocks.time_building_block_id%TYPE := NULL;
1941: l_app_ovn_temp hxc_time_building_blocks.object_version_number%TYPE := NULL;
1942: l_app_status_temp hxc_time_building_blocks.approval_status%TYPE := NULL;
1943: l_notif_status_temp VARCHAR2(150) := NULL;
1944: l_app_comp_id_temp hxc_app_period_summary.approval_comp_id%type;
1945: l_first_app_period BOOLEAN;
1946: l_time_category_id hxc_time_categories.time_category_id%TYPE := NULL;
1947: l_category_sequence hxc_app_period_summary.category_sequence%TYPE := NULL;
1948: l_creation_date DATE;

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

1943: l_notif_status_temp VARCHAR2(150) := NULL;
1944: l_app_comp_id_temp hxc_app_period_summary.approval_comp_id%type;
1945: l_first_app_period BOOLEAN;
1946: l_time_category_id hxc_time_categories.time_category_id%TYPE := NULL;
1947: l_category_sequence hxc_app_period_summary.category_sequence%TYPE := NULL;
1948: l_creation_date DATE;
1949: t_attributes hxc_time_attributes_api.timecard;
1950: l_tc_ap_link_exists VARCHAR2(50) := NULL;
1951: l_app_exists BOOLEAN;

Line 2037: --remove them from hxc_app_period_summary

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

Line 2039: hxc_app_period_summary_api.app_period_delete(l_app_id_temp);

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

Line 2100: hxc_app_period_summary_api.app_period_delete(l_app_id);

2096: --otherwise, it means, this app period still has details from
2097: --other timecards, can't delete the app period
2098: IF NOT has_details(l_app_id)
2099: THEN
2100: hxc_app_period_summary_api.app_period_delete(l_app_id);
2101: END IF;
2102: END IF;
2103:
2104: hr_utility.trace('Return(2)');

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

2294: if g_debug then
2295: hr_utility.trace('Generated the period');
2296: hr_utility.trace('app_id=' || l_app_id);
2297: hr_utility.trace('app_ovn=' || l_app_ovn);
2298: hr_utility.trace('Populating hxc_app_period_summary');
2299: end if;
2300: l_creation_date := get_creation_date(l_app_id, l_app_ovn);
2301:
2302: g_trace := l_proc || '80';

Line 2304: --populate hxc_app_period_summary with the new row

2300: l_creation_date := get_creation_date(l_app_id, l_app_ovn);
2301:
2302: g_trace := l_proc || '80';
2303:
2304: --populate hxc_app_period_summary with the new row
2305: hxc_app_period_summary_api.app_period_create(
2306: p_application_period_id => l_app_id
2307: ,p_application_period_ovn => l_app_ovn
2308: ,p_approval_status => 'SUBMITTED'

Line 2305: hxc_app_period_summary_api.app_period_create(

2301:
2302: g_trace := l_proc || '80';
2303:
2304: --populate hxc_app_period_summary with the new row
2305: hxc_app_period_summary_api.app_period_create(
2306: p_application_period_id => l_app_id
2307: ,p_application_period_ovn => l_app_ovn
2308: ,p_approval_status => 'SUBMITTED'
2309: ,p_time_recipient_id => p_time_recipient_id

Line 2329: UPDATE hxc_app_period_summary

2325: ELSE
2326:
2327: IF l_notification_status <> 'NOT_NOTIFIED' THEN
2328: -- don't create a new application period, but need to change status
2329: UPDATE hxc_app_period_summary
2330: SET notification_status = 'NOT_NOTIFIED'
2331: ,approval_comp_id = p_approval_comp.approval_comp_id
2332: WHERE application_period_id = l_app_id;
2333: elsif(p_approval_comp.approval_comp_id <> l_app_comp_id) then

Line 2336: UPDATE hxc_app_period_summary

2332: WHERE application_period_id = l_app_id;
2333: elsif(p_approval_comp.approval_comp_id <> l_app_comp_id) then
2334: -- do not create a new application period, but ensure the
2335: -- correct approval component id is used.
2336: UPDATE hxc_app_period_summary
2337: SET approval_comp_id = p_approval_comp.approval_comp_id
2338: WHERE application_period_id = l_app_id;
2339: END IF;
2340:

Line 3181: ,p_recipient_sequence IN hxc_app_period_summary.recipient_sequence%TYPE

3177: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
3178: ,p_period_start_date IN hxc_time_building_blocks.start_time%TYPE
3179: ,p_period_end_date IN hxc_time_building_blocks.stop_time%TYPE
3180: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
3181: ,p_recipient_sequence IN hxc_app_period_summary.recipient_sequence%TYPE
3182: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
3183: ,p_category_sequence IN hxc_app_period_summary.category_sequence%TYPE
3184: )
3185: RETURN VARCHAR2

Line 3183: ,p_category_sequence IN hxc_app_period_summary.category_sequence%TYPE

3179: ,p_period_end_date IN hxc_time_building_blocks.stop_time%TYPE
3180: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
3181: ,p_recipient_sequence IN hxc_app_period_summary.recipient_sequence%TYPE
3182: ,p_time_category_id IN hxc_time_categories.time_category_id%TYPE
3183: ,p_category_sequence IN hxc_app_period_summary.category_sequence%TYPE
3184: )
3185: RETURN VARCHAR2
3186: IS
3187:

Line 3194: ,p_recipient_sequence hxc_app_period_summary.recipient_sequence%TYPE

3190: ,p_resource_id hxc_time_building_blocks.resource_id%TYPE
3191: ,p_period_start_date hxc_time_building_blocks.start_time%TYPE
3192: ,p_period_end_date hxc_time_building_blocks.stop_time%TYPE
3193: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
3194: ,p_recipient_sequence hxc_app_period_summary.recipient_sequence%TYPE
3195: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
3196: ,p_category_sequence hxc_app_period_summary.category_sequence%TYPE
3197: )
3198: IS

Line 3196: ,p_category_sequence hxc_app_period_summary.category_sequence%TYPE

3192: ,p_period_end_date hxc_time_building_blocks.stop_time%TYPE
3193: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
3194: ,p_recipient_sequence hxc_app_period_summary.recipient_sequence%TYPE
3195: ,p_time_category_id hxc_time_categories.time_category_id%TYPE
3196: ,p_category_sequence hxc_app_period_summary.category_sequence%TYPE
3197: )
3198: IS
3199: SELECT aps.approval_status
3200: FROM hxc_app_period_summary aps

Line 3200: FROM hxc_app_period_summary aps

3196: ,p_category_sequence hxc_app_period_summary.category_sequence%TYPE
3197: )
3198: IS
3199: SELECT aps.approval_status
3200: FROM hxc_app_period_summary aps
3201: WHERE aps.resource_id = p_resource_id
3202: AND p_date BETWEEN aps.start_time AND aps.stop_time
3203: AND aps.approval_status <> 'APPROVED'
3204: AND (

Line 3393: p_resource_id in hxc_app_period_summary.resource_id%type

3389: and tc.object_version_number = p_ovn;
3390:
3391:
3392: CURSOR csr_get_appl_periods(
3393: p_resource_id in hxc_app_period_summary.resource_id%type
3394: ,p_timecard_id in hxc_timecard_summary.timecard_id%type
3395: )
3396: IS
3397: select aps.application_period_id,

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

Line 3419: from hxc_app_period_summary

3415: p_period_id number
3416: )
3417: IS
3418: select 'N'
3419: from hxc_app_period_summary
3420: where application_period_id = p_period_id
3421: and approval_status = 'SUBMITTED'
3422: and notification_status = 'NOT_NOTIFIED';
3423:

Line 3673: update hxc_app_period_summary

3669: SELECT hxc_approval_item_key_s.nextval
3670: INTO l_item_key
3671: FROM dual;
3672:
3673: update hxc_app_period_summary
3674: set notification_status = 'NOTIFIED',
3675: approval_item_type = itemtype,
3676: approval_process_name = l_process_name,
3677: approval_item_key = l_item_key

Line 3856: update hxc_app_period_summary

3852: hr_utility.trace('Before Update');
3853: hr_utility.set_location(l_proc, 360);
3854: end if;
3855:
3856: update hxc_app_period_summary
3857: set notification_status = 'NOTIFIED'
3858: where application_period_id = l_appl_period_bb_id
3859: and application_period_ovn = l_appl_period_bb_ovn;
3860:

Line 4315: from hxc_app_period_summary

4311:
4312: cursor c_appr_comp(p_app_bb_id number,p_app_bb_ovn number)
4313: is
4314: select approval_comp_id
4315: from hxc_app_period_summary
4316: where application_period_id = p_app_bb_id
4317: and application_period_ovn = p_app_bb_ovn;
4318:
4319: cursor c_app_comp_pm(p_bb_id number,p_bb_ovn number)