DBA Data[Home] [Help]

APPS.HXC_LOCK_UTIL dependencies on HXC_MESSAGE_TABLE_TYPE

Line 17: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

13: ,p_stop_time IN OUT NOCOPY DATE
14: ,p_time_building_block_id IN NUMBER
15: ,p_time_building_block_ovn IN NUMBER
16: ,p_time_scope IN OUT NOCOPY VARCHAR2
17: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
18: ,p_passed_check OUT NOCOPY BOOLEAN
19: ) IS
20:
21: cursor c_timecard_info is

Line 309: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

305: -- |---------------------------< check_grant > ----------------------|
306: -- ----------------------------------------------------------------------------
307: PROCEDURE check_grant(p_locker_type_owner_id IN NUMBER
308: ,p_locker_type_requestor_id IN NUMBER
309: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
310: ,p_grant_lock OUT NOCOPY VARCHAR2)
311: IS
312:
313: cursor c_grant_lock (p_locker_type_owner_id NUMBER,

Line 386: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

382: PROCEDURE validate_lock
383: (p_locker_type_owner_id IN OUT NOCOPY NUMBER
384: ,p_locker_type_requestor_id IN OUT NOCOPY NUMBER
385: ,p_lock_date IN OUT NOCOPY DATE
386: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
387: ,p_valid_lock IN OUT NOCOPY BOOLEAN) IS
388:
389: l_grant VARCHAR2(1);
390:

Line 485: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE) IS

481: -- ----------------------------------------------------------------------------
482: PROCEDURE delete_lock(p_rowid IN ROWID
483: ,p_locker_type_id IN NUMBER
484: ,p_process_locker_type IN VARCHAR2
485: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE) IS
486:
487: PRAGMA AUTONOMOUS_TRANSACTION;
488:
489: cursor c_rowid_info is

Line 581: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE)

577: -- ----------------------------------------------------------------------------
578: PROCEDURE delete_transaction_lock
579: (p_transaction_lock_id IN NUMBER
580: ,p_process_locker_type IN VARCHAR2
581: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE)
582: IS
583:
584: PRAGMA AUTONOMOUS_TRANSACTION;
585:

Line 609: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE)

605: -- |---------------------------< get_locker_type_req_id > ----------------------|
606: -- ----------------------------------------------------------------------------
607: FUNCTION get_locker_type_req_id
608: (p_process_locker_type IN VARCHAR
609: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE)
610: RETURN NUMBER IS
611:
612:
613: cursor c_locker_type_requestor (p_locker_type VARCHAR2

Line 722: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

718: ,p_process_locker_type IN VARCHAR2
719: ,p_resource_id IN NUMBER
720: ,p_time_building_block_id IN NUMBER
721: ,p_time_building_block_ovn IN NUMBER
722: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
723: ,p_row_locked OUT NOCOPY BOOLEAN)
724: IS
725:
726: cursor c_lock (p_tbb_id number, p_tbb_ovn number) is

Line 912: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

908: ,p_resource_id IN NUMBER
909: ,p_process_id IN NUMBER
910: ,p_attribute2 IN VARCHAR2
911: ,p_rowid IN ROWID
912: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
913: ,p_row_locked OUT NOCOPY BOOLEAN)
914: IS
915:
916: cursor c_full_name is