213: IF (l_person_id IS NULL) THEN
214: x_amount := 0;
215: ELSE -- l_person_id IS NOT NULL
216: -- Bug 3518004: Changed the package name from HXC_MAPPING_UTILITIES
217: -- to HXC_INTEGRATION_LAYER_V1_GRP.
218: x_amount := HXC_INTEGRATION_LAYER_V1_GRP.get_mappingvalue_sum (
219: p_bld_blk_info_type => g_bld_blk_info_type_PO,
220: p_field_name1 => g_field_AMOUNT,
221: p_field_name2 => g_field_PO_LINE_ID,
214: x_amount := 0;
215: ELSE -- l_person_id IS NOT NULL
216: -- Bug 3518004: Changed the package name from HXC_MAPPING_UTILITIES
217: -- to HXC_INTEGRATION_LAYER_V1_GRP.
218: x_amount := HXC_INTEGRATION_LAYER_V1_GRP.get_mappingvalue_sum (
219: p_bld_blk_info_type => g_bld_blk_info_type_PO,
220: p_field_name1 => g_field_AMOUNT,
221: p_field_name2 => g_field_PO_LINE_ID,
222: p_field_value2 => p_po_line_id,
340: -- PO. What we really want to check is, if there exist any submitted/approved
341: -- timecards that have NOT yet been interfaced into PO.
342:
343: -- Bug 3518004: Changed the package name from HXC_MAPPING_UTILITIES
344: -- to HXC_INTEGRATION_LAYER_V1_GRP.
345: x_timecard_exists := HXC_INTEGRATION_LAYER_V1_GRP.chk_mapping_exists (
346: p_bld_blk_info_type => g_bld_blk_info_type_PO,
347: p_field_name => p_field_name,
348: p_field_value => p_field_value,
341: -- timecards that have NOT yet been interfaced into PO.
342:
343: -- Bug 3518004: Changed the package name from HXC_MAPPING_UTILITIES
344: -- to HXC_INTEGRATION_LAYER_V1_GRP.
345: x_timecard_exists := HXC_INTEGRATION_LAYER_V1_GRP.chk_mapping_exists (
346: p_bld_blk_info_type => g_bld_blk_info_type_PO,
347: p_field_name => p_field_name,
348: p_field_value => p_field_value,
349: p_scope => g_scope_DETAIL,
574: IF (l_person_id IS NULL) THEN
575: x_amount := 0;
576: ELSE -- l_person_id IS NOT NULL
577: -- Bug 3518004: Changed the package name from HXC_MAPPING_UTILITIES
578: -- to HXC_INTEGRATION_LAYER_V1_GRP.
579: x_amount := HXC_INTEGRATION_LAYER_V2_GRP.get_mappingvalue_sum (
580: p_bld_blk_info_type => g_bld_blk_info_type_PO,
581: p_field_name1 => g_field_AMOUNT,
582: p_bld_blk_info_type2 => g_bld_blk_info_type_PO,