APPS.HXC_LOCK_API dependencies on HXC_MESSAGE_TABLE_TYPE

Line 20: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

16: ,p_time_building_block_id IN NUMBER
17: ,p_time_building_block_ovn IN NUMBER
18: ,p_transaction_lock_id IN NUMBER DEFAULT NULL
19: ,p_expiration_time IN NUMBER DEFAULT hxc_lock_util.c_ss_expiration_time
20: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
21: ,p_row_lock_id IN OUT NOCOPY ROWID
22: ,p_locked_success OUT NOCOPY VARCHAR2
23: ) IS
24:

Line 55: -- forms since we cannot passed the HXC_MESSAGE_TABLE_TYPE

51: -- ----------------------------------------------------------------------------
52: -- |---------------------------< request_lock > ----------------------|
53: -- ----------------------------------------------------------------------------
54: -- this request lock is going to be used in timekeeper
55: -- forms since we cannot passed the HXC_MESSAGE_TABLE_TYPE
56: -- as a type
57:
58:
59: PROCEDURE request_lock

Line 73: l_messages HXC_MESSAGE_TABLE_TYPE;

69: ,p_row_lock_id IN OUT NOCOPY ROWID
70: ,p_locked_success OUT NOCOPY BOOLEAN
71: )IS
72:
73: l_messages HXC_MESSAGE_TABLE_TYPE;
74:
75: BEGIN
76:
77: l_messages := hxc_message_table_type ();

Line 77: l_messages := hxc_message_table_type ();

73: l_messages HXC_MESSAGE_TABLE_TYPE;
74:
75: BEGIN
76:
77: l_messages := hxc_message_table_type ();
78:
79:
80: request_lock
81: (p_process_locker_type => p_process_locker_type

Line 114: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

110: ,p_time_building_block_id IN NUMBER
111: ,p_time_building_block_ovn IN NUMBER
112: ,p_transaction_lock_id IN NUMBER DEFAULT NULL
113: ,p_expiration_time IN NUMBER DEFAULT hxc_lock_util.c_ss_expiration_time
114: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
115: ,p_row_lock_id IN OUT NOCOPY ROWID
116: ,p_locked_success OUT NOCOPY BOOLEAN
117: ) IS
118:

Line 449: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

445: ,p_start_time IN OUT NOCOPY DATE
446: ,p_stop_time IN OUT NOCOPY DATE
447: ,p_time_building_block_id IN NUMBER
448: ,p_time_building_block_ovn IN NUMBER
449: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
450: ,p_timecard_locked OUT NOCOPY BOOLEAN
451: ,p_time_building_block_scope OUT NOCOPY VARCHAR2
452: ,p_process_locker_type_id OUT NOCOPY NUMBER
453: )IS

Line 877: l_messages HXC_MESSAGE_TABLE_TYPE;

873: l_locker_type_req_id NUMBER;
874: l_lock_date DATE;
875: l_locked BOOLEAN := FALSE;
876: l_row_id ROWID;
877: l_messages HXC_MESSAGE_TABLE_TYPE;
878:
879: BEGIN
880:
881: l_locker_type_req_id

Line 958: l_messages HXC_MESSAGE_TABLE_TYPE;

954: PROCEDURE release_lock
955: (p_row_lock_id IN ROWID)
956: IS
957:
958: l_messages HXC_MESSAGE_TABLE_TYPE;
959: l_released_success BOOLEAN;
960:
961: BEGIN
962:

Line 984: l_messages HXC_MESSAGE_TABLE_TYPE;

980: ,p_transaction_lock_id IN NUMBER DEFAULT NULL
981: ,p_released_success OUT NOCOPY BOOLEAN
982: ) IS
983:
984: l_messages HXC_MESSAGE_TABLE_TYPE;
985:
986: BEGIN
987:
988:

Line 1011: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

1007: ,p_start_time IN DATE DEFAULT NULL
1008: ,p_stop_time IN DATE DEFAULT NULL
1009: ,p_time_building_block_id IN NUMBER DEFAULT NULL
1010: ,p_time_building_block_ovn IN NUMBER DEFAULT NULL
1011: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
1012: ,p_released_success OUT NOCOPY BOOLEAN
1013: ) IS
1014:
1015: cursor c_timecard_info(p_tbb_id number, p_tbb_ovn number) is