464: ,p_stop_time
465: ,p_time_building_block_id
466: ,p_time_building_block_ovn
467: ,sysdate + (1/24/60)*p_expiration_time
468: ,fnd_global.user_id
469: ,to_char(fnd_global.employee_id)
470: ,to_char(fnd_global.session_id)
471: ,p_transaction_lock_id
472: ) RETURNING ROWID into p_row_lock_id;
465: ,p_time_building_block_id
466: ,p_time_building_block_ovn
467: ,sysdate + (1/24/60)*p_expiration_time
468: ,fnd_global.user_id
469: ,to_char(fnd_global.employee_id)
470: ,to_char(fnd_global.session_id)
471: ,p_transaction_lock_id
472: ) RETURNING ROWID into p_row_lock_id;
473:
466: ,p_time_building_block_ovn
467: ,sysdate + (1/24/60)*p_expiration_time
468: ,fnd_global.user_id
469: ,to_char(fnd_global.employee_id)
470: ,to_char(fnd_global.session_id)
471: ,p_transaction_lock_id
472: ) RETURNING ROWID into p_row_lock_id;
473:
474: COMMIT;
782: --OR p_process_locker_type = c_ss_timecard_view
783: THEN
784: l_locked_same_user_session
785: := check_session
786: (p_current_session_id => fnd_global.session_id
787: ,p_current_user_id => fnd_global.user_id
788: ,p_current_resource_id => p_resource_id
789: ,p_lock_session_id => to_number(csr_lock.attribute2)
790: ,p_lock_user_id => csr_lock.process_id
783: THEN
784: l_locked_same_user_session
785: := check_session
786: (p_current_session_id => fnd_global.session_id
787: ,p_current_user_id => fnd_global.user_id
788: ,p_current_resource_id => p_resource_id
789: ,p_lock_session_id => to_number(csr_lock.attribute2)
790: ,p_lock_user_id => csr_lock.process_id
791: ,p_lock_resource_id => csr_lock.resource_id);
794: END IF;
795: /*
796:
797: if g_debug then
798: hr_utility.trace('p_current_session_id '||fnd_global.session_id);
799: hr_utility.trace('p_current_user_id '||fnd_global.user_id);
800: hr_utility.trace('p_lock_session_id '||to_number(csr_lock.attribute2));
801: hr_utility.trace('p_lock_user_id '||csr_lock.process_id);
802: end if;
795: /*
796:
797: if g_debug then
798: hr_utility.trace('p_current_session_id '||fnd_global.session_id);
799: hr_utility.trace('p_current_user_id '||fnd_global.user_id);
800: hr_utility.trace('p_lock_session_id '||to_number(csr_lock.attribute2));
801: hr_utility.trace('p_lock_user_id '||csr_lock.process_id);
802: end if;
803:
950: OR p_process_locker_type = c_ss_timecard_view
951: THEN
952: l_locked_same_user_session
953: := check_session
954: (p_current_session_id => fnd_global.session_id
955: ,p_current_user_id => fnd_global.user_id
956: ,p_current_resource_id => p_resource_id
957: ,p_lock_session_id => to_number(p_attribute2)
958: ,p_lock_user_id => p_process_id
951: THEN
952: l_locked_same_user_session
953: := check_session
954: (p_current_session_id => fnd_global.session_id
955: ,p_current_user_id => fnd_global.user_id
956: ,p_current_resource_id => p_resource_id
957: ,p_lock_session_id => to_number(p_attribute2)
958: ,p_lock_user_id => p_process_id
959: ,p_lock_resource_id => null);
963: END IF;
964: /*
965:
966: if g_debug then
967: hr_utility.trace('p_current_session_id '||fnd_global.session_id);
968: hr_utility.trace('p_current_user_id '||fnd_global.user_id);
969: hr_utility.trace('p_lock_session_id '||to_number(p_attribute2));
970: hr_utility.trace('p_lock_user_id '||p_process_id);
971: end if;
964: /*
965:
966: if g_debug then
967: hr_utility.trace('p_current_session_id '||fnd_global.session_id);
968: hr_utility.trace('p_current_user_id '||fnd_global.user_id);
969: hr_utility.trace('p_lock_session_id '||to_number(p_attribute2));
970: hr_utility.trace('p_lock_user_id '||p_process_id);
971: end if;
972: