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 85: hxc_timecard_message_helper.addErrorToCollection

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

Line 88: ,hxc_timecard.c_error

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

Line 91: ,hxc_timecard.c_hxc

87: ,'HXC_CANT_DEL_TEMPL'
88: ,hxc_timecard.c_error
89: ,null
90: ,null
91: ,hxc_timecard.c_hxc
92: ,null
93: ,null
94: ,null
95: ,null

Line 103: hxc_timecard_message_helper.addErrorToCollection

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

Line 106: ,hxc_timecard.c_error

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

Line 109: ,hxc_timecard.c_hxc

105: ,'HXC_CANT_DEL_TEMPL'
106: ,hxc_timecard.c_error
107: ,null
108: ,null
109: ,hxc_timecard.c_hxc
110: ,null
111: ,null
112: ,null
113: ,null

Line 121: hxc_timecard_message_helper.addErrorToCollection

117: else
118:
119: -- Public Template Specific
120:
121: hxc_timecard_message_helper.addErrorToCollection
122: (p_messages
123: ,'HXC_CANT_DEL_PUB_TEMPL'
124: ,hxc_timecard.c_error
125: ,null

Line 124: ,hxc_timecard.c_error

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

Line 127: ,hxc_timecard.c_hxc

123: ,'HXC_CANT_DEL_PUB_TEMPL'
124: ,hxc_timecard.c_error
125: ,null
126: ,'GROUPS&'||l_attached_public_temp_grps
127: ,hxc_timecard.c_hxc
128: ,null
129: ,null
130: ,null
131: ,null

Line 184: hxc_timecard_message_helper.addErrorToCollection

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

Line 187: ,hxc_timecard.c_error

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

Line 190: ,hxc_timecard.c_hxc

186: ,'HXC_XXXXX_NO_BLOCKS'
187: ,hxc_timecard.c_error
188: ,null
189: ,null
190: ,hxc_timecard.c_hxc
191: ,null
192: ,null
193: ,null
194: ,null

Line 203: 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

199: --
200: -- The deposit mode must be SUBMIT, SAVE or AUDIT
201: -- (others not currently supported)
202: --
203: 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
204:
205: hxc_timecard_message_helper.addErrorToCollection
206: (p_messages
207: ,'HXC_XXXXX_INVALID_DEP_MODE'

Line 205: hxc_timecard_message_helper.addErrorToCollection

201: -- (others not currently supported)
202: --
203: 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
204:
205: hxc_timecard_message_helper.addErrorToCollection
206: (p_messages
207: ,'HXC_XXXXX_INVALID_DEP_MODE'
208: ,hxc_timecard.c_error
209: ,null

Line 208: ,hxc_timecard.c_error

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

Line 211: ,hxc_timecard.c_hxc

207: ,'HXC_XXXXX_INVALID_DEP_MODE'
208: ,hxc_timecard.c_error
209: ,null
210: ,'MODE&'||p_deposit_mode
211: ,hxc_timecard.c_hxc
212: ,null
213: ,null
214: ,null
215: ,null

Line 225: hxc_timecard_message_helper.addErrorToCollection

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

Line 228: ,hxc_timecard.c_error

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

Line 231: ,hxc_timecard.c_hxc

227: ,'HXC_XXXXX_INVALID_TEMPLATE'
228: ,hxc_timecard.c_error
229: ,null
230: ,'VALUE&'||p_template
231: ,hxc_timecard.c_hxc
232: ,null
233: ,null
234: ,null
235: ,null

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

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

Line 242: hxc_timecard_message_helper.addErrorToCollection

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

Line 245: ,hxc_timecard.c_error

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

Line 248: ,hxc_timecard.c_hxc

244: ,'HXC_XXXXX_INVALID_DEP_MODE'
245: ,hxc_timecard.c_error
246: ,null
247: ,'MODE&'||p_deposit_mode
248: ,hxc_timecard.c_hxc
249: ,null
250: ,null
251: ,null
252: ,null

Line 321: hxc_timecard_message_helper.addErrorToCollection

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

Line 325: ,p_message_level => hxc_timecard.c_error

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

Line 327: ,p_application_short_name => hxc_timecard.c_hxc

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

Line 712: ,p_details in hxc_timecard.block_list

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

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

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

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

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

Line 729: p_validate_on_save = hxc_timecard.c_yes

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

Line 733: hxc_timecard_message_helper.addErrorToCollection

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

Line 737: ,p_message_level => hxc_timecard.c_error

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

Line 739: ,p_application_short_name => hxc_timecard.c_hxc

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

Line 755: ,p_days in hxc_timecard.block_list

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

Line 756: ,p_details in hxc_timecard.block_list

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

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

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

Line 771: hxc_timecard_block_utils.date_value(

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

Line 793: ,p_props in hxc_timecard_prop_table_type

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

Line 794: ,p_days in hxc_timecard.block_list

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

Line 795: ,p_details in hxc_timecard.block_list

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

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

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

Line 873: hxc_timecard_block_utils.date_value(

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

Line 925: ,p_timecard_props in hxc_timecard_prop_table_type

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

Line 926: ,p_days in hxc_timecard.block_list

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

Line 927: ,p_details in hxc_timecard.block_list

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

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

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

Line 951: l_tc_index := hxc_timecard_block_utils.find_active_timecard_index

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

Line 955: l_validate_on_save := hxc_timecard_properties.find_property_value

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

Line 977: hxc_timecard_message_helper.addErrorToCollection

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

Line 980: ,hxc_timecard.c_error

976: --
977: hxc_timecard_message_helper.addErrorToCollection
978: (p_messages
979: ,'HXC_366333_TIMECARD_EXISTS'
980: ,hxc_timecard.c_error
981: ,null
982: ,null
983: ,hxc_timecard.c_hxc
984: ,null

Line 983: ,hxc_timecard.c_hxc

979: ,'HXC_366333_TIMECARD_EXISTS'
980: ,hxc_timecard.c_error
981: ,null
982: ,null
983: ,hxc_timecard.c_hxc
984: ,null
985: ,null
986: ,null
987: ,null

Line 1015: hxc_timecard_message_helper.addErrorToCollection

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

Line 1018: ,hxc_timecard.c_error

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

Line 1021: ,hxc_timecard.c_hxc

1017: ,'HXC_DETAIL_NON_ACTIVE'
1018: ,hxc_timecard.c_error
1019: ,null
1020: ,null
1021: ,hxc_timecard.c_hxc
1022: ,p_blocks(p_details(l_idx)).time_building_block_id
1023: ,p_blocks(p_details(l_idx)).object_version_number
1024: ,null
1025: ,null

Line 1226: (p_timecard_props in hxc_timecard_prop_table_type

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

Line 1299: (p_timecard_props in hxc_timecard_prop_table_type

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

Line 1437: (p_timecard_props in hxc_timecard_prop_table_type

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

Line 1471: (p_timecard_props in hxc_timecard_prop_table_type,

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

Line 1487: and aps.approval_status = hxc_timecard.c_approved_status

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

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

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

Line 1558: ,p_timecard_props in hxc_timecard_prop_table_type

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

Line 1559: ,p_days in hxc_timecard.block_list

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

Line 1560: ,p_details in hxc_timecard.block_list

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

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

1596: p_attributes
1597: )
1598: )
1599: OR
1600: (hxc_timecard_block_utils.is_new_block(p_blocks(p_details(l_detail_index)))))
1601: --AND
1602: --(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_detail_index))))
1603: )then
1604:

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

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

Line 1605: l_detail_date := trunc(hxc_timecard_block_utils.date_value

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

Line 1609: hxc_timecard_message_helper.addErrorToCollection

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

Line 1612: ,hxc_timecard.c_error

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

Line 1615: ,hxc_timecard.c_hxc

1611: ,'HXC_NO_MODIFY_APPROVED_DETAIL'
1612: ,hxc_timecard.c_error
1613: ,null
1614: ,null
1615: ,hxc_timecard.c_hxc
1616: ,p_blocks(p_details(l_detail_index)).time_building_block_id
1617: ,null
1618: ,null
1619: ,null

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

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

Line 1636: hxc_timecard_message_helper.addErrorToCollection

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

Line 1639: ,hxc_timecard.c_error

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

Line 1642: ,hxc_timecard.c_hxc

1638: ,'HXC_NO_MODIFY_APPROVED_DETAIL'
1639: ,hxc_timecard.c_error
1640: ,null
1641: ,null
1642: ,hxc_timecard.c_hxc
1643: ,p_blocks(p_details(l_detail_index)).time_building_block_id
1644: ,null
1645: ,null
1646: ,null

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

1702:
1703: l_index := p_blocks.first;
1704: LOOP
1705: Exit When ((Not p_blocks.exists(l_index)) or (l_found));
1706: if(hxc_timecard_block_utils.process_block(p_blocks(l_index))) then
1707: l_found := true;
1708: end if;
1709: l_index := p_blocks.next(l_index);
1710: END LOOP;

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

1712: if (not l_found) then
1713: l_index := p_attributes.first;
1714: LOOP
1715: Exit When ((Not p_attributes.exists(l_index)) or (l_found));
1716: if(hxc_timecard_attribute_utils.process_attribute(p_attributes(l_index))) then
1717: l_found := true;
1718: end if;
1719: l_index := p_attributes.next(l_index);
1720: END LOOP;

Line 1735: hxc_timecard_message_helper.addErrorToCollection

1731: END IF;
1732:
1733:
1734: if (not l_found) then
1735: hxc_timecard_message_helper.addErrorToCollection
1736: (p_messages
1737: ,'HXC_TIMECARD_NOT_SUBMITTED'
1738: ,hxc_timecard.c_error
1739: ,null

Line 1737: ,'HXC_TIMECARD_NOT_SUBMITTED'

1733:
1734: if (not l_found) then
1735: hxc_timecard_message_helper.addErrorToCollection
1736: (p_messages
1737: ,'HXC_TIMECARD_NOT_SUBMITTED'
1738: ,hxc_timecard.c_error
1739: ,null
1740: ,null
1741: ,hxc_timecard.c_hxc

Line 1738: ,hxc_timecard.c_error

1734: if (not l_found) then
1735: hxc_timecard_message_helper.addErrorToCollection
1736: (p_messages
1737: ,'HXC_TIMECARD_NOT_SUBMITTED'
1738: ,hxc_timecard.c_error
1739: ,null
1740: ,null
1741: ,hxc_timecard.c_hxc
1742: ,null

Line 1741: ,hxc_timecard.c_hxc

1737: ,'HXC_TIMECARD_NOT_SUBMITTED'
1738: ,hxc_timecard.c_error
1739: ,null
1740: ,null
1741: ,hxc_timecard.c_hxc
1742: ,null
1743: ,null
1744: ,null
1745: ,null

Line 1751: hxc_timecard_message_helper.addErrorToCollection

1747: end if;
1748:
1749: -- Added for
1750: if hxc_block_attribute_update.g_tc_api_flag = 'Y' then
1751: hxc_timecard_message_helper.addErrorToCollection
1752: (p_messages
1753: ,'HXC_TIMECARD_NOT_SUBMITTED'
1754: ,hxc_timecard.c_error
1755: ,null

Line 1753: ,'HXC_TIMECARD_NOT_SUBMITTED'

1749: -- Added for
1750: if hxc_block_attribute_update.g_tc_api_flag = 'Y' then
1751: hxc_timecard_message_helper.addErrorToCollection
1752: (p_messages
1753: ,'HXC_TIMECARD_NOT_SUBMITTED'
1754: ,hxc_timecard.c_error
1755: ,null
1756: ,null
1757: ,hxc_timecard.c_hxc

Line 1754: ,hxc_timecard.c_error

1750: if hxc_block_attribute_update.g_tc_api_flag = 'Y' then
1751: hxc_timecard_message_helper.addErrorToCollection
1752: (p_messages
1753: ,'HXC_TIMECARD_NOT_SUBMITTED'
1754: ,hxc_timecard.c_error
1755: ,null
1756: ,null
1757: ,hxc_timecard.c_hxc
1758: ,null

Line 1757: ,hxc_timecard.c_hxc

1753: ,'HXC_TIMECARD_NOT_SUBMITTED'
1754: ,hxc_timecard.c_error
1755: ,null
1756: ,null
1757: ,hxc_timecard.c_hxc
1758: ,null
1759: ,null
1760: ,null
1761: ,null

Line 1802: ,p_timecard_props in hxc_timecard_prop_table_type

1798: --
1799: PROCEDURE perform_process_checks
1800: (p_blocks in hxc_block_table_type
1801: ,p_attributes in hxc_attribute_table_type
1802: ,p_timecard_props in hxc_timecard_prop_table_type
1803: ,p_days in hxc_timecard.block_list
1804: ,p_details in hxc_timecard.block_list
1805: ,p_template in varchar2
1806: ,p_deposit_mode in varchar2

Line 1803: ,p_days in hxc_timecard.block_list

1799: PROCEDURE perform_process_checks
1800: (p_blocks in hxc_block_table_type
1801: ,p_attributes in hxc_attribute_table_type
1802: ,p_timecard_props in hxc_timecard_prop_table_type
1803: ,p_days in hxc_timecard.block_list
1804: ,p_details in hxc_timecard.block_list
1805: ,p_template in varchar2
1806: ,p_deposit_mode in varchar2
1807: ,p_messages in out nocopy hxc_message_table_type

Line 1804: ,p_details in hxc_timecard.block_list

1800: (p_blocks in hxc_block_table_type
1801: ,p_attributes in hxc_attribute_table_type
1802: ,p_timecard_props in hxc_timecard_prop_table_type
1803: ,p_days in hxc_timecard.block_list
1804: ,p_details in hxc_timecard.block_list
1805: ,p_template in varchar2
1806: ,p_deposit_mode in varchar2
1807: ,p_messages in out nocopy hxc_message_table_type
1808: ) IS