eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_DEPOSIT_CHECKS dependencies on HXC_TIMECARD

Line 82: hxc_timecard_message_helper.addErrorToCollection

78: ('TC_W_TMPLT_DFLT_VAL_USR'
79: ,1
80: ,l_pref_value);
81: if ( l_exists <> 0 ) THEN
82: hxc_timecard_message_helper.addErrorToCollection
83: (p_messages
84: ,'HXC_CANT_DEL_TEMPL'
85: ,hxc_timecard.c_error
86: ,null

Line 85: ,hxc_timecard.c_error

81: if ( l_exists <> 0 ) THEN
82: hxc_timecard_message_helper.addErrorToCollection
83: (p_messages
84: ,'HXC_CANT_DEL_TEMPL'
85: ,hxc_timecard.c_error
86: ,null
87: ,null
88: ,hxc_timecard.c_hxc
89: ,null

Line 88: ,hxc_timecard.c_hxc

84: ,'HXC_CANT_DEL_TEMPL'
85: ,hxc_timecard.c_error
86: ,null
87: ,null
88: ,hxc_timecard.c_hxc
89: ,null
90: ,null
91: ,null
92: ,null

Line 100: hxc_timecard_message_helper.addErrorToCollection

96: ('TC_W_TMPLT_DFLT_VAL_ADMIN'
97: ,1
98: ,l_pref_value);
99: if ( l_exists <> 0 ) THEN
100: hxc_timecard_message_helper.addErrorToCollection
101: (p_messages
102: ,'HXC_CANT_DEL_TEMPL'
103: ,hxc_timecard.c_error
104: ,null

Line 103: ,hxc_timecard.c_error

99: if ( l_exists <> 0 ) THEN
100: hxc_timecard_message_helper.addErrorToCollection
101: (p_messages
102: ,'HXC_CANT_DEL_TEMPL'
103: ,hxc_timecard.c_error
104: ,null
105: ,null
106: ,hxc_timecard.c_hxc
107: ,null

Line 106: ,hxc_timecard.c_hxc

102: ,'HXC_CANT_DEL_TEMPL'
103: ,hxc_timecard.c_error
104: ,null
105: ,null
106: ,hxc_timecard.c_hxc
107: ,null
108: ,null
109: ,null
110: ,null

Line 118: hxc_timecard_message_helper.addErrorToCollection

114: else
115:
116: -- Public Template Specific
117:
118: hxc_timecard_message_helper.addErrorToCollection
119: (p_messages
120: ,'HXC_CANT_DEL_PUB_TEMPL'
121: ,hxc_timecard.c_error
122: ,null

Line 121: ,hxc_timecard.c_error

117:
118: hxc_timecard_message_helper.addErrorToCollection
119: (p_messages
120: ,'HXC_CANT_DEL_PUB_TEMPL'
121: ,hxc_timecard.c_error
122: ,null
123: ,'GROUPS&'||l_attached_public_temp_grps
124: ,hxc_timecard.c_hxc
125: ,null

Line 124: ,hxc_timecard.c_hxc

120: ,'HXC_CANT_DEL_PUB_TEMPL'
121: ,hxc_timecard.c_error
122: ,null
123: ,'GROUPS&'||l_attached_public_temp_grps
124: ,hxc_timecard.c_hxc
125: ,null
126: ,null
127: ,null
128: ,null

Line 181: hxc_timecard_message_helper.addErrorToCollection

177: -- We must have at least one block to deposit
178: --
179: if(p_blocks.count <1) then
180:
181: hxc_timecard_message_helper.addErrorToCollection
182: (p_messages
183: ,'HXC_XXXXX_NO_BLOCKS'
184: ,hxc_timecard.c_error
185: ,null

Line 184: ,hxc_timecard.c_error

180:
181: hxc_timecard_message_helper.addErrorToCollection
182: (p_messages
183: ,'HXC_XXXXX_NO_BLOCKS'
184: ,hxc_timecard.c_error
185: ,null
186: ,null
187: ,hxc_timecard.c_hxc
188: ,null

Line 187: ,hxc_timecard.c_hxc

183: ,'HXC_XXXXX_NO_BLOCKS'
184: ,hxc_timecard.c_error
185: ,null
186: ,null
187: ,hxc_timecard.c_hxc
188: ,null
189: ,null
190: ,null
191: ,null

Line 200: if (NOT ((p_deposit_mode=hxc_timecard.c_submit) OR (p_deposit_mode=hxc_timecard.c_save) OR p_deposit_mode=hxc_timecard.c_audit)) then

196: --
197: -- The deposit mode must be SUBMIT, SAVE or AUDIT
198: -- (others not currently supported)
199: --
200: if (NOT ((p_deposit_mode=hxc_timecard.c_submit) OR (p_deposit_mode=hxc_timecard.c_save) OR p_deposit_mode=hxc_timecard.c_audit)) then
201:
202: hxc_timecard_message_helper.addErrorToCollection
203: (p_messages
204: ,'HXC_XXXXX_INVALID_DEP_MODE'

Line 202: hxc_timecard_message_helper.addErrorToCollection

198: -- (others not currently supported)
199: --
200: if (NOT ((p_deposit_mode=hxc_timecard.c_submit) OR (p_deposit_mode=hxc_timecard.c_save) OR p_deposit_mode=hxc_timecard.c_audit)) then
201:
202: hxc_timecard_message_helper.addErrorToCollection
203: (p_messages
204: ,'HXC_XXXXX_INVALID_DEP_MODE'
205: ,hxc_timecard.c_error
206: ,null

Line 205: ,hxc_timecard.c_error

201:
202: hxc_timecard_message_helper.addErrorToCollection
203: (p_messages
204: ,'HXC_XXXXX_INVALID_DEP_MODE'
205: ,hxc_timecard.c_error
206: ,null
207: ,'MODE&'||p_deposit_mode
208: ,hxc_timecard.c_hxc
209: ,null

Line 208: ,hxc_timecard.c_hxc

204: ,'HXC_XXXXX_INVALID_DEP_MODE'
205: ,hxc_timecard.c_error
206: ,null
207: ,'MODE&'||p_deposit_mode
208: ,hxc_timecard.c_hxc
209: ,null
210: ,null
211: ,null
212: ,null

Line 222: hxc_timecard_message_helper.addErrorToCollection

218: -- We must have a Y or N value for the template
219: --
220: if (NOT ((p_template='Y') OR (p_template='N'))) then
221:
222: hxc_timecard_message_helper.addErrorToCollection
223: (p_messages
224: ,'HXC_XXXXX_INVALID_TEMPLATE'
225: ,hxc_timecard.c_error
226: ,null

Line 225: ,hxc_timecard.c_error

221:
222: hxc_timecard_message_helper.addErrorToCollection
223: (p_messages
224: ,'HXC_XXXXX_INVALID_TEMPLATE'
225: ,hxc_timecard.c_error
226: ,null
227: ,'VALUE&'||p_template
228: ,hxc_timecard.c_hxc
229: ,null

Line 228: ,hxc_timecard.c_hxc

224: ,'HXC_XXXXX_INVALID_TEMPLATE'
225: ,hxc_timecard.c_error
226: ,null
227: ,'VALUE&'||p_template
228: ,hxc_timecard.c_hxc
229: ,null
230: ,null
231: ,null
232: ,null

Line 237: if ((p_template='Y') AND (p_deposit_mode = hxc_timecard.c_save)) then

233: );
234:
235: end if;
236:
237: if ((p_template='Y') AND (p_deposit_mode = hxc_timecard.c_save)) then
238:
239: hxc_timecard_message_helper.addErrorToCollection
240: (p_messages
241: ,'HXC_XXXXX_INVALID_DEP_MODE'

Line 239: hxc_timecard_message_helper.addErrorToCollection

235: end if;
236:
237: if ((p_template='Y') AND (p_deposit_mode = hxc_timecard.c_save)) then
238:
239: hxc_timecard_message_helper.addErrorToCollection
240: (p_messages
241: ,'HXC_XXXXX_INVALID_DEP_MODE'
242: ,hxc_timecard.c_error
243: ,null

Line 242: ,hxc_timecard.c_error

238:
239: hxc_timecard_message_helper.addErrorToCollection
240: (p_messages
241: ,'HXC_XXXXX_INVALID_DEP_MODE'
242: ,hxc_timecard.c_error
243: ,null
244: ,'MODE&'||p_deposit_mode
245: ,hxc_timecard.c_hxc
246: ,null

Line 245: ,hxc_timecard.c_hxc

241: ,'HXC_XXXXX_INVALID_DEP_MODE'
242: ,hxc_timecard.c_error
243: ,null
244: ,'MODE&'||p_deposit_mode
245: ,hxc_timecard.c_hxc
246: ,null
247: ,null
248: ,null
249: ,null

Line 318: hxc_timecard_message_helper.addErrorToCollection

314: l_att_index:=p_attributes.next(l_att_index);
315: END LOOP;
316:
317: IF l_found THEN
318: hxc_timecard_message_helper.addErrorToCollection
319: (p_messages => l_missing_reasons
320: ,p_message_name => 'HXC_REASON_NOT_ENTERED'
321: ,p_message_tokens => NULL
322: ,p_message_level => hxc_timecard.c_error

Line 322: ,p_message_level => hxc_timecard.c_error

318: hxc_timecard_message_helper.addErrorToCollection
319: (p_messages => l_missing_reasons
320: ,p_message_name => 'HXC_REASON_NOT_ENTERED'
321: ,p_message_tokens => NULL
322: ,p_message_level => hxc_timecard.c_error
323: ,p_message_field => NULL
324: ,p_application_short_name => hxc_timecard.c_hxc
325: ,p_time_building_block_id => NULL
326: ,p_time_building_block_ovn => NULL

Line 324: ,p_application_short_name => hxc_timecard.c_hxc

320: ,p_message_name => 'HXC_REASON_NOT_ENTERED'
321: ,p_message_tokens => NULL
322: ,p_message_level => hxc_timecard.c_error
323: ,p_message_field => NULL
324: ,p_application_short_name => hxc_timecard.c_hxc
325: ,p_time_building_block_id => NULL
326: ,p_time_building_block_ovn => NULL
327: ,p_time_attribute_id => NULL
328: ,p_time_attribute_ovn => NULL

Line 709: ,p_details in hxc_timecard.block_list

705: End inactive_detail;
706:
707: Procedure check_start_stop_time
708: (p_blocks in hxc_block_table_type
709: ,p_details in hxc_timecard.block_list
710: ,p_messages in out nocopy hxc_message_table_type
711: ,p_validate_on_save in hxc_pref_hierarchies.attribute1%type
712: ) is
713: l_index number;

Line 720: if(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_index)))) then

716:
717: l_index := p_details.first;
718: Loop
719: Exit When Not p_details.exists(l_index);
720: if(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_index)))) then
721:
722: IF p_blocks(p_details(l_index)).start_time is not null and
723: p_blocks(p_details(l_index)).stop_time is null and
724: (p_blocks(p_details(l_index)).approval_status = hxc_timecard.c_submitted_status

Line 724: (p_blocks(p_details(l_index)).approval_status = hxc_timecard.c_submitted_status

720: if(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_index)))) then
721:
722: IF p_blocks(p_details(l_index)).start_time is not null and
723: p_blocks(p_details(l_index)).stop_time is null and
724: (p_blocks(p_details(l_index)).approval_status = hxc_timecard.c_submitted_status
725: or
726: p_validate_on_save = hxc_timecard.c_yes
727: )
728: THEN

Line 726: p_validate_on_save = hxc_timecard.c_yes

722: IF p_blocks(p_details(l_index)).start_time is not null and
723: p_blocks(p_details(l_index)).stop_time is null and
724: (p_blocks(p_details(l_index)).approval_status = hxc_timecard.c_submitted_status
725: or
726: p_validate_on_save = hxc_timecard.c_yes
727: )
728: THEN
729:
730: hxc_timecard_message_helper.addErrorToCollection

Line 730: hxc_timecard_message_helper.addErrorToCollection

726: p_validate_on_save = hxc_timecard.c_yes
727: )
728: THEN
729:
730: hxc_timecard_message_helper.addErrorToCollection
731: (p_messages => p_messages
732: ,p_message_name => 'HXC_NULL_STOP_SUBMIT'
733: ,p_message_tokens => NULL
734: ,p_message_level => hxc_timecard.c_error

Line 734: ,p_message_level => hxc_timecard.c_error

730: hxc_timecard_message_helper.addErrorToCollection
731: (p_messages => p_messages
732: ,p_message_name => 'HXC_NULL_STOP_SUBMIT'
733: ,p_message_tokens => NULL
734: ,p_message_level => hxc_timecard.c_error
735: ,p_message_field => NULL
736: ,p_application_short_name => hxc_timecard.c_hxc
737: ,p_time_building_block_id => p_blocks(p_details(l_index)).time_building_block_id
738: ,p_time_building_block_ovn => NULL

Line 736: ,p_application_short_name => hxc_timecard.c_hxc

732: ,p_message_name => 'HXC_NULL_STOP_SUBMIT'
733: ,p_message_tokens => NULL
734: ,p_message_level => hxc_timecard.c_error
735: ,p_message_field => NULL
736: ,p_application_short_name => hxc_timecard.c_hxc
737: ,p_time_building_block_id => p_blocks(p_details(l_index)).time_building_block_id
738: ,p_time_building_block_ovn => NULL
739: ,p_time_attribute_id => NULL
740: ,p_time_attribute_ovn => NULL

Line 752: ,p_days in hxc_timecard.block_list

748:
749:
750: Procedure find_detail_date_extremes
751: (p_blocks in hxc_block_table_type
752: ,p_days in hxc_timecard.block_list
753: ,p_details in hxc_timecard.block_list
754: ,p_early_detail in out nocopy date
755: ,p_late_detail in out nocopy date
756: ) is

Line 753: ,p_details in hxc_timecard.block_list

749:
750: Procedure find_detail_date_extremes
751: (p_blocks in hxc_block_table_type
752: ,p_days in hxc_timecard.block_list
753: ,p_details in hxc_timecard.block_list
754: ,p_early_detail in out nocopy date
755: ,p_late_detail in out nocopy date
756: ) is
757: l_index number;

Line 766: if(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_index)))) then

762: l_index := p_details.first;
763:
764: Loop
765: Exit When Not p_details.exists(l_index);
766: if(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_index)))) then
767: l_detail_date := trunc(
768: hxc_timecard_block_utils.date_value(
769: p_blocks(
770: p_days(

Line 768: hxc_timecard_block_utils.date_value(

764: Loop
765: Exit When Not p_details.exists(l_index);
766: if(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_index)))) then
767: l_detail_date := trunc(
768: hxc_timecard_block_utils.date_value(
769: p_blocks(
770: p_days(
771: p_blocks(p_details(l_index)).parent_building_block_id
772: )

Line 790: ,p_props in hxc_timecard_prop_table_type

786: End find_detail_date_extremes;
787:
788: Procedure chk_inactive_details
789: (p_blocks in hxc_block_table_type
790: ,p_props in hxc_timecard_prop_table_type
791: ,p_days in hxc_timecard.block_list
792: ,p_details in hxc_timecard.block_list
793: ,p_block_idxs out nocopy block_list
794: ) is

Line 791: ,p_days in hxc_timecard.block_list

787:
788: Procedure chk_inactive_details
789: (p_blocks in hxc_block_table_type
790: ,p_props in hxc_timecard_prop_table_type
791: ,p_days in hxc_timecard.block_list
792: ,p_details in hxc_timecard.block_list
793: ,p_block_idxs out nocopy block_list
794: ) is
795:

Line 792: ,p_details in hxc_timecard.block_list

788: Procedure chk_inactive_details
789: (p_blocks in hxc_block_table_type
790: ,p_props in hxc_timecard_prop_table_type
791: ,p_days in hxc_timecard.block_list
792: ,p_details in hxc_timecard.block_list
793: ,p_block_idxs out nocopy block_list
794: ) is
795:
796: l_early_detail date := hr_general.end_of_time;

Line 868: if(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_block_index)))) then

864: l_block_index := p_details.first;
865:
866: Loop
867: Exit When Not p_details.exists(l_block_index);
868: if(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_block_index)))) then
869: l_detail_date := trunc(
870: hxc_timecard_block_utils.date_value(
871: p_blocks(
872: p_days(

Line 870: hxc_timecard_block_utils.date_value(

866: Loop
867: Exit When Not p_details.exists(l_block_index);
868: if(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_block_index)))) then
869: l_detail_date := trunc(
870: hxc_timecard_block_utils.date_value(
871: p_blocks(
872: p_days(
873: p_blocks(p_details(l_block_index)).parent_building_block_id
874: )

Line 922: ,p_timecard_props in hxc_timecard_prop_table_type

918: --
919: PROCEDURE perform_checks
920: (p_blocks in hxc_block_table_type
921: ,p_attributes in hxc_attribute_table_type
922: ,p_timecard_props in hxc_timecard_prop_table_type
923: ,p_days in hxc_timecard.block_list
924: ,p_details in hxc_timecard.block_list
925: ,p_messages in out nocopy hxc_message_table_type
926: ) IS

Line 923: ,p_days in hxc_timecard.block_list

919: PROCEDURE perform_checks
920: (p_blocks in hxc_block_table_type
921: ,p_attributes in hxc_attribute_table_type
922: ,p_timecard_props in hxc_timecard_prop_table_type
923: ,p_days in hxc_timecard.block_list
924: ,p_details in hxc_timecard.block_list
925: ,p_messages in out nocopy hxc_message_table_type
926: ) IS
927:

Line 924: ,p_details in hxc_timecard.block_list

920: (p_blocks in hxc_block_table_type
921: ,p_attributes in hxc_attribute_table_type
922: ,p_timecard_props in hxc_timecard_prop_table_type
923: ,p_days in hxc_timecard.block_list
924: ,p_details in hxc_timecard.block_list
925: ,p_messages in out nocopy hxc_message_table_type
926: ) IS
927:
928: l_tc_index NUMBER;

Line 938: l_validate_on_save hxc_pref_hierarchies.attribute1%type := hxc_timecard.c_no;

934: l_block_idxs block_list;
935:
936: l_proc varchar2(72) := g_package||'perform_checks';
937:
938: l_validate_on_save hxc_pref_hierarchies.attribute1%type := hxc_timecard.c_no;
939:
940:
941: BEGIN
942:

Line 948: l_tc_index := hxc_timecard_block_utils.find_active_timecard_index

944: -- First find the "active" timecard scope building block
945: -- index.
946: --
947:
948: l_tc_index := hxc_timecard_block_utils.find_active_timecard_index
949: (p_blocks => p_blocks);
950:
951:
952: l_validate_on_save := hxc_timecard_properties.find_property_value

Line 952: l_validate_on_save := hxc_timecard_properties.find_property_value

948: l_tc_index := hxc_timecard_block_utils.find_active_timecard_index
949: (p_blocks => p_blocks);
950:
951:
952: l_validate_on_save := hxc_timecard_properties.find_property_value
953: (p_timecard_props
954: ,'TsPerValidateOnSaveValidateOnSave'
955: ,null
956: ,null

Line 974: hxc_timecard_message_helper.addErrorToCollection

970: ) then
971: --
972: -- There is an existing timecard, stop processing.
973: --
974: hxc_timecard_message_helper.addErrorToCollection
975: (p_messages
976: ,'HXC_366333_TIMECARD_EXISTS'
977: ,hxc_timecard.c_error
978: ,null

Line 977: ,hxc_timecard.c_error

973: --
974: hxc_timecard_message_helper.addErrorToCollection
975: (p_messages
976: ,'HXC_366333_TIMECARD_EXISTS'
977: ,hxc_timecard.c_error
978: ,null
979: ,null
980: ,hxc_timecard.c_hxc
981: ,null

Line 980: ,hxc_timecard.c_hxc

976: ,'HXC_366333_TIMECARD_EXISTS'
977: ,hxc_timecard.c_error
978: ,null
979: ,null
980: ,hxc_timecard.c_hxc
981: ,null
982: ,null
983: ,null
984: ,null

Line 1012: hxc_timecard_message_helper.addErrorToCollection

1008: l_idx := l_block_idxs.first;
1009: Loop
1010: Exit When not l_block_idxs.exists(l_idx);
1011:
1012: hxc_timecard_message_helper.addErrorToCollection
1013: (p_messages
1014: ,'HXC_DETAIL_NON_ACTIVE'
1015: ,hxc_timecard.c_error
1016: ,null

Line 1015: ,hxc_timecard.c_error

1011:
1012: hxc_timecard_message_helper.addErrorToCollection
1013: (p_messages
1014: ,'HXC_DETAIL_NON_ACTIVE'
1015: ,hxc_timecard.c_error
1016: ,null
1017: ,null
1018: ,hxc_timecard.c_hxc
1019: ,p_blocks(p_details(l_idx)).time_building_block_id

Line 1018: ,hxc_timecard.c_hxc

1014: ,'HXC_DETAIL_NON_ACTIVE'
1015: ,hxc_timecard.c_error
1016: ,null
1017: ,null
1018: ,hxc_timecard.c_hxc
1019: ,p_blocks(p_details(l_idx)).time_building_block_id
1020: ,p_blocks(p_details(l_idx)).object_version_number
1021: ,null
1022: ,null

Line 1223: (p_timecard_props in hxc_timecard_prop_table_type

1219:
1220: End prohibitedBlockChange;
1221:
1222: Function never_locked
1223: (p_timecard_props in hxc_timecard_prop_table_type
1224: ,p_early_date in date
1225: ,p_late_date in date
1226: ) return boolean is
1227:

Line 1296: (p_timecard_props in hxc_timecard_prop_table_type

1292:
1293: End never_locked;
1294:
1295: Function find_locking_preference
1296: (p_timecard_props in hxc_timecard_prop_table_type
1297: ,p_date in date
1298: ,p_preference in varchar2
1299: ) return varchar2 is
1300:

Line 1434: (p_timecard_props in hxc_timecard_prop_table_type

1430: END IF;
1431: END detail_with_day;
1432:
1433: Function day_locked
1434: (p_timecard_props in hxc_timecard_prop_table_type
1435: ,p_resource_id in hxc_time_building_blocks.resource_id%type
1436: ,p_date in date
1437: ) return boolean is
1438:

Line 1468: (p_timecard_props in hxc_timecard_prop_table_type,

1464:
1465: End day_locked;
1466:
1467: Function detail_locked
1468: (p_timecard_props in hxc_timecard_prop_table_type,
1469: p_resource_id in hxc_time_building_blocks.resource_id%type,
1470: p_date in date,
1471: p_detail_id in hxc_ap_detail_links.time_building_block_id%type,
1472: p_detail_ovn in hxc_ap_detail_links.time_building_block_ovn%type

Line 1484: and aps.approval_status = hxc_timecard.c_approved_status

1480: hxc_app_period_summary aps
1481: where adl.time_building_block_id = p_detail_id
1482: and adl.time_building_block_ovn = p_detail_ovn
1483: and adl.application_period_id = aps.application_period_id
1484: and aps.approval_status = hxc_timecard.c_approved_status
1485: and not exists(select 1
1486: from hxc_ap_detail_links adl2,
1487: hxc_app_period_summary aps2
1488: where adl2.time_building_block_id = adl.time_building_block_id

Line 1492: and aps2.approval_status <> hxc_timecard.c_approved_status);

1488: where adl2.time_building_block_id = adl.time_building_block_id
1489: and adl2.time_building_block_ovn = adl.time_building_block_ovn
1490: and adl2.application_period_id <> adl.application_period_id
1491: and adl2.application_period_id = aps2.application_period_id
1492: and aps2.approval_status <> hxc_timecard.c_approved_status);
1493:
1494: l_locked boolean := false;
1495: l_pref varchar2(2);
1496: l_dummy varchar2(1);

Line 1555: ,p_timecard_props in hxc_timecard_prop_table_type

1551: --
1552: PROCEDURE chk_approved_locked_days
1553: (p_blocks in hxc_block_table_type,
1554: p_attributes in hxc_attribute_table_type
1555: ,p_timecard_props in hxc_timecard_prop_table_type
1556: ,p_days in hxc_timecard.block_list
1557: ,p_details in hxc_timecard.block_list
1558: ,p_messages in out nocopy hxc_message_table_type
1559: ) IS

Line 1556: ,p_days in hxc_timecard.block_list

1552: PROCEDURE chk_approved_locked_days
1553: (p_blocks in hxc_block_table_type,
1554: p_attributes in hxc_attribute_table_type
1555: ,p_timecard_props in hxc_timecard_prop_table_type
1556: ,p_days in hxc_timecard.block_list
1557: ,p_details in hxc_timecard.block_list
1558: ,p_messages in out nocopy hxc_message_table_type
1559: ) IS
1560:

Line 1557: ,p_details in hxc_timecard.block_list

1553: (p_blocks in hxc_block_table_type,
1554: p_attributes in hxc_attribute_table_type
1555: ,p_timecard_props in hxc_timecard_prop_table_type
1556: ,p_days in hxc_timecard.block_list
1557: ,p_details in hxc_timecard.block_list
1558: ,p_messages in out nocopy hxc_message_table_type
1559: ) IS
1560:
1561: l_modify_days varchar2(2) := 'N';

Line 1597: (hxc_timecard_block_utils.is_new_block(p_blocks(p_details(l_detail_index)))))

1593: p_attributes
1594: )
1595: )
1596: OR
1597: (hxc_timecard_block_utils.is_new_block(p_blocks(p_details(l_detail_index)))))
1598: --AND
1599: --(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_detail_index))))
1600: )then
1601:

Line 1599: --(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_detail_index))))

1595: )
1596: OR
1597: (hxc_timecard_block_utils.is_new_block(p_blocks(p_details(l_detail_index)))))
1598: --AND
1599: --(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_detail_index))))
1600: )then
1601:
1602: l_detail_date := trunc(hxc_timecard_block_utils.date_value
1603: (p_blocks(p_days(p_blocks(p_details(l_detail_index)).parent_building_block_id)).start_time

Line 1602: l_detail_date := trunc(hxc_timecard_block_utils.date_value

1598: --AND
1599: --(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_detail_index))))
1600: )then
1601:
1602: l_detail_date := trunc(hxc_timecard_block_utils.date_value
1603: (p_blocks(p_days(p_blocks(p_details(l_detail_index)).parent_building_block_id)).start_time
1604: ));
1605: if(day_locked(p_timecard_props, p_blocks(p_details(l_detail_index)).resource_id,l_detail_date)) then
1606: hxc_timecard_message_helper.addErrorToCollection

Line 1606: hxc_timecard_message_helper.addErrorToCollection

1602: l_detail_date := trunc(hxc_timecard_block_utils.date_value
1603: (p_blocks(p_days(p_blocks(p_details(l_detail_index)).parent_building_block_id)).start_time
1604: ));
1605: if(day_locked(p_timecard_props, p_blocks(p_details(l_detail_index)).resource_id,l_detail_date)) then
1606: hxc_timecard_message_helper.addErrorToCollection
1607: (p_messages
1608: ,'HXC_NO_MODIFY_APPROVED_DETAIL'
1609: ,hxc_timecard.c_error
1610: ,null

Line 1609: ,hxc_timecard.c_error

1605: if(day_locked(p_timecard_props, p_blocks(p_details(l_detail_index)).resource_id,l_detail_date)) then
1606: hxc_timecard_message_helper.addErrorToCollection
1607: (p_messages
1608: ,'HXC_NO_MODIFY_APPROVED_DETAIL'
1609: ,hxc_timecard.c_error
1610: ,null
1611: ,null
1612: ,hxc_timecard.c_hxc
1613: ,p_blocks(p_details(l_detail_index)).time_building_block_id

Line 1612: ,hxc_timecard.c_hxc

1608: ,'HXC_NO_MODIFY_APPROVED_DETAIL'
1609: ,hxc_timecard.c_error
1610: ,null
1611: ,null
1612: ,hxc_timecard.c_hxc
1613: ,p_blocks(p_details(l_detail_index)).time_building_block_id
1614: ,null
1615: ,null
1616: ,null

Line 1619: if(hxc_timecard_block_utils.is_new_block(p_blocks(p_details(l_detail_index)))) then

1615: ,null
1616: ,null
1617: );
1618: else
1619: if(hxc_timecard_block_utils.is_new_block(p_blocks(p_details(l_detail_index)))) then
1620: --
1621: -- It is ok, this entry is allowed, the day is not locked, and it is a new
1622: -- building block
1623: --

Line 1633: hxc_timecard_message_helper.addErrorToCollection

1629: l_detail_date,
1630: p_blocks(p_details(l_detail_index)).time_building_block_id,
1631: p_blocks(p_details(l_detail_index)).object_version_number
1632: )) then
1633: hxc_timecard_message_helper.addErrorToCollection
1634: (p_messages
1635: ,'HXC_NO_MODIFY_APPROVED_DETAIL'
1636: ,hxc_timecard.c_error
1637: ,null

Line 1636: ,hxc_timecard.c_error

1632: )) then
1633: hxc_timecard_message_helper.addErrorToCollection
1634: (p_messages
1635: ,'HXC_NO_MODIFY_APPROVED_DETAIL'
1636: ,hxc_timecard.c_error
1637: ,null
1638: ,null
1639: ,hxc_timecard.c_hxc
1640: ,p_blocks(p_details(l_detail_index)).time_building_block_id

Line 1639: ,hxc_timecard.c_hxc

1635: ,'HXC_NO_MODIFY_APPROVED_DETAIL'
1636: ,hxc_timecard.c_error
1637: ,null
1638: ,null
1639: ,hxc_timecard.c_hxc
1640: ,p_blocks(p_details(l_detail_index)).time_building_block_id
1641: ,null
1642: ,null
1643: ,null

Line 1698: if(hxc_timecard_block_utils.process_block(p_blocks(l_index))) then

1694:
1695: l_index := p_blocks.first;
1696: LOOP
1697: Exit When ((Not p_blocks.exists(l_index)) or (l_found));
1698: if(hxc_timecard_block_utils.process_block(p_blocks(l_index))) then
1699: l_found := true;
1700: end if;
1701: l_index := p_blocks.next(l_index);
1702: END LOOP;

Line 1708: if(hxc_timecard_attribute_utils.process_attribute(p_attributes(l_index))) then

1704: if (not l_found) then
1705: l_index := p_attributes.first;
1706: LOOP
1707: Exit When ((Not p_attributes.exists(l_index)) or (l_found));
1708: if(hxc_timecard_attribute_utils.process_attribute(p_attributes(l_index))) then
1709: l_found := true;
1710: end if;
1711: l_index := p_attributes.next(l_index);
1712: END LOOP;

Line 1716: hxc_timecard_message_helper.addErrorToCollection

1712: END LOOP;
1713: end if;
1714:
1715: if (not l_found) then
1716: hxc_timecard_message_helper.addErrorToCollection
1717: (p_messages
1718: ,'HXC_TIMECARD_NOT_SUBMITTED'
1719: ,hxc_timecard.c_error
1720: ,null

Line 1718: ,'HXC_TIMECARD_NOT_SUBMITTED'

1714:
1715: if (not l_found) then
1716: hxc_timecard_message_helper.addErrorToCollection
1717: (p_messages
1718: ,'HXC_TIMECARD_NOT_SUBMITTED'
1719: ,hxc_timecard.c_error
1720: ,null
1721: ,null
1722: ,hxc_timecard.c_hxc

Line 1719: ,hxc_timecard.c_error

1715: if (not l_found) then
1716: hxc_timecard_message_helper.addErrorToCollection
1717: (p_messages
1718: ,'HXC_TIMECARD_NOT_SUBMITTED'
1719: ,hxc_timecard.c_error
1720: ,null
1721: ,null
1722: ,hxc_timecard.c_hxc
1723: ,null

Line 1722: ,hxc_timecard.c_hxc

1718: ,'HXC_TIMECARD_NOT_SUBMITTED'
1719: ,hxc_timecard.c_error
1720: ,null
1721: ,null
1722: ,hxc_timecard.c_hxc
1723: ,null
1724: ,null
1725: ,null
1726: ,null

Line 1767: ,p_timecard_props in hxc_timecard_prop_table_type

1763: --
1764: PROCEDURE perform_process_checks
1765: (p_blocks in hxc_block_table_type
1766: ,p_attributes in hxc_attribute_table_type
1767: ,p_timecard_props in hxc_timecard_prop_table_type
1768: ,p_days in hxc_timecard.block_list
1769: ,p_details in hxc_timecard.block_list
1770: ,p_template in varchar2
1771: ,p_deposit_mode in varchar2

Line 1768: ,p_days in hxc_timecard.block_list

1764: PROCEDURE perform_process_checks
1765: (p_blocks in hxc_block_table_type
1766: ,p_attributes in hxc_attribute_table_type
1767: ,p_timecard_props in hxc_timecard_prop_table_type
1768: ,p_days in hxc_timecard.block_list
1769: ,p_details in hxc_timecard.block_list
1770: ,p_template in varchar2
1771: ,p_deposit_mode in varchar2
1772: ,p_messages in out nocopy hxc_message_table_type

Line 1769: ,p_details in hxc_timecard.block_list

1765: (p_blocks in hxc_block_table_type
1766: ,p_attributes in hxc_attribute_table_type
1767: ,p_timecard_props in hxc_timecard_prop_table_type
1768: ,p_days in hxc_timecard.block_list
1769: ,p_details in hxc_timecard.block_list
1770: ,p_template in varchar2
1771: ,p_deposit_mode in varchar2
1772: ,p_messages in out nocopy hxc_message_table_type
1773: ) IS