867: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
868: -- end if;
869: end if;
870:
871: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_output_txt);
872: end if;
873:
874:
875: /* Inserting the Promotion details in the table */
994: else
995: l_promo_cnt := l_promo_cnt + 1;
996: end if;
997: l_output := l_emp_no ||fnd_global.local_chr(9)||l_promo_cnt || fnd_global.local_chr(9) || l_promo_dt;
998: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_output);
999: l_prev_emp := l_emp_no;
1000: end loop;
1001: /* Deleteing the promotion records from per_ca_ee_report_lines table */
1002: delete from
1067: /*else
1068: l_output := l_emp_no ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_start_dt||fnd_global.local_chr(9)
1069: ||l_end_dt||fnd_global.local_chr(9)||l_term_dt;
1070: end if;*/
1071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_output);
1072: l_prev_emp := l_emp_no;
1073: end loop;
1074: /* Deleting the temporary employee records from the per_ca_ee_report_lines table */
1075: delete from
1166: l_flag :='Y';
1167: end if;
1168:
1169: if l_flag = 'Y' then
1170: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_output);
1171: end if;
1172: l_flag :='N';
1173: end loop;
1174: close c_excep_report;