APPS.HXC_TIMEKEEPER_PROCESS dependencies on HXC_LOCK_API

Line 931: hxc_lock_api.request_lock (

927:
928: l_row_id := NULL;
929: l_row_lock_id := NULL;
930: l_tc_lock_success := 'FALSE';
931: hxc_lock_api.request_lock (
932: p_process_locker_type => l_process_lock_type,
933: p_resource_id => resource_info.person_id,
934: p_start_time => p_start_period,
935: p_stop_time => p_end_period + g_one_day,

Line 3112: hxc_lock_api.request_lock (

3108:
3109: l_row_id := NULL;
3110: l_row_lock_id := NULL;
3111: l_tc_lock_success := 'FALSE';
3112: hxc_lock_api.request_lock (
3113: p_process_locker_type => l_process_lock_type,
3114: p_resource_id => resource_info.person_id,
3115: p_start_time => p_start_period,
3116: p_stop_time => p_end_period + g_one_day,

Line 4833: hxc_lock_api.release_lock (

4829: p_resource_id => g_submit_table (l_index).resource_id,
4830: p_submission_id => l_max_submission_id
4831: );
4832: p_insert := TRUE;
4833: hxc_lock_api.release_lock (
4834: p_row_lock_id => g_submit_table (l_index).row_lock_id,
4835: p_process_locker_type => 'PUI_TIMEKEEPER_ACTION',
4836: p_transaction_lock_id => p_trx_id,
4837: p_released_success => l_success

Line 4847: hxc_lock_api.request_lock (

4843: p_timecard_id => NULL,
4844: p_row_lock_id => g_submit_table (l_index).row_lock_id,
4845: p_operation => 'N'
4846: );
4847: hxc_lock_api.request_lock (
4848: p_process_locker_type => 'PUI_TIMEKEEPER_ACTION',
4849: p_resource_id => g_submit_table (l_index).resource_id,
4850: p_start_time => p_start_time,
4851: p_stop_time => p_stop_time + g_one_day,

Line 5150: l_lock_row_id := hxc_lock_api.check_lock (

5146: p_timecard_index_info => l_timecard_index_info,
5147: p_timecard_id => l_timecard_id
5148: );
5149: --check the lock
5150: l_lock_row_id := hxc_lock_api.check_lock (
5151: p_process_locker_type => l_process_lock_type,
5152: p_transaction_lock_id => l_lock_trx_id,
5153: p_resource_id => c_resource.resource_id
5154: );

Line 5177: hxc_lock_api.release_lock (

5173: /*ADVICE(4482): FETCH into a list of variables instead of a record [204] */
5174:
5175: CLOSE crs_employee_info;
5176: fnd_file.put_line (fnd_file.LOG, RTRIM (l_empnumber) || ' - ' || RTRIM (l_empname));
5177: hxc_lock_api.release_lock (
5178: p_row_lock_id => l_lock_row_id,
5179: p_process_locker_type => l_process_lock_type,
5180: p_transaction_lock_id => l_lock_trx_id,
5181: p_resource_id => NULL,

Line 5192: hxc_lock_api.release_lock (

5188: );
5189: ELSIF NVL (l_timecard_status, 'xx') = 'xx' THEN
5190: l_timecard.DELETE;
5191: l_attributes.DELETE;
5192: hxc_lock_api.release_lock (
5193: p_row_lock_id => l_lock_row_id,
5194: p_process_locker_type => l_process_lock_type,
5195: p_transaction_lock_id => l_lock_trx_id,
5196: p_resource_id => NULL,

Line 5207: hxc_lock_api.request_lock (

5203: );
5204: ELSE
5205: --if lock is removed again request lock
5206: IF l_lock_row_id IS NULL THEN
5207: hxc_lock_api.request_lock (
5208: p_process_locker_type => l_process_lock_type,
5209: p_resource_id => c_resource.resource_id,
5210: p_start_time => fnd_date.canonical_to_date (p_start_period),
5211: p_stop_time => fnd_date.canonical_to_date (p_end_period) + g_one_day,

Line 5267: hxc_lock_api.release_lock (

5263: p_tk_notify_to => l_notify_to,
5264: p_tk_notify_type => l_notify_type
5265: );
5266: l_relased_success := FALSE;
5267: hxc_lock_api.release_lock (
5268: p_row_lock_id => l_lock_row_id,
5269: p_process_locker_type => l_process_lock_type,
5270: p_transaction_lock_id => l_lock_trx_id,
5271: p_resource_id => NULL,