APPS.HXC_TIMEKEEPER_PROCESS dependencies on HXC_LOCK_API

Line 983: hxc_lock_api.request_lock (

979:
980: l_row_id := NULL;
981: l_row_lock_id := NULL;
982: l_tc_lock_success := 'FALSE';
983: hxc_lock_api.request_lock (
984: p_process_locker_type => l_process_lock_type,
985: p_resource_id => resource_info.person_id,
986: p_start_time => p_start_period,
987: p_stop_time => p_end_period + g_one_day,

Line 3256: hxc_lock_api.request_lock (

3252:
3253: l_row_id := NULL;
3254: l_row_lock_id := NULL;
3255: l_tc_lock_success := 'FALSE';
3256: hxc_lock_api.request_lock (
3257: p_process_locker_type => l_process_lock_type,
3258: p_resource_id => resource_info.person_id,
3259: p_start_time => p_start_period,
3260: p_stop_time => p_end_period + g_one_day,

Line 6185: hxc_lock_api.release_lock (

6181: p_resource_id => g_submit_table (l_index).resource_id,
6182: p_submission_id => l_max_submission_id
6183: );
6184: p_insert := TRUE;
6185: hxc_lock_api.release_lock (
6186: p_row_lock_id => g_submit_table (l_index).row_lock_id,
6187: p_process_locker_type => 'PUI_TIMEKEEPER_ACTION',
6188: p_transaction_lock_id => p_trx_id,
6189: p_released_success => l_success

Line 6199: hxc_lock_api.request_lock (

6195: p_timecard_id => NULL,
6196: p_row_lock_id => g_submit_table (l_index).row_lock_id,
6197: p_operation => 'N'
6198: );
6199: hxc_lock_api.request_lock (
6200: p_process_locker_type => 'PUI_TIMEKEEPER_ACTION',
6201: p_resource_id => g_submit_table (l_index).resource_id,
6202: p_start_time => p_start_time,
6203: p_stop_time => p_stop_time + g_one_day,

Line 6502: l_lock_row_id := hxc_lock_api.check_lock (

6498: p_timecard_index_info => l_timecard_index_info,
6499: p_timecard_id => l_timecard_id
6500: );
6501: --check the lock
6502: l_lock_row_id := hxc_lock_api.check_lock (
6503: p_process_locker_type => l_process_lock_type,
6504: p_transaction_lock_id => l_lock_trx_id,
6505: p_resource_id => c_resource.resource_id
6506: );

Line 6529: hxc_lock_api.release_lock (

6525: /*ADVICE(4482): FETCH into a list of variables instead of a record [204] */
6526:
6527: CLOSE crs_employee_info;
6528: fnd_file.put_line (fnd_file.LOG, RTRIM (l_empnumber) || ' - ' || RTRIM (l_empname));
6529: hxc_lock_api.release_lock (
6530: p_row_lock_id => l_lock_row_id,
6531: p_process_locker_type => l_process_lock_type,
6532: p_transaction_lock_id => l_lock_trx_id,
6533: p_resource_id => NULL,

Line 6544: hxc_lock_api.release_lock (

6540: );
6541: ELSIF NVL (l_timecard_status, 'xx') = 'xx' THEN
6542: l_timecard.DELETE;
6543: l_attributes.DELETE;
6544: hxc_lock_api.release_lock (
6545: p_row_lock_id => l_lock_row_id,
6546: p_process_locker_type => l_process_lock_type,
6547: p_transaction_lock_id => l_lock_trx_id,
6548: p_resource_id => NULL,

Line 6559: hxc_lock_api.request_lock (

6555: );
6556: ELSE
6557: --if lock is removed again request lock
6558: IF l_lock_row_id IS NULL THEN
6559: hxc_lock_api.request_lock (
6560: p_process_locker_type => l_process_lock_type,
6561: p_resource_id => c_resource.resource_id,
6562: p_start_time => fnd_date.canonical_to_date (p_start_period),
6563: p_stop_time => fnd_date.canonical_to_date (p_end_period) + g_one_day,

Line 6619: hxc_lock_api.release_lock (

6615: p_tk_notify_to => l_notify_to,
6616: p_tk_notify_type => l_notify_type
6617: );
6618: l_relased_success := FALSE;
6619: hxc_lock_api.release_lock (
6620: p_row_lock_id => l_lock_row_id,
6621: p_process_locker_type => l_process_lock_type,
6622: p_transaction_lock_id => l_lock_trx_id,
6623: p_resource_id => NULL,