97: output_file VARCHAR2(255);
98:
99: --variables for WIP_logger
100: l_params wip_logger.param_tbl_t;
101: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
102: l_returnStatus VARCHAR2(1);
103: l_audsid NUMBER;
104:
105: BEGIN
517: desformat VARCHAR2(10);
518:
519: --variables for WIP_logger
520: l_params wip_logger.param_tbl_t;
521: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
522: l_returnStatus VARCHAR2(1);
523:
524: report_retcode number;
525:
978: n_undeleted_records NUMBER ;
979:
980: --variables for WIP_logger
981: l_params wip_logger.param_tbl_t;
982: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
983: l_returnStatus VARCHAR2(1);
984: x_return_status VARCHAR2(255);
985:
986: