296: AND flv.meaning = p_meaning;
297: --
298: begin
299: --
300: hr_utility.set_location('pay_bee_upgrade_pkg.convert_display_to_internal',1);
301: --
302: if (p_lookup_type is not null and
303: l_display_value is not null) then
304: --
313: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
314: pay_core_utils.push_token ('LOOKUP_TYPE', p_lookup_type);
315: pay_core_utils.push_token ('UOM', p_uom_value);
316: pay_core_utils.push_token ('VALUE', l_display_value);
317: --hr_utility.raise_error;
318: raise lov_error;
319: else
320: l_formatted_value := p_input_value;
321: end if;
331: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
332: pay_core_utils.push_token ('LOOKUP_TYPE', p_lookup_type);
333: pay_core_utils.push_token ('UOM', p_uom_value);
334: pay_core_utils.push_token ('VALUE', l_display_value);
335: --hr_utility.raise_error;
336: raise lov_error;
337: else
338: l_formatted_value := p_input_value;
339: end if;
354: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
355: pay_core_utils.push_token ('VALUE_SET_ID', p_value_set_id);
356: pay_core_utils.push_token ('UOM', p_uom_value);
357: pay_core_utils.push_token ('VALUE', l_display_value);
358: --hr_utility.raise_error;
359: raise lov_error;
360: else
361: l_formatted_value := p_input_value;
362: end if;
381: --
382: end if;
383: --
384: --
385: hr_utility.trace('IN:'||p_input_value);
386: hr_utility.trace('OUT:'||l_formatted_value);
387: hr_utility.set_location('pay_bee_upgrade_pkg.convert_display_to_internal',2);
388: --
389: if ((p_input_value is not null and l_formatted_value is null) or
382: end if;
383: --
384: --
385: hr_utility.trace('IN:'||p_input_value);
386: hr_utility.trace('OUT:'||l_formatted_value);
387: hr_utility.set_location('pay_bee_upgrade_pkg.convert_display_to_internal',2);
388: --
389: if ((p_input_value is not null and l_formatted_value is null) or
390: (p_input_value is null)) then
383: --
384: --
385: hr_utility.trace('IN:'||p_input_value);
386: hr_utility.trace('OUT:'||l_formatted_value);
387: hr_utility.set_location('pay_bee_upgrade_pkg.convert_display_to_internal',2);
388: --
389: if ((p_input_value is not null and l_formatted_value is null) or
390: (p_input_value is null)) then
391: return p_input_value;
395: --
396: exception
397: when lov_error then
398: --
399: hr_utility.set_location('pay_bee_upgrade_pkg.convert_display_to_internal',3);
400: --
401: hr_utility.raise_error;
402: when others then
403: --
397: when lov_error then
398: --
399: hr_utility.set_location('pay_bee_upgrade_pkg.convert_display_to_internal',3);
400: --
401: hr_utility.raise_error;
402: when others then
403: --
404: hr_utility.set_location('pay_bee_upgrade_pkg.convert_display_to_internal',4);
405: --
400: --
401: hr_utility.raise_error;
402: when others then
403: --
404: hr_utility.set_location('pay_bee_upgrade_pkg.convert_display_to_internal',4);
405: --
406: if p_batch_line_status in ('V','T') then
407: pay_core_utils.push_message (800,'HR_449110_BEE_UPG_CONV','A');
408: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
408: pay_core_utils.push_token ('BATCH_LINE_ID', p_batch_line_id);
409: pay_core_utils.push_token ('VALUE_ID', 'VALUE_'||p_iv_number);
410: pay_core_utils.push_token ('UOM', p_uom_value);
411: pay_core_utils.push_token ('VALUE', l_display_value);
412: hr_utility.raise_error;
413: else
414: return p_input_value;
415: end if;
416: --
679: payplnk.g_payplnk_call := false;
680: --
681: pay_core_utils.push_message (800,'HR_449111_BEE_UPG_UPD','A');
682: pay_core_utils.push_token ('BATCH_LINE_ID', p_rec.batch_line_id);
683: hr_utility.raise_error;
684: --
685: end;
686: --
687: end if;
738: --
739: begin
740: --
741: --
742: hr_utility.set_location('pay_bee_upgrade_pkg.upgrade_iv_values',1);
743: --
744: --
745: open csr_min_asg_act;
746: fetch csr_min_asg_act into l_chunk_number,L_BG_ID,L_LEG_CODE,L_PCT_ID;
752: -- will be updated.
753: --
754:
755: --
756: hr_utility.trace('ASG ID:'||L_ASG_ID);
757: hr_utility.trace('LEG CODE:'||L_LEG_CODE);
758: hr_utility.trace('BG ID:'||L_ASG_ID);
759: --
760:
753: --
754:
755: --
756: hr_utility.trace('ASG ID:'||L_ASG_ID);
757: hr_utility.trace('LEG CODE:'||L_LEG_CODE);
758: hr_utility.trace('BG ID:'||L_ASG_ID);
759: --
760:
761: FOR g_rec IN csr_batch_lines(L_ASG_ID,L_BG_ID,L_LEG_CODE) LOOP
754:
755: --
756: hr_utility.trace('ASG ID:'||L_ASG_ID);
757: hr_utility.trace('LEG CODE:'||L_LEG_CODE);
758: hr_utility.trace('BG ID:'||L_ASG_ID);
759: --
760:
761: FOR g_rec IN csr_batch_lines(L_ASG_ID,L_BG_ID,L_LEG_CODE) LOOP
762:
760:
761: FOR g_rec IN csr_batch_lines(L_ASG_ID,L_BG_ID,L_LEG_CODE) LOOP
762:
763: --
764: hr_utility.trace('BL ID:'||g_rec.batch_line_id);
765: --
766:
767: -- Call subprogramms to update associated tables.
768: convert_pay_input(g_rec);
783: -- Within this loop each records will be fetched and its associated table contents
784: -- will be updated.
785: --
786: --
787: hr_utility.trace('ASG ID:'||NULL);
788: hr_utility.trace('LEG CODE:'||L_LEG_CODE);
789: hr_utility.trace('BG ID:'||L_ASG_ID);
790: --
791: FOR g_rec IN csr_batch_lines(NULL,L_BG_ID,L_LEG_CODE) LOOP
784: -- will be updated.
785: --
786: --
787: hr_utility.trace('ASG ID:'||NULL);
788: hr_utility.trace('LEG CODE:'||L_LEG_CODE);
789: hr_utility.trace('BG ID:'||L_ASG_ID);
790: --
791: FOR g_rec IN csr_batch_lines(NULL,L_BG_ID,L_LEG_CODE) LOOP
792: --
785: --
786: --
787: hr_utility.trace('ASG ID:'||NULL);
788: hr_utility.trace('LEG CODE:'||L_LEG_CODE);
789: hr_utility.trace('BG ID:'||L_ASG_ID);
790: --
791: FOR g_rec IN csr_batch_lines(NULL,L_BG_ID,L_LEG_CODE) LOOP
792: --
793: hr_utility.trace('BL ID:'||g_rec.batch_line_id);
789: hr_utility.trace('BG ID:'||L_ASG_ID);
790: --
791: FOR g_rec IN csr_batch_lines(NULL,L_BG_ID,L_LEG_CODE) LOOP
792: --
793: hr_utility.trace('BL ID:'||g_rec.batch_line_id);
794: --
795: -- Call subprogramms to update associated tables.
796: convert_pay_input(g_rec);
797: --
800: end if;
801: --
802:
803: --
804: hr_utility.set_location('pay_bee_upgrade_pkg.upgrade_iv_values',2);
805: --
806: --
807: end;
808: --