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 896: l_messages HXC_MESSAGE_TABLE_TYPE;

892: l_locker_type_req_id NUMBER;
893: l_lock_date DATE;
894: l_locked BOOLEAN := FALSE;
895: l_row_id ROWID;
896: l_messages HXC_MESSAGE_TABLE_TYPE;
897:
898: BEGIN
899:
900: l_locker_type_req_id

Line 977: l_messages HXC_MESSAGE_TABLE_TYPE;

973: PROCEDURE release_lock
974: (p_row_lock_id IN ROWID)
975: IS
976:
977: l_messages HXC_MESSAGE_TABLE_TYPE;
978: l_released_success BOOLEAN;
979:
980: BEGIN
981:

Line 1003: l_messages HXC_MESSAGE_TABLE_TYPE;

999: ,p_transaction_lock_id IN NUMBER DEFAULT NULL
1000: ,p_released_success OUT NOCOPY BOOLEAN
1001: ) IS
1002:
1003: l_messages HXC_MESSAGE_TABLE_TYPE;
1004:
1005: BEGIN
1006:
1007:

Line 1030: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

1026: ,p_start_time IN DATE DEFAULT NULL
1027: ,p_stop_time IN DATE DEFAULT NULL
1028: ,p_time_building_block_id IN NUMBER DEFAULT NULL
1029: ,p_time_building_block_ovn IN NUMBER DEFAULT NULL
1030: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
1031: ,p_released_success OUT NOCOPY BOOLEAN
1032: ) IS
1033:
1034: cursor c_timecard_info(p_tbb_id number, p_tbb_ovn number) is