595:
596: BEGIN
597: LOOP
598: l_count := l_count + 1;
599: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID' THEN
600: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
601: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'REPORTED_DATE' THEN
602: l_reported_date := fnd_date.canonical_to_date(pay_mag_tape.internal_prm_values(l_count));
603: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'BP_HI_NUMBER' THEN -- 3506171
596: BEGIN
597: LOOP
598: l_count := l_count + 1;
599: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID' THEN
600: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
601: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'REPORTED_DATE' THEN
602: l_reported_date := fnd_date.canonical_to_date(pay_mag_tape.internal_prm_values(l_count));
603: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'BP_HI_NUMBER' THEN -- 3506171
604: l_bp_hi_number := pay_mag_tape.internal_prm_values(l_count);
597: LOOP
598: l_count := l_count + 1;
599: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID' THEN
600: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
601: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'REPORTED_DATE' THEN
602: l_reported_date := fnd_date.canonical_to_date(pay_mag_tape.internal_prm_values(l_count));
603: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'BP_HI_NUMBER' THEN -- 3506171
604: l_bp_hi_number := pay_mag_tape.internal_prm_values(l_count);
605: END IF;
598: l_count := l_count + 1;
599: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID' THEN
600: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
601: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'REPORTED_DATE' THEN
602: l_reported_date := fnd_date.canonical_to_date(pay_mag_tape.internal_prm_values(l_count));
603: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'BP_HI_NUMBER' THEN -- 3506171
604: l_bp_hi_number := pay_mag_tape.internal_prm_values(l_count);
605: END IF;
606: END LOOP;
599: IF pay_mag_tape.internal_prm_names(l_count) = 'TRANSFER_PAYROLL_ACTION_ID' THEN
600: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
601: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'REPORTED_DATE' THEN
602: l_reported_date := fnd_date.canonical_to_date(pay_mag_tape.internal_prm_values(l_count));
603: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'BP_HI_NUMBER' THEN -- 3506171
604: l_bp_hi_number := pay_mag_tape.internal_prm_values(l_count);
605: END IF;
606: END LOOP;
607: EXCEPTION
600: l_payroll_action_id := to_number(pay_mag_tape.internal_prm_values(l_count));
601: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'REPORTED_DATE' THEN
602: l_reported_date := fnd_date.canonical_to_date(pay_mag_tape.internal_prm_values(l_count));
603: ELSIF pay_mag_tape.internal_prm_names(l_count) = 'BP_HI_NUMBER' THEN -- 3506171
604: l_bp_hi_number := pay_mag_tape.internal_prm_values(l_count);
605: END IF;
606: END LOOP;
607: EXCEPTION
608: WHEN NO_DATA_FOUND THEN