DBA Data[Home] [Help]

APPS.OKL_SETUPDQUALITYS_PVT dependencies on OKL_PQY_VALUES_PUB

Line 1063: l_del_pqvv_tbl Okl_Pqy_Values_Pub.pqvv_tbl_type;

1059: ,p_pdqv_rec IN pdqv_rec_type) IS
1060:
1061: i PLS_INTEGER :=0;
1062: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1063: l_del_pqvv_tbl Okl_Pqy_Values_Pub.pqvv_tbl_type;
1064:
1065: CURSOR pqv_csr IS
1066: SELECT pqvv.id
1067: FROM okl_pdt_pqy_vals_v pqvv

Line 1078: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.delete_pqy_values

1074: i := i + 1;
1075: l_del_pqvv_tbl(i).id := pqv_rec.id;
1076: END LOOP;
1077: IF l_del_pqvv_tbl.COUNT > 0 THEN
1078: -- Start of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.delete_pqy_values
1079: IF(L_DEBUG_ENABLED='Y') THEN
1080: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1081: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1082: END IF;

Line 1085: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pqy_Values_Pub.delete_pqy_values ');

1081: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1082: END IF;
1083: IF(IS_DEBUG_PROCEDURE_ON) THEN
1084: BEGIN
1085: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pqy_Values_Pub.delete_pqy_values ');
1086: END;
1087: END IF;
1088: Okl_Pqy_Values_Pub.delete_pqy_values(p_api_version => p_api_version,
1089: p_init_msg_list => p_init_msg_list,

Line 1088: Okl_Pqy_Values_Pub.delete_pqy_values(p_api_version => p_api_version,

1084: BEGIN
1085: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSDQB.pls call Okl_Pqy_Values_Pub.delete_pqy_values ');
1086: END;
1087: END IF;
1088: Okl_Pqy_Values_Pub.delete_pqy_values(p_api_version => p_api_version,
1089: p_init_msg_list => p_init_msg_list,
1090: x_return_status => l_return_status,
1091: x_msg_count => x_msg_count,
1092: x_msg_data => x_msg_data,

Line 1096: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Pqy_Values_Pub.delete_pqy_values ');

1092: x_msg_data => x_msg_data,
1093: p_pqvv_tbl => l_del_pqvv_tbl);
1094: IF(IS_DEBUG_PROCEDURE_ON) THEN
1095: BEGIN
1096: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Pqy_Values_Pub.delete_pqy_values ');
1097: END;
1098: END IF;
1099: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.delete_pqy_values
1100:

Line 1099: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.delete_pqy_values

1095: BEGIN
1096: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSDQB.pls call Okl_Pqy_Values_Pub.delete_pqy_values ');
1097: END;
1098: END IF;
1099: -- End of wraper code generated automatically by Debug code generator for Okl_Pqy_Values_Pub.delete_pqy_values
1100:
1101: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1102: RAISE G_EXCEPTION_HALT_PROCESSING;
1103: ELSE