9146: x_trxv_rec trxv_rec_type;
9147: l_talv_rec talv_rec_type;
9148: --l_line_number NUMBER := 0;
9149:
9150: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
9151: l_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
9152: l_pdt_parameter_rec2 OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
9153: x_no_data_found BOOLEAN;
9154:
9147: l_talv_rec talv_rec_type;
9148: --l_line_number NUMBER := 0;
9149:
9150: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
9151: l_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
9152: l_pdt_parameter_rec2 OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
9153: x_no_data_found BOOLEAN;
9154:
9155:
9148: --l_line_number NUMBER := 0;
9149:
9150: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
9151: l_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
9152: l_pdt_parameter_rec2 OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
9153: x_no_data_found BOOLEAN;
9154:
9155:
9156: -- Bug 6674730 end
9258: l_pdt_parameter_rec.reporting_pdt_id <> OKL_API.G_MISS_NUM)
9259: THEN
9260: l_pdtv_rec.ID := l_pdt_parameter_rec.reporting_pdt_id;
9261: IF (is_debug_statement_on) THEN
9262: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_SETUPPRODUCTS_PUB.Getpdt_parameters ');
9263: END IF;
9264:
9265: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(
9266: p_api_version => p_api_version,
9261: IF (is_debug_statement_on) THEN
9262: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Calling OKL_SETUPPRODUCTS_PUB.Getpdt_parameters ');
9263: END IF;
9264:
9265: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(
9266: p_api_version => p_api_version,
9267: p_init_msg_list => p_init_msg_list,
9268: x_return_status => x_return_status,
9269: x_msg_count => x_msg_count,
9271: p_pdtv_rec => l_pdtv_rec,
9272: x_no_data_found => x_no_data_found,
9273: p_pdt_parameter_rec => l_pdt_parameter_rec2);
9274: IF (is_debug_statement_on) THEN
9275: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name ,'Called OKL_SETUPPRODUCTS_PUB.Getpdt_parameters x_return_status = '||x_return_status);
9276: END IF;
9277:
9278: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9279: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;